SQLViewer

Browse and edit SQLite databases in the Lister via F3

SQLViewer is a Total Commander Lister plugin that shows the contents of an SQLite database when you press F3 on it. The database is opened read-only, tables and views are chosen from a drop-down list, and cells can be edited after confirmation. SQLite comes from the built-in Windows library winsqlite3.dll (Windows 10 and later), so nothing else needs to be installed.

Features

• Files are recognized by the SQLite format 3 header, the extension does not matter.
• A drop-down list with all tables, views and the sqlite_master schema.
• A virtual list, fast even for large tables (the first 500,000 rows of each table are loaded).
• Sorting by clicking a column header, aware of numbers; the # column restores the original order.
• BLOBs are shown as text if they look like text, otherwise as [BLOB n B] HEX…; NULL is shown explicitly.
• Ctrl+C copies the full cell value or the selected rows separated by tabs; the context menu offers the same actions.
• Cell editing (double click, F2 or Enter) in a multi-line editor with a Set NULL button; the database is opened for writing only after you confirm.
• Search with F7 across all rows of the current table, selectable list font.