rcoder on Nostr: Once upon a time you'd have to move on from SQLite if you wanted to be able to ...
Once upon a time you'd have to move on from SQLite if you wanted to be able to survive node failure w/o data loss, but with stuff like Litestream and Verneuil out there it's a much smaller gap now. Postgres still does rich data types (JSON, GIS, probablistic structures) better.
Published at
2022-07-18 22:11:20Event JSON
{
"id": "d9ba4f7ef1b40d06d9d0d85a21647a3a7ab5e8a6fd617d8333e56aed593ca220",
"pubkey": "e4c47aedea8ea54255f5ba07a77053b24553e9b975435e56da343da19aec7881",
"created_at": 1658182280,
"kind": 1,
"tags": [
[
"p",
"46fcbe3065eaf1ae7811465924e48923363ff3f526bd6f73d7c184b16bd8ce4d",
"wss://nostr-pub.wellorder.net"
],
[
"p",
"40e162e0a8d139c9ef1d1bcba5265d1953be1381fb4acd227d8f3c391f9b9486"
],
[
"e",
"c5270ca814b4d10d0bbb640cad769ce245f64df43dde7c10a5ea0be5c7a4f932"
],
[
"e",
"20931a047937db2a5e603736acc7c480248633571e41b51c37dbaee75eeb3bee",
"wss://relay.damus.io"
]
],
"content": "Once upon a time you'd have to move on from SQLite if you wanted to be able to survive node failure w/o data loss, but with stuff like Litestream and Verneuil out there it's a much smaller gap now. Postgres still does rich data types (JSON, GIS, probablistic structures) better.",
"sig": "bd0bec4a360b5f25cc45be72db9c48e300215071f768feeaae708e1cd641ec4e0821169887289d04a3e44c5032553178a84c6ae87e745a5f62f5cd7eaaa0c2b9"
}
