SQLite 歷史舊版本 Page31

更新時間：2019-07-11
更新細節：

What's new in this version:

- Added the SQLITE_DBCONFIG_DQS_DML and SQLITE_DBCONFIG_DQS_DDL actions to sqlite3_db_config() for activating and deactivating the double-quoted string literal misfeature. Both default to "on" for legacy compatibility, but developers are encouraged to turn them "off", perhaps using the -DSQLITE_DQS=0 compile-time option
- DSQLITE_DQS=0 is now a recommended compile-time option

Improvements to the query planner:
- Improved optimization of AND and OR operators when one or the other operand is a constant
- Enhancements to the LIKE optimization for cases when the left-hand side column has numeric affinity
- Added the "sqlite_dbdata" virtual table for extracting raw low-level content from an SQLite database, even a database that is corrupt

Enhancements to the CLI:
- Add the ".recover" command which tries to recover as much content as possible from a corrupt database file
- Add the ".filectrl" command useful for testing
- Add the long-standing ".testctrl" command to the ".help" menu
- Added the ".dbconfig" command

Hashes:
- SQLITE_SOURCE_ID: 2019-07-10 17:32:03 fc82b73eaac8b36950e527f12c4b5dc1e147e6f4ad2217ae43ad82882a88bfa6
- SHA3-256 for sqlite3.c: d9a5daf7697a827f4b2638276ce639fa04e8e8bb5fd3a6b683cfad10f1c81b12

更新時間：2019-06-28
更新細節：

What's new in this version:

- Fix Windows Sandbox missing from apps list

更新時間：2019-06-28
更新細節：

What's new in this version:

- Tweaked the VUI Code, If video you import video has Metadata for ColorSpace
- It Will AutoSelect the proper values
- Slight Tweak to HDR VUI as well
- Updated x265 & Nvencc Encoder Settings
- x265 will now Targets 3.1
- Tweaked the VS startup filters
- Included Two versions of exe file, One targets 4.7.2 framework and other targets the newer 4.8 framework
- Updated FFMpeg, NVEnc, QSVEnc, x265, MKVTool, MTN and few other Files

更新時間：2019-06-22
更新細節：

What's new in this version:

- Add TLS (SSL) support in the Windows binaries. Opportunistic TLS is now supported on all platforms (included in PR #231 by albertosottile, requested in #217 by alxpettit)
- Add support for releasing via Snap and AppImage. Travis CI now automatically builds releases for macOS, Snap, and AppImage after every commit. This version of Syncplay is also published in the Snap store and on AppImageHub (Snap: PR #231 by albertosottile, requested in #199 by Mikaela; AppImage: coded by albertosottile)
- Add support for installing Syncplay using setuptools via a setup.py script. This required a change in our folder structure, though this change should not affect end-users. (PR #231 by albertosottile, contributions by Et0h and ObserverOfTime via PR #230, suggested in #207 by alxpettit)
- Remove the "Update list" button for public servers from the configuration dialog (PR #233 by Et0h)
- Fix an issue that prevented to use SMPlayer (issue #234 raised by elvissteinjr and resolved by Et0h)
- Some images in the GUI now scale their pixel density for Hi-DPI/Retina displays (819e6b6 and 8f5b77c by albertosottile)
- Add getValueForOS function in constants to store and extract different values for different operating systems (ff6bb74 by albertosottile)
- All the png files in resources are now automatically included in the distribution bundles (3a4cf41 by albertosottile)
- Do not ask anymore to "Press enter to exit" after closing mpv when Syncplay is used from its CLI (issue #238 raised by alxpettit and resolved by albertosottile)
- Embed darkdetect (GitHub, BSD-3-Clause) version 0.1.1 in the project vendor folder
- Some files in the repository are now released under the MIT license, while the repository stays on Apache 2.0. This is explicitly stated in the header of those files. At this moment, this exception applies to README.md and travis/appimage-script.sh.
- Upgrade qt5reactor to version 0.5
- Upgrade py2exe to version 0.9.3.0
- Upgrade PySide2 to version 5.12.3

更新時間：2019-05-19
更新細節：

What's new in this version:

- fix: downloads were using 7z extension even though it was zip instead of 7z
- update: LSMASHSource avs
- update: mkvtoolnix

更新時間：2019-05-13
更新細節：

What's new in this version:

- new: experimental new icon, please give feedback if you like it, if it's not liked then it will be reverted to the old icon
- new: in the main menu under 'Apps > Media Info > vspipe' you can show info like shown here. The main menu was not reset so it shows only if you reset it at: Tools > Edit Menu
- change: selecting a filter in the filter menu, the names that are shown in the list were improved
- update: nvenc
- update: ffmpeg, it's now possible to use vpy with ffmpeg
- update: rav1e, it's now possible to use rav1e with VapourSynth
- internal: Release() method (F11 key) added to automate the release process
- internal: Test() method updated to use relative paths

更新時間：2019-04-17
更新細節：

更新時間：2019-04-17
更新細節：

What's new in this version:

Enhanced window functions:
- Add support the EXCLUDE clause
- Add support for window chaining
- Add support for GROUPS frames
- Add support for " PRECEDING" and " FOLLOWING" boundaries in RANGE frames
- Added the new sqlite3_stmt_isexplain(S) interface for determining whether or not a prepared statement is an EXPLAIN
- Enhanced VACUUM INTO so that it works for read-only databases

New query optimizations:
- Enable the LIKE optimization for cases when the ESCAPE keyword is present and PRAGMA case_sensitive_like is on
- In queries that are driven by a partial index, avoid unnecessary tests of the constraint named in the WHERE clause of the partial index, since we know that constraint must always be true

Enhancements to the TCL Interface:
- Added the -returntype option to the function method
- Added the new bind_fallback method

Enhancements to the CLI:
- Added support for bound parameters and the .parameter command
- Fix the readfile() function so that it returns an empty BLOB rather than throwing an out-of-memory error when reading an empty file
- Fix the writefile() function so that when it creates new directories along the path of a new file, it gives them umask permissions rather than the same permissions as the file
- Change --update option in the .archive command so that it skips files that are already in the archive and are unchanged. Add the new --insert option that works like --update used to work
- Added the fossildelta.c extension that can create, apply, and deconstruct the Fossil DVCS file delta format that is used by the RBU extension
- Added the SQLITE_DBCONFIG_WRITABLE_SCHEMA verb for the sqlite3_db_config() interface, that does the same work as PRAGMA writable_schema without using the SQL parser
- Added the sqlite3_value_frombind() API for determining if the argument to an SQL function is from a bound parameter

Security and compatibilities enhancements to fts3_tokenizer():
- The fts3_tokenizer() function always returns NULL unless either the legacy application-defined FTS3 tokenizers interface are enabled using the sqlite3_db_config(SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER) setting, or unless the first argument to fts3_tokenizer() is a bound parameter
- The two-argument version of fts3_tokenizer() accepts a pointer to the tokenizer method object even without the sqlite3_db_config(SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER) setting if the second argument is a bound parameter
- Improved robustness against corrupt database files
- Miscellaneous performance enhancements
- Established a Git mirror of the offical SQLite source tree. The canonical sources for SQLite are maintained using the Fossil DVCS

更新時間：2019-04-17
更新細節：

What's new in this version:

R-Studio 8.10.173857
- Change log not available for this version


R-Studio 8.9.173593
Bug-fixes:
- The program may have crashed when parsing damaged xattr on the UFS2 file system
- Some small internal bugfixes


R-Studio 8.9.173589
New features:
- Estimation of chances for successful file recovery
- Recovery of names and paths for files deleted to Recycle Bin and Trash
- Support for ReFS 3.4 file system

Improvements:
- A complete redesign of the Find/Mark dialog box.
- The parsing and reconstruction of the FAT32 and NTFS file systems has been improved.
- The parsing of scanned APFS partitions has been improved, especially for large APFS file systems, for which the decrease of parsing time may reach several thousand times.

Bug-fixes:
- Large ext4 file systems (60+TB) may have been processed incorrectly. Fixed.
- Sometimes the program may have crashed or frozen during file enumeration and disk scan. Fixed.
- The program may have written data to network drives incorrectly. Fixed.
- Sometimes file systems on automatically created virtual RAIDs may have been created incorrectly when the RAID parents were disk images. Fixed.

更新時間：2019-04-17
更新細節：

What's new in this version:

Enhanced window functions:
- Add support the EXCLUDE clause
- Add support for window chaining
- Add support for GROUPS frames
- Add support for "<expr> PRECEDING" and "<expr> FOLLOWING" boundaries in RANGE frames
- Added the new sqlite3_stmt_isexplain(S) interface for determining whether or not a prepared statement is an EXPLAIN
- Enhanced VACUUM INTO so that it works for read-only databases

New query optimizations:
- Enable the LIKE optimization for cases when the ESCAPE keyword is present and PRAGMA case_sensitive_like is on
- In queries that are driven by a partial index, avoid unnecessary tests of the constraint named in the WHERE clause of the partial index, since we know that constraint must always be true

Enhancements to the TCL Interface:
- Added the -returntype option to the function method
- Added the new bind_fallback method

Enhancements to the CLI:
- Added support for bound parameters and the .parameter command
- Fix the readfile() function so that it returns an empty BLOB rather than throwing an out-of-memory error when reading an empty file
- Fix the writefile() function so that when it creates new directories along the path of a new file, it gives them umask permissions rather than the same permissions as the file
- Change --update option in the .archive command so that it skips files that are already in the archive and are unchanged. Add the new --insert option that works like --update used to work
- Added the fossildelta.c extension that can create, apply, and deconstruct the Fossil DVCS file delta format that is used by the RBU extension
- Added the SQLITE_DBCONFIG_WRITABLE_SCHEMA verb for the sqlite3_db_config() interface, that does the same work as PRAGMA writable_schema without using the SQL parser
- Added the sqlite3_value_frombind() API for determining if the argument to an SQL function is from a bound parameter

Security and compatibilities enhancements to fts3_tokenizer():
- The fts3_tokenizer() function always returns NULL unless either the legacy application-defined FTS3 tokenizers interface are enabled using the sqlite3_db_config(SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER) setting, or unless the first argument to fts3_tokenizer() is a bound parameter
- The two-argument version of fts3_tokenizer() accepts a pointer to the tokenizer method object even without the sqlite3_db_config(SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER) setting if the second argument is a bound parameter
- Improved robustness against corrupt database files
- Miscellaneous performance enhancements
- Established a Git mirror of the offical SQLite source tree. The canonical sources for SQLite are maintained using the Fossil DVCS