RazorSQL
RazorSQL 6.3.4
Your rating: Now say why...

(2) 4.25

Manage multiple databases from a single application.   Demo ($99.95)
Add to my Watch List
Email me when discounted
RazorSQL allows you to query, update, navigate, and manage all major databases from one database tool.

With RazorSQL, an 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
What's New
Version 6.3.4:
  • Added H2 database conversion support to and from HSQLDB, MySQL, Oracle, SQLite, MS SQL Server, PostgreSQL, and MS Access
  • Added MonetDB support
  • When closing RazorSQL with unsaved files, added a cancel option to the Yes/No save dialog
  • New session window no longer required mouse to navigate
  • Changed memory settings on Mac OS X 64-bit version
  • DynamoDB select count(*) queries with where clauses - where clauses getting ignored
  • Percent of original size field not showing correct values in zip file viewer
Version 6.3.4:
  • Added H2 database conversion support to and from HSQLDB, MySQL, Oracle, SQLite, MS SQL Server, PostgreSQL, and MS Access
  • Added MonetDB support
  • When closing RazorSQL with unsaved files, added a cancel option to the Yes/No save dialog
  • New session window no longer required mouse to navigate
  • Changed memory settings on Mac OS X 64-bit more...
Requirements
  • Intel, 64-bit processor
  • OS X 10.7 or later



MacUpdate - RazorSQL




  • Sequel Pro
    +5

  • MesaSQLite
    +1

  • DB Solo
    +1

  • MySQL Workbenc...
    +1

  • Froq
    +1

  • SQLiteManager
    +1
RazorSQL User Discussion (Write a Review)
ver. 6.x:
(2)
Your rating: Now say why...
Overall:
(10)

sort: smiles | time
burypromote
+1

+21

Popguru reviewed on 30 Jan 2013
RazorSQL has become one of my must-have development tools.

Pros:
* supports nearly every DBMS you throw at it (I've mostly used it with MySQL, SQLite, and SimpleDB)
* powerful features for editing data, generating queries, import and export
* developer is very responsive to bug reports and feature requests

Cons:
* UI takes a little getting used to
* no auto-update or update-checking functionality
* a bit pricy: if you don't work with multiple DBMSes or don't need advanced features, it may not be worth it.
[Version 6.0.3]

1 Reply

burypromote
-1

+2
rz192072 replied on 22 Mar 2013
Try Valentina Studio. It is FREE.
burypromote

+13

Lorin-Rivers reviewed on 26 Oct 2010
I would give this 5 stars (which I rarely do, reserving such for truly excellent) if it had auto-update (i.e., when new versions come out).

It would also be nice if it could translate one DB to another. That said, nothing else is quite like it, working equally well with such a wide variety of RDBMS.

It's also rock-solid, something that PGAdmin can't claim.
[Version 5.2.5]


burypromote
+1

+59

VeryVito reviewed on 03 Jun 2009
This is a full-featured DB app, and it's one of the few that handles both MySQL and SQLite (among several others). I've purchased it and remain happy with it. The price is reasonable, and the publisher is constantly improving the app with frequent free updates that continue to move it forward.

That said: While its appearance is far better than many "cross platform" DB solutions, it still doesn't feel like a "native" OS X app, and the overall navigation seems more cumbersome than it need be (for instance, one must open a separate "edit table" window, rather than simply editing a table in its current view). I'm sure this allows the app to be more flexible than say, the excellent Sequel Pro app for MySQL, but it also leads me to reach for those db-specific tools (such as Sequel Pro, SQLite Manager) first... which kills the point of the "one app to rule them all" that I was hoping this would provide.

In other words, it DOES work well with every DB I've thrown at it -- but if you don't need to access different types of DB servers, you may find you prefer a more specialized tool designed for your particular brand of database.
[Version 4.5.9]


burypromote
+1

+18
barefeettom commented on 19 Apr 2008
Here's a detailed comparison of RazorSQL with alternative SQLite GUI programs:
http://www.tandb.com.au/sqlite/compare/
[Version 4.2.4]


burypromote

+18

barefeettom reviewed on 09 Mar 2008
The improvements look great :-) Some feedback on your feedback ;-) :

