rcoder on Nostr: SQLite is always going to be faster for the same simple, ...
SQLite is always going to be faster for the same simple, single-writer/local-readers-only usage patterns b/c there's no network overhead. Postgres comes into its own with more write contention, or if you want access to the richer datatypes + extension ecosystem.
Published at
2022-07-18 22:09:19Event JSON
{
"id": "20931a047937db2a5e603736acc7c480248633571e41b51c37dbaee75eeb3bee",
"pubkey": "e4c47aedea8ea54255f5ba07a77053b24553e9b975435e56da343da19aec7881",
"created_at": 1658182159,
"kind": 1,
"tags": [
[
"p",
"40e162e0a8d139c9ef1d1bcba5265d1953be1381fb4acd227d8f3c391f9b9486"
],
[
"p",
"46fcbe3065eaf1ae7811465924e48923363ff3f526bd6f73d7c184b16bd8ce4d",
"wss://nostr-pub.wellorder.net"
],
[
"e",
"c5270ca814b4d10d0bbb640cad769ce245f64df43dde7c10a5ea0be5c7a4f932"
],
[
"e",
"f345286ce45adf06e0cd4bf4b90d69abfa2aaa828de3b63c9ea81751b4a614ad"
]
],
"content": "SQLite is always going to be faster for the same simple, single-writer/local-readers-only usage patterns b/c there's no network overhead. Postgres comes into its own with more write contention, or if you want access to the richer datatypes + extension ecosystem.",
"sig": "1b7080a4d53248ae35ba6911a7142ffa04d61ca4d58382c41ca3d39cbfbdfb6ff05e62824b314f31852ed33335d2d28fd4230d4d57636025007fde9398a337fa"
}
