SQLiteSpy 1.9.10

Ralf Junker in Servers / Other Server Applications

SQLiteSpy screenshot

User Rating: 2.2 (29 votes)

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.

top download editor's pick
File Size: 1.599609375 MB License: Freeware Price: FREE
Platform: Windows 2000, Windows 2003, Windows XP, Windows Vista, Windows 7
Downloads: Total: 191 | This Month: 22 Released: 2015-08-17
SQLiteSpy Similar Software

SQLite2009 Pro Enterprise Manager 3.7.9 Osen Kusnadi    

SQLite2009 Pro Enterprise Manager is a freeware tool that enables you to manage your SQLite3 databases. Features: * Encryption Method is now compatible with wxSQLite3 (AES-128 bits) and SQLite3 ADO.NET Provider (RSA-MS Crypt) * Syntax Highlight * Hex Viewer * Dump .... Free download of SQLite2009 Pro Enterprise Manager 3.7.9

software pick   

Microsoft Security Compliance Manager 2.5.40.0 Microsoft    

The Microsoft Security Compliance Manager package provides centralized security baseline management features, a baseline portfolio, customization capabilities, and security ... flexibility to accelerate your organization’s ability to efficiently manage the security and compliance process for the most ... Accelerator will help you plan, deploy, operate, and manage your security baselines for Windows client and server .... Free download of Microsoft Security Compliance Manager 2.5.40.0

software pick   

Microsoft System Center Service Manager 2012 SP1 Beta Microsoft    

The upcoming version of Service Manager 2012 will deliver standardized, compliant, and automated IT ... SharePoint self-service portal, service catalog, service requests, release management, IT business intelligence, and many other improvements that are being added to Service Manager. Kurt Van Hoecke is working more or ... SCCM, SCOM and now heavily working with Service Manager. From the beta releases of SCSM 2010 he .... Free download of Microsoft System Center Service Manager 2012 SP1 Beta

software pick   

Microsoft Office Migration Planning Manager 2010 2.2 Microsoft    

The Office Migration Planning Manager (OMPM) 2010 package provides a group of tools designed to help administrators during the planning and testing phases of a Microsoft Office 2010 deployment. OMPM assists administrators in the discovery and compatibility assessment of existing Office documents for migration from the binary document formats (.doc, .... Free download of Microsoft Office Migration Planning Manager 2010 2.2

software pick   

TwonkyMedia Manager 3.1.0.55 PacketVideo Corporation    

TwonkyMedia manager streams your music, photos and videos to compatible ... the TV icon. Creating playlists in TwonkyMedia manager is simple. And if you don’t want to ... of the things you can do with TwonkyMedia manager. • Play a photo slideshow on your TV ... Listen to Internet radio View and manage all your media files in one user interface .... Free download of TwonkyMedia Manager 3.1.0.55

software pick   
Popular Software in Servers / Other Server Applications

PHPRunner 10.0 B32133 Xlinesoft.com     update

Database driven PHP web site with no programming. Free download of PHPRunner 10.0 B32133

software pick   

Portable RazorSQL 8.2.1 Richardson Software, LLC     update

Can help you query, update, navigate, and manage all major databases. Free download of Portable RazorSQL 8.2.1

software pick   

SQLyog Pro x64 12.5.1 Webyog, Inc.     update

Created to provide users with a means of administering MySQL databases. Free download of SQLyog Pro x64 12.5.1

Navicat Lite for Oracle 12.1.9 PremiumSoft CyberTech Ltd.     update

A GUI for Oracle server administration and development. Free download of Navicat Lite for Oracle 12.1.9

software pick   

SQL Examiner Suite 7.1.6.203 TulaSoft, LLC     update

Compares and synchronizes database schemas and contents. Free download of SQL Examiner Suite 7.1.6.203