#SQLite
5 posts tagged SQLite. All posts
Python's sqlite3 module: row factories, transactions, WAL and adaptersPractical sqlite3 for Python 3.12+: sqlite3.Row, what with conn really does, the autocommit attribute, executemany, WAL mode, date adapters and threads.
Idempotent ETL jobs: watermarks, upserts and safe rerunsBuild an incremental extract-and-load job that can run twice without harm: high-watermarks, an overlap window for late rows, SQLite upserts and run ids.
Explicit resource management in TypeScript with using and await usingHow using and await using work in TypeScript: Symbol.dispose, DisposableStack, tsconfig settings, Node 24 support, plus temp directory and SQLite transaction examples.
Retrieval-augmented generation from scratch with SQLiteBuild RAG in about 130 lines of Python: chunk Markdown, embed it locally, store vectors in SQLite, search by cosine similarity and get cited answers from Claude.
A REST API in Rust with Axum 0.8 and SQLxBuild a small todo API with Axum 0.8 and SQLx on SQLite: routing with /{id} paths, State and Json extractors, migrations, an error type, and oneshot tests.
© 2026 David Li · Home · Blog · RSS ·Classic site · Built with Astro, Starlight and three.js · Logos:Font Awesome Free (CC BY 4.0)