DEV Community

Serializable Isolation Level in SQL Databases Series' Articles

Back to Franck Pachot's Series
A brief example of an SQL serializable transaction
franckpachot profile

A brief example of an SQL serializable transaction

#yugabytedb #postgres #oracle #database
26
Comments 13
7 min read
You Probably Don't Need Serializable Isolation
franckpachot profile

You Probably Don't Need Serializable Isolation

#yugabytedb #postgres #oracle #database
6
Comments
4 min read
The Doctor's On-Call Shift example and a Normalized Relational Schema to Avoid Write Skew
franckpachot profile

The Doctor's On-Call Shift example and a Normalized Relational Schema to Avoid Write Skew

#yugabytedb #postgres #oracle #database
3
Comments 3
7 min read
Indexing for a Scalable Serialization Isolation Level
Cover image for Indexing for a Scalable Serialization Isolation Level
franckpachot profile

Indexing for a Scalable Serialization Isolation Level

#sql #yugabytedb #postgres #database
4
Comments 2
5 min read
No Gap Ordered Numbering in SQL: A Unique Index to Serialize In Read Committed
franckpachot profile

No Gap Ordered Numbering in SQL: A Unique Index to Serialize In Read Committed

#yugabytedb #distributed #postgres #database
Comments
5 min read
Document data modeling to avoid write skew anomalies
Cover image for Document data modeling to avoid write skew anomalies
franckpachot profile

Document data modeling to avoid write skew anomalies

#yugabytedb #distributed #postgres #json
19
Comments 5
4 min read
The Doctor's On-Call Shift solved with SQL Assertions
franckpachot profile

The Doctor's On-Call Shift solved with SQL Assertions

#oracle #sql #assertion #consistency
2
Comments 1
7 min read
Serializable Transactions in MongoDB: The Doctor's On-Call Shift example
Cover image for Serializable Transactions in MongoDB: The Doctor's On-Call Shift example
franckpachot profile

Serializable Transactions in MongoDB: The Doctor's On-Call Shift example

#mongodb #acid #document #database
Comments
6 min read
Avoiding range overlaps in PostgreSQL with EXCLUDE constraint, better than serializable or assertions
franckpachot profile

Avoiding range overlaps in PostgreSQL with EXCLUDE constraint, better than serializable or assertions

#postgres #oracle #sql #database
Comments 1
12 min read