SQLite (64-bit) 歷史版本列表
更新時間：2022-11-17
更新細節：
What's new in this version:
- Add support for compiling SQLite to WASM and running it in web browsers. NB: The WASM build and its interfaces are considered "beta" and are subject to minor changes if the need arises. We anticipate finalizing the interface for the next release.
- Add the recovery extension that might be able to recover some content from a corrupt database file
- Query planner enhancement
- Recognize covering indexes on tables with more than 63 columns where columns beyond the 63rd column are used in the query and/or are referenced by the index
- Extract the values of expressions contained within expression indexes where practical, rather than recomputing the expression
- The NOT NULL and IS NULL operators (and their equivalents) avoid loading the content of large strings and BLOB values from disk
- Avoid materializing a view on which a full scan is performed exactly once. Use and discard the rows of the view as they are computed
- Allow flattening of a subquery that is the right-hand operand of a LEFT JOIN in an aggregate query
- A new typedef named sqlite3_filename is added and used to represent the name of a database file. Various interfaces are modified to use the new typedef instead of "char*". This interface change should be fully backwards compatible, though it might cause (harmless) compiler warnings when rebuilding some legacy applications
- Add the sqlite3_value_encoding() interface
- Security enhancement: SQLITE_DBCONFIG_DEFENSIVE is augmented to prohibit changing the schema_version. The schema_version becomes read-only in defensive mode
- Enhancements to the PRAGMA integrity_check statemen
- Columns in non-STRICT tables with TEXT affinity should not contain numeric values
- Columns in non-STRICT tables with NUMERIC affinity should not contain TEXT values that could be converted into numbers
- Verify that the rows of a WITHOUT ROWID table are in the correct order
- Enhance the VACUUM INTO statement so that it honors they PRAGMA synchronous setting
- Enhance the sqlite3_strglob() and sqlite3_strlike() APIs so that they are able to accept NULL pointers for their string parameters and still generate a sensible result
- Provide the new SQLITE_MAX_ALLOCATION_SIZE compile-time option for limiting the size of memory allocations
- Change the algorithm used by SQLite's built-in pseudo-random number generator (PRNG) from RC4 to Chacha20
- Allow two or more indexes to have the same name as long as they are all in separate schemas
- Miscellaneous performance optimizations result in about 1% fewer CPU cycles used on typical workloads
更新時間：2022-11-17
更新細節：
What's new in this version:
Features:
- Added an app.getPreferredSystemLanguages() API to return the user's system languages
Fixed:
- Fixed an issue where calling app.dock.setIcon(/path/t/icon) would crash when called before the ready event on app
Other Changes:
- Updated Chromium to 106.0.5249.181
- Reverted fix for chromium:1361612 due to stability issues
更新時間：2022-11-17
更新細節：
What's new in this version:
Features:
- Added an app.getPreferredSystemLanguages() API to return the user's system languages
Fixed:
- Fixed an issue where calling app.dock.setIcon(/path/t/icon) would crash when called before the ready event on app
Other Changes:
- Updated Chromium to 106.0.5249.181
- Reverted fix for chromium:1361612 due to stability issues
更新時間：2022-11-16
更新細節：
What's new in this version:
- This minor release features 29 bug fixes in Core and 21 bug fixes for the block editor
更新時間：2022-11-02
更新細節：
What's new in this version:
- After introducing foundational elements for block themes and style variations in releases 5.9 and 6.0, WordPress site builders welcome a new default theme, Twenty Twenty-Three, that is powered by 10 different styles and tagged as “Accessibility Ready.” These intentionally unique styles ensure users can apply a different look and feel to their site with a single click—all within a single theme.
New templates for an improved creator experience:
- New and more refined templates now give site builders more control over the creation of their sites. In this suite of new templates, find a custom template for posts & pages in the Site Editor. Create and edit template parts like headers and footers more quickly with a new search-and-replace tool and easily view your new site.
Design tools for more consistency and control:
- Thoughtful upgrades to the controls for design elements and blocks make laying out and building your new site a more consistent, complete, and intuitive experience
Manage menus with ease:
- New fallback options in the navigation block mean you can edit the menu that’s open; no searching needed. Plus, the controls for choosing and working on menus have their own place in the block settings. The mobile menu system also gets an upgrade with new features, including different icon options, to make the menu yours.
Cleaner layouts and document settings visualization:
- View and manage post and page settings with a better-organized display improving the use of features like template picker and scheduler
One-click lock setting for all inner blocks:
- When locking blocks, a new toggle lets you apply your lock settings to all the blocks in a containing block like the group, cover, and column blocks
Improved block placeholders:
- Various blocks have improved placeholders that reflect customization options to help you design your site and its content. For example, the Image block placeholder displays custom borders and duotone filters even before selecting an image.
Compose richer lists and quotes with inner blocks:
- The List and Quote blocks now support inner blocks, allowing for more flexible and rich compositions like adding headings inside your Quote blocks
More responsive text with fluid typography:
- Fluid typography lets you define font sizes that adapt for easy reading in any screen size
Add starter patterns to any post type:
- In WordPress 6.0, when you created a new page, you would see suggested patterns so you did not have to start with a blank page. In 6.1, you will also see the starter patterns modal when you create a new instance of any post type
Find block themes faster:
- The Themes Directory has a filter for block themes, and a pattern preview gives a better sense of what the theme might look like while exploring different themes and patterns
Keep your Site Editor settings for later:
- Site Editor settings are now persistent for each user. This means your settings will now be consistent across browsers and devices.
A streamlined style system:
- The CSS rules for margin, padding, typography, colors, and borders within the styles engine are now all in one place, reducing time spent on layout-specific tasks and helps to generate semantic class names
Updated interface options and features:
- Updates include styling elements like buttons, citations, and links globally; controlling hover, active, and focus states for links using theme.json (not available to control in the interface yet); and customizing outline support for blocks and elements, among other features.
Continued evolution of layout options:
- The default content dimensions provided by themes can now be overridden in the Styles Sidebar, giving site builders better control over full-width content. Developers have fine-grained control over these controls.
Block Template parts in classic themes:
- Block template parts can now be defined in classic themes by adding the appropriate HTML files `parts` directory at the root of the theme
Expanded support for Query Loop blocks:
- New filters let Query Block variations support custom queries for more powerful variations and advanced hierarchical post types filtering options
Filters for all your styles:
- Leverage filters in the Styles sidebar to control settings at all four levels of your site—core, theme, user, or block, from less to more specific
Spacing presets for faster, consistent design:
- Save time and avoid hard-coding values into a theme with preset margin and padding values for multiple blocks
Content-only editing support for container blocks:
- Thanks to content-only editing settings, layouts can be locked within container blocks. In a content-only block, its children are invisible to the List View and entirely uneditable. So you control the layout while your writers can focus on the content. Combine it with block-locking options for even more advanced control over your blocks.
Other notes of interest:
- 6.1 includes a new time-to-read feature showing content authors the approximate time-to-read values for pages, posts, and custom post types
- The site tagline is empty by default in new sites but can be modified in General Settings
- A new modal design offers a background blur effect, making it easier to focus on the task at hand
Enhancing WordPress 6.1 Accessibility:
- Accessibility is an integral part of the WordPress mission of fostering an inclusive community and supporting users of all types around the world. With this in mind, WordPress 6.1 includes nearly 60 updates specifically focused on enhancing the accessibility of the platform. Read these updates to learn more about the continual initiatives aimed at improving accessibility.
Improved Performance in WordPress 6.1:
- WordPress 6.1 resolves more than 25 tickets dedicated to enhancing performance with improvements for every type of site. A full breakdown can be found in the Performance Field Guide.
更新時間：2022-10-23
更新細節：
更新時間：2022-10-18
更新細節：
What's new in this version:
Security updates included in this release:
- The security team would like to thank the following people for responsibly reporting vulnerabilities, and allowing them to be fixed in this release.
- Stored XSS via wp-mail.php (post by email) – Toshitsugu Yoneyama of Mitsui Bussan Secure Directions, Inc. via JPCERT
- Open redirect in `wp_nonce_ays` – devrayn
- Sender’s email address is exposed in wp-mail.php – Toshitsugu Yoneyama of Mitsui Bussan Secure Directions, Inc. via JPCERT
- Media Library – Reflected XSS via SQLi – Ben Bidner from the WordPress security team and Marc Montpas from Automattic independently discovered this issue
- CSRF in wp-trackback.php – Simon Scannell
- Stored XSS via the Customizer – Alex Concha from the WordPress security team
- Revert shared user instances introduced in 50790 – Alex Concha and Ben Bidner from the WordPress security team
- Stored XSS in WordPress Core via Comment Editing – Third-party security audit and Alex Concha from the WordPress security team
- Data exposure via the REST Terms/Tags Endpoint – Than Taintor
- Content from multipart emails leaked – Thomas Kräftner
- SQL Injection due to improper sanitization in `WP_Date_Query` – Michael Mazzolini
- RSS Widget: Stored XSS issue – Third-party security audit
- Stored XSS in the search block – Alex Concha of the WP Security team
- Feature Image Block: XSS issue – Third-party security audit
- RSS Block: Stored XSS issue – Third-party security audit
- Fix widget block XSS – Third-party security audit
更新時間：2022-09-30
更新細節：
What's new in this version:
Fixed:
- Fix the build on Windows so that it works with -DSQLITE_OMIT_AUTOINIT
- Fix a long-standing problem in the btree balancer that might, in rare cases, cause database corruption if the application uses an application-defined page cache
- Enhance SQLITE_DBCONFIG_DEFENSIVE so that it disallows CREATE TRIGGER statements if one or more of the statements in the body of the trigger write into shadow tables
- Fix a possible integer overflow in the size computation for a memory allocation in FTS3
- Fix a misuse of the sqlite3_set_auxdata() interface in the ICU Extension
更新時間：2022-09-30
更新細節：
更新時間：2022-09-30
更新細節：
What's new in this version:
Improved:
- core: Raise error if required metadata.json box fields are not present
- core: Provider helpful error when box version format is invalid
Fixed:
- Fix flakiness when bringing up a machine that forwards ssh
- communicator/ssh: Fix private_key_path behavior when keys_only is disabled
- synced_folder/nfs: Update exports file creation
- util/downloader: Fix user agent
Vagrant-go:
- Support secret interactive input
- Support terminal coloring
- Validate if requested provider is usable and append/prepend information to errors
- Raise error if required metadata.json box fields are not present