What's New in Version 1.0.30

+ Arrow keys can now be used to navigate tables when editing.+ Updated internal SQLite version to 3.8.4.3. See https://sqlite.org/changes.html for version details.+ When dragging a table/column to the query editor, the query editor now gets focussed correctly.+ Fixed an issue where the table list could sometimes scroll to the top.+ Fixed an issue that could cause the app to not properly detect when a database has been modified by an external source.+ A few improvements to autocomplete.+ Fixed an issue when editing favorite queries.+ Fixed an issue where users may be unable to edit rows containing a column without a datatype.+ Fixed searching within the query editor.+ Fixed an issue with unique columns which could cause application crashes on database load.+ Fixed a crash that could happen if the query execution shortcut contained the return key.

What's New in Version 1.0.29

+ Updated the SQL3 engine to version 3.8.2.+ Added the ability to load sqlite extensions.+ Included a sample database.+ Fixed an issue with columns with no types may not always display correctly.+ Improved auto-complete.

What's New in Version 1.0.27

What's New in Version 1.0.26

+ Timestamp columns are now displayed as date-times (this can be disabled via preferences).+ You can now enter a date values into a timestamp column.+ Fixed wonky column resizing when executing a query.

What's New in Version 1.0.23

What's New in Version 1.0.22

+ You can now disable the rowcount display. This greatly improves performance for databases with large numbers of rows.+ Added the 'Vacuum' context menu item.+ Fixed a bug where databases with invalid foreign keys would not show any tables.

What's New in Version 1.0.21

Import & Export updates

+ You can now specify the separator for CSV files.+ Improved performance for all exports/imports.+ Table context menus now include export/import options.+ Import/Export default tables are now context sensitive to the selected table.

Bugfixes:+ Fix an issue with escaping column names when using the inline filters.+ Fixed an issue that would cause quotes and dashes to be replaced with Smart Quotes and Dashes in Mavericks.

What's New in Version 1.0.20

+ Filter button now toggles state when it is set.+ Added a preferences window. You can now toggle Line Numbers, Syntax Highlighting, Font and Query Execution shortcut.+ Bugfix: Adding a index now updates the schema tab.+ Bugfix: Default name when adding an index is now unique.+ Bugfix: Fixed an issue where toggling null on new columns would sometimes not work properly.+ Bugfix: Fixed an issue that could cause the application to crash on Mavericks when opening a WAL database.

What's New in Version 1.0.19

+ Fixed an issue with creating a new database.+ Fixed a tabbing issue when editing data.+ Fixed an issue when editing data that could cause the action to not apply if another UI option was chosen before the data was committed.

What's New in Version 1.0.16

What's New in Version 1.0.15

+ Cmd + 1,2 & 3 can now be used to switch between tabs.+ Fix for executing PRAGMA commands from within the UI.+ Fixed an issue with handling unique columns.+ Fixed an issue that could cause json export to freeze.+ Fixed an issue with adding/renaming a column.

What's New in Version 1.0.14

+ Improved multi-query execution. You can now get the dataset for multiple queries.+ Fixed an issue with square brackets and highlighting.+ When selecting a view, columns are now visible in the UI (but cannot be added or modified directly).+ You can now insert, update and delete from 'manifest' views.+ Triggers can now be added to views via the UI.+ Filters now work properly for views on the data tab.+ Added a column modification dialog that allows for multiple actions to be taken at once. Handy when creating a new table. (You can also continue to use the existing column view for modifications).+ Improvements to dependency resolution (when renaming a table or view).+ Triggers are now visible in the structure tab.+ Inline editing has been improved. You can now tab through fields and rows easier than before.+ Advanced data editor has been improved.

What's New in Version 1.0.13

+ Made some UI improvements based on user feedback!+ You can now Drag & Drop table columns to reorder.+ Recent files on main page can now be double clicked to open.+ Moved the table/view search-bar over a few pixels to better center it.+ Deleting a column now confirms your intent.+ Possibly fixed an issue where setting null did not always work. Bug was noted in a user review, but I was unable to reproduce. If the bug still exists, I would love the user to visit our forum :)+ Modified a few resizing options (splitters, columns).

What's New in Version 1.0.9

1.0.9:

+ You can now apply a data filter via the return key rather than needing to hit the apply button.+ You can now drag+drop table/view names directly to the query window.+ Added an execution time display to the query tab.+ Fixed an issue that could cause a crash when deleting a column that has a unique index.+ Fixed an issue with CSV import.+ Fixed an issue with Export to MySQL.+ Fixed a rename issue with favorite queries.+ Fixed an issue with unicode characters in the query view.+ You can now delete multiple rows of data at once.+ You can now copy data directly from the data table to your clipboard.

1.0.8:

+ Databases are now automatically reloaded when a modification happens outside of the application.

+ Fixed an issue with handling columns with no data type. This issue would cause crashes or flaky behavior. + Fixed an issue with filtering tables. + Added additional supported file types. + When in the query tab, if you have a partial query highlighted, it will now be executed instead of the full query.