RazorSQL 9.4.5

RazorSQL – программа для управления основными базами данных внутри одной программы. Программа позволяет запускать SQl запросы, визуально редактировать, создавать, изменять и просматривать таблицы, импортировать и экспортировать данные, создавать запросы в программе создания запросов и просматривать базы данных в навигаторе баз данных. Программа также содержит встроенную реляционную базу данных, которая не требует никаких настроек. RazorSQL работает со всеми популярными базами данных, включая MySQL, Oracle, DB2, Microsoft SQL Server, PostgreSQL, Microsoft Access, Pointbase, и Sybase.

Что нового:

Version 9.0.0:
Enhancements:

• Added support for Couchbase
• Navigator / Database Browser Filter: Allow comma separated values in the contains and not contains fields
• Added a Connections -> New Tab (New Connection) menu option to the Connections main menu and context menu
• Added a Connections -> New Tab (Copy Editor) menu option to the Connections main menu and context menu
• Added a Connections -> Same Tab (Switch Connection) menu option to the Connections main menu and context menu
• Added New Session (New Connection) and New Session (Copy Editor) options to the new button popup
• Added support for Derby 10.15 for supported operating systems. NOTE: Linux 32-bit and legacy Mac OS X versions do not support Derby 10.15
• Copy Table to Another Database: Added a Generate Alter Table checkbox. If checked foreign keys are attempted to be assigned via alter table statements

Changes:

• Linux 64-bit: Updated Java Runtime Environment to version 11
• macOS (Catalina and Mojave version): Updated Java Runtime Environment to 11.0.5
• Windows 32-bit and 64-bit: Updated Java Runtime Environment to 11.0.5
• Editor Auto Save. If user closes an unsaved file and auto save is on, still prompt if the user wants to save the file
• Export Numeric Formatting Changes:
• If exporting query results (SQL, Delimited File, XML, HTML, Text): Formatting used is based on query results preference values for Locale options (primary) and decimal separator (if locale option not set)
• If exporting query results (XLS, XLSX): No formatting is used. Locale specific preferences within Excel determine how the cells are formatted
• If exporting from table(s): Numeric formatting is based on Number Format locale selected on the export window with the default being no specific formatting
• SQL -> Recent Queries menu options: Order is now based on order the statement was executed not just the timestamp when the statement was executed
• DynamoDB: Scan Requests with where clauses: For tables that have more rows than the "Max Results Per Query" value set on the RazorSQL connection profile, RazorSQL will continue to scan the table until either more rows than the Max Results Per Query value are returned, or there are no more rows to scan
• MySQL and MariaDB connections, autoReconnect property is now set to true by default
• Keep Alive: Default keep alive interval changed from 4 minutes to 2 minutes
• Keep Alive Preference: Added an option for 0.5 (30 seconds) to the keep alive interval

Bug Fixes:

• MongoDB: macOS notarized version: Not allowing connections over TLS / SSL connections that use SNI such as MongoDB Atlas free tier servers
• Mac repeat hold key preference is not on the correct line in preferences
• Query Results: Create Table from Results on Current Connection throws an error in certain situations
• SQL History: When running large numbers of statements through the editor such as thousands of inserts, SQL History process can get backed up and cause delays when trying to exit RazorSQL
• Fedora Linux: Very slow startup time / hangs on startup can occur
• Database Conversion Multiple Tables: When converting to MySQL, if the table name is a reserved word, the table name is getting wrapped in double quotes instead of tick marks in the generated SQL
• DynamoDB: Generate SQL operations from query results: Where clause not always populated

Снимки экрана:

• 
• 
•