General
- PostgreSQL: About
- How to install PostgreSQL on a Mac with Homebrew - How to install and perpetually run postgres on a Mac
Usage
- How to Get or Create in PostgreSQL • Lots of good advice for avoiding gotchas with this seemingly simple operation • Haki Benita 📖
- Is your Postgres ready for production? • A short checklist of essential safeguards and optimations • Craig Kerstiens 📖
- How to take random samples from big PostgreSQL tables • Several approaches, with query runtimes ranging from multiple minutes to less than a second • Render 📖
Comparison to other databases
- SQLite or PostgreSQL? It’s Complicated! | Twilio - The answer is PostgreSQL :)
- postgres for main db + sqlite for tests?
- What’s the main advantage of using Postgres over sqlite as a beginner : r/django - Reddit discussion where the answers converged on the theme of “practice the skills you’ll need at work”
- Postgres is all you need, even for vectors • Postgres with pgvector can replace the need for a dedicated vector database • Eric Zakariasson 📖
Inbox
-
How Postgres stores data on disk – this one’s a page turner | drew’s dev blog • Fascinating deep dive • Drew Silcock 📖
-
postgres.new: In-browser Postgres with an AI interface • Postgres in the browser for cheap • Supabase 🛠️
-
PGlite • Postgres running in the browser via WASM • PGLite 🛠️