Mac OS X | Business / Productivity | Database | RazorSQL

RazorSQL - 4.2.7

query, edit, browse & manage all major databases

Download v 4.2.10

(File Size: 12.9M)

Free Product Alerts!

All Time:	(5.0)
Version 4.2.7:	(5.0)
Selected Version:	4.2.7
Release Date:	2008-06-11
License:	Commercial
Downloads (version 4.2.7):	614
Downloads (all versions):	14,173
Price:	$49.95

Information Related to Version:

Broken Link? Newer Version? Tell us!

Product Description:

Query, edit, browse, and manage all major databases from one database tool. RazorSQL is a universal database query tool, programming and sql editor, database navigator, and administration tool with built-in connection capabilities for DB2, Derby, Firebird, FrontBase, HSQLDB, Informix, Microsoft SQL Server, MySQL, OpenBase, Oracle, PostgreSQL, SQL Anywhere, SQLite, and Sybase. Any other JDBC or ODBC (Windows only) compliant database is also supported. RazorSQL ships with a built-in relational database engine that is up and running out of the box and requires no end-user administration. Some of the main features contained in RazorSQL are visual tools for creating, editing, describing, altering, dropping, and viewing database objects; tools for importing and exporting data; a database browser for the viewing of database objects and structures; and a robust programming editor with support for SQL, PL/SQL, TransactSQL, SQL PL, PHP, Java, XML, HTML, and eleven other programming languages. Also included are a query builder, tools for creating, editing, and executing stored procedures, triggers, and functions, a tool to compare table data and/or query results, and SQL history. Add functionality with the plugin API.

What's new in this version:

General: By default, if a connection is dropped, RazorSQL will automatically try to re-establish the connection.
Preferences: Added option to keep alive preferences for automatically reconnecting dropped connections.
Command Line: Added import command as a command line option
Editor: Added regular expression find and replace
Auto Table Lookup: Now recognizes join clauses and will do auto table lookup on comma space in a select from clause
Auto Table Lookup: By default, auto table lookup no longer prepends schema or database for tables in current schema or current database
Auto Table Lookup: Added preference for whether or not to show schemas and databases in auto table lookup results
Auto Table Lookup: Added preference for whether or not to prepend current schema or database for tables in current schema or database.
Auto Column Lookup: Column names now displayed after "and" or "or" text.
Export Tool: By default, non insert statement exports convert nulls to blank. Can be overriden by deselecting the convert nulls . . .box
Column Lookup, Describe, and View Table Contents: Now will automatically execute without a prompt for an object name if there is selected text in the editor that matches the selected object in the current dropdown options for the tools
Column Lookup: Now remembers last schema and does a better job of remembering last table
Table Lookup: Now remembers tables, views, and system tables selection, and does a better job of remembering last schema and catalog
Table Lookup: Adde an option for whether or not to prepend schemas or databases
General: Add an "Open Copy" option to the right-click menu of the Tab
General: Add a "Make Backup" option to the right-click menu of the Tab
Check for warn if modified on focus instead of just when switching tabs
Space character now select lookup dialogs value in addition to the ENTER key
Should only be able to have one lookup dialog open at a time
System Database Navigator: Fetch size settings from the preferences are now used when retrieving database objects using the System navigator
Auto lookup and lookup dialogs no longer modal and now can be moved
Delete and Backspace characters now close lookup dialogs in addition to ESCAPE
Windows: Only one instance of RazorSQL can be opened at a time
File -> Tools and File -> Conversions not working
Commit and Match Tag share the same default keyboard shortcut
If using SPACE as an option for a keyboard shortcut inserting an extra space when typing the shortcut
Execute Procedure Tool: Parameters not being retrieved correctly for schemas or databases with spaces in the name

Operating System Requirements:

This product is designed to run on the following operating systems:

Mac OS X 10.5 Intel
Mac OS X 10.5 PPC
Mac OS X 10.4 Intel
Mac OS X 10.4 PPC
Mac OS X 10.3.9
Mac OS X 10.3
Mac OS X 10.2

Additional Requirements:

Java 1.4 or higher

Feedback Summary:

Version 4.2.7:
Overall Rating:	(5.0)	Features:	(5.0)	Support:	(4.0)
Ease of Use:	(4.0)	Quality / Stability:	(5.0)	Price:	Not rated (0.0)

Key to Types of Feedback:

Reviews Reviews Troubleshooting Usage Tips Developer Notes Commentary Featured Reviews

If you need an SQL GUI this is it - Version: 4.2.7, 6/11/2008 01:37PM PST

jeetsukumaran

I've tried almost every other, except NaviCat. This is by far the best. Both MySQL and PostgreSQL have great CLI clients, but when dealing with big tables it is sometimes difficult to browse results (especially with large text fields/ image blobs/ etc.). That's where a GUI makes itself useful. A GUI client at a minimum needs to:

(a) hassle-free/easy manual SQL composition and execution (don't need to lock oneself into idiot mode all the time)
(b) easy way to view, browse, sort and edit large tables and query results
(c) form-based editing of records with large/expanded text fields
(d) code-completion (to avoid having to remember all those column/field names!).

RazorSQL does all this (and much, much, much more). It's SQL editor is amazing. I could not bring myself to try NaviCat because it seems silly to have to buy separate GUI's for MySQL and PostgrSQL, since all that's involved is plugging in a new module to the abstraction layers, but of all the other Mac-based SQL front-ends I've tried, RazorSQL has stood out clearly as the best.