SQLiteSpy is a portable database manager for SQLite. It operates via an intuitive and clean Graphical User Interface GUI. It can be used to read SQLite3 files and execute Structured Query Language SQL against them. This embedded graphical database management tool simplifies the process of exploring, viewing, and manipulating your SQLite3 databases.
About SQLiteSpy
SQLiteSpy is a GUI database manager for SQLite. This compact SQL database management tool offers a range of features that make SQLite Spy efficient for working with databases. Here's a summary highlighting some of its most notable features:
- Schema Tree view: Displays all items in a database, including tables, columns, indexes, and triggers. Allows easy exploration and analysis.
- Grid Cell Editing: Table cells are editable in the grid. Changes can be made and confirmed to write back to the table.
- SQL Data Type Display: Different background colors for native SQL data types to help detect type errors.
- Full Unicode Support: Supports SQLite's Unicode capabilities for data display and entry.
- Multiple SQL Edits: Uses modern tabs to edit and display multiple SQL queries for easy comparison.
- SQL Execution Time Measurement: Automatically measures and displays SQL execution time to help optimize queries.
- SQL Regular Expressions: Supports the SQL keyword REGEXP with regular expression syntax similar to Perl.
- Mathematical SQL Functions: Includes additional mathematical SQL functions in addition to SQLite default functions.
- SQL Data Compression: Provides SQL functions for compressing and decompressing text or BLOB values using zlib's deflate.
- Compact Result Storage: Uses SQLite's native data types for optimal compatibility and memory efficiency.
- Built in SQLite Engine: Comes as a single-file executable with the SQLite database engine built into the application.
- Database Encryption Support: Can read and modify encrypted database files generated by DISQLite3.
- Loadable Extensions: Supports loading runtime extension modules compiled with specific calling conventions.
- Compact Portable: No installation is needed; the program creates a single SQLite database file for options and settings, making it stand-alone.
SQLiteSpy Specifications and Download
- Authors Website: Project Page
- Developer: Yunqa
- License: Freeware
- Extracted Size: Requires roughly 2MB of free space for complete standalone installation to a portable USB drive.
- Supported OS: Windows
- Downloading: You can get this compact and free SQLite database manager here:
SQLiteSpy Download