SQLite (64-bit) 歷史版本列表
更新時間：2020-12-13
更新細節：
What's new in this version:
Headline changes:
- Fix Syncplay v1.6.6 VLC connection issue
- Add support for IINA player
- Add Turkish translation
- Update Russian translation
Tweaks:
- Update version of py2exe used
- Move python_mpv_jsonipc to the vendor folder
- Actually save/load autoplayRequireSameFilenames
更新時間：2020-12-11
更新細節：
更新時間：2020-12-09
更新細節：
What's new in this version:
child_processes:
- add AbortSignal support
deps:
- update ICU to 68.1
events:
- support signal in EventTarget
- graduate Event, EventTarget, AbortController
http:
- enable call chaining with setHeader()
module:
- add isPreloading indicator
stream:
- support abort signal
- add FileHandle support to Read/WriteStream
worker:
- add experimental BroadcastChannel
更新時間：2020-12-09
更新細節：
What's new in this version:
Greater layout flexibility:
- Bring your stories to life with more tools that let you edit your layout with or without code. Single column blocks, designs using mixed widths and columns, full-width headers, and gradients in your cover block—make small changes or big statements with equal ease!
More block patterns:
- In some themes, preconfigured block patterns make setting up standard pages on your site a breeze. Let the power of patterns streamline your workflow and save you clicks. Plus, share these features with clients, editors, and more.
Better video captioning:
- To help you add subtitles or captions to your videos, you can now upload them within your post or page. This makes it easier than ever to make your videos accessible for anyone who needs or prefers to use subtitles.
Twenty Twenty-One is here:
- Twenty Twenty-One is a blank canvas for your ideas, and the block editor is the best brush. It is built for the block editor and packed with brand-new block patterns you can only get in the default themes. Try different layouts in a matter of seconds, and let the theme’s eye-catching, yet timeless design make your work shine.
- What’s more, this default theme puts accessibility at the heart of your website. It conforms to the WordPress accessibility-ready guidelines and addresses several more specialized standards from the Web Content Accessibility Guidelines (WCAG) 2.1 at level AAA. It will help you meet the highest level of international accessibility standards when you create accessible content and choose plugins which are accessible too!
A rainbow of soft pastels:
- Perfect for a new year, Twenty Twenty-One gives you a range of pre-selected color palettes in pastel, all of which conform to AAA standards for contrast. You can also choose your own background color for the theme, and the theme chooses accessibility-conscious text colors for you — automatically!
- Need more flexibility than that? You can also choose your own color palette from the color picker
Improvements for everyone:
Expanding auto-updates:
- For years, only developers have been able to update WordPress automatically. But now you have that option, right in your dashboard. If this is your first site, you have auto-updates ready to go, right now! Upgrading an existing site? No problem! Everything is the same as it was before.
Accessibility Statement:
- Even if you’re not an expert, you can start letting others know about your site’s commitment to accessibility! The new feature plugin includes template copy for you to edit and publish, and it’s written to support different contexts and jurisdictions.
Built-in Patterns:
- If you’ve not had the chance to play with block patterns yet, all default themes now feature a range of block patterns that let you master complex layouts with minimal effort. Customize the patterns to your liking with the copy, images, and colors that fit your story or brand.
For developers:
REST API authentication with Application Passwords:
- Thanks to the API’s new Application Passwords authorization feature, third-party apps can connect to your site seamlessly and securely. This new REST API feature lets you see what apps are connecting to your site and control what they do.
More PHP 8 support:
- 5.6 marks the first steps toward WordPress Core support for PHP 8. Now is a great time to start planning how your WordPress products, services, and sites can support the latest PHP version. For more information about what to expect next, read the PHP 8 developer note.
jQuery:
- Updates to jQuery in WordPress take place across three releases 5.5, 5.6, and 5.7. As we reach the mid-point of this process, run the update test plugin to check your sites for errors ahead of time
- If you find issues with the way your site looks ( e.g. a slider doesn’t work, a button is stuck — that sort of thing), install the jQuery Migrate plugin
更新時間：2020-12-08
更新細節：
更新時間：2020-12-03
更新細節：
更新時間：2020-12-02
更新細節：
What's new in this version:
- Added the sqlite3_txn_state() interface for reporting on the current transaction state of the database connection
- Enhance recursive common table expressions to support two or more recursive terms as is done by SQL Server, since this helps make queries against graphs easier to write and faster to execute
- Improved error messages on CHECK constraint failures
CLI enhancements:
- The .read dot-command now accepts a pipeline in addition to a filename
- Added options --data-only and --nosys to the .dump dot-command
- Added the --nosys option to the .schema dot-command
- Table name quoting works correctly for the .import dot-command
- The generate_series(START,END,STEP) table-valued function extension is now built into the CLI
- The .databases dot-command now show the status of each database file as determined by sqlite3_db_readonly() and sqlite3_txn_state()
- Added the --tabs command-line option that sets .mode tabs
- The --init option reports an error if the file named as its argument cannot be opened. The --init option also now honors the --bail option
Query planner improvements:
- Improved estimates for the cost of running a DISTINCT operator
- When doing an UPDATE or DELETE using a multi-column index where only a few of the earlier columns of the index are useful for the index lookup, postpone doing the main table seek until after all WHERE clause constraints have been evaluated, in case those constraints can be covered by unused later terms of the index, thus avoiding unnecessary main table seeks
- The new OP_SeekScan opcode is used to improve performance of multi-column index look-ups when later columns are constrained by an IN operator
- The BEGIN IMMEDIATE and BEGIN EXCLUSIVE commands now work even if one or more attached database files are read-only
- Enhanced FTS5 to support trigram indexes
- Improved performance of WAL mode locking primitives in cases where there are hundreds of connections all accessing the same database file at once
- Enhanced the carray() table-valued function to include a single-argument form that is bound using the auxiliary sqlite3_carray_bind() interface
- The substr() SQL function can now also be called "substring()" for compatibility with SQL Server
The syntax diagrams are now implemented as Pikchr scripts and rendered as SVG for improved legibility and ease of maintenance
更新時間：2020-12-02
更新細節：
更新時間：2020-11-25
更新細節：
What's new in this version:
Changes:
- (SEMVER-MINOR) dns: add a cancel() method to the promise Resolver
- (SEMVER-MINOR) events: add max listener warning for EventTarget
- (SEMVER-MINOR) http: add support for abortsignal to http.request
- (SEMVER-MINOR) http2: allow setting the local window size of a session
- (SEMVER-MINOR) lib: add throws option to fs.f/l/statSync
- (SEMVER-MINOR) path: add path/posix and path/win32 alias modules
- (SEMVER-MINOR) readline: add getPrompt to get the current prompt
- (SEMVER-MINOR) src: add loop idle time in diagnostic report
- (SEMVER-MINOR) util: add util/types alias module
更新時間：2020-11-20
更新細節：
What's new in this version:
Improvements:
- host/windows: Update filesystem type matching on WSL2
Fixed:
- core: Track raw actions as they are applied to prevent multiple insertions
- core/bundler: Update solution file resolution to support prerelease matching
- guest/darwin: Mount vmware synced folders for big sur guests