SQLPro for SQLite Changelog

What's new in SQLPro for SQLite 2024.10

Jan 25, 2024
  • Performance improvements.

New in SQLPro for SQLite 2023.52 (Jan 25, 2024)

  • Working on fixing a hanging crash some users were seeing.

New in SQLPro for SQLite 2023.50 (Jan 25, 2024)

  • Fixed a crash on macOS 10.13.

New in SQLPro for SQLite 2023.45 (Jan 25, 2024)

  • Can now use 'Any' filter. [#910](https://github.com/hankinsoft/SQLPro/issues/910)

New in SQLPro for SQLite 2023.43 (Jan 25, 2024)

  • Fixed an issue with pates.

New in SQLPro for SQLite 2023.42 (Jan 25, 2024)

  • Added support for FTS3,FTS4 & FTS5.
  • Added support for 'STRICT' tables.

New in SQLPro for SQLite 2023.35 (Jan 25, 2024)

  • Fixed a crash that could occur when launching the app.

New in SQLPro for SQLite 2023.31 (Jan 25, 2024)

  • Fixed horizontal grid setting not working properly.
  • Added 'decimal separator' and 'thousands separator' to the results appearance section in preferences.
  • Fixed an issue with column wildcard search in autocomplete.
  • Added a 'Select All Occurrences' context menu item to the editor.

New in SQLPro for SQLite 2023.28 (Jan 25, 2024)

  • Fixed a core date conversion issue. [893](https://github.com/hankinsoft/SQLPro/issues/893)

New in SQLPro for SQLite 2023.27 (Jan 25, 2024)

  • Added an additional 'view timestamps as' option. [#893](https://github.com/hankinsoft/SQLPro/issues/893)

New in SQLPro for SQLite 2023.15 (Jan 25, 2024)

  • Added the full file path to the title bar.

New in SQLPro for SQLite 2022.103 (Feb 7, 2023)

  • Fixed an issue where selecting data rows would not enable the 'remove row' button via the UI. [#861](https://github.com/hankinsoft/SQLPro/issues/861)

New in SQLPro for SQLite 2022.96 (Feb 7, 2023)

  • Fixed an issue with adding a new column.

New in SQLPro for SQLite 2022.40 (Jun 11, 2022)

  • Fixed an issue where editing a value cause columns to resize and/or filters to get reset. [#777](https://github.com/hankinsoft/SQLPro/issues/777)

New in SQLPro for SQLite 2022.31 (Jun 11, 2022)

  • Fixed an issue with setting foreign keys. [#571](https://github.com/hankinsoft/SQLPro/issues/571)
  • Fixed an issue where the `sqlite_sequence` table was not showing up in system tables. [#771](https://github.com/hankinsoft/SQLPro/issues/771)

New in SQLPro for SQLite 2022.30 (Jun 11, 2022)

  • The filter keyboard shortcut should now no longer require the data or results grid to be selected. [#739](https://github.com/hankinsoft/SQLPro/issues/739)

New in SQLPro for SQLite 2022.28 (Jun 11, 2022)

  • You can now resize the name column on the favourites editor. [#765](https://github.com/hankinsoft/SQLPro/issues/765)

New in SQLPro for SQLite 2022.27 (Jun 11, 2022)

  • Fixed an issue where switching between tables may not update the visible records properly. [#762](https://github.com/hankinsoft/SQLPro/issues/762)

New in SQLPro for SQLite 2022.26 (Jun 11, 2022)

  • Fixed an issue where `ON CONFLICT` statements were being dropped when altering tables. [#761](https://github.com/hankinsoft/SQLPro/issues/761)

New in SQLPro for SQLite 2022.24 (Jun 11, 2022)

  • Window position and sidebar size is now stored properly. [#411](https://github.com/hankinsoft/SQLPro/issues/411)
  • Fixed a crash that could occur when modifying columns. [#755](https://github.com/hankinsoft/SQLPro/issues/755)
  • App icon will no longer bounce if the database file has been reloaded. [#560](https://github.com/hankinsoft/SQLPro/issues/560)

New in SQLPro for SQLite 2022.12 (Feb 24, 2022)

  • Made some improvements to the data grid.

New in SQLPro for SQLite 2022.11 (Feb 23, 2022)

  • Fixed an issue where adding and removing records on the data field would not update the row count.
  • Fixed an issue where inserting rows would not display an updated value (for say a primary key auto increment).

New in SQLPro for SQLite 2022.4 (Feb 23, 2022)

  • Fixed a crash that could occur when discarding changes.

New in SQLPro for SQLite 2022.3 (Feb 23, 2022)

  • Fixed an issue where some users were being prompted to purchase.

New in SQLPro for SQLite 2022.2 (Feb 23, 2022)

  • Improvements with the data grid.

New in SQLPro for SQLite 2022.1 (Jan 5, 2022)

  • Fixed an issue where the favourites menu may disappear. [#460](https://github.com/hankinsoft/SQLPro/issues/460)

New in SQLPro for SQLite 2021.110 (Jan 5, 2022)

  • Favorites are now stored on the iCloud file system (or local file system if iCloud is disabled).

New in SQLPro for SQLite 2021.72 (Jan 5, 2022)

  • Fixed a crash which could occur when comparing databases.

New in SQLPro for SQLite 2021.55 (Jan 5, 2022)

  • Fixed an issue where the query editors theme might not switch properly with light/dark mode.

New in SQLPro for SQLite 2021.34 (Jan 5, 2022)

  • General improvements.

New in SQLPro for SQLite 2021.32 (Jan 5, 2022)

  • Attempt at fixing CSV export window not disappearing.

New in SQLPro for SQLite 2021.27 (Mar 26, 2021)

  • Fixed a crash issue when importing a CSV file into a table with no data types set.

New in SQLPro for SQLite 2021.20 (Mar 23, 2021)

  • App icon now uses Big Sur style guide.
  • Insert CSV now includes 'treat blank string as null' option.
  • Export CSV now includes 'tread null as blank string' option.
  • Fixed a crash that could occur for some users when opening preferences.

New in SQLPro for SQLite 2021.19 (Mar 23, 2021)

  • Fixed an issue with updating multiple rows in an sqlite connection.
  • Queries run through the 'preview dialog' are now added to the query history.

New in SQLPro for SQLite 2021.18 (Mar 23, 2021)

  • Additional CSV import improvements.

New in SQLPro for SQLite 2021.17 (Mar 23, 2021)

  • Improvements with imports.
  • You can now duplicate tables from the database tree.
  • Fixed an issue when editing multiple data rows and hitting apply, semicolons were not being added to split statements up.

New in SQLPro for SQLite 2021.16 (Mar 23, 2021)

  • Import improvements.

New in SQLPro for SQLite 2021.15 (Mar 23, 2021)

  • Additional improvements with CSV, JSON and XML imports.

New in SQLPro for SQLite 2021.14 (Mar 23, 2021)

  • Some CSV import improvements.
  • Added a copy css with headers keyboard shortcut (CMD+Shift+C).

New in SQLPro for SQLite 2020.106 (Mar 23, 2021)

  • Fixed an issue with loading non-v4 UUIDs. (https://github.com/hankinsoft/SQLPro/issues/543)
  • Autocomplete improvements when using BigSur.

New in SQLPro for SQLite 2020.104 (Nov 30, 2020)

  • Apple Silicon support.
  • Fixed a crash that some users were seeing when exporting results.
  • Big Sur improvements.

New in SQLPro for SQLite 2020.96 (Nov 30, 2020)

  • Apple Silicon support.

New in SQLPro for SQLite 2020.92 (Nov 30, 2020)

  • MacOS 10.12 or above is now the minimum version supported.
  • Fixed a crash which could occur when running large queries. [#514](https://github.com/hankinsoft/SQLPro/issues/514).
  • Restored SQLite2 support.
  • Added 'SQLite3' as an export option (creates a duplicate of the database).

New in SQLPro for SQLite 2020.86 (Nov 30, 2020)

  • Fixed a keyboard shortcut issue when using dvorak layout.
  • Fixed an issue where exporting as Pipe would not always work. [#498](https://github.com/hankinsoft/SQLPro/issues/498)
  • Multi cursor improvements with arrow up/down cursor selection.
  • Fixed an issue with query line numbers display.
  • Fixed an issue that could cause a crash when inserting/duplicating rows, deleting rows, then cancelling actions together on the results grid.

New in SQLPro for SQLite 2020.80 (Nov 30, 2020)

  • Fixed an issue with escaping values. [#488](https://github.com/hankinsoft/SQLPro/issues/488)
  • Added the common enter/exit full-screen keyboard shortcut. [#497](https://github.com/hankinsoft/SQLPro/issues/497).

New in SQLPro for SQLite 2020.75 (Sep 16, 2020)

  • Fixed an issue where numeric column names were not being escaped properly in the data view.
  • Some improvements with the autocomplete cache.

New in SQLPro for SQLite 2020.61 (Jul 10, 2020)

  • Fixed an issue where editing values may cause a crash. [#450](https://github.com/hankinsoft/SQLPro/issues/450)
  • Opening a SQLite file will no longer prompt to access wal and shm files.

New in SQLPro for SQLite 2020.35 (Apr 7, 2020)

  • [macOS] Fixed an issue with tabs in the query editor. [#395](https://github.com/hankinsoft/SQLPro/issues/395)
  • [macOS] Improvements with the History popup. [#400](https://github.com/hankinsoft/SQLPro/issues/400)
  • [macOS] Alias improvements. [#396](https://github.com/hankinsoft/SQLPro/issues/396)
  • [macOS] When modifying rows via the results-grid there is now an 'Apply' button, so that changes can be applied without needing to preview first.
  • [macOS] Fixed an issue with SQLite table editor not displaying column types in dropdown. [#398](https://github.com/hankinsoft/SQLPro/issues/398)
  • [macOS] Result messages are now monospaced.
  • [macOS] Result messages now uses the same font size as the query text editor.
  • [macOS] Result error messages are now more of a 'whiteish-pink' when using a dark theme (a bit easier on the eyes).
  • [macOS] Fixed an issue where SQLite column names were not being escaped when updated. [#388](https://github.com/hankinsoft/SQLPro/issues/388)
  • [macOS] Improvements on handling syntax highlighting if object types conflict. [#298](https://github.com/hankinsoft/SQLPro/issues/298)
  • [macOS] Fix for 'blue turds' in query text view. [via twitter](https://twitter.com/danielpunkass/status/1236062931097473024?s=21)
  • [macOS/iOS] Fixed an issue where autocomplete may sometimes escape object object when not required. [346](https://github.com/hankinsoft/SQLPro/issues/346)
  • [macOS] Fixed an issue when CSV importing when column name case did not match the csv file.
  • [macOS] Failed CSV imports now have a 'view insert' option which displays the failed insert statement.
  • [macOS]** Fixed an issue where having cap-locks on would disable tab indent/un-indent. [#335](https://github.com/hankinsoft/SQLPro/issues/335)
  • [macOS]** Fixed a crash with autocomplete.

New in SQLPro for SQLite 2019.09.09 (Sep 10, 2019)

  • Resolved an issue which could cause an occasional crash.
  • Improved database support.

New in SQLPro for SQLite 2019.06.21 (Jul 9, 2019)

  • You can now specify appearance for results - such as font size, font & padding.
  • Fixed an issue where disabling database auto-reloading may not work for all users.
  • Timestamp display can now be configured as integer, epoc, or core data for display.

New in SQLPro for SQLite 1.0.457 (Apr 17, 2019)

  • Fixed an issue where some users were being prompted for a license key when running a query.

New in SQLPro for SQLite 1.0.456 (Apr 14, 2019)

  • Fixed an issue with copying from the data tab after reordering columns. Previously the re-order was not copying correctly. It is now.
  • Added 'default copy' options. They can be accessed from the preferences menu item.

New in SQLPro for SQLite 1.0.455 (Apr 11, 2019)

  • Previously, when truncating a table via the context menu, the data tab was not cleared. This has been resolved.
  • Fixed an issue where the preview query dialog was not showing the app icon.

New in SQLPro for SQLite 1.0.454 (Apr 11, 2019)

  • Fixed an issue where hitting the 'filter' button would sometimes be blank.

New in SQLPro for SQLite 1.0.440 (Mar 15, 2019)

  • Fixed an issue where the 'alter table' window would sometimes not be visible.

New in SQLPro for SQLite 1.0.430 (Mar 15, 2019)

  • Fix for messages when running update statements. Rather than x rows affected, message was displaying 0 results found.
  • Improvements for saving database files.
  • Fixed a few low hanging crashes.

New in SQLPro for SQLite 1.0.402 (Feb 27, 2019)

  • Fixed a crash that could occur for some users when loading foreign keys.

New in SQLPro for SQLite 1.0.401 (Feb 27, 2019)

  • Added foreign key linking support.
  • Fixed an issue where line numbers would appear hidden on the 'Data' tab.

New in SQLPro for SQLite 1.0.315 (Jan 13, 2019)

  • Fixed query execution keyboard shortcut always requiring shift.
  • Fixed an issue where the data tab may sometimes display duplicate columns.
  • Fixed an issue with creating new SQLite documents.

New in SQLPro for SQLite 1.0.306 (Nov 8, 2018)

  • Fix for query history not persisting between app launches.
  • Fix for decimal rounding and truncations not appearing correctly.

New in SQLPro for SQLite 1.0.301 (Oct 14, 2018)

  • Mojave and Dark mode support.
  • Performance improvements for large queries.
  • Updated SQLite version to 3.25.1.

New in SQLPro for SQLite 1.0.113 (Nov 18, 2017)

  • Fixed a crash that could occur when editing a result set inline.

New in SQLPro for SQLite 1.0.112 (Oct 30, 2017)

  • Fixed a crash that could occur when expanding results text from the data tab.

New in SQLPro for SQLite 1.0.110 (Oct 28, 2017)

  • SQLite version updated to 3.21.0.
  • High Sierra improvements.
  • Improvements for JSON export (null handling and numeric handling).
  • Memory improvements for CSV export.

New in SQLPro for SQLite 1.0.105 (Nov 5, 2016)

  • Fixed a performance issue some users were seeing when loading databases.

New in SQLPro for SQLite 1.0.102 (Oct 18, 2016)

  • Improvements in dealing with large datasets.
  • Resolved an issue where changes could sometimes be lost.

New in SQLPro for SQLite 1.0.101 (Sep 27, 2016)

  • Resolved a few performance issues.

New in SQLPro for SQLite 1.0.98 (Aug 28, 2016)

  • Resolved an issue which could cause crashes when editing results with null values.
  • Added an option 'dark results grid' mode.

New in SQLPro for SQLite 1.0.94 (Aug 21, 2016)

  • SQLite updated to 3.14.
  • Fixed an issue with copying from the results grid (it could contain duplicate entries).
  • Fixed an issue where some users could experience crashes when switching between tables.
  • Fixed an issue where triggers could sometimes not be detected.

New in SQLPro for SQLite 1.0.87 (May 29, 2016)

  • Fixed an issue where database changes would sometimes not be saved.

New in SQLPro for SQLite 1.0.75 (Apr 22, 2016)

  • Added error highlighting in the sql view.
  • Added a preference to disable displaying system tables.
  • Added a preference to enable foreign key enforcement upon opening a databases.
  • Fixed an issue where sqlite_stat table may appear in the tables list.
  • Fixed a few cases where the application could crash.
  • Fixed an issue where disabling table counts did not work properly.
  • Fixed an issue with processing foreign keys.

New in SQLPro for SQLite 1.0.58 (Mar 24, 2016)

  • Both 'timestamp' and 'datetime' columns will adhere to the 'display as date' option.
  • Fixed a few issues around creating virtual CSV tables.
  • Updated internal SQLite version to 3.11.0.
  • Fixed an issue where saving could cause the UI to display no data (even though the data exists).
  • Fixed a few issues around foreign key handling.
  • Fixed a few crashing issues.

New in SQLPro for SQLite 1.0.53 (Jan 26, 2016)

  • Added 'Edit' -> 'Format Query' menu item.
  • Fixed the 'Format Query' text editor context menu item.
  • Fixed an issue that would not allow certain characters of languages to be typed properly.
  • Structure tab now includes 'IF NOT EXISTS' on most creation scripts.
  • Fixed an issue which could sometimes cause crashes on JSON import.
  • Fixed an issue which could sometimes cause crashes when executing queries.
  • Fixed an issue where importing CSV files did not properly import NULLS.

New in SQLPro for SQLite 1.0.52 (Nov 19, 2015)

  • Fixed an issue with database auto refresh.
  • Added an option to manually refresh database.
  • Added an option to disable auto database refresh.
  • Fixed a crashing issue which some users were seeing when importing files.

New in SQLPro for SQLite 1.0.51 (Oct 15, 2015)

  • Fixed an issue with accessing WAL databases.
  • Updated history button to use the new SQLPro dialog.

New in SQLPro for SQLite 1.0.50 (Oct 4, 2015)

  • New app icon.
  • Performance and bug fixes.
  • Fixed an issue where pragma queries could cause crashes.
  • Added system tables to the database tree.
  • Fixed an issue with reloading databases when the file has been replaced.

New in SQLPro for SQLite 1.0.49 (Jun 18, 2015)

  • Fixed an issue which could cause crashes on specific queries starting with single line comments.

New in SQLPro for SQLite 1.0.48 (May 27, 2015)

  • The history drop-down menu on the query tab now includes syntax highlighting.
  • Queries in the trigger designer table now include syntax highlighting.
  • New start-up window (more Yosemite like).

New in SQLPro for SQLite 1.0.47 (May 15, 2015)

  • The 'Execute current query' preference has been improved. Now the currently highlighted query will be slightly highlighted in the query editor.
  • Many improvements to the query editor.
  • Fixed an issue where some users may see a red app icon.

New in SQLPro for SQLite 1.0.46 (Apr 30, 2015)

  • Improvements to syntax highlighting performance.
  • Fixed an issue where adding table entries via the UI may fail.
  • Fixed an issue where line numbers may not update properly when switching between tables.
  • Fixed a few issues with custom themes.

New in SQLPro for SQLite 1.0.45 (Apr 21, 2015)

  • Unfortunately support for OSX 10.7 is being dropped. SQLPro for SQLite now requires a minimum version of OS X 10.8.
  • Fixed an issue where null objects in a JSON file could cause crashing when importing.
  • Added single cell selection.
  • Updated internal SQLite version to be 3.8.8.2.
  • Enabled support for the ICU library.
  • Fixed a crash if a user attempt to move the lowest column down.
  • Added support for uuid displays.
  • Fixed a crash that could happen when expanding rows on the data grid.
  • Fixed an issue which could cause crashes if executed queries contained placeholders such as ? or :myColumn.
  • Fixed an issue with line numbers appearing incorrectly on OS X 10.10.3.

New in SQLPro for SQLite 1.0.44 (Apr 1, 2015)

  • Fixed an issue with creating virtual tabs from CSV.
  • Fixed an issue with importing that could sometimes cause failures.
  • Auto query recovery.
  • Added crash reporting.
  • Fixed an issue that could cause a crash on undo/redo.
  • Fixed an issue where the current query could get overwritten with a previous version.
  • App minimum version has been set to 10.8.
  • Fixed an issue where null objects in a JSON file could cause crashing when importing.
  • Added single cell selection.
  • Updated internal SQLite version to be 3.8.8.2.
  • Enabled support for the ICU library.
  • Fixed a crash if a user attempt to move the lowest column down.
  • Added support for uuid displays.
  • Fixed a crash that could happen when expanding rows on the data grid.
  • Fixed an issue which could cause crashes if executed queries contained placeholders such as ? or :myColumn.

New in SQLPro for SQLite 1.0.43 (Apr 1, 2015)

  • Improved crash reporting.
  • Fixed an issue that could cause a crash on undo/redo.
  • Fixed an issue where the current query could get overwritten with a previous version.

New in SQLPro for SQLite 1.0.40 (Jan 10, 2015)

  • Improved overall performance.
  • UI Update.
  • Primary key detection when executing custom queries.
  • Custom query results can now be edited inline if primary keys have been detected.
  • Some query results can now be expanded inline.
  • Added bracket matching to query editors (and a preference to disable).
  • Enabled 'Enhanced Query Syntax Precedence' for FTS.
  • Improvements to dependency resolutions.
  • Fixed an issue with newlines when exporting a CSV file.
  • Fixed an issue with exporting to MySQL.
  • Fixed an issue that could cause sql history to not work correctly.
  • Fixed an issue that could cause a crash when a timestamp column had a function as the default value, and a new row was added via the data browser.

New in SQLPro for SQLite 1.0.38 (Dec 4, 2014)

  • Added 'WITHOUT ROWID' support.

New in SQLPro for SQLite 1.0.36 (Jul 16, 2014)

  • Fixed an issue where when running a CTE query SQLite Professional could freeze.
  • Fixed an issue that could cause crashes when updating a table that included unique columns.
  • Fixed an issue where unchecking 'Allow Null' on a new table would not work correctly.
  • Fixed an issue with auto-increment detection.

New in SQLPro for SQLite 1.0.35 (Jun 13, 2014)

  • Fixed an issue that would cause the data table to display blank after an export.
  • Fixed a few issues around themes.
  • Colors would get slightly darker every time themes were saved.
  • Renaming a theme was not working on all systems.
  • Sometimes it would appear that themes had not saved changes.
  • Fixed an issue that could cause the application to crash when opening a database with
  • write-ahead logging enabled.

New in SQLPro for SQLite 1.0.34 (Jun 7, 2014)

  • Added themes. You can now pick from any of our built in themes, or customize your own.
  • Pre-emptive fixes for newer operating systems.
  • Fixed a few issues with auto-refresh.
  • Improved database loading performance.

New in SQLPro for SQLite 1.0.31 (May 28, 2014)

  • Added an index row header to results and data view.
  • Fixed an issue that could sometimes cause binary columns to display as null.
  • Can now select a column when copying data results.
  • Generic performance improvements.
  • Fixed an issue where 'Add as Favorite' could cause a hang.
  • Tab/Shift+Tab now indents code rather than replacing it with the tab character (visual studios style behaviour).
  • CMD + ] (or CMD + [) also indents code (xcode style behaviour).
  • Added semi-colon as a CSV export/import option.
  • Fixed an issue that could cause column collations to be dropped.

New in SQLPro for SQLite 1.0.29 (Mar 13, 2014)

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

New in SQLPro for SQLite 1.0.27 (Mar 5, 2014)

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

New in SQLPro for SQLite 1.0.26 (Feb 20, 2014)

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

New in SQLPro for SQLite 1.0.24 (Feb 15, 2014)

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

New in SQLPro for SQLite 1.0.23 (Jan 29, 2014)

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

New in SQLPro for SQLite 1.0.22 (Jan 24, 2014)

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

New in SQLPro for SQLite 1.0.21 (Nov 14, 2013)

  • 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.
  • Bug fixes:
  • 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.

New in SQLPro for SQLite 1.0.19 (Oct 21, 2013)

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

New in SQLPro for SQLite 1.0.18 (Oct 12, 2013)

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

New in SQLPro for SQLite 1.0.17 (Oct 8, 2013)

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

New in SQLPro for SQLite 1.0.15 (Sep 10, 2013)

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

New in SQLPro for SQLite 1.0.14 (Sep 2, 2013)

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

New in SQLPro for SQLite 1.0.13 (Jul 31, 2013)

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

New in SQLPro for SQLite 1.0.12 (Jul 29, 2013)

  • CSV Import improvements. Improved encoding detection, plus you now have the option to specify the encoding manually.

New in SQLPro for SQLite 1.10 (Jun 29, 2013)

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

New in SQLPro for SQLite 1.0.9 (May 31, 2013)

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

New in SQLPro for SQLite 1.0.8 (Apr 26, 2013)

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

New in SQLPro for SQLite 1.0.7 (Apr 11, 2013)

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

New in SQLPro for SQLite 1.0.6 (Mar 20, 2013)

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

New in SQLPro for SQLite 1.0.5 (Mar 5, 2013)

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

New in SQLPro for SQLite 1.0.4 (Feb 27, 2013)

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

New in SQLPro for SQLite 1.0.3 (Feb 13, 2013)

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

New in SQLPro for SQLite 1.0.2 (Feb 7, 2013)

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

New in SQLPro for SQLite 1.0.1 (Jan 11, 2013)

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