Self-contained, embeddable, zero-configuration SQL database engine

SQLite 3.29.0 (64-bit)

July, 11th 2019 - 819.2 KB - Freeware

Free Download

Security Status

Latest Version

SQLite 3.45.3 (64-bit)
Operating System

Windows XP64 / Vista64 / Windows 7 64 / Windows 8 64 / Windows 10 64
User Rating

Click to vote
Author / Product

Richard Hipp / External Link
Filename

sqlite-dll-win64-x64-3290000.zip

Sometimes latest versions of the software can cause issues when installed on older devices or devices running an older version of the operating system. Software makers usually fix these issues but it can take them some time. What you can do in the meantime is to download and install an older version of SQLite 3.29.0 (64-bit).

For those interested in downloading the most recent release of SQLite (64-bit) or reading our review, simply click here.

All old versions distributed on our website are completely virus-free and available for download at no cost.

We would love to hear from you

If you have any questions or ideas that you want to share with us - head over to our Contact page and let us know. We value your feedback!

Download SQLite 3.29.0 (64-bit)

SQLite 3.29.0 (64-bit) Screenshots

The images below have been resized. Click on them to view the screenshots in full size.

What's new in this version:

- Added the SQLITE_DBCONFIG_DQS_DML and SQLITE_DBCONFIG_DQS_DDL actions to sqlite3_db_config() for activating and deactivating the double-quoted string literal misfeature. Both default to "on" for legacy compatibility, but developers are encouraged to turn them "off", perhaps using the -DSQLITE_DQS=0 compile-time option
- DSQLITE_DQS=0 is now a recommended compile-time option

Improvements to the query planner:
- Improved optimization of AND and OR operators when one or the other operand is a constant
- Enhancements to the LIKE optimization for cases when the left-hand side column has numeric affinity
- Added the "sqlite_dbdata" virtual table for extracting raw low-level content from an SQLite database, even a database that is corrupt

Enhancements to the CLI:
- Add the ".recover" command which tries to recover as much content as possible from a corrupt database file
- Add the ".filectrl" command useful for testing
- Add the long-standing ".testctrl" command to the ".help" menu
- Added the ".dbconfig" command

Hashes:
- SQLITE_SOURCE_ID: 2019-07-10 17:32:03 fc82b73eaac8b36950e527f12c4b5dc1e147e6f4ad2217ae43ad82882a88bfa6
- SHA3-256 for sqlite3.c: d9a5daf7697a827f4b2638276ce639fa04e8e8bb5fd3a6b683cfad10f1c81b12