Nostr database benchmark SQLite vs Postgres.

Nostr database benchmark SQLite vs Postgres.

Wow thanks! I was doing similar tests. Are you using sqlite or something like better-sqlite3?
wow. not what i expected
Sqlite is a beast!
Are you using ‘sqlite3’ or ‘better-sqlite3’?
If you enable write ahead logging better-sqlite3 is about an order of magnitude faster.
I’ve also heard that Bun’s built in bindings are even faster than better-sqlite3 but I haven’t tested it myself
Is the test big enough? How many rows are in the tables?
Why have you excluded MariaDB?