New YuCurl released!
YuCurl is a robust client-side URL library for Delphi that integrates libcurl directly into applications, enabling efficient handling of various Internet protocols while enhancing performance, security, and portability without relying on external DLLs. Learn more …

Differences

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

Link to this comparison view

--- wiki:sqlitespy:index [2021/03/26 18:34] – [SQLiteSpy: Wiki] zorro
+++ wiki:sqlitespy:index [2021/03/27 13:23] (current) – admin
@@ Line 3: / Line 3: @@
 {{page>products:sqlitespy: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 =====
-  * 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.
   * 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.
 ===== Feature Suggestions =====
@@ Line 23: / Line 19: @@
   * 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