SQLite is getting better with WAL, but still not that great compared to PostgreSQL.
RocksDB and DuckDB are looking pretty interesting. I'd be curious to see performance metrics on them.
Waethorn /
npub1ah…j6ee5
2024-08-19 18:25:33
in reply to nevent1q…58na
Author Public Key
npub1ahd4wv5s8uns8rpgefrmctarq3vepta8w8x086hdhpk4tk2tcl7qkj6ee5Published at
2024-08-19 18:25:33Event JSON
{
"id": "642d31f4a9189247344a39810dc32e193abc29306a406ef254e64ba580531c9e",
"pubkey": "eddb5732903f27038c28ca47bc2fa3045990afa771ccf3eaedb86d55d94bc7fc",
"created_at": 1724091933,
"kind": 1,
"tags": [
[
"e",
"67187f090c62859dd13b1571798f4f6198bc68586bb227bd734c28abbe8e3c5d",
"wss://freespeech.social/relay",
"root"
],
[
"e",
"1550920695715f1d7bc2ac5a42a4b442121be5137b75644347845371e154bae4",
"wss://freespeech.social/relay",
"reply"
],
[
"p",
"0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd"
],
[
"p",
"d58d6402f3a90dd89d51735753f93058225eb19abf4e8034512ff5a1bd0d3cfc"
]
],
"content": "SQLite is getting better with WAL, but still not that great compared to PostgreSQL. \n\nRocksDB and DuckDB are looking pretty interesting. I'd be curious to see performance metrics on them.",
"sig": "4c9f4a11f8e2b09044dcc363c66d1bfd23dee246a1c1242640bd03a3dc405b175d8c376d981076cdfd2b1c3c6a74db7c2a709192b32838fa1a4676b27e6a3012"
}