The Portable Freeware Collection

SQLiteSpy V1.8.16
Suggested by MarcoNovaro - Updated by Checker on 31 Aug 2010
2MB (uncompressed) - Popularity score (5864)
Website - Screenshot - Download - Comments (12) - Post comment - Permalink

Category: Others - Database Tools (6)

Synopsis: SQLiteSpy is a fast and compact GUI database manager for SQLite. It reads SQLite 3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze and manipulate SQLite databases.

Writes settings to: Application folder

How to extract: Download the ZIP package and extract to a folder of your choice. Delete World.db3. Launch SQLiteSpy.exe.

Stealth [?]: Yes

Unicode support: Yes

License: Freeware

System Requirements: Win95 / Win98 / WinME / WinNT / Win2K / WinXP / Vista

What's new: >>

Update built-in DB engine to SQLite 3.7.2 (DISQLite3 2.3.1).
Print some sqlite3_stmt_status() performance counters to the status bar.
Faster processing of large SQL scripts.
Fix table mode browsing (double clicking on a table name) for tables which use some of the INTEGER PRIMARY KEY aliases as column names. Output a warning if the table can not be browsed because all three names (ROWID, OID, or _ROWID_) are in use by the table. This sould be very rare, however.

Posted comments:

Euler German: Wow! That's exactly what I was looking for. I'm very well impressed, and very pleased, BTW. Thanks!! [2007-02-13 08:28]

Charlie Zhu: It's surely a smart and very useful tool. Thanks. [2007-05-08 19:38]

Nuno: FANTASTIC!!!!
A must-have for those who work with SQLite 3 databases under windows. [2007-10-09 06:19]

Vikingdread: If you like SQLiteSpy you will love SQLite Administrator

http://sqliteadmin.orbmu2k.de/ [2008-01-23 00:49]

sodele: hi folks,
do you know any comparable tool that i can use for relational databases in general?

some tiny gui where i can run sql statements...
actually exactely what this tool is like but not only for sqlite....?!?!?!

thanxxx in advance [2008-04-21 05:07]

Vikingdread: For general purpose database stuff I use "Data Tool" from Vista Software.

http://www.ex-designz.net/softwaredetail.asp?fid=1243 [2008-04-22 00:41]

10secondtourism: sodele.. for mysql databases you can try use http://www.heidisql.com/ (portable) or sqlyog http://www.webyog.com/en/ [2008-07-09 10:50]

Transcontinental: With Firefox and Chrome browsers the SQLite database has come to public attention. This manager is most welcome. I'm giving it a try! [2009-12-10 16:38]

Transcontinental: I would have loved to try it, but after having spent 300 seconds on the developer's homepage still haven't found the download link. A pain in the neck!!! LET THERE BE LINKS AND LET THEM NE VISIBLE FOR CRYING OUT LOUD !!! (that's for portablefreeware.com, not for this nice place!) [2009-12-10 16:49]

zomg: Worked like a charm for salvaging a few things from my Firefox's corrupted .sqlite files. [2010-01-24 16:53]

ReDeX: @Vikingdread
You know if SQLite Administrator is portable? [2010-02-26 08:38]

Faust: Transcontinental:

ctrl-f
"download" [2010-07-30 01:41]

Post your comment:

All HTML tags will be removed from your comment. URLs (http, https, ftp) will be automatically detected and hyperlinked. I reserve the right to delete irrelevant, frivolous or offensive comments. For more general topics (eg. whether apps that write to the registry, leave traces on the host machine, rely on certain versions of IE etc. can be considered portable), please post to the Portable Freeware Discussion forum. If your virus scanner has detected a virus in the application, please email the author directly or post to the forum. Note that false positives (i.e. flagging a virus when there is actually none) are extremely common for virus scanners. When in doubt, try an online scanner like Online Malware Scanner or VirusTotal, which scans files using multiple anti-virus engines. It is very likely to be a false positive if only a few engines raise the red flag.

Your name:		Remember me
Comment:

Turing test: