General improvements.

General improvements.

- Edit Record: PostgreSQL enum columns are now a menu of their values, every column shows the right nullability, and required fields say so. - Filtering results works on number, date and other non-text columns in PostgreSQL, SQL Server, Oracle and Snowflake. - SQL Server and Oracle spatial columns are readable in the grid and can be shown on a map. - Oracle: dates show in full with their time zone, internal tables are hidden, and view definitions are cleaner. - iPad: the query editor uses the full iPad layout with floating autocomplete. - One-year-of-updates license keys from our website now unlock the app. - Fixes a clipped filter bar on iPhone and other small layout issues.

- Fixes a freeze at launch when restoring a session whose SQLite file is slow to open. The tables now load in the background. - Fixes crashes when closing a tab in the tabs overview, tapping a database tree row that had just been removed, and opening a session while autocomplete was loading. - Running a query no longer hangs in rare cases, and the statement under the cursor is picked the same way as on the Mac.

+ General improvements to make the app run smoother.

+ iPhone duo improvements + Additional generic fixes

- Ready for iPhone Duo, with layouts for both the outer and inner displays. - Filter query: build a WHERE clause and row limit from a form, and SQLPro writes the SQL into the query for you. - Large result sets use far less memory, and exports stream to disk instead of being held in memory. - Fixes a freeze at launch when restoring a session that used a SQLite database. Restored sessions now bring back their query filter. - Renaming or editing a saved favorite now sticks. - Microsoft Fabric: fixes SQL Server logins to Fabric warehouses.

+ General fixes

• Database connections now stay open while you switch to another app, so temporary tables, session settings and open transactions are no longer lost. • The database tree shows which database is selected and that it can be changed. • Toolbar buttons use symbols, and the table designer uses the system tab bar. • Fixes and refinements throughout, including groundwork for iPhone Duo.

+ General improvements

+ Improvements to tabs

- SQL Server: sign in with Microsoft Entra ID (MFA) - SQL Server: new Encryption setting, automatic retry after an Azure idle disconnect, and Azure Synapse dedicated SQL pool support - Tabs now work on iPhone: browse open tabs as preview cards, switch between them, and going Back keeps the tab open - Better support for foldables and rotation: the layout switches between phone and tablet styles without losing your queries or results - New setting to ask before closing a connection with unsaved tabs (on by default on iPad) - Results grid: new selection action bar, add rows to a table, and fixed a crash when sorting or resizing columns on iOS 26 - MySQL: redesigned connection editor with read-only mode, authentication method, timezone and timeout options - Oracle: read-only connection option - Snowflake: SSO sessions sign back in automatically when they expire, and NULLs and column types display correctly - Fixed mongodb+srv:// and other DNS SRV lookups - Fixed query formatting indentation - Enter a license key from the paywall or Settings. Restoring a purchase unlocks the app immediately, and renewed subscriptions no longer show as expired - Crash fixes for SQL Server messages, Postgres "Copy as SQL update" and MongoDB document editing

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.