SQLite Database (.db / .sqlite / .sqlite3)
.db.sqlite.sqlite3SQLite, mobile apps, embedded data loggers, desktop applications, and scientific acquisition databases
What it is
The standard embedded relational database format. AltaiPlot introspects the database, lists all contained tables, and imports the chosen table via Python's standard sqlite3 engine without requiring SQL knowledge.
Who produces it
Software engineers, instrument data loggers, GIS applications, and scientific pipelines storing structured relational records.
What we read / what we don't read
What we read
- Full database table introspection (listing all user tables)
- Interactive table picker when multiple tables exist
- Numeric (INTEGER, REAL), text (TEXT), and timestamp columns
- Sanitized queries guarded against SQL injection
What we don't read
- Binary BLOB columns (skipped to keep tabular plotting clean)
- Encrypted SQLite databases (e.g. SQLCipher)
- Complex dynamic SQL views relying on external C extensions
How to import it into AltaiPlot
- Open AltaiPlot and drag your .db, .sqlite, or .sqlite3 file onto the window, or use File → Import.
- AltaiPlot verifies the SQLite header and lists all tables available in the database.
- Pick the table you wish to visualize.
- Click Import to load all records into an AltaiPlot worksheet.
Auditability note: this page's capability claims are sourced fromresources/python/app_sidecar.py:1510 — see the full format list for every extension AltaiPlot recognizes.