Könyv SQLite Beyond the Happy Path Stas Kolod

SQLite Beyond the Happy Path

Build Reliable Local Applications with Constraints, Transactions, and Tested Recovery

Szerző: Stas Kolod
Nyelv: Angol
Kötés: Puha kötésű
Elérhetőség: Várható készletfeltöltés
Küldés 23. 11. 2026
6 462 Ft
Nem kézbesítjük karácsonyig
Make your SQLite application hold up when the easy path ends.A repeated request can consume capacity...

Információk a könyvről

Szerző
Nyelv
Angol
Kötés
Könyv - Puha kötésű
Kiadva
2026
oldal
112
EAN
9798144042529
Enbook ID
54579964
Súly
148
Méretek
152 x 229 x 7

Teljes leírás

Make your SQLite application hold up when the easy path ends.

A repeated request can consume capacity twice. An interrupted operation can leave related records out of step. A backup can open successfully and still contain the wrong application state.

SQLite Beyond the Happy Path teaches you to prevent and detect these failures through Cedar Workshop, a small Python application for managing workshop bookings. Each exercise gives you a defined starting state, an operation to challenge, and results you can inspect.

Build stronger database operations.

Use constraints and explicit transactions to keep seat counts, bookings, and event history consistent. Preserve request identities across retries, cancel without erasing history, and use savepoints to reject failed work within an import.

Practice recovery you can verify.

Observe competing writers and stale WAL snapshots. Interrupt a process before and after commit, test schema changes as one operation, and restore a backup into a separate database. Learn why structural integrity checks must be supported by checks of your application's own rules.

For developers who know basic Python and SQL.

The exercises run locally with Python's standard library. Complete core source code, expected results, and a final acceptance exercise help you connect the techniques and apply the testing method to your own local applications.