Don't rely on IF NOT EXISTS for concurrent index creation in PostgreSQL(shayon.dev)

60 points by shayonj 2 years ago | 43 comments

The perils of UUID primary keys in SQLite(andersmurphy.com)

142 points by emschwartz 4 months ago | 87 comments

Creating a search engine with PostgreSQL(xata.io)

461 points by todsacerdoti 3 years ago | 160 comments

Xata blog post, part 1 of a series, exploring how to build an advanced full-text search engine using PostgreSQL's built-in features.

Postgres Webhooks with Pgstream(xata.io)

145 points by mebcitto 2 years ago | 20 comments

Reading the internals of Postgres: Database cluster, databases, and tables(buraksen.dev)

76 points by buraksen 3 months ago | 1 comments

100k TPS over a billion rows: the unreasonable effectiveness of SQLite(andersmurphy.com)

344 points by speckx 10 months ago | 124 comments

Blog post by Anders Murphy benchmarking SQLite at 100k transactions per second over a billion rows, arguing its embedded single-writer design helps it scale.