Shift 歷史舊版本 Page47

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

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

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

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

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

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

What's new in this version:

Enhancements:
- Import Tool: Added an option for whether or not to fully qualify table names in generated insert statements for delimited, Excel, and fixed width imports
- Database Browser: Added support for View Contents - Limit Results for SQLite, HSQLDB, and H2
- Added an Edit -> Backup User Data menu option for backing up all user specific RazorSQL data such as preferences, connections, etc. to a zip file
- Query Results: Added a locale specific number formatting option on the Edit -> Preferences -> Query Results screen

Changes:
- Associate File: If file is already open on an unconnected and unmodified tab, connect that tab instead of creating a new tab
- Launch Edit Table Tool from query results: If the query is a select * query and all the results are retrieved, use the already retrieved results for editing instead of re-executing a new query
- Edit Table Tool: Max rows to retrieve per table now use the connection profile specific max rows setting instead of the global max rows setting from the preferences
- Edit Table Tool: Query to populate uses a limit clause for certain databases to prevent retrieval of extra rows and improve performance

Bug Fixes:
- Connection Wizard: If profile is deleted, copied, or renamed, profile tree does not update immediately

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

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

What's new in this version:

Fixed:
- When analyzing audio in videos, the statusbar would not update properly
- Using Intel QuickSync Hardware Encoding to stream to Panel or JRemote could result in playback failing in some cases
- Typo "Confirm Actiom"
- The right and left arrows to advance image playback was not working in all cases (between 2D and 3D viewer, etc.)
- If a playlist to be uploaded was renamed in the action window, the new name didn't 'stick'

Changed:
- Further increased performance when encoding or streaming videos, both in general and specifically with active subtitles
- Made the maximum height of a menu 75% of the height of the monitor instead of 50% the height
- TV option "Closed Captions (only supported for analog television)" is renamed "Closed Captions"
- Made the lyrics lookup handle list style artist fields (it will lookup each artist individually until it finds a match)
- Uploaded playlist files can be 16 or 24 bit and can have sample rates up to 192khz

New:
- Sat>IP DVB-S channels can be scanned using Network Information Table, instead of using the static frequency list
- Added "Analyze Audio" to the customize toolbar dialog
- Closed Captioning will be turned on automatically at live TV start up if "Closed Captions" option is on

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

What's new in this version:

Enhancements:
- Connection Wizard: Added a tree view for existing connection profiles for faster selection
- Connection Wizard: Added the ability to categorize connections inside sub-folders
- Added a columnEncryptionSetting configurable property for the MS SQL Server JDBC driver
- DynamoDB: Added the ability to scan for values inside of Map columns. See https://razorsql.com/docs/dynamodb_sql_support.html for syntax details
- Connection Process: Added the ability to associate a file to a connection profile. Whenever the connection profile is connected, the file will load in the SQL editor

Changes:
- Salesforce: Updated API version to 45
- Execute procedure tool - if procedure returns a result set, results are now displayed in the query results tab of the main window
- Oracle: If DBMS Output is turned on, and query / statement does not return results but does return output, output is displayed in the query results section
- Added ability to call SQL Server / Sybase functions that return a table via the Call Procedure Tool
- Import Tool: Create Table from Import: If data values are decimal, will pre-populate decimal type with estimated precision and scale set on the create table window

Bug Fixes:
- MySQL and MariaDB: Column aliases not always appearing as column names in query results for queries that use aliases for the column names
- Initial screen size may be larger than current screen for multiple monitor machines having monitors with different resolutions