How SELECT FOR UPDATE Works | HARIL
Here are some things to keep in mind when dealing with the select for update syntax in PostgreSQL.| haril.dev
Database Remote-Copy Tool For SQLite| www.sqlite.org
Transaction| www.sqlite.org
Small. Fast. Reliable.| www.sqlite.org
@tef @bert_hubert@fosstodon.org There may be some use cases where REPEATABLE READ arguably is better than SERIALIZABLE, but I think most of the time it makes sense to either use READ COMMITTED or SERIALIZABLE, given that RR already requires retry handling for transient errors. The main reason to use RR over S is lower overhead for read heavy workloads, but I think most of the time using READ ONLY DEFERRABLE is preferable.| mastodon.social
Here are some things to keep in mind when dealing with the select for update syntax in PostgreSQL.| haril.dev
13.2. Transaction Isolation # 13.2.1. Read Committed Isolation Level 13.2.2. Repeatable Read Isolation Level 13.2.3. Serializable Isolation Level The SQL standard …| PostgreSQL Documentation
READ COMMITTED| dev.mysql.com
Result and Error Codes| www.sqlite.org
Write-Ahead Logging| www.sqlite.org
