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 revisionPrevious revision
Next revision
Previous revision
wiki:sqlitespy:index [2021/03/01 11:37] – Answer "no auto-save on exit" feature suggestion adminwiki: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 =====
Line 21: 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
wiki/sqlitespy/index.txt · Last modified: 2021/03/27 13:23 by admin