What if we treated Postgres like SQLite? (maragu.dev)

Screenshot of maragu.dev: What if we treated Postgres like SQLite?

First screen, captured 1 year ago.

Looks similar

Screenshot of fzakaria.com: Executable Is a SQLite Database

Executable Is a SQLite Database (fzakaria.com)

479 points by setheron 2 months ago | 90 comments

Blog post by Farid Zakaria on replacing the ELF executable format with SQLite databases, and how the idea pairs with Nix.

sqlite elf executable-formats nix

Screenshot of maragu.dev: Choose Boring Technology and LLMs

Choose Boring Technology and LLMs (maragu.dev)

60 points by markusw 1 year ago | 65 comments

Screenshot of emschwartz.me: Subtleties of SQLite Indexes

Subtleties of SQLite Indexes (emschwartz.me)

117 points by emschwartz 1 year ago | 51 comments

Screenshot of evanhahn.com: Prefer strict tables in SQLite

Prefer strict tables in SQLite (evanhahn.com)

313 points by ingve 3 months ago | 160 comments

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

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.

sqlite database-performance benchmarks clojure

Screenshot of shayon.dev: Don't rely on IF NOT EXISTS for concurrent index creation in PostgreSQL

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

60 points by shayonj 2 years ago | 43 comments

Looks similar

Executable Is a SQLite Database(fzakaria.com)

Choose Boring Technology and LLMs(maragu.dev)

Subtleties of SQLite Indexes(emschwartz.me)

Prefer strict tables in SQLite(evanhahn.com)

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

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