This extension lets you edit SQLite files without having to write SQL queries, a feature that is not available in any other extensions.
IMPORTANT: This extension requires Python >=3.6 compiled with SQLite >=3.37.0 (fully supported) or >=3.8.8 (partially supported). The extension will tell you if the requirements are not met.
Spreadsheet GUI for Browsing and Editing Data
This extension offers several advantages over other extensions:
Advanced Query Editor
Although this extension was created to fill the need for an extension that could intuitively edit SQLite databases using a GUI, it also has an advanced query editor with auto completion, syntax highlighting, hover information, and signature help.
This extension also includes a find widget that enables you to filter records using regex, whole word, and case-sensitivity switches, making data searching faster than using the query editor to write WHERE clauses.
*1: To edit data through a view or a custom query, you need to build a helper program to access the SQLite C/C++ interface. Everything else works fine without the helper program.
This extension recognizes
This extension displays a "Send error report" button on error notifications. When clicked, it sends the error message with sensitive information removed to the extension's author using Microsoft/vscode-extension-telemetry, or opens a GitHub issue, depending on the user's telemetry settings. If vscode-extension-telemetry is used, the system information (i.e. the "common properties" of Microsoft/vscode-extension-telemetry) will also be included. Keep in mind that the bugs may not be fixed if the reports do not include enough information or the developer is busy, but your help in reporting errors is greatly appreciated.