Lightweight and portable application with limited features that enable users to manage SQLite databases with ease in a comfortable workspace
SQLiteSpy is a small-sized and easy-to-use program that enables users to manage SQLite databases in a friendly working environment. It comes packed with limited features.
As installation is not a prerequisite, you can just drop the executable file somewhere on the hard disk and run it directly.
It is also possible to move SQLite to a USB flash disk or similar storage unit, in order to run it on any machine without prior installers.
An important factor to take into account is that the Windows registry is not updated with new entries, and file traces do not remain on the system once the program is removed.
The package also includes a DB3 database for testing purposes. Files can be loaded into the workspace using the file browser only, since the drag-and-drop support is not featured. The app supports SQLITE, SQLITE3, DB and DB3 formats.
You can attach additional databases, build new SQL queries, view, copy and drop tables, edit cells, view “select” and “create” statements, as well as check out indexes, triggers and collations.
It is possible to execute the entire SQL query or just a selection, analyze and vacuum the database, convert text to Unicode characters, enable read-only mode, set the decimal separator, as well as ignore regular expression matching cases.
SQLiteSpy does not put a strain on system performance, as it runs on a very low amount of CPU and RAM. It has a good response time and works well, without causing the operating system to hang, crash or pop up error dialogs. All in all, SQLiteSpy offers a simple solution to viewing and executing SQL queries.
Reviewed by Elena Opris, last updated on August 22nd, 2014
In a hurry? Add it to your Download Basket!
What's New in This Release:
- Update built-in DISQLite3 engine to SQLite 3.8.6.
- Attached database: Double clicking a table node did not work. Fixed.
- New MediaMonkey.dll extension which adds the IUNICODE collation sequence needed to open MediaMonkey databases.
Application descriptionSQLiteSpy was specially designed to be a fast and compact GUI database manager for SQLite. The program can reads SQLit...