-
Latest Version
SQLite 3.46.0 (64-bit) LATEST
-
Review by
-
Operating System
Windows XP64 / Vista64 / Windows 7 64 / Windows 8 64 / Windows 10 64 / Windows 11
-
User Rating
Click to vote -
Author / Product
-
Filename
sqlite-dll-win-x64-3460000.zip
Features and Highlights
- Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.
- Zero-configuration - no setup or administration needed.
- Full SQL implementation with advanced features like partial indexes and common table expressions. (Omitted features)
- A complete database is stored in a single cross-platform disk file. Great for use as an application file format.
- Supports terabyte-sized databases and gigabyte-sized strings and blobs.
- Small code footprint: less than 500KiB fully configured or much less with optional features omitted.
- Simple, easy to use API.
- Written in ANSI-C. TCL bindings included. Bindings for dozens of other languages available separately.
- Well-commented source code with 100% branch test coverage.
- Available as a single ANSI-C source-code file that is easy to compile and hence is easy to add to a larger project.
- Self-contained: no external dependencies.
- Cross-platform: Android, *BSD, iOS, Linux, Mac, Solaris, VxWorks, and Windows (Win32, WinCE, WinRT) are supported out of the box. Easy to port to other systems.
- Sources are in the public domain. Use it for any purpose.
- It comes with a standalone command-line interface (CLI) client that can be used to administer SQ Lite databases.
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 112.0 Build 5197.30 (64-bit)
4K Download4K Video Downloader+ 1.8.0 (64-bit)
PhotoshopAdobe Photoshop CC 2024 25.11 (64-bit)
PC RepairPC Repair 1.0.3
Opera GXOpera GX 111.0.5168.99 (64-bit)
Adobe AcrobatAdobe Acrobat Pro 2024.002.20965
BlueStacksBlueStacks - Play on PC 5.21.300
Hero WarsHero Wars - Online Action Game
Trade IdeasTrade Ideas - AI Stock Trading Signals
AnyRecoverAnyRecover 6.3.2
Comments and User Reviews