SQLite Client by SQLPro

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

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

+ Fixed a crash that could occur on older devices.

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

+ 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 with exporting to json. [#1000](https://github.com/hankinsoft/SQLPro/issues/1000)

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

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

+ Fixed a crash on macOS 10.13.

+ Fixed an issue with pates.

+ Fixed an issue where some users were being requested to enter a license key.

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

+ Fixed an issue where some users were being prompted to purchase. (SQLPro for SQLite does not need any additional purchases ever).

+ Fixed an issue where some users were being prompted to purchase. (SQLPro for SQLite does not need any additional purchases ever).

+ Fixed an issue with could cause a crash once an `Export to SQLite2` has completed.
+ Fixed an issue where switching between the query editor and other tabs could cause text in the query editor to revert to previous text.

+ Major improvements to query autocomplete/intellisense. Suggestions are now based on the query you are typing. IE, if you run `SELECT * FROM myTable WHERE` - the entries after WHERE will be filtered to myTable and related columns.
+ Aliases are now highlighted when writing queries.
+ Query tab favorites, history and run query button are now at the top (matching other SQLPro products).
+ Customize toolbar should now store its state.
+ Fixed an issue with 'Export to SQLite2'.
+ Fixed proper case for a few menu items.
+ Fixed an issue where 'New virtual table' -> 'From CSV' would display an error.

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

+ Additional improvements to help resolve a crash some users are seeing.

+ Additional changes to fix an issue which could cause crashes when writing queries.

+ Fixed an issue which could cause crashes when writing queries (pasting queries would trigger it most often).
+ Fixed an issue where opening certain sqlite databases could cause the app to hang.

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

+ Fixed an issue where the app could close for some users when opening preferences.
+ Autocomplete no longer requires the AS keyword to detect table aliases.

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

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

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

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

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