-
Latest Version
-
Operating System
Windows XP / Vista / Windows 7 / Windows 8 / Windows 10
-
User Rating
Click to vote -
Author / Product
-
Filename
sqlite-dll-win-x86-3460000.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.46.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!
What's new in this version:
Enhance PRAGMA optimize in multiple ways, to make it simpler to use:
- PRAGMA optimize automatically implements a temporary analysis limit to prevent excess runtime on large databases
- Added the new 0x10000 bitmask option to check for updates on all tables
- Automatically re-analyze tables that do not have sqlite_stat1 entries
Enhancements to the date and time functions:
- The strftime() SQL function now supports %G, %g, %U, and %V
- New modifiers 'ceiling' and 'floor' control the algorithm used to resolve ambiguous dates when shifting a date by an integer number of months and/or years
- The 'utc' and 'localtime' modifiers are now no-ops if SQLite knows that the time is already in UTC or in the localtime, respectively
- Add support for underscore ("_") characters between digits in numeric literals
- Add the json_pretty() SQL function
Query planner improvements:
- The "VALUES-as-coroutine" optimization enables INSERT statements with thousands of rows in the VALUES clause to parse and run in about half the time and using about half as much memory
- Allow the use of an index for queries like "SELECT count(DISTINCT col) FROM ...", even if the index records are not smaller than the table records
- Improved recognition of cases where the value of an SQL function is constant because all its arguments are constant
- Enhance the WHERE-clause push-down optimization so that it is able to push down WHERE clause terms containing uncorrelated subqueries
- Allocate additional memory from the heap for the SQL parser stack if that stack overflows, rather than reporting a "parser stack overflow" error
JSON changes:
- Allow ASCII control characters within JSON5 string literals
- Fix the -> and ->> operators so that when the right-hand side operand is a string that looks like an integer it is still treated as a string, because that is what PostgreSQL does
- Allow large hexadecimal literals to be used as the DEFAULT value to a table column
- OperaOpera 114.0 Build 5282.222 (64-bit)
- 4K Download4K Video Downloader+ 1.10.0 (64-bit)
- PhotoshopAdobe Photoshop CC 2025 26.1 (64-bit)
- OKXOKX - Buy Bitcoin or Ethereum
- iTop VPNiTop VPN 6.1.0 - Fast, Safe & Secure
- Premiere ProAdobe Premiere Pro CC 2025 25.0
- BlueStacksBlueStacks 10.41.610.1001
- Hero WarsHero Wars - Online Action Game
- TradingViewTradingView - Trusted by 60 Million Traders
- LockWiperiMyFone LockWiper (Android) 5.7.2
Comments and User Reviews