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

SQLite 3.39.0 (32-bit)

June, 26th 2022 - 512 KB - Freeware

Free Download

Security Status

Latest Version

SQLite 3.45.3 (32-bit)
Operating System

Windows XP / Vista / Windows 7 / Windows 8 / Windows 10
User Rating

Click to vote
Author / Product

Richard Hipp / External Link
Filename

sqlite-dll-win32-x86-3390000.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.39.0 (32-bit).

For those interested in downloading the most recent release of SQLite (32-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.39.0 (32-bit)

SQLite 3.39.0 (32-bit) Screenshots

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

What's new in this version:

- Add (long overdue) support for RIGHT and FULL OUTER JOIN
- Add new binary comparison operators IS NOT DISTINCT FROM and IS DISTINCT FROM that are equivalent to IS and IS NOT, respective, for compatibility with PostgreSQL and SQL standards
- Add a new return code (value "3") from the sqlite3_vtab_distinct() interface that indicates a query that has both DISTINCT and ORDER BY clauses
- Added the sqlite3_db_name() interface
- The unix os interface resolves all symbolic links in database filenames to create a canonical name for the database before the file is opened
- Defer materializing views until the materialization is actually needed, thus avoiding unnecessary work if the materialization turns out to never be used
- The HAVING clause of a SELECT statement is now allowed on any aggregate query, even queries that do not have a GROUP BY clause
- Many microoptimizations collectively reduce CPU cycles by about 2.3%