SQLite 歷史版本列表 Page2

更新時間：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

更新時間：2023-07-27
更新細節：

What's new in this version:

New features:
- Added support to detach partitions using concurrently and finalize
- Added all supported index storage parameters while creating an index
- Added new/missing parameters to pg_dumpall (Backup Server)
- Added new/missing parameters to pg_dump (Backup Objects)
- Added new/missing parameters to pg_restore

Housekeeping:
- Remove Bootstrap and jQuery from authentication pages and rewrite them in ReactJS
- Enable cluster deployment with gp3 volume for AWS & BigAnimal cloud providers
- Clarify the LICENSE file to indicate that it is the PostgreSQL Licence
- Remove unsupported PostgreSQL versions from the container

Fixed:
- Fix an issue where queries can’t complete execution
- Fixed an issue where Import Export not working when using pgpassfile
- Fix an issue where queries longer than 1 minute get stuck - Container 7
- Fix an issue where queries get stuck with auto-completion enabled
- Fixed Query Tool/ PSQL tool tab title not getting updated on database rename
- Ensure user gets proper error if incorrect credentials are entered while authenticating AWS
- Fix an issue where the edit server fails in desktop mode if the server password is not stored
- Ensure that Backup, Restore, and Maintenance should work properly when pgpass file is used
- Fix the query tool auto-complete issue on the server reconnection
- Fix the query tool restore connection issue
- Fix the reconnecton issue if the PostgreSQL server is restarted from the backend
- Fix the connection and stability issues since v7, possibly related to background schema changes
- Fixed an issue where the query tool is unable to execute a query on Postgres 10 and below versions
- Fix the lost connection error in v7.4
- Fixed an issue where pgAdmin failed to setup role with hyphens in name
- Fixed an issue where filters are not working and query history shows empty queries
- Fix an issue where adding a sub-folder inside a folder is not working as expected in File Manager
- Fix an error ‘list’ object has no attribute ‘strip’ while attempting to populate auto-complete manually the first time
- Fixed an issue where ERD Tool can’t load the saved pgerd file from Shared Storage
- Fix an issue where inserting more than 10 rows does not work correctly in View Data; only parts end up in the table.

更新時間：2023-06-29
更新細節：

What's new in this version:

New features:
- Added support to drop databases using the ‘WITH (FORCE)’ option
- Add “[ NULLS [ NOT ] DISTINCT ]” option while creating an Index
- Added ‘OR REPLACE’ clause while creating trigger
- Added security_invoker option while creating a view

Housekeeping:
Fixed:
- Fix an issue where object explorer tree crashes occasionally
- Ensure that query tool shortcuts are working properly
- Add Password exec command and Expiration time to server export JSON and also allow them to import
- When opening pgAdmin the layout should be auto reset if it is corrupted. Reset layout menu should work if layout is corrupted while using pgAdmin
- Fix an issue where loading more rows indicator will not disappear if connection is lost
- Fix an encoding error when connecting through Pgbouncer
- Fix an issue where explain plan details is showing HTML escaped characters
- Fixed an issue where queries with temporary tables in the same transaction is not working
- Fixed an issue where preview images for themes were not loading
- Fix raise notice from func/proc or code blocks are no longer displayed live
- Fix an issue where PSQL is not working if the database name have quotes or double quotes
- Fix an issue where all the menus are enabled when pgAdmin is opened and no object is selected in the object explorer

更新時間：2023-05-17
更新細節：

What's new in this version:

- 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
- "--" as a command-line argument means all subsequent arguments that start with "-" are interpreted as normal non-option argument
- Magic parameters ":inf" and ":nan" bind to floating point literals Infinity and NaN, respectively
- The --utf8 command-line option omits all translation to or from MBCS on the Windows console for interactive sessions, and sets the console code page for UTF-8 I/O during such sessions. The --utf8 option is a no-op on all other platforms
- Add the ability for application-defined SQL functions to have the same name as join keywords: CROSS, FULL, INNER, LEFT, NATURAL, OUTER, or RIGHT
- Enhancements to PRAGMA integrity_check
- Detect and raise an error when a NaN value is stored in a NOT NULL column
- Improved error message output identifies the root page of a b-tree when an error is found within a b-tree
- Allow the session extension to be configured to capture changes from tables that lack an explicit ROWID
- Added the subsecond modifier to the date and time functions
- Negative values passed into sqlite3_sleep() are henceforth interpreted as 0
- The maximum recursion depth for JSON arrays and objects is lowered from 2000 to 1000
- Extended the built-in printf() function so the comma option now works with floating-point conversions in addition to integer conversions
- Miscellaneous bug fixes and performance optimizations

