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

Screenshot of andersmurphy.com: The perils of UUID primary keys in SQLite

First screen, captured 4 months ago.

Looks similar

Screenshot of andersmurphy.com: SQLite improving performance with pre-sort

SQLite improving performance with pre-sort (andersmurphy.com)

44 points by tosh 4 months ago | 4 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 buraksen.dev: Reading the internals of Postgres: Database cluster, databases, and tables

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

76 points by buraksen 3 months ago | 1 comments

Screenshot of maciejwalkowiak.com: PostgreSQL and UUID as Primary Key

PostgreSQL and UUID as Primary Key (maciejwalkowiak.com)

387 points by taubek 2 years ago | 296 comments

A blog post by Maciej Walkowiak discussing the use of UUIDs as primary keys in PostgreSQL, including storage and performance considerations, with Java examples.

postgresql uuid primary-keys java

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 mrsuh.com: SQLite Index Visualization

SQLite Index Visualization (mrsuh.com)

274 points by mrsuh 1 year ago | 23 comments

Looks similar

SQLite improving performance with pre-sort(andersmurphy.com)

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

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

PostgreSQL and UUID as Primary Key(maciejwalkowiak.com)

Subtleties of SQLite Indexes(emschwartz.me)

SQLite Index Visualization(mrsuh.com)