1. RazorSQL now recognizing SQLite's rowid column for updates/deletes looks great. We can edit tables now that use the rowid implicit primary key. If there is an explicit primary key, however, I think RazorSQL should default to using that key and not rowid. At present it uses both, which seems redundant (eg executes WHERE rowid = 120 AND ID = 120). And if rowid is already present in a view, RazorSQL shouldn't add yet another copy of it.

2. Tabbing through a row (from column to column) now works nicely.

3. The pop up menu option to "Edit Table" is a welcome more direct method. Perhaps better still would be for double clicking on the table/view. Double click in the entity browser currently just does the same as clicking the expansion triangle so would be better utilized.

4&6. Nulls now show as empty cells in the query results pane (great), but not in the edit window (show as "null"), which makes it look cluttered. Admittedly you'd need some way to show and enter null as distinct from empty cells when editing. Perhaps something less obtrusive than the word "null", or a reference on what to show. Presumably a text entry of the literal word "null" currently appears the same as a null, so it is currently ambiguous anyway.

5. I confirmed that RazorSQL does enter integers into an integer column in a table, thank you. It is not true that "SQLite views are read-only". SQLite uses "instead of" triggers to redirect update/insert/delete on views to tables etc, making changes to views seamless. I notice that RazorSQL thankfully still allows me to edit the data in a view if I initiate it by double clicking in the query result, but that the more direct "Edit Table" option in the pop up menu in the entity browser is disabled. Please re-enable it. As for the type of the data to be entered in an update or insert, you can use pragma table_info(tableName) to get the data types of columns in views and tables and implement it to enter the correct data type. Also, RazorSQL should enter null not '' in an insert where data cells are left empty. This is especially a problem for integer primary key columns since '' is not allowed but null is happily accepted and auto replaced by the next integer, but also unnecessarily populates '' in cells where I did not ask for anything to be entered. The incomplete support for editing views is a show stopper problem.

Some more points:

7. RazorSQL shows the results of a query in a pane in the main window. When I initiate editing of data there (such as by double clicking on a data cell), RazorSQL opens a new window with a copy of that same table, and I have to locate the data cell again. It would be more intuitive, efficient and streamlined to perform the editing directly in the query result pane, rather than opening a new window.

8. Each query result shows in a new tab in the bottom right panel. They are labeled "Query 1", "Query 2" etc, which gives no indication of their origin. It would be helpful to show the table/view name.

9. The syntax coloring looks great. It would be helpful to have literals (in single quotes) show as a different color to identifiers (in double quotes). It would be even more helpful to show all identifiers (in double quotes or square brackets or unbracketed table/view/trigger/index/column names) in the same color.

10. How about a view of one record at a time, similar to "line" mode, eg:

fieldname1: value of fieldname1 in record n
fieldname2: value of fieldname2 in record n
fieldname3: value of fieldname3 in record n
fieldname4: value of fieldname5 in record n

This devotes one window/screen to one record at a time, with more room to edit.

11. The SQL formatter (indenting SQL statements) is good idea, but the current implementation is of limited use, since, for instance, it treats commas in the select statement to same as commas within brackets.

12. I struggle with the Java app GUI. Native Cocoa would look and work much better.

I'll review more if point 5 (editing of views) is addressed, since then I can find some use for it.

Thanks.
[Version 4.2.1]


burypromote
cheryl444 commented on 27 Jan 2008
I use this every day, mostly for Oracle, but also for MS SQL, Sybase, and Informix, and in my opinion, this is the best SQL client for the mac. I would recommend it to any developers.
[Version 4.1.7]


burypromote

+18

barefeettom reviewed on 03 Jan 2008
RazorSQL now supports SQLite and spaces in names (of tables, views, columns etc), which is great. It seems to be unaware of the implicit rowid primary key field in SQLite, which makes editing data in some tables impossible.

I like many of the features such as SQL History and the way it marks inserted, updated and deleted rows to be applied as a batch change.

The editing of cells has a few problems. It shows nulls as which is a bit ugly (some sort of blank would be better). It seems impossible to enter a null since entering enters that literal string. RazorSQL doesn't seem to check the type of fields when entering values, so enters integers as text instead (at least in the tables/views I tried).

Unfortunately the GUI is built on Java or something that's quite un-Mac-like and gets a bit annoying. For instance: editing the next cell in a row requires several clicks instead of just hitting tab; after selecting a table and clicking Edit, RazorSQL then asks me to re-choose the table from a pop up menu; I can't drag and drop an SQLite database file onto the app.