更新時間：2023-05-17
更新細節：

更新時間：2023-05-17
更新細節：

What's new in this version:

- Block themes parsing shortcodes in user generated data; thanks to Liam Gladdy of WP Engine for reporting this issue
- A CSRF issue updating attachment thumbnails; reported by John Blackbourn of the WordPress security team
- A flaw allowing XSS via open embed auto discovery; reported independently by Jakub Żoczek of Securitum and during a third party security audit
- Bypassing of KSES sanitization in block attributes for low privileged users; discovered during a third party security audit.
- A path traversal issue via translation files; reported independently by Ramuel Gall and during a third party security audit.

更新時間：2023-03-30
更新細節：

What's new in this version:

Meet the reimagined Site Editor:
- Ready for you to dive in and explore: 6.2 is your invitation to discover what the next generation of WordPress—and block themes—can do
- Now out of beta, the Site Editor has an updated interface, giving you a new way to interact with your entire site. Explore full previews of your templates and template parts, then jump in and get to editing your site from wherever you choose.

Manage menus in more ways with the Navigation block:
- Add, remove, and reorder menu items faster—with a new sidebar experience that makes editing your site’s navigation easier.

Discover a smoother experience for the Block Inserter:
- A refreshed design gives you easier access to the content you need. Use the Media tab to quickly drag and drop content from your existing Media Library. Find patterns faster with a split view that lets you navigate categories and see previews all at once.

Find the controls you want when you need them:
- Your block settings sidebar is better organized with tabs for Settings and Styles. So the tools you need are easy to identify and access.

Build faster with headers and footers for block themes:
- Discover a new collection of header and footer patterns. Use them with any block theme as a quick, high-quality starting point for your site’s templates.

Explore Openverse media right from the Editor:
- Openverse’s library catalogs over 700 million+ free, openly licensed stock images and audio—and now it’s directly integrated into the WordPress experience through the Inserter.

Focus on writing with Distraction Free mode:
- For those times you want to be alone with your ideas. You can now hide all your panels and controls, leaving you free to bring your content to life.

Meet the new Style Book:
- Get a complete overview of how every block in your site’s library looks. All in one place, all at a glance, directly in the Site Editor.

Copy and paste styles:
- Perfect the design on one type of block, then copy and paste those styles to other blocks to get just the look you want

Custom CSS:
- Power up your site any way you wish with design tools and custom CSS for another level of control over your site’s look and feel for maximum creativity and artistry in your designs
- Other highlights in 6.2
- Sticky positioning: Choose to keep top-level group blocks fixed to the top of a page as visitors scroll
- Importing widgets: Options to import your favorite widgets from Classic themes to Block themes
- Local fonts in themes: Default WordPress themes offer better privacy with Google Fonts now included

更新時間：2023-03-29
更新細節：

What's new in this version:

Tweaks and bug fixes:
- If LANG parameter is set in setup, don’t show language dialog
- Trusted Domains: Allow trusting a domain regardless of HTTP basic auth credentials
- Allow playlists to be played from network
- Fix room name case sensitivity UI issue
- Remove redundant help button from dialogs
- macOS build: upgrade to Python 3.9 and PySide2 5.15.2
- Remove Encoding from .desktop files as it’s depreciated now and add Keywords entry to .desktop files.
- Console: Document setting offset in help
- Add deprecation notice for offset help
- Add Windows Store mpv.net path support
- Update PT-BR translation
- Fixed server argument max-username-length not working
- Fix disconnected monitor bug
- Print timestamp when pausing
- Add Windows Store mpv.net path support (issue #494 raised by @soredake and resolved by @Et0h)
- Correct persistence argument type
- Remove mpv fallback warning spam
- Fixed permanent rooms on Windows servers
- Fixes converting lines to array
- Made Hungarian chars usable from MPV: ő and ű
- Typo fixes
- Linux: Fix dark mode detection by moving to darkdetect v0.7.1
- macOS: bundle PySide6, create a universal2 app; and explicitly exclude tkinter
- Explicitly pass certifi as trustRoot for Twisted
- Don’t detect SMPlayer as mplayer2
- Fix localhost connection breaking mpv chat
- More verbose connection error messages
- Fix mpv quit message
- Log –debug as UTF-8 to fix charmap mapping
- Add/fix wildcard matching of trusted subdomains
- Restore server-side playlist on reconnect

更新時間：2023-03-22
更新細節：

What's new in this version:

Updated to core 6.7.2:
- Fixed an issue where volatile licenses were eating activations
- Fixed encoding issue in installer translations
- Fixed file types filtering in archives scanning
- Minor Fixes

更新時間：2023-03-22
更新細節：