SQLite (64-bit) 歷史版本列表
更新時間：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 "<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
更新時間：2019-04-17
更新細節：
更新時間：2019-04-14
更新細節：
What's new in this version:
- Fix non-hybrid shutdown used
更新時間：2019-04-13
更新細節：
更新時間：2019-04-09
更新細節：
更新時間：2019-04-09
更新細節：
更新時間：2019-04-08
更新細節：
What's new in this version:
Python and Notebooks:
- Use a shared Python session to execute Python chunks via reticulate
- Simple bindings to access R objects from Python chunks and vice versa
- Show matplotlib plots emitted by Python chunks
Keyring:
- Store passwords and secrets securely with keyring by calling rstudioapi::askForSecret()
- Install keyring directly from dialog prompt
D3:
- Author D3 visualizations in RStudio and preview in the Viewer pane
- Use r2d3 D3 visualizations in R Notebook chunks
Jobs:
- Run any R script as a background job in a clean R session
- Monitor progress and see script output in real time
- Optionally give jobs your global environment when started, and export values back when complete
SQL:
- Author SQL queries in RStudio and preview in the SQL Results pane
Testing:
- Run Tests command in testthat R scripts for direct running
- testthat output in the Build pane with navigable issue list
- Integration with shinytest to record and run Shiny app tests
PowerPoint:
- Create PowerPoint presentations with R Markdown
Package Management:
- Specify a primary CRAN URL and secondary CRAN repos from the package preferences pane.
- Link to a package’s primary CRAN page from the packages pane.
- Configure CRAN repos with a repos.conf configuration file and the r-cran-repos-file option.
- Suggest additional secondary CRAN repos with the r-cran-repos-url option.
Plumber:
- Create Plumber APIs in RStudio
- Execute Plumber APIs within RStudio to view Swagger documentation and make test calls to the APIs
- Publish Plumber APIs to RStudio Connect
Miscellaneous:
- Git ‘Create Branch’ dialog defaults to remote associated w/current branch (if any)
- Added link to purrr cheat sheet (in Help) and link to browse all cheat sheets
- Added option to temporarily disable environment pane refreshing
- Improve NSE detection for dplyr (better understands S3 dispatch and idioms)
- Add ability to search for displayed database objects in Connections tab
- Add button to open profiler output in an external browser
- Add option to show the R Markdown render command used when knitting
- Add option to show hidden files in the Files pane
- Upgrade embedded Pandoc to 2.2.1
- Allow renames that change only file case on Windows
- Remember scroll position when navigating in Help pane
- Show warning when attempting to edit a generated file
- Allow opening .ini files with file.edit
- Add shinymod snippet for Shiny modules
- Allow changing zoom level without reloading
- New command ‘Pull with Rebase’ to pull and rebase a branch in a single step
- Click on promises in the Environment pane now calls force on the promise
- Add Rename command to File menu for quick rename of current file
- Numeric filtering in data viewer shows value distribution and supports user-entered values
- Improved support for custom knitr engines in R Notebooks
- Add support for viewing external web URLs in the Viewer pane
- Add option to disable drag-and-drop for text in the editor
- Add option to disable cursor save/load; improves performance on some Windows machines
- R startup files (e.g. .Rprofile) are now always saved with trailing newlines
- Update embedded libclang to 5.0.2 (Windows only)
- RStudio now a 64-bit application on Windows (Linux and Mac are already 64-bit)
Bug Fixes:
- Fix “Invalid byte sequence” when spell checking
- Fix incorrect Git status pane display when git detects that a file has been copied
- Fix hang when submitting empty passwords and password encryption is turned off
- Fix HTTP 500 error when navigating to directories such as /js/
- Fix issue where Build pane would get ‘stuck’ on failed Rcpp::compileAttributes() call
- Fix low/no-contrast colors with HTML widgets in notebooks with a dark theme
- Fix invalid YAML in some cases when changing R Markdown output type via dialog
- Fix error when quitting while a function named q() is present
- Fix crash when executing multiple R Notebook chunks with a failing Rcpp chunk
- Fix missing blank lines in code chunks in R Notebook preview
- Fix selection in Files pane when files are modified while checked
- Fix incorrect truncation of some R object descriptions in Environment pane
- Fix duplicate prompts in each window when using RStudio API showPrompt
- Fix proxy timeouts with the websocket used for the Terminal, via keepalive messages
- Fix file.edit failures with Chinese filenames on Windows
- Fix errors when importing non-ASCII filenames in base Import Dataset
- Fix rserver crash that can occur when proxying websockets to Shiny apps
- Fix hang on some Linux systems caused by X11 clipboard monitoring w/ option to disable monitoring
- Fix empty column titles when viewing matrices without column names
- Fix error when pressing F1 on non-function autocomplete results
- Fix hang when autocompleting filenames in large directories
- Fix inability to copy content from Viewer pane and data viewer in IE11
- Fix errant addition of msys-ssh to path on non-Windows platforms
- Fix buggy behavior with when ANSI colors are present
- Fix external process slowness (git, etc.) when open file limit RLIMIT_NOFILE is high
- Fix issue caused by resolving symlinks when choosing Git path
- Fix display of consecutive spaces in the Data Viewer
- Fix issue where ‘#’ in YAML strings would be highlighted as comments
- Fix over-eager loading of yaml package when IDE starts up
- Fix issue on Windows with R dialogs showing behind RStudio window
- Fix incorrect insertion of mousewheel handler into HTML widget JavaScript
- Fix unresponsive buttons in Connections pane when connection deletion is cancelled
- Fix RStudio hang when installing packages (e.g. BH) in Packrat projects on Windows
RStudio Server Pro:
- Overhauled R versions, allowing you to specify version labels, load environment modules, and execute a prelaunch script when loading specific - versions.
- New rsession-diagnostics-enabled option for rserver.conf to enable session launch diagnostics mode to help diagnose session launch failures.
- Added support for auth-pam-sessions-use-password option in a load balanced setup.
- Added ability to suspend sessions from user home page.
- Added hmac signature verification for proxy auth mode with new auth-proxy-require-hmac option in rserver.conf.
- Add nodes to RStudio Server Pro load-balanced clusters without service interruptions.
更新時間：2019-04-08
更新細節：
更新時間：2019-04-03
更新細節：
What's new in this version:
- Point mac users to the launched desktop app