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
wiki:sqlitespy:index [2021/03/26 18:34]
zorro [SQLiteSpy: Wiki]
wiki:sqlitespy:index [2021/03/27 13:23] (current)
admin
Line 3: Line 3:
 {{page>products:sqlitespy:header}} {{page>products:sqlitespy:header}}
 {{page>:wiki-header}} {{page>:wiki-header}}
-As already mentioned, CSV support, at least for export, would be welcome. 
-At this time I have to visit sqliteonline.com just to export in CSV when all other tasks are seamlessly operated by SqliteSpy. 
  
 ===== 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 23: 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