
SQLiteSpy 1.9.14
A fast and compact GUI database manager for SQLite
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
SQLiteSpy 1.9.14 full details

File Size: | 4.50 MB |
---|---|
License: | Freeware |
Price: | FREE |
Released: | 2020-02-05 |
Downloads: | Total: 3526 | This Month: 7 |
Publisher: | Ralf Junker |
Publisher URL: | https://www.yunqa.de/ |

Download SQLiteSpy 1.9.14
Save SQLiteSpy to My Stuff
Tweet
SQLiteSpy - Windows 7 Download awards
SQLiteSpy 1.9.14 full description
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 – The 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, use the context menu for frequently used commands.
Grid Cell Editing – Table cells are editable in the grid: Display a table via the schema treeview, select a cell and press F2 to invoke the editor. Then modify and confirm to write your changes back to the table.
Data Type Display – The native SQL data types are displayed with different background colors to help detect type errors. Type errors can cause performance degradation or wrong SELECT result sets if NULL values are 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 are used to edit and display multiple SQL queries for easy comparison of query statements and results. SQL queries are executed by typing or loading them into the SQL edit. Then press F9 to run the query, or CTRL+F9 to run the current line or selection only.
Time Measurement – SQL execution time is automatically measured and displayed to help optimize queries.
Regular Expressions – The SQL keyword REGEXP is supported and adds the complete regular expression syntax of Perl 5.10 to SQLiteSpy. The implementation was realized using the DIRegEx library.
Mathematical SQL Functions – The following mathematical SQL functions are available in addition to the SQLite default: ACOS(), ASIN(), ATAN(), ATAN(), ATAN2(), CEIL(), CEILING(), COS(), COT(), DEGREES(), EXP(), FLOOR(), LN(), LOG(), LOG(), LOG2(), LOG10(), MOD(), PI(), POW(), RADIANS(), SIGN(), SIN(), SQRT(), TAN(), TRUNCATE().
Data Compression – The SQL functions COMPRESS() applies zlib's deflate to any text or BLOB 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 – The internal data storage mechanism uses SQLite's native data types for optimal compatibility. 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 build into the application. There is no need to distribute any DLLs, which makes SQLiteSpy easy to deploy with customers.
Encryption Support – SQLiteSpy can read and modify encrypted database files generated by DISQLite3. DISQLite3 implements its own native AES encryption which is not compatible with the commercial SQLite Encryption Extension (SSE) or any such implementation offered by other 3rd parties.
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 store options and settings. It does not write any other files or to the registry. Uninstalling is as simple as deleting two files only: The application's executable and its options database file.
Freeware – SQLiteSpy is Freeware for personal and educational use. If you are using SQLiteSpy commercially, your donation is welcome to promote the ongoing development of this software. Thank you!
Database at a Glance – The 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, use the context menu for frequently used commands.
Grid Cell Editing – Table cells are editable in the grid: Display a table via the schema treeview, select a cell and press F2 to invoke the editor. Then modify and confirm to write your changes back to the table.
Data Type Display – The native SQL data types are displayed with different background colors to help detect type errors. Type errors can cause performance degradation or wrong SELECT result sets if NULL values are 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 are used to edit and display multiple SQL queries for easy comparison of query statements and results. SQL queries are executed by typing or loading them into the SQL edit. Then press F9 to run the query, or CTRL+F9 to run the current line or selection only.
Time Measurement – SQL execution time is automatically measured and displayed to help optimize queries.
Regular Expressions – The SQL keyword REGEXP is supported and adds the complete regular expression syntax of Perl 5.10 to SQLiteSpy. The implementation was realized using the DIRegEx library.
Mathematical SQL Functions – The following mathematical SQL functions are available in addition to the SQLite default: ACOS(), ASIN(), ATAN(), ATAN(), ATAN2(), CEIL(), CEILING(), COS(), COT(), DEGREES(), EXP(), FLOOR(), LN(), LOG(), LOG(), LOG2(), LOG10(), MOD(), PI(), POW(), RADIANS(), SIGN(), SIN(), SQRT(), TAN(), TRUNCATE().
Data Compression – The SQL functions COMPRESS() applies zlib's deflate to any text or BLOB 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 – The internal data storage mechanism uses SQLite's native data types for optimal compatibility. 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 build into the application. There is no need to distribute any DLLs, which makes SQLiteSpy easy to deploy with customers.
Encryption Support – SQLiteSpy can read and modify encrypted database files generated by DISQLite3. DISQLite3 implements its own native AES encryption which is not compatible with the commercial SQLite Encryption Extension (SSE) or any such implementation offered by other 3rd parties.
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 store options and settings. It does not write any other files or to the registry. Uninstalling is as simple as deleting two files only: The application's executable and its options database file.
Freeware – SQLiteSpy is Freeware for personal and educational use. If you are using SQLiteSpy commercially, your donation is welcome to promote the ongoing development of this software. Thank you!
SQLiteSpy 1.9.14 download tags
SQLiteSpy 1.9.14 Windows 7 release notes
New Release
The download package now contains SQLiteSpy.exe Win32 as well as Win64 executables.
Update built-in DISQLite3 engine to SQLite 3.31.1.
Add the BLOBIO SQL function extension. Example:
CREATE TABLE t(a blob);
INSERT INTO t VALUES (x'01020304');
SELECT readblob('main', 't', 'a', 1, 0, 4);
Add the DBDATA virtual table extension. Examples:
SELECT * FROM sqlite_dbdata();
SELECT * FROM sqlite_dbptr();
Add the FOSSILDELTA SQL function extension. Example:
SELECT delta_apply(x'0102', delta_create(x'0102', x'0304'));
Add the URIFUNCS SQL functions extension. Examples:
select sqlite3_filename_database('main');
select sqlite3_filename_journal('main');
select sqlite3_filename_wal('main');
Add the UUID SQL functions extension. Examples:
SELECT uuid();
SELECT uuid_str(uuid());
SELECT uuid_blob(uuid());
Add redo to SQL edit.
Automatic column widths of result grid take column caption into account.
[ SQLiteSpy release history ]
The download package now contains SQLiteSpy.exe Win32 as well as Win64 executables.
Update built-in DISQLite3 engine to SQLite 3.31.1.
Add the BLOBIO SQL function extension. Example:
CREATE TABLE t(a blob);
INSERT INTO t VALUES (x'01020304');
SELECT readblob('main', 't', 'a', 1, 0, 4);
Add the DBDATA virtual table extension. Examples:
SELECT * FROM sqlite_dbdata();
SELECT * FROM sqlite_dbptr();
Add the FOSSILDELTA SQL function extension. Example:
SELECT delta_apply(x'0102', delta_create(x'0102', x'0304'));
Add the URIFUNCS SQL functions extension. Examples:
select sqlite3_filename_database('main');
select sqlite3_filename_journal('main');
select sqlite3_filename_wal('main');
Add the UUID SQL functions extension. Examples:
SELECT uuid();
SELECT uuid_str(uuid());
SELECT uuid_blob(uuid());
Add redo to SQL edit.
Automatic column widths of result grid take column caption into account.
[ SQLiteSpy release history ]
SQLiteSpy for Windows 7 - Copyright information
All SQLiteSpy reviews, submitted ratings and written comments become the sole property of Windows 7 download. You acknowledge that you, not windows7download, are responsible for the contents of your submission. However, windows7download reserves the right to remove or refuse to post any submission for any reason.
Windows 7 Download periodically updates pricing and software information of SQLiteSpy full version from the publisher, but some information may be out-of-date. You should confirm all information.
Using warez version, crack, warez passwords, patches, serial numbers, registration codes, key generator, pirate key, keymaker or keygen for SQLiteSpy license key is illegal and prevent future development of SQLiteSpy. Download links are directly from our mirrors or publisher's website, SQLiteSpy torrent or shared files from free file sharing and free upload services, including Rapidshare, MegaUpload, YouSendIt, SendSpace, DepositFiles, DivShare, HellShare, HotFile, FileServe or MediaFire, are not used.
Windows 7 Download periodically updates pricing and software information of SQLiteSpy full version from the publisher, but some information may be out-of-date. You should confirm all information.
Using warez version, crack, warez passwords, patches, serial numbers, registration codes, key generator, pirate key, keymaker or keygen for SQLiteSpy license key is illegal and prevent future development of SQLiteSpy. Download links are directly from our mirrors or publisher's website, SQLiteSpy torrent or shared files from free file sharing and free upload services, including Rapidshare, MegaUpload, YouSendIt, SendSpace, DepositFiles, DivShare, HellShare, HotFile, FileServe or MediaFire, are not used.
Post SQLiteSpy review


