simonw

simonw / sqlite-history-json

Public

SQLite table history tracking using a JSON audit log

20
0
100% credibility
Found Feb 09, 2026 at 12 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
Python
AI Summary

A Python library that automatically records all inserts, updates, and deletes on SQLite tables into a JSON audit log for viewing history and restoring past states.

How It Works

1
💡 Discover the history keeper

You have a simple database file where you store important info like inventory or customer lists, and you worry about losing track of changes over time.

2
📦 Get the tool

You add this handy history tool to your Python setup so it can watch your database.

3
🔗 Open your database

You open your database file in your Python script, ready to start protecting your data.

4
✅ Turn on tracking

With one simple command, you activate history recording for your favorite table, and it automatically snapshots everything right now.

5
✏️ Make changes freely

Now whenever you add, update, or remove items in that table, every change gets safely logged with timestamps.

6
Explore or rewind
📜
Check the log

See a list of all changes, who changed what and when, grouped if done in batches.

⏪
Restore old version

Create a copy of the table as it was at any exact time or after a specific change.

🎉 Data always safe

Your information is now protected with a complete rewindable history, giving you peace of mind forever.

Sign up to see the full architecture

5 more

Sign Up Free

Star Growth

See how this repo grew from 12 to 20 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is sqlite-history-json?

sqlite-history-json is a Python library for SQLite that automatically tracks table changes in a JSON audit log, capturing inserts, updates, and deletes with timestamps. You enable it on any table with a primary key, query history via API or CLI, and restore snapshots to exact timestamps or versions—even swapping the live table. It solves the pain of manual auditing in SQLite apps, giving you full table history without external tools.

Why is it gaining traction?

It beats basic logging with self-contained restores that replay history precisely, plus change groups for batch ops like migrations. The CLI handles sqlite table list history, row-specific views, and restores to new DBs, making it a quick sqlite github python win over verbose alternatives. Devs hook on the atomic setup and support for compound keys or tricky sqlite table names.

Who should use this?

SQLite backend devs auditing user data in web apps or tools needing compliance history. Analysts using sqlite table viewer CLI to track schema evolutions or sqlite table size changes over time. Prototypers ditching complex CDC for simple sqlite table exists checks with built-in audit trails.

Verdict

Solid pick for SQLite audit needs—excellent docs, CLI, and tests—but 12 stars and 1.0% credibility score signal early maturity; test thoroughly before prod. Ideal sqlite github mirror companion for history dives.

(198 words)

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.