dbinspect_sqflite 0.1.0

A sqflite adapter for dbinspect_bridge, so a desktop client can browse your app's SQLite databases while it runs.

Changelog

0.1.0

First release. The sqflite / SQLite adapter for dbinspect_bridge.

• Stores from sqlite_master, schema from PRAGMA table_info, paging with LIMIT/OFFSET. Blobs truncated at 64 KB.
• Filtering and sorting, and rawQuery behind a single-statement read-only gate.
• Writes — insertRow, updateRow, deleteRow — opt-in per adapter and refused unless you ask for them.
• Written against DatabaseExecutor, so it depends on sqflite_common and no Flutter plugin.
• Transactions (docs/PROTOCOL.md §3.1), when the adapter was given a Database rather than a bare DatabaseExecutor — an executor is already inside one. Reported as capabilities.transactions so a client knows before the keystroke. It holds SQLite's write lock while open, which is what a transaction is; the protocol's idle timeout and rollback-on-close are the guard around that.