Presumably a text entry of the literal word "null" currently appears the same as a null, so it is currently ambiguous anyway.ĥ. Perhaps something less obtrusive than the word "null", or a reference on what to show. Admittedly you'd need some way to show and enter null as distinct from empty cells when editing. 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. Double click in the entity browser currently just does the same as clicking the expansion triangle so would be better utilized.Ĥ&6. Perhaps better still would be for double clicking on the table/view. The pop up menu option to "Edit Table" is a welcome more direct method. Tabbing through a row (from column to column) now works nicely.ģ. And if rowid is already present in a view, RazorSQL shouldn't add yet another copy of it.Ģ.
At present it uses both, which seems redundant (eg executes WHERE rowid = 120 AND ID = 120). If there is an explicit primary key, however, I think RazorSQL should default to using that key and not rowid. We can edit tables now that use the rowid implicit primary key. RazorSQL now recognizing SQLite's rowid column for updates/deletes looks great. The improvements look great :-) Some feedback on your feedback -) :ġ. 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. which kills the point of the "one app to rule them all" that I was hoping this would provide.
RAZORSQL REVIEW PRO
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. 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).
RAZORSQL REVIEW FREE
The price is reasonable, and the publisher is constantly improving the app with frequent free updates that continue to move it forward. I've purchased it and remain happy with it. This is a full-featured DB app, and it's one of the few that handles both MySQL and SQLite (among several others).
RAZORSQL REVIEW DRIVER
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. 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. It even comes with a built-in relational database engine that requires no configuration. 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.
RAZORSQL REVIEW PROFESSIONAL
The work environment is very comprehensive but is intended only for advanced and professional users.įor database experts, RazorSQL is a powerful manager that offers a wealth of capabilities in a lightweight and fast package.RazorSQL allows you to query, update, navigate, and manage all major databases from one database tool. RazorSQL also includes a powerful SQL script editor. You can query, compare tables, import or export data, create backup of tables or an entire database, cut or merge files, obtain detailed information on the DB, look at logs and more. RazorSQL is well made, light and reacts very quickly to commands.
0 kommentar(er)
