Sqlthon – A lightweight Pythonic layer for SQLite

Sqlthon is a compact Python wrapper around SQLite3 that provides a more Pythonic API for defining schemas, inserting data, and querying a local SQLite database. It exposes a Connect context manager for opening databases, a Field object for building query conditions with standard Python operators, and a set of type/constraint keywords (e.g., INT, STR, PRIMARY_KEY, AUTO_INCREMENT, NOT_NULL, UNIQUE) to declare table columns. Installation is via pip and full usage docs are hosted on Read the Docs.

The repository contains a small codebase and documentation (docs, src/sqlthon, README, mkdocs configuration, and pyproject), with a history of 75 commits. Core operations shown in examples include add_table to define tables, add_record to stage rows, save_to_database to persist changes, and find_record to retrieve rows based on Field-based conditions. The project aims for simplicity and quick integration for projects that need lightweight SQLite access without a heavy ORM. Repository activity and community traction are minimal (one star, no forks), so users should review the docs and code for production readiness.