Comments (1)
Hey Bruno, sorry for the really late reply on this!
Good question, and thank you for reading!
I've been reading about isolation levels lately. But it's all theoretical - just showing DB features. Meaningful examples, how to apply those DB features to applications, are scarce.
If you have a resource (blog, book, something else) to recommend on this topic in the vein of your article linked above I'd be grateful!
I wish I had something better for you here, but I'd still reference the Postgres docs on isolation levels as the best canonical source of reading around.
There are a few other decent blog posts online, but like those docs they tend to focus more on the technical aspect of isolation levels than how to build applications with them (and you've probably read them). Two I'd call out from large-ish companies are:
- "Cross shard transactions at 10 million requests per second" https://dropbox.tech/infrastructure/cross-shard-transactions-at-10-million-requests-per-second
- "Why you should pick strong consistency, whenever possible" https://cloud.google.com/blog/products/gcp/why-you-should-pick-strong-consistency-whenever-possible
I've been looking for a book that covers this kind of thing in detail, but haven't found one to date. My hypothesis is that the intersection between know how on isolation levels and people that practically architecture apps is a far smaller specialization than you'd hope. There are a lot of technical database people who know about isolation levels and not much about building applications, and there are a lot of people who build applications and who don't know much about their underlying databases, but people (and by extension published material) with significant experience in both are relatively rare.
Anyway, going to close this out for now, but let me know if you find something!
from sorg.
Related Issues (20)
- Question: pool HOT 4
- — is not being displayed as – HOT 1
- Learning from Terminals...: Have you tried Emacs? HOT 2
- release HOT 3
- Theme for hugo HOT 4
- HTTP Transactions: Why not queue the jobs after the user record is successfully created? HOT 4
- API versioning HOT 1
- HTTP transactions: questions on performance and correctness HOT 1
- Broken URL with parentheses HOT 1
- Missing image for Tenet HOT 1
- ffmpeg-h265 quicktime playback of 5.1 aac HOT 2
- Idempotency keys: using a completer might be unexpected to the client HOT 3
- Add dark theme HOT 1
- Why not use check constraints? HOT 1
- Unable to horizontally scroll code blocks on mobile HOT 4
- Feature Casualties of Large Databases: test suite for checking indices HOT 6
- Transactionally Staged Job Drains in Postgres - Sidekiq extension HOT 3
- Memory leak in "A simple HTTP retry and backoff loop in Go" HOT 2
- Close defer snippet incorrect for http retry? HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sorg.