Yunqa • The Delphi Inspiration

Delphi Components and Applications

User Tools

Site Tools


wiki:sqlitespy:index

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
wiki:sqlitespy:index [2021/02/27 16:00]
zorro [Feature Suggestions]
wiki:sqlitespy:index [2021/03/27 13:23] (current)
admin
Line 6: Line 6:
 ===== Delphi Components used in SQLiteSpy ===== ===== Delphi Components used in SQLiteSpy =====
  
-  * Unicode support is realized Delphi's native Unicode controls (formerly [[products:tntunicodecontrols:|Tnt Unicode Controls]]). 
   * Data grid and the schema treeview are implemented as [[https://github.com/Virtual-TreeView/Virtual-TreeView/|TVirtualStringTree]] descendants.   * Data grid and the schema treeview are implemented as [[https://github.com/Virtual-TreeView/Virtual-TreeView/|TVirtualStringTree]] descendants.
   * Modern tabs are displayed by JVCL TJvTabBar (formerly with added Unicode support).   * Modern tabs are displayed by JVCL TJvTabBar (formerly with added Unicode support).
   * [[https://github.com/SynEdit/SynEdit|SynEdit]] (formerly UniSynEdit) and a customized SQLite3 highlighter bring SQL Unicode syntax highlighting to SQLiteSpy.   * [[https://github.com/SynEdit/SynEdit|SynEdit]] (formerly UniSynEdit) and a customized SQLite3 highlighter bring SQL Unicode syntax highlighting to SQLiteSpy.
- 
  
 ===== Feature Suggestions ===== ===== 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.   * 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.
 +    * The SQLite database engine does not know the idea of "save on exit". It writes all database changes directly to disk by default. One way to prevent this is to execute ''BEGIN TRANSACTION;'' before other SQL commands. When done, and before closing SQLiteSpy, execute ''COMMIT TRANSACTION;'' to save your changes.
  
   * 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.   * 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.
Line 20: Line 19:
   * Support of "INSTEAD OF" triggers in views, to allow cell editing (F2) of corresponding view columns   * Support of "INSTEAD OF" triggers in views, to allow cell editing (F2) of corresponding view columns
  
-  * CSV export and import.+  * CSV import and export: 
 +    * For CSV import, use the [[https://sqlite.org/csv.html|CSV extension]]. Example: <code sql> 
 +CREATE VIRTUAL TABLE temp.t1 USING csv(filename='thefile.csv'); 
 +SELECT * FROM t1; 
 +</code> 
 +    * CSV export is not yet supported. The clipboard can be a workaround: Select rows, copy, and paste into a spreadsheet application.
  
   * Create / Modify / Delete Tables by Wizard   * Create / Modify / Delete Tables by Wizard
Line 29: Line 33:
  
   * Use external SQLite DLL (for custom SQLite builds).   * 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.
-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).   * 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'+  * On File Menu, 'Vacuum Database'
- +    * The ''VACUUM;'' SQL command is available as a menu item at ''Menu -> Execute -> Vacuum 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