Effective Oracle by design
by Thomas Kyte · first published 2003
2mentions
1recommended by
2HN commenters
2016–2021first – last mentioned
50% recommend50% neutral
Affiliate links. As an Amazon Associate I earn from qualifying purchases.
1. Godel, Escher, Bach -- Because it sparked my interest and got me started down the path. 2. The Pragmatic Programmer -- a classic. Reminds me that I need to re-read it. 3. Effective Oracle by Design, by Tom Kyte -- Not that I use Oracle any more, thankfully, but really provided a lot of insight about how databases function and how it pays to deeply understand their internals when writing webapps.
on “Ask HN: What three books impacted your career the most?” ↗…difficult to implement. The hardest part is actually making sure #devops are aware of the concept ! Tom Kyte, he of Oracle fame had a particularly good discussion of the concept in one of his books (Effective Oracle by Design ... IIRC). IIRC, the Oracle way is to enable rowdependencies for the table(s) in question and then use ora_rowscn. But in reality, you can use almost anything that changes in a defined fashion (timestamps,…
on “Adding Optimistic Locking to an API” ↗