A local Python desktop app for editing SQLite tables in a spreadsheet-like grid, with live CSV mirroring.
python -m venv .venv
.\.venv\Scripts\Activate.ps1
pip install -r requirements.txtpython main.pyOn first launch, the app creates runtime data under:
data/database.sqlite
data/csv/<table_name>.csv
When you open or create another database, its CSV mirror is stored beside it:
example.sqlite
example_csv/<table_name>.csv
SQLite is the source of truth. CSV files are regenerated after successful table edits.
- Open or create SQLite database files.
- Create, rename, rebuild, and delete tables.
- Add, rename, delete, drag, and multi-select rows/columns.
- Edit and empty selected cells.
- Search with highlight or row filtering.
- Switch CSV preview between raw highlighted text and read-only table mode.
- View the persistent change log and use common undo/redo.
python -m unittest discover