SQLite 歷史版本列表
SQLite (32-bit)SQLite (64-bit)
更新時間：2023-11-25
更新細節：
What's new in this version:
- Fixes multiple issues with deleting text in the script
更新時間：2023-11-25
更新細節：
更新時間：2023-11-25
更新細節：
What's new in this version:
Headline changes:
- Adding --interface-ipv4 and --interface-ipv6 command line switches to server to allow better control over binding to interfaces
- Now offering a SyncplayConsole.exe bundle. This is a command line version of the Syncplay client for Windows.
- AppImage support discontinued
- Use PySide6 for Python >= 3.12 and continue to use it macOS
Tweaks:
- Re-work readiness notifications for non-operators
- Show current offset in set offset dialog
Bug fixes and maintenance:
- Fix ArchLinux GUI TypeError
- Playlist restoration should not undo clearing actions
- Support player arguments like –no-border in mpv
- Ensure MPC-HC resets position on playlist change
- Define desktop filename for Wayland compliance to fix icon
- Fix offset sub-second precision bug
- Remove broken setAlignment calls
- Don’t pass empty model to QCompleter
更新時間：2023-11-22
更新細節：
What's new in this version:
- 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
更新時間：2023-11-01
更新細節：
What's new in this version:
- 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. This works for the FTS3, FTS4, FTS5, RTREE, and GEOPOLY extensions.
- The SQLITE_DBCONFIG_DEFENSIVE setting now prevents PRAGMA writable_schema from being turned on. Previously writable_schema could be turned on, but would not actually allow the schema to be writable. Now it simply cannot be turned on.
- Tag the built-in FTS3, FTS4, FTS5, RTREE, and GEOPOLY virtual tables as SQLITE_VTAB_INNOCUOUS so that they can be used inside of triggers in high-security deployments.
- The PRAGMA case_sensitive_like statement is deprecated, as its use when the schema contains LIKE operators can lead to reports of database corruption by PRAGMA integrity_check
- SQLITE_USE_SEH (Structured Exception Handling) is now enabled by default whenever SQLite is built using the Microsoft C compiler. It can be disabled using -DSQLITE_USE_SEH=0
Query planner optimizations:
- In partial index scans, if the WHERE clause implies a constant value for a table column, replace occurrences of that table column with the constant. This increases the likelihood of the partial index being a covering index.
- Disable the view-scan optimization (added in version 3.42.0 - item 1c) as it was causing multiple performance regressions. In its place, reduce the estimated row count for DISTINCT subqueries by a factor of 8.
- SQLite now performs run-time detection of whether or not the underlying hardware supports "long double" with precision greater than "double" and uses appropriate floating-point routines depending on what it discovered.
- The CLI for Windows now defaults to using UTF-8 for both input and output on platforms that support it. The --no-utf8 option is available to disable UTF8 support.
更新時間：2023-10-11
更新細節：
What's new in this version:
- 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
更新時間：2023-09-12
更新細節：
What's new in this version:
Fixed:
- 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
更新時間：2023-08-25
更新細節：
What's new in this version:
- Google Chrome url tracking plugin fix
- MS Edge url tracking plugin fix
更新時間：2023-08-25
更新細節：
What's new in this version:
New features:
- Added Expression to CREATE INDEX
- Added cascade option while creating an extension
- Added ‘Ignore Grants’ option in the schema diff tool
- Added ‘Ignore Tablespace’ option in the schema diff tool
- Added support for ALTER INDEX column statistics
- Added unlogged option while creating a sequence
- Added all like options while creating a table
- Added support for SYSTEM, CONCURRENTLY and TABLESPACE options in REINDEX
- Added WAL option to EXPLAIN ANALYZE command
- Added new/missing options to the VACUUM command
- Added SKIP_LOCKED and BUFFER_USAGE_LIMIT option to Analyze command
- Add support for TRUNCATE trigger in foreign table
- Ensure that Schema Diff comparison results should be displayed in the sorted order
Housekeeping:
- Generate software bill of materials as part of the package builds
- Added support for PostgreSQL and EPAS 16 to ensure it works without any errors
Fixed:
- Fix incorrect redirection URL after authentication by removing fixed value set to SCRIPT_NAME environment variable in pgAdmin4.wsgi file
- Allow changing the POOL_SIZE and MAX_OVERFLOW config values of the pgAdmin config DB connection pool
- Fix an issue where query tool on shared server is throwing error if the pgAdmin config DB is external
- Fix the query tool issue where raise Notice from func/proc or code blocks are no longer displayed live
- Fix the issue where query tool window turns blank if the user tries to generate a graph on the result
- Fix an issue where changing MFA_SUPPORTED_METHODS breaks the MFA validation
- Fix an issue where pgAdmin 7.5 fails to render table SQL with extension loaded index method
- Fix an issue where cycle syntax was not added in SQL when creating new sequence from UI
- Fix an issue where the SET directive is excluded from the function header in the schema diff tool
- Fix a query tool error ‘pgAdminThread’ object has no attribute ‘native_id’
- Ensure keyboard shortcut for query execution is disabled when query execution is in progress
更新時間：2023-08-25
更新細節：
What's new in this version:
- 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.
- Added the octet_length(X) SQL function
- Added the sqlite3_stmt_explain() API
- Performance enhancements to JSON processing results in a 2x performance improvement for some kinds of processing on large JSON strings
- New makefile target "verify-source" checks to ensure that there are no unintentional changes in the source tree. (Works for canonical source code only - not for precompiled amalgamation tarballs.)
- Added the SQLITE_USE_SEH compile-time option that enables Structured Exception Handling on Windows while working with the memory-mapped shm file that is part of WAL mode processing. This option is enabled by default when building on Windows using Makefile.msc.
- The VFS for unix now assumes that the nanosleep() system call is available unless compiled with -DHAVE_NANOSLEEP=0
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
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
- If X is a floating-point value, then the decimal(X) function now does a full expansion of that value into its exact decimal equivalent