It is one of the better SQLite editors out there, but impractical to use in every day database editing. It's improving though.
[Version 4.1.4]

2 Replies

burypromote

+18
barefeettom replied on 03 Jan 2008
oops, it seems that this web forum doesn't like me typing .

So to clarify part of my review:

RazorSQL shows nulls as , which is a bit ugly (something unobtrusive like some kind of blank would be better). It seems impossible to set a cell to null since entering enters that as literal text.
burypromote
razorsql (developer) replied on 08 Jan 2008
The latest RazorSQL update - 4.1.5 - addresses several things from your review:

1. Unaware of SQLite rowid field

The edit table tool now displays the rowid field for SQLite.

2. Editing via the edit table tool requires several clicks

The edit table tool is now automatically editable on tab, shift-tab, click, etc. Clicking is no longer required to edit.

3. After selecting a table and hitting edit, asked to re-select table

I believe you are referring to selecting a table from the database navigator on the left-hand side of the screen. If you use the context menu for the
database navigator, you will be taken directly to the edit table tool. If you use the main Tools Edit Table menu, you will be shown a list of tables to choose
from. To determine which table to populate in the dropdown, RazorSQL first checks any highlighted text in the SQL editor to see if it is a table, and now this version also checks any selected tables in the navigator if there are no highlighted tables in the SQL editor.

4. RazorSQL showing SQLite null values as <NULL>

This problem has been addressed

5. Edit table tools enters integers as text

RazorSQL does check the field type to determine whether or not to wrap it in single quotes, etc. This problem may have been caused because you were editing a view. RazorSQL no longer allows users to bring up the edit table tool for views in SQLite since SQLite views are read-only.

6. Showing nulls in the edit table tool

RazorSQL does show null values as null in the edit table tool as it is important to many users to distinguish between null values and empty values, i.e. ''. Previous versions were incorrectly displaying null values in SQLite, and this problem has been addressed.
burypromote

+18
barefeettom commented on 06 Mar 2007
Seems like a thorough SQL database front end. But it lacks SQLite support. SQLite is built in on Mac OS X and above, and requires no server setup etc. So the user could make a database immediately using just RazorSQL, or open existing databases.

Please add SQLite support.
[Version 3.8]

2 Replies

burypromote
razorsql (developer) replied on 12 Nov 2007
SQLite support was added in version 4.0.1, which was released in July of 2007.
burypromote

+18
barefeettom commented on 12 Nov 2007
Yes, that's great to see SQLite support added now, since my original post. I've started testing Razor with some SQLite databases.

It looks good, except that it fails to parse column names containing a space (usually encapsulated in "" or [ ]), so even simple tasks such as inserting new data fails (since the generated INSERT statement is built incorrectly.
There are currently no troubleshooting comments. If you are experiencing a problem with this app, please post a comment.


Qx2 rated on 07 Mar 2014

[Version 6.3.3]



texan301 rated on 17 Mar 2012

[Version 5.6.3]



imyeez rated on 14 Apr 2011

[Version 5.5.0]



+84

Moxiesozo rated on 28 Feb 2011

[Version 5.4.0]



Sergioonweb rated on 30 Jan 2011

[Version 5.3.0]


Downloads:26,458
Version Downloads:124
Type:Developer Tools
License:Demo
Date:01 Apr 2014
Platform:Intel 64 / OS X
Price: $99.95
Overall (Version 6.x):
Features:
Ease of Use:
Value:
Stability:
Displaying 1-8 of 8
Displaying 1-5 of 5
-
-
-
Please login or create a new
MacUpdate Member account
to use this feature
Watch Lists are available to
MacUpdate Desktop Members
Upgrade Now
Install with MacUpdate Desktop.
Save time moving files & cleaning
up space wasting archives.
RazorSQL allows you to query, update, navigate, and manage all major databases from one database tool.

With RazorSQL, an 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, Firebird, FrontBase, HSQLDB, Informix, MongoDB, MySQL, OpenBase, Oracle, PostgreSQL, SimpleDB, SQLite, SQL Azure, SQL Anywhere, SQL Server, Sybase, and Teradata.


- -