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
- 🔗 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
- 🔗 Citus 10: Columnar for Postgres, rebalancer, single-node, & more
- 🔗 Hosting SQLite databases on Github Pages - (or any static file hoster) - phiresky's blog
Details
- Revised
- Created
- Edited