Version 1.9.12

[1.9.12 beta] - 2024-05-16

Fixed:

• Views are now listed after tables in exported dumps, preventing the "Table '...' doesn't exist" error in cases when views alphabetically go before the tables they reference (e.g. a view named "a" referencing a table named "d" caused that error, because "d" has not been created yet when "a" CREATE statement was run).
• A bug which prevented deleting "handy queries" in Settings (they could be edited and reordered, but not deleted).
• A bug in profiler after clicking "Stop" and "Run" in quick succession (double-clicking "Stop" basically). Profiler created a new thread in that case while keeping the old thread alive, running profiling in two threads and displaying confusing results. (Profiler's front-end was actually fully rewritten.)
• OpenCart extension: Servers with non-UTC PHP and/or DB time zones were always causing "ACCESS DENIED" under certain conditions no matter what (a combination of time zone and session duration). OpenCart's internal config value is used now to sync PHP with DB and work in the same time zone (in the same way OpenCart itself handles it).

Added:

• It is now possible to refresh the list of databases, list of tables and a table's structure and indexes - with the new "Refresh" icon (at the top of panels).
• A new query-only panel type, opened by a new "SQL" icon. The new panel type is the same as a table panel, only lacking Structure and Indexes (and it's not linked to any table in the database). Unlike table panel, it opens without any initial pre-filled query.
• Databases' comments and tables' comments are now displayed if present. (Table fields' comments are not displayed yet.)

Changed:

• Profiler was visually redesigned to make it clearer when the timeout between the queries happens.

Version 1.9.11

[1.9.11 beta] - 2024-03-05

Fixed:

• A critical bug in duplicated panels and panels restored from a saved session - they sometimes had a different query applied when using automatic pagination than the query in the Query box.

Added:

• Foreign keys are now listed (in "Indexes", in both MariaDB/MySQL and PostgreSQL).

Version 1.9.10

[1.9.10 beta] - 2024-02-19

Fixed:

• PostgreSQL: REFRESH MATERIALIZED VIEW caused a fatal error in Profiler (and possibly other queries). Those queries correctly fall back to the non-precise measurement now.

Added:

• PostgreSQL: Materialized Views are now listed in the tables/views panels.

Version 1.9.9

[1.9.9 beta] - 2024-02-06

Fixed:

• Deleting a query from query history occasionally deleted a wrong query (not the clicked one).
• Multi-line-style comment/comments at the start of the query resulted in a fatal PHP error in PHP 8.1 and later (one-line comments were fine). In PHP versions below 8.1 another glitch happened with such queries (only if they were SELECTs): the total number of rows was not returned and auto-pagination did not appear. Both drivers were affected.
• Columns labeled as KEY index in "Structure" were not always single-column indexes (sometimes MUL should have been displayed instead). Both drivers were affected.
• OpenCart extension: Refreshing the SQLantern page resulted in ACCESS DENIED. You need to clear all cookies on your domain if you still encounter this bug or if you now always get ACCESS DENIED after this update (you might have an old conflicting cookie in your browser after the update).

Version 1.9.8

[1.9.8 beta] - 2024-01-29

Fixed:

• Greatly reduced the chances of "Out of memory" browser tab crashes after receiving too much data from the server (hopefully, almost completely eliminated).
• Reduced the chances of occasional silent session save/auto-save failures without visible errors (when browser could display the data, but the session cannot be saved and auto-saved with that data because of the 5MB-per-SessionStorage-value limitation). A quick fix is provided for now, there will be a better fix in the future.
• Fixed undesireable behaviour: if a query was run repeatedly with a timer, clicking "Stop" was executing the query once again (before actually stopping), sometimes changing the results.
• Single-file version did not contain LICENSE file (LICENSE link in the About text led nowhere in the best case scenario).
• Small JavaScript fixes.

Added:

• MariaDB/MySQL: New "Primary" column in "Indexes" (which wasn't there, unlike PostreSQL).

Version 1.9.7

[1.9.7 beta] - 2024-01-22

Fixed:

• PostgreSQL: Fixed major breakage on some databases caused by the tables' index improvement in the previous version. Tested much more thoroughly this time.
• PostgreSQL: Fixed occasionally wrong Columns in Indexes.

Added:

• The index columns' separator is now configurable (SQL_INDEX_COLUMNS_CONCATENATOR). Columns are combined with " + " by default, but users can set other values.

Version 1.9.6

[1.9.6 beta] - 2024-01-19

Fixed:

• Eliminated an extremely annoying major bug: if the last line of the query was commented out by -- , auto-pagination did not work and unlimited results were returned. At the same time pagination was displayed, creating an illusion that there was no problem. Both drivers were affected by this bug (MariaDB/MySQL and PostgreSQL).
• index.php is added specifically to the back side URL, for the servers which know and execute PHP, but don't consider index.php a default index file and other related situations.
• PostgreSQL: Connection to non-standard ports is now supported (is was accidentally not supported before).
• PostgreSQL: Eliminated a confusing and non-working pagination for queries with LIMIT.
• Joomla plugin: Fixed a critical bug, which caused a global PHP error when trying to edit a menu item in Joomla 4 admin panel (caused in fact by unused dev-only code; Joomla 3 was not affected).
• A minor bug: "Cardinality" hasn't been formatted as a number, as intented.

Changed:

• Improved tables' indexes listing for both drivers (MariaDB/MySQL and PostgreSQL).

Version 1.9.5

[1.9.5 beta] - 2024-01-12

Fixed:

• Under some conditions there was an unhandled and uncontrolled browser-induced horizontal scroll after duplicating a panel. That wasn't working as it had been intended and it had worked properly some time before the public release (handled by our JS, not by the browser), but broken when the sessions were introduced. The horizontal scroll after panel duplication is now working as initially intended.
• PostgreSQL: Databases with multiple schemas and schemas outside search_path are now supported (only tables and views in search_path were accidentally supported before). If there are only tables/views in one schema in a database, and that schema is listed in search_path, tables are not prefixes with a schema. If there are multiple schemas OR one non-search_path schema, all tables get their schema added at the start.

Version 1.9.4

[1.9.4 beta] - 2024-01-03

Fixed:

• Sessions did not properly save and restore views in panels with tables' lists (views looked like tables after restore, not marked as views; they technically worked though).
• Export in databases without views works again (adding views support in the previous version broke Export almost completely).
• pgsql: Databases are listed alphabetically now (facepalm.jpg).
• Built-in support for spaces in tables' and views' names. Putting it into "Fixed", because they were bugged (listed, but couldn't be used by the built-in functions).

Changed:

• Connections are listed alphabetically now (instead of "natural" order of how they were added).

Version 1.9.3

[1.9.3 beta] - 2023-12-27

Fixed:

• Brought back PHP 5.6 compatibility. (Broken by deduplication-related changes in 1.9.2.)