Back
Similar todos
researching materialized view in postgres for 
#djangopackages to help clean things up
deep dive into ClickHouse projections for a use-case and replace the materialized view as it was a worse approach 
#spectate
Spec out persistence vs materialised views vs live queries vs resourceCache 
#upbeat
Metric View 
#resultjam
Persist column states between views/refreshes 
#matterloop
Make SQL queries less precise so Postgres can cache results 
#buildinpublic
learned postgresql trigger functions
Learn postgres basics 
#remoteleaf
use guide to make postgres search really fast
Enable pg_stat_statements on 
#simpleanalytics database
TIL how to check index creation progress in postgres 
#til
tilcards.com/posts/46
discover window functions for leaderboard (www.postgresql.org/docs/curre…) 
#kornwolf
learn a ton about Postgres front end/backend protocol
improve postgres settings 
#turreto