SQLite Professional

Licence: Commercial with demo
Version 1.0.30 | Release Date: 2014-04-24 | Download

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.

Version 1.0.29 | Release Date: 2014-03-14 | Download

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.

Version 1.0.27 | Release Date: 2014-02-27 | Download

What's New in Version 1.0.27

+ Improvements to auto-complete.
+ Changes to the way 'wal' databases are handled.

Version 1.0.26 | Release Date: 2014-02-20 | Download

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.

Version 1.0.24 | Release Date: 2014-02-16 | Download

What's New in Version 1.0.24

+ Columns are now listed in the tree view. (And can be disabled via preferences).
+ Improvements to auto-complete.

Version 1.0.23 | Release Date: 2014-01-29 | Download

What's New in Version 1.0.23

+ Fixed an issue where importing could cause a hang/crash.
+ Really added the 'Vacuum' command.

Version 1.0.22 | Release Date: 2014-01-25 | Download

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.

Version 1.0.21 | Release Date: 2013-11-14 | Download

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.

Version 1.0.20 | Release Date: 2013-10-31 | Download

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.

Version 1.0.19 | Release Date: 2013-10-18 | Download

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.

Version 1.0.18 | Release Date: 2013-10-12 | Download

What's New in Version 1.0.18

+ Fixed an issue that could cause the database to application to crash when loading a database with a unique column.
+ Fixed an issue that could cause the application to hang.

Version 1.0.17 | Release Date: 2013-10-02 | Download

What's New in Version 1.0.17

+ Fixed a few issues around reading/writing to databases using WAL mode.
+ Fixed an issue with duplicating a file.

Version 1.0.16 | Release Date: 2013-09-19 | Download

What's New in Version 1.0.16

+ Fixed an issue where some of the UI could become disabled.
+ Fixed an issue dealing with spaces in primary key column names.

Version 1.0.15 | Release Date: 2013-09-11 | Download

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.

Version 1.0.14 | Release Date: 2013-09-01 | Download

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.

Version 1.0.13 | Release Date: 2013-08-21 | Download

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).

Version 1.10 | Release Date: 2013-06-30 | Download

What's New in Version 1.10

+ Auto-Complete has been added!
+ Fixed an issue with auto-increment column detection.
+ Improved column type detection.
+ Fixed an issue where importing binary data may not properly display.
+ Fixed an issue that could sometimes cause import functionality to fail.
+ General UI updates.

Version 1.0.9 | Release Date: 2013-06-26 | Download

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.

1.0.7:

+ Added CSV, Json and XML import.
+ Fixed a UI update issue when designing foreign keys.

1.0.6:

+ Added favorites options for custom queries.
+ Added history menu to custom queries.

1.0.5:

+ Added an export option to custom query results.
+ Fixed an issue that could cause some databases to be blank.
+ Fixed an issue that could cause Delete/Update actions for foreign keys to be removed.

1.0.4:

+ Added backwards compatibility for SQLite 2 databases.
+ Fixed an issue with setting column sizes and default values.
+ Improved data handling.
+ Fixed an issue with column names containing spaces.
+ Virtual table details will no longer be forgotten.
+ Column widths are now persistent.

1.0.3:

+ Fixed an issue that could cause crashes on launch for some users.
+ Fixed an issue with clearing filters.
+ Fixed an issue with the filter display.

1.0.2:

+ Added support for tables with foreign keys.
+ Added support for tables with triggers.
+ Updated user interface.
+ Better index support.
+ Better support for decimal data types.
+ Fixed an issue with handling datatypes.

1.0.1:

+ 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.

Version 1.0.3 | Release Date: 2013-02-18 | Download

<div class="product-review" metrics-loc="Titledbox_What's New in Version 1.0.3" more-text="More">

<h4>

What's New in Version 1.0.3
</h4>



<p>1.0.3:<br /><br />✓ Fixed an issue that could cause crashes on launch for some users.<br />✓ Fixed an issue with clearing filters.<br />✓ Fixed an issue with the filter display.<br /><br />1.0.2: <br /><br />✓ Added support for tables with foreign keys. <br />✓ Added support for tables with triggers. <br />✓ Updated user interface. <br />✓ Better index support. <br />✓ Better support for decimal data types. <br />✓ Fixed an issue with handling datatypes. <br /><br />1.0.1: <br /><br />✓ Fixed an issue with handling columns with no data type. This issue would cause crashes or flaky behavior. <br />✓ Fixed an issue with filtering tables. <br />✓ Added additional supported file types. <br />✓ When in the query tab, if you have a partial query highlighted, it will now be executed instead of the full query.</p>


</div>