SQLite3 full changelog
SQLite3 3.45.2
released Mar 12, 2024 (New Release)
SQLite3 3.45.0
released Jan 16, 2024 (New Release)
SQLite3 3.44.2
released Nov 24, 2023 (New Release)
Fix a mistake in the CLI that was introduced by the fix (item 15 above) in 3.44.1.
Fix a problem in FTS5 that was discovered during internal fuzz testing only minutes after the 3.44.1 release was tagged.
Fix incomplete assert() statements that the fuzzer discovered the day after the previous release.
Fix a couple of harmless compiler warnings that appeared in debug builds with GCC 16.
Fix a problem in FTS5 that was discovered during internal fuzz testing only minutes after the 3.44.1 release was tagged.
Fix incomplete assert() statements that the fuzzer discovered the day after the previous release.
Fix a couple of harmless compiler warnings that appeared in debug builds with GCC 16.
SQLite3 3.44.1
released Nov 22, 2023 (New Release)
Change the CLI so that it uses UTF-16 for console I/O on Windows. This enables proper display of unicode text on old Windows7 machines.
Other obscure bug fixes.
Other obscure bug fixes.
SQLite3 3.44.0
released Nov 1, 2023 (New Release)
Aggregate functions can now include an ORDER BY clause after their last parameter. The arguments to the function are processed in the order specified. This can be important for functions like string_agg() and json_group_array().
Add support for the concat() and concat_ws() scalar SQL functions, compatible with PostgreSQL, SQLServer, and MySQL.
Add support for the string_agg() aggregate SQL function, compatible with PostgreSQL and SQLServer.
New conversion letters on the strftime() SQL function: %e %F %I %k %l %p %P %R %T %u
Add new C-language APIs: sqlite3_get_clientdata() and sqlite3_set_clientdata().
Many errors associated with CREATE TABLE are now raised when the CREATE TABLE statement itself is run, rather than being deferred until the first time the table is actually used.
The PRAGMA integrity_check command now verifies the consistency of the content in various built-in virtual tables using the new xIntegrity method.
Add support for the concat() and concat_ws() scalar SQL functions, compatible with PostgreSQL, SQLServer, and MySQL.
Add support for the string_agg() aggregate SQL function, compatible with PostgreSQL and SQLServer.
New conversion letters on the strftime() SQL function: %e %F %I %k %l %p %P %R %T %u
Add new C-language APIs: sqlite3_get_clientdata() and sqlite3_set_clientdata().
Many errors associated with CREATE TABLE are now raised when the CREATE TABLE statement itself is run, rather than being deferred until the first time the table is actually used.
The PRAGMA integrity_check command now verifies the consistency of the content in various built-in virtual tables using the new xIntegrity method.
SQLite3 3.43.2
released Oct 10, 2023 (New Release)
Fix a couple of obscure UAF errors and an obscure memory leak.
Omit the use of the sprintf() function from the standard library in the CLI, as this now generates warnings on some platforms.
Avoid conversion of a double into unsigned long long integer, as some platforms do not do such conversions correctly.
Omit the use of the sprintf() function from the standard library in the CLI, as this now generates warnings on some platforms.
Avoid conversion of a double into unsigned long long integer, as some platforms do not do such conversions correctly.
SQLite3 3.43.1
released Sep 11, 2023 (New Release)
Fix a regression in the way that the sum(), avg(), and total() aggregate functions handle infinities.
Fix a bug in the json_array_length() function that occurs when the argument comes directly from json_remove().
Fix the omit-unused-subquery-columns optimization (introduced in in version 3.42.0) so that it works correctly if the subquery is a compound where one arm is DISTINCT and the other is not.
Other minor fixes.
Fix a bug in the json_array_length() function that occurs when the argument comes directly from json_remove().
Fix the omit-unused-subquery-columns optimization (introduced in in version 3.42.0) so that it works correctly if the subquery is a compound where one arm is DISTINCT and the other is not.
Other minor fixes.
SQLite3 3.43.0
released Aug 24, 2023 (New Release)
Add support for Contentless-Delete FTS5 Indexes. This is a variety of FTS5 full-text search index that omits storing the content that is being indexed while also allowing records to be deleted.
Enhancements to the date and time functions:
Added new time shift modifiers of the form ±YYYY-MM-DD HH:MM:SS.SSS.
Added the timediff() SQL function.
Added the octet_length(X) SQL function.
Added the sqlite3_stmt_explain() API.
Query planner enhancements:
Generalize the LEFT JOIN strength reduction optimization so that it works for RIGHT and FULL JOINs as well. Rename it to OUTER JOIN strength reduction.
Enhance the theorem prover in the OUTER JOIN strength reduction optimization so that it returns fewer false-negatives.
Enhancements to the decimal extension:
New function decimal_pow2(N) returns the N-th power of 2 for integer N between -20000 and +20000.
New function decimal_exp(X) works like decimal(X) except that it returns the result in exponential notation - with a "e+NN" at the end.
Enhancements to the date and time functions:
Added new time shift modifiers of the form ±YYYY-MM-DD HH:MM:SS.SSS.
Added the timediff() SQL function.
Added the octet_length(X) SQL function.
Added the sqlite3_stmt_explain() API.
Query planner enhancements:
Generalize the LEFT JOIN strength reduction optimization so that it works for RIGHT and FULL JOINs as well. Rename it to OUTER JOIN strength reduction.
Enhance the theorem prover in the OUTER JOIN strength reduction optimization so that it returns fewer false-negatives.
Enhancements to the decimal extension:
New function decimal_pow2(N) returns the N-th power of 2 for integer N between -20000 and +20000.
New function decimal_exp(X) works like decimal(X) except that it returns the result in exponential notation - with a "e+NN" at the end.
SQLite3 3.42.0
released May 16, 2023 (New Release)
Add the FTS5 secure-delete command. This option causes all forensic traces to be removed from the FTS5 inverted index when content is deleted.
Enhance the JSON SQL functions to support JSON5 extensions.
The SQLITE_CONFIG_LOG and SQLITE_CONFIG_PCACHE_HDRSZ calls to sqlite3_config() are now allowed to occur after sqlite3_initialize().
New sqlite3_db_config() options: SQLITE_DBCONFIG_STMT_SCANSTATUS and SQLITE_DBCONFIG_REVERSE_SCANORDER.
Query planner improvements:
Enable the "count-of-view" optimization by default.
Avoid computing unused columns in subqueries.
Improvements to the push-down optimization.
Enhancements to the CLI:
Add the --unsafe-testing command-line option. Without this option, some dot-commands (ex: ".testctrl") are now disabled because those commands that are intended for testing only and can cause malfunctions misused.
Allow commands ".log on" and ".log off", even in --safe mode.
Enhance the JSON SQL functions to support JSON5 extensions.
The SQLITE_CONFIG_LOG and SQLITE_CONFIG_PCACHE_HDRSZ calls to sqlite3_config() are now allowed to occur after sqlite3_initialize().
New sqlite3_db_config() options: SQLITE_DBCONFIG_STMT_SCANSTATUS and SQLITE_DBCONFIG_REVERSE_SCANORDER.
Query planner improvements:
Enable the "count-of-view" optimization by default.
Avoid computing unused columns in subqueries.
Improvements to the push-down optimization.
Enhancements to the CLI:
Add the --unsafe-testing command-line option. Without this option, some dot-commands (ex: ".testctrl") are now disabled because those commands that are intended for testing only and can cause malfunctions misused.
Allow commands ".log on" and ".log off", even in --safe mode.
SQLite3 3.41.2
released Mar 22, 2023 (New Release)
SQLite3 for Windows 7 - free download notice
Windows 7 Download periodically updates software information of SQLite3 from the publisher.
« BACK
My Account
Help
Windows 7 Software Coupons
-
WinX DVD Ripper
50% Off -
WinX DVD Copy Pro
42% Off -
MacX DVD Video Converter
58% Off -
MacX DVD Ripper Pro
50% Off -
WinX MediaTrans
63% Off
My Saved Stuff
You have not saved any software.
Click "Save" next to each software.
Click "Save" next to each software.
Would you like to receive announcements of new versions of your software by email or by RSS reader? Register for FREE!
Windows 7 Downloads Picks
- Portable RazorSQL 10.5.5
- PHPRunner 10.91 B41974
- SQLite Expert Personel 5.5.14
- Smart Alert Pro 1.30.12
- SQLite Expert Profesional 5.5.14
- Event Calendar Plus 1.15.5
- Air Video Server 2.3.0 Beta 1
- Print2Email Server 12.22
- Database Master 12.0.0
- ESF Database Migration Toolkit Standard 11.3.03
- MDB (Access) to DBF Converter 3.45
- SyBrowser 9.1
- Database Pooler 0.1.6
- TIFF Viewer Server 14.86
- ASA PHP Generator Professional 22.8
- DB2 PHP Generator Professional 22.8
- SharePoint Search and Replace 1.0.0.58
- Subsonic 6.1.6
- ODBC Database Query 2.2
- MailEnable Log Analysis Utility 1.0
Popular Tags
ftp server
web part
smtp server
sharepoint
log analysis
backup
log
idisk
software
analysis
iscsi target
ipds printing
server
sharepoint web part
active directory management
database
dscsi
active directory reports
sharepoint server
web server
mail server
web
sharepoint component
file server
log analyzer
virtualization
client server
network disk
pop3 server
script
Popular Windows 7 Software
- Portable RazorSQL 10.5.5
- PHPRunner 10.91 B41974
- Smart Alert Pro 1.30.12
- SQLite Expert Personel 5.5.14
- IBExpert 2024.04.07
- SmarterMail Free Edition Build 8895
- SQLite Expert Profesional 5.5.14
- Event Calendar Plus 1.15.5
- Air Video Server 2.3.0 Beta 1
- RDS Server Monitoring 5.4.1024
- IP2Location IP-COUNTRY-REGION-CITY-LATITUDE-LONGITUDE-ZIPCODE-TIMEZONE-ISP-DOMAIN-NETSPEED-AREACODE- March.2024
- Print2Email Server 12.22
- GeoServer 2.16.1
- Smart ID Pro 1.9.1
- C-MOR IP Video Surveillance Software 5.1101
© 2024 Windows7Download.com - All logos, trademarks, art and other creative works are and remain copyright and property of their respective owners. Microsoft Windows is a registered trademarks of Microsoft Corporation. Microsoft Corporation in no way endorses or is affiliated with windows7download.com.