SQLPro for SQLite is now free to download. If you bought it before, everything stays unlocked. - Free: open, browse and query any SQLite database. - Premium adds editing, inserting and deleting rows, the table designer, exports and instant query results. Choose yearly (starts with a free week), monthly, or a one-time lifetime purchase. - A new welcome tour with a sample database. - SQLPro for SQLite > License... accepts sqlitepro.com license keys. - Bug fixes and performance improvements.

+ Added support for field and table CHECK constraints (#480) + Fixed table designer changes (columns, indexes, foreign keys, triggers) not being applied.

+ Data tab: added an "All rows" option to the rows-per-page picker (also in Settings > General) so a whole table can be browsed without paging. (#993) + Fixed restoring a purchase not unlocking the app until relaunch, and the trial screen sometimes appearing on a cold launch for licensed users. (#1173, #1169)

+ Sidebar text size: Settings > Sidebar lets you enlarge the database tree text (14 to 24 pt) with a live preview. Icons, row heights and indentation grow with the text. (#1170) + Refreshed icon set for the sidebar tree and autocomplete, redrawn as crisp vector art that stays sharp at every size. + Results grid: new selection aggregates strip. Select cells and see Count, Sum, Average, Min, Max, Median and Mode at the bottom of the results. Toggle it per tab with the Σ button, or turn it on by default in Settings > Results grid. (#286, #948) + Results grid: right-click a column header and choose "Select column" (or Cmd-click the header) to select every cell in that column, handy with the aggregates strip. (#1172) + Results grid: "Copy with headers as..." now offers CSV, TSV and other separators, and you can set a preferred separator in Settings. (#1167, #1168) + Added a "Copy nulls as blank string" option so NULL cells paste as empty values instead of the text NULL. (#1157) + Sidebar keyboard shortcuts: press Delete on a table to drop it (with confirmation) or Return to rename it. (#1162) + Renaming a table no longer fails part-way with "no such table", and views and triggers that reference the table are rewritten correctly. + Saving now copies the database file directly instead of routing it through memory, which is faster and uses far less memory on large databases. + The table designer no longer blocks the interface while it acquires a database connection. + Duplicate table now reveals the copy in the sidebar and only opens the designer when you ask for it. (#1158) + Autocomplete: fixed columns of tables named in the query going missing from suggestions. (#1166) + Edited cells are now marked in amber (inserted rows stay green) so pending edits no longer look like deletions. + Settings: the Appearance font field is clickable and the font picker stays on screen (#1151); keyboard shortcuts such as Cmd-Return no longer change after reopening Settings (#1160); section headers, button spacing and clipped labels tidied up (#1161); spelling fixes across the interface (#1159). + Sidebar: fixed stale selection text colour and softened the unfocused selection highlight.

+ Fixed an issue where UTF-16LE SQLite databases fail to open.

+ There is now a pagination for the data grid. [993](https://github.com/hankinsoft/SQLPro/issues/993)

- Fixed a hang when opening very large SQL files. The editor's scroller workaround used to force full-document layout and could trip the watchdog on multi-MB files. - Fixed a crash when "Copy as SQL update" was triggered on certain result sets (column metadata is now fetched off the main thread). - Fixed alias-aware syntax highlighting after restoring a query from History (and inside the History preview). - Fixed a SQLite crash on the auto-refresh path that could fire when external processes (Python, etc.) were inserting data into the database while the app had it open.

+ Improved support for macOS 26. + Improvements for https://github.com/hankinsoft/SQLPro/issues/1030. + Improvements for https://github.com/hankinsoft/SQLPro/issues/1021

+ Fixed an issue with UUID display. [#1077](https://github.com/hankinsoft/SQLPro/issues/1077) + macOS 26 improvements.

+ Fixed a crash some users were seeing.

+ Improvements for importing. #1030 Can now assign constants or expressions. + Improvements for titlebar. #1063 + Improvements for clearing up temp files.

+ Fixed a crash that could occur on older devices.

+ Improvements to imports.

+ Fixed an issue where editing records via the editor dialog was not working properly. [#1047](https://github.com/hankinsoft/SQLPro/issues/1047) + Fixed an issue where the 'contains' filter was not always working with nulls. [#1046](https://github.com/hankinsoft/SQLPro/issues/1046)

+ Favorites editor: + New and modified favourites now shows an astrix and are green. + Removed favourites are red and have a strikethrough. + Fixed an issue where autocomplete only suggests a single order by entry. [#1031](https://github.com/hankinsoft/SQLPro/issues/1031) + After deleting a row, the next row is now selected. [#1036](https://github.com/hankinsoft/SQLPro/issues/1036) + When inserting a favourite, the favourites name is now added as a comment to the top of the SQL. [#1033](https://github.com/hankinsoft/SQLPro/issues/1033) + Fixed an issue with the favourites dropdown where entries would be missing after filtering and selecting an entry. [#1034](https://github.com/hankinsoft/SQLPro/issues/1034)

+ Fixed an issue where you could not truncate a table with a hypen in its name. [#1028](https://github.com/hankinsoft/SQLPro/issues/1028) + Added an option to export JUST the selected rows from a result set. [#1027](https://github.com/hankinsoft/SQLPro/issues/1027) + The 'edit row' window now has a split view and can be resized. [#1026](https://github.com/hankinsoft/SQLPro/issues/1026) + Fixed an issue where editing a column that has the string 'null' as a primary key would not work properly. + Changed the date format display to be 2024-11-08 21:16:34 rather than 2024/11/08 21:16:34 which is better inline with ISO standards. [#1014](https://github.com/hankinsoft/SQLPro/issues/1014)

+ Fix for String field "NULL" is interpreted as NULL instead of as a string. [#1021](https://github.com/hankinsoft/SQLPro/issues/1021)

+ Fixed an issue where the app name was sometimes displaying as blank.

+ Fixed an issue with exporting to json. [#1000](https://github.com/hankinsoft/SQLPro/issues/1000)

+ Fixed a crash some users were seeing.

+ Fixed an encoding issue where some columns may display null even though the contents are not null. [#990](https://github.com/hankinsoft/SQLPro/issues/990) + Updated to the latest SQLite version.

+ Fixed an issue where the app may lock up when loading rows. [#983](https://github.com/hankinsoft/SQLPro/issues/983) + Fixed an issue where importing from csv may be slow, or could cause hangs. [#982](https://github.com/hankinsoft/SQLPro/issues/982)

+ Fixed a crash that could occur when renaming columns. [#967](https://github.com/hankinsoft/SQLPro/issues/967)

+ Performance improvements.

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