A PostgreSQL planner semi-join gotcha with CTE, LIMIT, and RETURNING(shayon.dev)49 points by namanyayg 1 year ago | 38 comments
Don't rely on IF NOT EXISTS for concurrent index creation in PostgreSQL(shayon.dev)60 points by shayonj 2 years ago | 43 comments
Selective async commits in PostgreSQL – balancing durability and performance(shayon.dev)89 points by shayonj 1 year ago | 29 comments
Rendering complex scripts in terminal and OSC 66(thottingal.in)30 points by sthottingal 7 months ago | 10 comments
Short-Circuiting Correlated Subqueries in SQLite(emschwartz.me)6 points by emschwartz 10 months ago | 0 comments