---
title: "#sqlite articles | Hashnode"
description: "SQLite is a relational database management system contained in a C programming library. In contrast to many other database management systems, SQLite is not..."
url: "https://hashnode.com/tag/sqlite"
---

Tag

# #sqlite

461 posts · 2,498 followers

[HaoJie Luo (Fone)](https://hashnode.com/@imminer668) · [8h ago](https://hashnode.com/posts/review-an-order-retry-flow-before-accepting-a-checkout-handover/6afb2157d2bdb7937c0df729)

### [Review an Order Retry Flow Before Accepting a Checkout Handover](https://0xfone.hashnode.dev/review-an-order-retry-flow-before-accepting-a-checkout-handover?utm_source=hashnode&utm_medium=feed)

Run a Python and SQLite example to check lost responses, conflicting retries, concurrency and restart recovery before accepting a checkout handover.

3 min read · [0xfone.hashnode.dev](https://0xfone.hashnode.dev/review-an-order-retry-flow-before-accepting-a-checkout-handover?utm_source=hashnode&utm_medium=feed)

[Nursier](https://hashnode.com/@nursier) · [15h ago](https://hashnode.com/posts/build-a-local-first-study-tracker-with-python-and-sqlite-review-queues-mistake-logs-and-tests/6afabf2ed1a53d0a83d4fe45)

### [Build a Local-First Study Tracker with Python and SQLite: Review Queues, Mistake Logs, and Tests](https://nursier-blog.hashnode.dev/build-a-local-first-study-tracker-with-python-and-sqlite-review-queues-mistake-logs-and-tests?utm_source=hashnode&utm_medium=feed)

Build a local-first study tracker with Python and SQLite, including review scheduling, mistake tracking, parameterized queries, and unit tests.

15 min read · [nursier-blog.hashnode.dev](https://nursier-blog.hashnode.dev/build-a-local-first-study-tracker-with-python-and-sqlite-review-queues-mistake-logs-and-tests?utm_source=hashnode&utm_medium=feed)

[Kasim Rangwala](https://hashnode.com/@kasim1011) · [1d ago](https://hashnode.com/posts/money-in-sqlite-building-an-offline-first-expense-tracker-with-expo/6af9babf7664253e4754dff2)

### [Money in SQLite: building an offline-first expense tracker with Expo](https://getspendwise.hashnode.dev/money-in-sqlite-building-an-offline-first-expense-tracker-with-expo?utm_source=hashnode&utm_medium=feed)

Schema migrations, integer minor units, one scope predicate, and a hand-written XLSX writer.

7 min read · [getspendwise.hashnode.dev](https://getspendwise.hashnode.dev/money-in-sqlite-building-an-offline-first-expense-tracker-with-expo?utm_source=hashnode&utm_medium=feed)

[ZyVOP](https://hashnode.com/@zyvop) · [1d ago](https://hashnode.com/posts/your-api-key-doesn-t-know-when-to-stop-building-a-spend-kill-switch-in-an-afternoon-4hg8s/6af96bc635f860a258a948ec)

### [Your API Key Doesn't Know When to Stop: Building a Spend Kill-Switch in an Afternoon](https://blog.zyvop.com/your-api-key-doesn-t-know-when-to-stop-building-a-spend-kill-switch-in-an-afternoon-4hg8s?utm_source=hashnode&utm_medium=feed)

A tiny local proxy that holds your API key, tracks cost per script, and shuts the tap when a loop goes wrong, in under 200 lines of Python.

12 min read · [blog.zyvop.com](https://blog.zyvop.com/your-api-key-doesn-t-know-when-to-stop-building-a-spend-kill-switch-in-an-afternoon-4hg8s?utm_source=hashnode&utm_medium=feed)

[Aswani Kumar](https://hashnode.com/@ashwin31) · [2d ago](https://hashnode.com/posts/how-to-auto-grade-sql-exercises-against-a-real-sqlite-database/6af8951fc5d2ed68bb8c0247)

### [How to auto-grade SQL exercises against a real SQLite database](https://ashwin31.hashnode.dev/how-to-auto-grade-sql-exercises-against-a-real-sqlite-database?utm_source=hashnode&utm_medium=feed)

Grade students' SQL queries by running each one on the same SQLite database and comparing rows: a 40-line Python grader and five traps to avoid.

10 min read · [ashwin31.hashnode.dev](https://ashwin31.hashnode.dev/how-to-auto-grade-sql-exercises-against-a-real-sqlite-database?utm_source=hashnode&utm_medium=feed)

[Tristan Manchester](https://hashnode.com/@tristanmanchester) · [2d ago](https://hashnode.com/posts/how-gravity-sync-keeps-both-versions-of-your-note/6af851c87342a46cfb1ce40c)

### [How Gravity Sync keeps both versions of your note](https://gravitynotes.hashnode.dev/how-gravity-sync-keeps-both-versions-of-your-note?utm_source=hashnode&utm_medium=feed)

One SQLite database per library, operations instead of states, and a test suite that tries to break it.

9 min read · [gravitynotes.hashnode.dev](https://gravitynotes.hashnode.dev/how-gravity-sync-keeps-both-versions-of-your-note?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/how-gravity-sync-keeps-both-versions-of-your-note/6af851c87342a46cfb1ce40c)

[Tristan Manchester](https://hashnode.com/@tristanmanchester) · [2d ago](https://hashnode.com/posts/how-i-took-gravity-s-search-from-0-to-99/6af85242e72c3fafbf538785)

### [How I took Gravity's search from 0% to 99%](https://gravitynotes.hashnode.dev/how-i-took-gravity-s-search-from-0-to-99?utm_source=hashnode&utm_medium=feed)

A 200-case search eval, a 17 MB embedding model, and one search contract for iPhone, Android, Mac, the CLI and Claude.

21 min read · [gravitynotes.hashnode.dev](https://gravitynotes.hashnode.dev/how-i-took-gravity-s-search-from-0-to-99?utm_source=hashnode&utm_medium=feed)

[SpinHire](https://hashnode.com/@spinhire) · [4d ago](https://hashnode.com/posts/sqlite-wal-in-production/6af5d7770e01b51e59f7f698)

### [SQLite in WAL mode in production: the backup that corrupted our database on every deploy](https://spinhire.hashnode.dev/sqlite-wal-in-production?utm_source=hashnode&utm_medium=feed)

Three pragmas, one innocent cp, and why the online backup API is the only safe way to copy a live SQLite file

7 min read · [spinhire.hashnode.dev](https://spinhire.hashnode.dev/sqlite-wal-in-production?utm_source=hashnode&utm_medium=feed)

[ZyVOP](https://hashnode.com/@zyvop) · [4d ago](https://hashnode.com/posts/link-rot-is-quietly-hurting-your-blog-build-a-dead-link-checker-in-python-hbjv8/6af52e2e84eb1584f775060b)

### [Link Rot Is Quietly Hurting Your Blog: Build a Dead-Link Checker in Python](https://blog.zyvop.com/link-rot-is-quietly-hurting-your-blog-build-a-dead-link-checker-in-python-hbjv8?utm_source=hashnode&utm_medium=feed)

A polite, cached link checker that finds broken outbound links, ignores false alarms, and sends one weekly report.

24 min read · [blog.zyvop.com](https://blog.zyvop.com/link-rot-is-quietly-hurting-your-blog-build-a-dead-link-checker-in-python-hbjv8?utm_source=hashnode&utm_medium=feed)

[6](https://hashnode.com/posts/link-rot-is-quietly-hurting-your-blog-build-a-dead-link-checker-in-python-hbjv8/6af52e2e84eb1584f775060b)

[Coding-Dev-Tools](https://hashnode.com/@coding-dev-tools) · [4d ago](https://hashnode.com/posts/one-memory-store-several-agents-wiring-codex-cursor-and-claude-code-to-the-same-scoped-store/6af5627f6d4be7247c685530)

### [One memory store, several agents: wiring Codex, Cursor and Claude Code to the same scoped store](https://engraphis.hashnode.dev/one-memory-store-several-agents-wiring-codex-cursor-and-claude-code-to-the-same-scoped-store?utm_source=hashnode&utm_medium=feed)

How to give Codex, Cursor and Claude Code one scoped local memory store: decisions, temporal history, citations, and abstention.

4 min read · [engraphis.hashnode.dev](https://engraphis.hashnode.dev/one-memory-store-several-agents-wiring-codex-cursor-and-claude-code-to-the-same-scoped-store?utm_source=hashnode&utm_medium=feed)