Windows 7 SQLiteSpy related downloads
My Account
Help
Windows 7 Software Coupons
-
Media Player Morpher
85% Off -
MacX MediaTrans
50% Off -
MacX Video Converter Pro
50% Off -
MacX Media Management Bundle
70% Off -
FREE VPN PROXY by SEED4.ME WINDOWS
Free VPN by Seed4Me
My Saved Stuff
You have not saved any software.
Click "Save" next to each software.
Click "Save" next to each software.
Would you like to receive announcements of new versions of your software by email or by RSS reader? Register for FREE!
Windows 7 Downloads Picks
- Serva64 3.2.0
- Aqua Data Studio x64 21.1.3
- Aqua Data Studio 21.1.3
- PHPRunner 10.5 B36520
- cwRsync 6.2.1
- MySQL Workbench 8.0.23
- FreeNAS 12.0-U2.1
- TIFF Viewer Server 12.94
- Smart Alert Pro 1.27.13
- Portable RazorSQL 9.3.1
- ESF Database Migration Toolkit Standard 10.2.05
- MySQL 8.0.23
- XAMPP 7.4.12-0
- dbForge SQL Complete Standard 6.7.5
- SqlDbx Personal 6.14
- CC Proxy 8.0
- SQLite3 3.34.1
- SQLiteSpy 1.9.14
- dbForge Data Compare Express for Oracle 5.3.12
- Helicon Ape 3.1.0.256
Popular Tags
search windows 7 downloads
bangla keyboard
radio tuner
windows 7
operating system
winrar
photo viewer
spider solitaire
facebook
super mario
chrome
service pack 3
gadget
javascript
internet explorer 10
counter strike
animated wallpaper
dock
solitaire
mozilla firefox
google chrome
photo editor
turbo c
java
microsoft office
visual basic
skype
sound equalizer
free vlc media player
firefox
Popular Windows 7 Software
- UFO VPN for Windows 2.2.0
- Serva64 3.2.0
- Aqua Data Studio x64 21.1.3
- Aqua Data Studio 21.1.3
- SecureCRT 9.0.0 B2430
- PHPRunner 10.5 B36520
- cwRsync 6.2.1
- FreeNAS 12.0-U2.1
- Wild Media Server (UPnP, DLNA, HTTP) 5.01
- MySQL Workbench 8.0.23
- IBExpert 2021.02.16
- Portable SecureCRT 6.7.5
- JAP/JonDo 00.20.001
- TIFF Viewer Server 12.94
- Windows 7 Firewall Control 8.4.0
© 2021 Windows7Download.com - All logos, trademarks, art and other creative works are and remain copyright and property of their respective owners. Microsoft Windows is a registered trademarks of Microsoft Corporation. Microsoft Corporation in no way endorses or is affiliated with windows7download.com.