Http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index
Sqlitespy is a fast and compact GUI, Database Manager for SQLite. It reads SQLite3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze, and manipulate SQLite3 databases.
- database at a Glance , Haven schema TreeView displays all items contained in a Database, including tables, columns, Indexes and triggers. Press
F5 to update the schema tree, double-click a table or view-to-display its data with the context menu for frequent Ly used commands.
- Grid Cell Editing –table cells is editable in the Grid:display a Table via the schema treeview, select a cell and press to
F2 invoke the editor. Then modify and confirm to write your changes back to the table.
- data type Display , haven native SQL Data types is displayed with different background colors to help detect Type Errors. Type errors can cause performance degradation or wrong SELECT result sets if NULL values is confused with empty strings.
- Full Unicode –sqlitespy fully supports SQLite ' s Unicode capabilities. Data display and entry is completely realized as Unicode, including SQL commands.
- multiple SQL edits –modern tabs is used to edit and display multiple SQL queries for easy comparison of query s Tatements and results. SQL queries is executed by typing or loading them into the SQL edit. Then press F9 to run of the query, or CTRL+F9 to run of the current line or selection only.
- Time measurement –sql Execution time is automatically measured and displayed to help optimize queries.
- Regular Expressions , haven SQL keyword is supported and adds the complete
REGEXP Regular expression syntax of Perl 5.10 to Sqlitespy. The implementation was realized using the Diregex library.
- Mathematical SQL Functions , haven following mathematical SQL Functions is available in addition to the SQLite def Ault:acos (), ASIN (), ATAN (), ATAN (), ATAN2 (), Ceil (), CEILING (), COS (), COT (), DEGREES (), EXP (), Floor (), LN (), LOG (), LO G (), LOG2 (), LOG10 (), MOD (), PI (), POW (), RADIANS (), sign (), SIN (), SQRT (), TAN (), TRUNCATE ().
- Data Compression , Haven SQL Functions COMPRESS () applies zlib ' s deflate to any text Orblob value. The raw deflate data stream is returned. Uncompress () Inflates this stream back to the original. integers, doubles, and Nulls are returned unchanged.
- Compact Result Storage , haven internal data Storage mechanism uses SQLite ' s native data types for optimal Compatib Ility. As a result, Sqlitespy uses far less memory than other SQLite managers and handles large tables much more efficiently.
- built-in SQLite engine –sqlitespy comes as a single file executable with the SQLite database engine already Buil D into the application. There is no need-distribute anydlls, which makes sqlitespy easy-to-deploy with customers.
- encryption Support –sqlitespy can read and modify encrypted the database files generated by DISQLite3. DISQLite3 implements its own native AES encryption which are not compatible with the commercial SQLite encryption Extension (SSE) or any such implementation offered by other 3rd parties.
- Loadable Extensions –sqlitespy loads runtime extension modules compiled with with "Fastcall" (c + + Builder) or "R Egister "(Delphi) calling conventions. Extensions can loaded for the current database via
SELECT load_extension(‘FileName.dll‘); or automatically for all databases by entering extension file Names to the Options dialog.
- Easy Install & Uninstall –to run Sqlitespy, just extract the SQLiteSpy.exe file to any directory and execute The file. No installation is needed–when first started, the program creates a single file Sqlitespy.db3 (a SQLite3 database) to St Ore options and settings. It does not write any other files or to the registry. Uninstalling is as simple as deleting, only:the application ' s executable and its options database file.
- freeware –sqlitespy is freeware for personal and educational use. If you were using Sqlitespy commercially, your donation is welcome to promote the ongoing development of this software. Thank you!
If contribute to Sqlitespy:please post comments, suggestions, feature requests and bugs reports to the mailing List. Thanks to all who has already shared their encouragement and ideas!
Sqlitespy-a Fast and compact GUI Database manager for SQLite
