poka.sh

 Docs

SQLITE3

Generated by scripts/gen-format-pages.py from docs/data/format-metadata/, FILE_FORMATS.csv and docs/formats-master.csv. Do not edit by hand: change the source, then run the script.

Sqlite Preview.

At a glance
Original creator D. Richard Hipp
First published 2004
Purpose The SQLite 3 database file under its longer extension; the same format as .sqlite.
Extensions .sqlite, .sqlite3
Poka parser poka-sqlite
Viewer poka-tree-viewer
Depth tier Parser with a shared viewer (see Depth tiers)
Breadth tier B4 Summary (see Breadth tiers)

How much Poka reads

B4 Summary. The container and metadata are read and summarised (counts, properties, structure), but the main content is not rendered.

Confidence: high (the reviewer read the code and a test that proves the claim). Basis: Reviewed 2026-10-16: same parser as .sqlite (poka-sqlite claims .sqlite3 as an alias in plugin.json, so the viewer and AST are identical); tests/samples.rs runs both extensions (corpus: pyinstaller_django_db.sqlite3). Same coverage and gaps as SQLITE. Covers SQLite 3 files with UTF-8 text.

What Poka does not read

  • No table rows or cell values are shown
  • Databases with UTF-16 text encoding have schema names read as UTF-8 and so garbled
  • Overflow pages are not followed, so very long CREATE statements are cut
  • Row counts for WITHOUT ROWID tables read as 0 (index b-tree pages are not walked)
  • Index columns, foreign keys, constraints and view or trigger bodies are not shown
  • Write-ahead log (WAL) content is not applied
  • Row counting stops at 1000000 rows; tree capped at 3000 nodes

Background

Same format and same parser as .sqlite: poka-sqlite claims .sqlite3 as an alias. See the SQLite page for history and what Poka reads.

Versions

Version Identifier Poka Note
SQLite 3 SQLite format 3\0 Partly read As for .sqlite: the tree stops at 3,000 nodes, a UTF-16 database is read as UTF-8, and a WITHOUT ROWID table reports 0 rows.

Libraries

Libraries Poka uses or has assessed for this format, with the status, licence and language the registry records.

Sources