SQLiteSpy 1.9.16

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!

Author Ralf Junker
License Freeware
Price FREE
Released 2022-07-06
Downloads 498
Filesize 4.50 MB
Requirements
Installation Instal And Uninstall
Keywords Database Manager, Grid Cell Editor, Manage Database, Manage, Manager, Management
Users' rating
(15 rating)
SQLiteSpyOther Server ApplicationsWindows 2000, Windows 2003, Windows XP, Windows Vista, Windows Vista x64, Windows 7, Windows 7 x64, Windows 8, Windows 8 x64, Windows 10, Windows 10 x64, Windows 11
SQLiteSpy - Download Notice

Using SQLiteSpy Free Download crack, warez, password, serial numbers, torrent, keygen, registration codes, key generators is illegal and your business could subject you to lawsuits and leave your operating systems without patches. We do not host any torrent files or links of SQLiteSpy on rapidshare.com, depositfiles.com, megaupload.com etc. All SQLiteSpy download links are direct SQLiteSpy full download from publisher site or their selected mirrors.
Avoid: oem software, old version, warez, serial, torrent, SQLiteSpy keygen, crack.
Consider: SQLiteSpy full version, full download, premium download, licensed copy.

SQLiteSpy - The Latest User Reviews

Most popular Other Server Applications downloads

IP-CITY-TIMEZONE-AREACODE Database

February.2023 download

IP address to country, city, latitude, longitude, zip code, IDD and area code.

New Version

dbForge SQL Complete Standard

6.14.7 download

SQL code autocompletion and formatting tool for SQL Server Management Studio

Free SQL Health Monitor

2.0 download

Monitors important parameters of MS SQL database

New Version

Navicat Lite for Oracle (Linux)

16.1.7 download

A GUI for Oracle server administration and development

New Version

IP-COUNTRY-CITY-WEATHER Database

February.2023 download

IP address to country, time zone, latitude, longitude, weather station code.

New Version

Fortitude HTTP x 64

1.0.4.2 download

Easy-to-use alternative to commercial web servers

miniSipServer

40 B20230203 download

An easy-to-deploy yet powerful SIP / VOIP server

New Version

Home Media Center

2.9.6042.28114 download

Home Media Center is a server application for UPnP / DLNA compatible devices

ESF Database Migration Toolkit Standard

11.0.14 download

This software converts between various database formats

New Version

GSM Guard

2.7.8.711 download

GSM Guard - monitoring for SMS, GSM, GPRS, RS232 alarm and control systems