Your download link is at the very bottom of the page... always.



Processed through Paypal
No account required.


Donate Bitcoin to this wallet:
1KkUMXvQ2ko3xcJkzitB7WYgoW6m79WFfm
Donate Ethereum to this wallet:
0x40E56922F43637224935CDC35e2c96E0392A8505
Donate Litecoin to this wallet:
LLYAFEyqjH69gkyCEpRjXNyedRCWrVChfL

Buy our over-priced crap to help keep things running.
OlderGeeks 2025OG Dad CapNo Password


Follow us on BlueskyFollow us on XJoin our Facebook groupFollow us on InstagramOur RSS FeedJoin us on TikTokJoin us on LinkedIn


 Home » OlderGeeks.com Freeware Downloads » Database Utilities » SQLiteSpy v1.9.26   
File - Download SQLiteSpy v1.9.26
Description
A plea...
Deanna and I have been running this site since 2008 and lately we're seeing a big increase in
users (and cost) but a decline in percentage of users who donate. Our ad-free and junkware-free
download site only works if everyone chips in to offset the revenue that ads on other sites bring
in. Please donate at the bottom of the page. Every little bit helps. Thank you so much.
Sincerely,
your Older Geeks: Randy and Deanna



Always scroll to the bottom of the page for the main download link.
We don't believe in fake/misleading download buttons and tricks. The link is always in the same place.


SQLiteSpy v1.9.26

A fast and compact GUI database manager for SQLite.

SQLiteSpy reads SQLite3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze, and manipulate SQLite3 databases.




Overview

• SQLiteSpyDatabase 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 supports regular expression syntax similar to Perl. It is implemented with the help of the YuPcre2 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.
• Loadable Extensions – SQLiteSpy loads runtime extension modules compiled with with “fastcall” (C++ Builder) or “register” (Delphi) calling conventions. Extensions can be loaded for the current database via SELECT load_extension('FileName.dll'); or automatically for all databases by entering extension file names to the Options dialog.
• Easy Install and 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.

Changes:
v1.9.26 – 8 Nov 2024
Update the built-in database engine to SQLite 3.47.0, DISQLite3 v5.50.0.
Add the stmtrand() SQL function extension.















Click here to visit the author's website.
Continue below for the main download link.


Downloads Views Developer Last Update Version Size Type Rank
2,957 5,505 Ralf Junker <img src="https://www.oldergeeks.com/downloads/gallery/thumbs/sqlitespy1_th.png"border="0"> Nov 21, 2024 - 12:15 1.9.26 5.48MB ZIP 5/5, out of 27 Votes.
File Tags
SQLiteSpy  v1.9.26  
      
Ope! Hold on, Speedy.
You gotta read this before you download below:

There are no ads, no fake download buttons and no crapware here.
This website has lived for 16 years solely through donations.
You can download without donating but we use the "Honor System"
here in the Ozarks. If your momma raised you to be honorable,
make your donation to keep things running.
Your momma would be so proud!

Thank you! -Randy & Deanna (The Older Geeks)
Missouri Ozarks, USA

Monthly operating costs = $750
Donations cover operating costs first
then are set aside for future upgrades and/or
handed-over to Deanna for new shoes.

PayPal or Credit/Debit
IMPORTANT: This donation will show up as Home Computer Repair on your bank statement.
Or

Or

Or
Send a check payable to Home Computer Repair LLC, 208 E. Water St. Mount Vernon, MO 65712

Recent Super Donors ($50+)
Thanks, Bill
Thanks, Joanna
Thanks, Richard
Thanks, Richard
Thanks, Paul

Recent Donors
Thanks, Amy
Thanks, Owen
Thanks, Gregory
Thanks, Peterland Computer Serv.
Thanks, James
Thanks, Barry
Thanks, Uwe
Thanks, T.
Thanks, David
Thanks, Clifford

→ Download Your File ←


Click to Rate File     Share it on Twitter →


OlderGeeks.com Copyright (c) 2025