• Fixed a rare crash at launch. • A smaller download. • SQL Server: connecting no longer waits on another server that is not responding. • Bug fixes and improvements.
ER diagrams, and Oracle sign-in through RADIUS. - ER diagrams are now available in the Tables section. Available for MySQL, PostgreSQL, SQL Server and SQLite. - RADIUS (MFA) sign-in for Oracle. If your Oracle databases sign in through RADIUS with Duo or Okta, set the connection's Authentication to "RADIUS (MFA)". Approve the push when connecting, or type your password followed by a comma and the passcode. - Clearer messages when a RADIUS sign-in is rejected or times out. - PostgreSQL: "Verify CA" and "Verify full" SSL modes now work without choosing a root certificate, you can import your own root CA, and the SSL mode is saved with the connection. - Other improvements and fixes.
- Oracle: connections that use a service name (such as FREEPDB1) now connect. The app was asking the server for ORCL instead, which failed with TNS-12514. Saved connections work without any changes. - Fixes a crash when copying selected results with headers.
• Fixed the app sometimes being closed by iOS right after launch when connection icons were still syncing from iCloud. • Favorites: fixed saved queries sometimes missing until the next launch when iCloud was slow to respond, and a rare hang at startup.
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.
+ 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.