RazorSQL allows you to query, update, navigate, and manage all major databases from one database tool. With RazorSQL, a SQL query tool, SQL editor, and database navigator, you can run SQL scripts, visually edit, create, alter, and view tables, import and export data, build queries with a query builder tool, and navigate databases with the database navigator. It even comes with a built-in relational database engine that requires no configuration.
The SQL programming editor has syntax highlighting for SQL, PL/SQL, TransactSQL, SQL PL, and Java, automatic function/method lookup, automatic column lookup, key ahead, built-in and customizable templates, multi-tabular display of query results, query logging, and many other features including a tool to call stored procedures and a tool to compare table and/or query data.
RazorSQL has been tested with virtually all popular databases, and includes built in driver support for Cassandra, DB2, Derby, DynamoDB, Firebird, FrontBase, Hive, HSQLDB, Informix, MongoDB, MySQL, OpenBase, Oracle, PostgreSQL, Redshift, Salesforce, SimpleDB, SQLite, SQL Azure, SQL Anywhere, SQL Server, Sybase, Teradata, and others.
- File System Browser and FTP / SFTP Browser: Added ability to sort by file type
- Added print editor contents using web browser and print editor contents with line numbers using web browser options to the File -> Print menu
- Added print query results using web browser and print query results with line numbers using web browser options to the File -> Print menu
- Added the ability to open the same file in multiple tabs via the Edit -> Preferences -> Editor / GUI -> Allow Same File in Multiple Tabs preference
- File -> Open: If a SQLite database is detected, prompts for whether to connect to the database or edit the database file in the editor
- Upgraded DB2 driver to version 3.72. Now supports TLS version 1.2
- Upgraded SQLite driver to version 3.23
- Cassandra: Non-select statements with comments prior to the statement throwing errors
- SQLite: Certain images / binary data / blobs are not getting displayed in hex value in query results causing potential hanging issues
- MongoDB: When authentication is enabled, can't connect with role that doesn't have listDatabases / listCollections.
- Salesforce: If a parent field referenced in the query has a null value and a child field referenced in the query has the same name as another field in the query, the value is getting set incorrectly
OS X 10.7 or later, 64-bit processor