New YuOpenSSL-3.6 released!
YuOpenSSL-3.6 updates the YuOpenSSL series to the current OpenSSL 3.6 library. It adds support for opaque symmetric key managment, QUIC shutdown, EC keygen error fixes, relaxed file:/ URI paths, and safer EC and PKCS#12 defaults. 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 17:34] – [SQLiteSpy: Wiki] zorro
+++ wiki:sqlitespy:index [2021/03/27 12: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