LIBRISTO
LIBROAMANTO
mandatory
Become part of a community of book lovers from all over the world and get access to a whole bunch of benefits. Create an account for free
0
Austrian Post 5.99 € GLS courier 5.49 € DPD courier 4.99 € DPD point 3.99 €

SQLite Beyond the Happy Path

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

Language EnglishEnglish
Book Paperback
Book SQLite Beyond the Happy Path Stas Kolod
Libristo code: 54579964
Publishers Independently published, November 2026
Make your SQLite application hold up when the easy path ends.A repeated request can consume capacity... Full description
? points 41 b Coming soon Coming soon New New
16.89 € VAT included
Delivery after Christmas ▾ Expected in stock Expected 24. 11. 2026
Austria Delivery to Austria

Up to 30 days for returns

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.

Actress & Polyglot
EWA KASP for
Play video
Ewa Kasp
Libristo has the largest selection of foreign-language books. That’s why I buy my books there.

About the book

Full name SQLite Beyond the Happy Path
Author Stas Kolod
Language English
Binding Book - Paperback
Date of issue 2026
Number of pages 112
EAN 9798144042529
Libristo code 54579964
Weight 148
Dimensions 152 x 229 x 7
Give this book today
It's easy
1 Add to cart and choose Deliver as present at the checkout 2 We'll send you a voucher 3 The book will arrive at the recipient's address

Login

Log in to your account. Don't have a Libristo account? Create one now!

 
mandatory
mandatory

Don’t have an account? Discover the benefits of having a Libristo account!

With a Libristo account, you'll have everything under control.

Create a Libristo account
Book advisor Libroamiko
Hi, I'm Libroamiko, can I help?