wiki:sqlitespy:index
Delphi 12 Athens Updates Available!
To download, click your product: DIContainers, DIConverters, DICreole, DIFileFinder, DIGoogleReader, DIHtmlLabel, DIHtmlParser, DIMime, DIRegEx, DISQLite3, DITidy, DIUcl, DIUnicode, DIXml, YuBrotli, YuImage, YuNetSurf, YuOpenSSL, YuPcre2, YuPdf, YuStemmer, YuXmlSec, YuZip.
To download, click your product: DIContainers, DIConverters, DICreole, DIFileFinder, DIGoogleReader, DIHtmlLabel, DIHtmlParser, DIMime, DIRegEx, DISQLite3, DITidy, DIUcl, DIUnicode, DIXml, YuBrotli, YuImage, YuNetSurf, YuOpenSSL, YuPcre2, YuPdf, YuStemmer, YuXmlSec, YuZip.
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
wiki:sqlitespy:index [2021/02/27 16:00] – [Feature Suggestions] zorro | wiki:sqlitespy:index [2021/03/26 18:34] – [SQLiteSpy: Wiki] zorro | ||
---|---|---|---|
Line 3: | Line 3: | ||
{{page> | {{page> | ||
{{page>: | {{page>: | ||
+ | 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 ===== | ||
Line 15: | Line 17: | ||
* No auto-save on exit. There is the Read-only option, but any modification is auto-saved on exit which may be problematic, | * No auto-save on exit. There is the Read-only option, but any modification is auto-saved on exit which may be problematic, | ||
+ | * 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 '' | ||
* Command-line version of the SQLiteSpy' | * Command-line version of the SQLiteSpy' | ||
Line 29: | Line 32: | ||
* 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 | + | * On File Menu, 'Vacuum |
- | + | * The '' | |
- | > VACUUM | + |
wiki/sqlitespy/index.txt · Last modified: 2021/03/27 13:23 by admin