bert hubert 🇺🇦🇪🇺 on Nostr: Been reading up on SQL transaction isolation levels, and wow, is this a world of ...
Been reading up on SQL transaction isolation levels, and wow, is this a world of pain. Surprising find, SQLite, often incorrecty derided as 'not a real database' defaults to a more stringent transaction model ('serializable') than PostgreSQL ('read committed'). However, PostgreSQL supports serializable as well. And if you are experiencing problems with SQLite's serializable mode, this PostgreSQL page has useful tips on that mode:
https://www.postgresql.org/docs/current/transaction-iso.htmlPublished at
2025-02-15 15:04:53Event JSON
{
"id": "b2e774f294d5a5b6cb290e8254fc5d0aa224b252ef808ed40953d4f91ce0a15e",
"pubkey": "b2a729af72f53eaf7a64944a3b4fcc1a5c4e4476852b80513bf405183c484187",
"created_at": 1739631893,
"kind": 1,
"tags": [
[
"proxy",
"https://fosstodon.org/users/bert_hubert/statuses/114008515788062848",
"activitypub"
]
],
"content": "Been reading up on SQL transaction isolation levels, and wow, is this a world of pain. Surprising find, SQLite, often incorrecty derided as 'not a real database' defaults to a more stringent transaction model ('serializable') than PostgreSQL ('read committed'). However, PostgreSQL supports serializable as well. And if you are experiencing problems with SQLite's serializable mode, this PostgreSQL page has useful tips on that mode: https://www.postgresql.org/docs/current/transaction-iso.html",
"sig": "dd35417ec731aefc993169a8587fcbc47a60b414b57480c0a50c54b330ec2dd689e27ed85cf78352c43821de1b3b4d35cae14ab5df1c4c2dcb79d9e56ab0ec38"
}
