Updates and improvements.
- Fixed an issue where Setapp activation was not always working. - Snowflake: Login improvements, including additional login methods. - MySQL: connecting to servers that do not use SSL now works again in the Disabled and Prefer SSL modes (fixes a case where the connection failed even though the server was reachable). - Postgres: fixed a crash that could happen when connecting to certain hosts. - Tables, schemas and objects that contain a dot in their name (for example a schema named "first.second") now resolve correctly in the database tree and in queries. - Fixed several freezes/hangs at launch and while editing large queries. - General crash and stability fixes.
+ Fixed an issue that could cause the app to lockup when opening some sqlite files.
- Opening a SQLite file no longer freezes the UI while the schema is read, especially on large or iCloud-backed databases. - Autocomplete: debounce on keystroke updates, plus O(1) allowed-tables lookup per entry. Large schemas no longer slow typing in the query editor. - Connection-pool teardown no longer blocks the UI while a remote database closes its socket. Disconnect and tab-close return immediately even when the database is unreachable. - Result-set sort treats signed numeric strings as NSDecimalNumber so "-100" sorts below "-50" instead of the other way around. - Fixed a crash when copying a geometry cell value. - Moved some logic that should have been on a background thread, from a foreground thread to a background thread.
- Faster, more responsive query editor when typing. Autocomplete is now much quicker on large schemas and no longer stutters while you type at speed. - Performance improvements while typing in the query editor. - Fixed a crash when editing rows in a table with GIS geometry columns. - MySQL: New per-connection option: "Use FOUND_ROWS". Available in the edit-connection screen under Advanced -> Row counts.
+ General performance and stability improvements.
+ Fixed a crash when loading larger files.
- Sort order for negative numbers ([#1131](https://github.com/hankinsoft/SQLPro/issues/1131)). Sorting a column of numeric values now orders negative numbers correctly. Previously a column containing both positive and negative values could end up out of order when the database returned numeric values as strings (most commonly with Oracle). - iPad schema sidebar crash. Fixed a table-view crash when removing the last table from a database in the schema sidebar. - Large-cell tooltips. Faster scrolling and pointer-driven tooltips on result grids that contain very large string values (multi-megabyte JSON / log columns no longer cause UI hitches). - Open from Files / Share sheet. Opening a `.sql` file from the Files app or a Share-sheet provider no longer freezes the app on slow sources (iCloud Drive, Google Drive, OneDrive). The file is now read on a background thread with a *Loading…* placeholder in the destination tab. - Oracle autocomplete crash. Fixed a crash that could occur when refreshing autocomplete on a connection that lists many schemas. - Postgres autocomplete. Faster typing in long queries when the connection has a large keyword set. The autocomplete refresh that runs on every keystroke is now O(1) per keyword check instead of scanning the full reserved-word list.
- Fixed a rare launch hang on memory-constrained devices when first loading the autocomplete favorites cache.
- MongoDB support improved, including a visual Find Builder tab (collection, filter, sort, skip, limit) so you can explore collections without hand-writing JSON. - Geometry / spatial viewer: preview POINT, LINESTRING, POLYGON, and other shape data right inside the result grid, with "Open in Maps" for point data. - Custom connection icons: choose any image from your photo library, adjust it with a built-in crop editor, and sync icons across your devices via iCloud. - Tab colour picker on every connection so each database has its own colour in your tab bar. - Improvements to Auto-reconnect when the server drops the connection (idle timeouts, brief network blips, server restarts). - Various crash fixes and stability improvements.
+ MongoDB improvements. + Geometry viewer. [#688](https://github.com/hankinsoft/SQLPro/issues/688)
+ Fixed an issue that could cause a crash when removing Oracle connections. + Fixed an issue that could cause a crash when exporting data. + Fixed an issue where adding a SQLite database could cause no action to occur.
+ Added Oracle support.
+ Improved support for iOS 26.
+ Fixed an issue where logs would sometimes not be visible. + Fixed an issue with the Setapp framework.
+ Fixed an issue with line numbers.
General: + Improvements with line number displays for queries. SQLite: + Fixed a crash some users could have when modifying sqlite databases. + Improvements to modifying sqlite table ddl. + Fixed an issue where scripting views would not always work.
+ Fixed an issue that could cause a crash when editing SQLite DDL.
+ Autocomplete can now be disabled.
+ Fixed a crash that could occur when adding or editing a trigger. + Fixes some color issues.
+ Fixed a crash that could occur when long pressing a connection. + Fixed an issue where colors would mess up on table options. + Fixed an issue that could cause a crash when expanding table options.
+ Improvements to shortcuts.
+ Fixed a crash some users were seeing during settings.
+ Fixed a crash some users were seeing on connections.
+ Fixed a few crash issues some users were seeing.
+ Additional fixes for crashes that were occurring when removing connections.
+ Fixed a crash that could occur when removing connections.
+ Autocomplete improvements. + Fixed a crash some users were seeing.
+ Added SQLite support. + Added the legacy 'enable compression' option for mysql connections.
+ Editing now provides custom keyboard for numbers and floating values. [#677](https://github.com/hankinsoft/SQLPro/issues/677)
+ Fixed a crash some users would see at startup.
+ Fixed an issue where postgres connections could sometimes not be editable.
+ Fixed a crash that could occur when adding a trigger in MSSQL.
+ Fixed an issue with Setapp support.
+ Improvements to ssh tunnelling.
+ Improved some logging for SSH fingerprint approval.
+ Improvements for automatic reconnections.
+ Fix for Setapp accounts not working properly.
+ Updated internal frameworks.
+ iOS 15 improvements.
+ iOS 15 improvements.
+ Fixed an issue where postgres views would only load from a single schema.
+ Postgres functions now display the function overload. + Fixed an issue with Postgres functions not display from other schemas. + Improvements with handing alter/create Redshift functions. + Fixed an issue where scripting tables/views/fuctions/etc might be incorrectly formatted.
+ Improvements with keyboard navigation of results.