#Razorsql log update

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. 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. SQLite uses 'instead of' triggers to redirect update/insert/delete on views to tables etc, making changes to views seamless. It is not true that 'SQLite views are read-only'. I confirmed that RazorSQL does enter integers into an integer column in a table, thank you. 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 log 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 log 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 log 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 allows you to query, update, navigate, and manage all major databases from one database tool.