Yunqa • The Delphi Inspiration

Delphi Components and Applications

User Tools

Site Tools


wiki:sqlitespy:index

This is an old revision of the document!


SQLiteSpy: Wiki

Please register and / or log in to edit. Anonymous Wiki edits are disabled to protect against vandalism.

Delphi Components used in SQLiteSpy

  • Unicode support is realized Delphi's native Unicode controls (formerly Tnt Unicode Controls).
  • Data grid and the schema treeview are implemented as TVirtualStringTree descendants.
  • Modern tabs are displayed by JVCL TJvTabBar (formerly with added Unicode support).
  • SynEdit (formerly UniSynEdit) and a customized SQLite3 highlighter bring SQL Unicode syntax highlighting to SQLiteSpy.

Feature Suggestions

  • No auto-save on exit. There is the Read-only option, but any modification is auto-saved on exit which may be problematic, especially for beginners who aren't aware and expect a save confirmation on exit and possibly a save item in the menu.
  • Command-line version of the SQLiteSpy's SQLite engine (including math/regexp functions etc) with the ability to read from stdin or to be used as a shell.
  • Support of “INSTEAD OF” triggers in views, to allow cell editing (F2) of corresponding view columns
  • CSV export and import.
  • Create / Modify / Delete Tables by Wizard
  • Create / Modify / Delete Views by Wizard
  • Create / Modify / Delete Triggers by Wizard
  • Use external SQLite DLL (for custom SQLite builds).
A SQLiteSpy version which uses an external sqlite3.dll as external database engine is available from the author upon request.
  • Add a command-line option to also open a given text file in the editor (on top of the existing param for opening a given DB).
  • On File Menu, 'Vaccuum Database'.
VACUUM DATABASE is available as a menu command at Menu → Execute → Vacuum Database.
wiki/sqlitespy/index.1614438020.txt.gz · Last modified: 2021/02/27 16:00 by zorro