Savepoints (SQLite)
https://www.sqlite.org/lang_savepoint.htmlSavepoints can be used in many places transactions can, but have the benefit of nesting. This is particularly handy when you are building an application, where you might want to have (for example) a utility function that is an atomic transaction when used on it's own, but is not a full transaction when used as part of some bigger process - savepoints handle the nesting of transactions.
Tags
Related By Tags
- 🔗 Duckdb - an embedded analytics database
- 🔗 Pragma statements supported by SQLite
- 🔗 Getting Started - Litestream
- 🔗 Simple declarative schema migration for SQLite
- 🔗 SQLite: Past, Present, and Future
- 🔗 Datasette — Datasette documentation
- 🔗 Fast Dictionary-Based Compression for Inverted Indexes | Proceedings of the Twelfth ACM International Conference on Web Search and Data Mining
- 🔗 ClickHouse Playground
- 🔗 Some SQL Tricks of an Application DBA | Haki Benita
- 🔗 Game UI Database | Welcome
Details
- Revised
- Created
- Edited