{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":657718973,"defaultBranch":"main","name":"sqlantern","ownerLogin":"nekto-kotik","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-06-23T17:24:01.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/35164628?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1715881954.0","currentOid":""},"activityList":{"items":[{"before":"4846e1dfc27da696f09c4e8ea289404b561c57cb","after":"d434049af9847237da9887927d9486115b4efe10","ref":"refs/heads/main","pushedAt":"2024-05-16T17:24:34.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"[1.9.12 beta] - 2024-05-16\n\nFixed:\n- 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).\n- A bug which prevented deleting \"handy queries\" in Settings (they could be edited and reordered, but not deleted).\n- 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.)\n- 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).\n\nAdded:\n- 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).\n- 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.\n- Databases' comments and tables' comments are now displayed if present. (Table fields' comments are not displayed yet.)\n\nChanged:\n- Profiler was visually redesigned to make it clearer when the timeout between the queries happens.","shortMessageHtmlLink":"[1.9.12 beta] - 2024-05-16"}},{"before":"f06bcf33d577f31bce44afa3e91fb377692d4ea9","after":"4846e1dfc27da696f09c4e8ea289404b561c57cb","ref":"refs/heads/main","pushedAt":"2024-03-05T15:35:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"[1.9.11 beta] - 2024-03-05\n\nFixed:\n- 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.\n\nAdded:\n- Foreign keys are now listed (in \"Indexes\", in both MariaDB/MySQL and PostgreSQL).","shortMessageHtmlLink":"[1.9.11 beta] - 2024-03-05"}},{"before":"92a5738c8aa8a259312445e7097a8ca0976cdf35","after":"f06bcf33d577f31bce44afa3e91fb377692d4ea9","ref":"refs/heads/main","pushedAt":"2024-02-19T14:52:53.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"[1.9.10 beta] - 2024-02-19\n\nFixed:\n- 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.\n\nAdded:\n- PostgreSQL: Materialized Views are now listed in the tables/views panels.","shortMessageHtmlLink":"[1.9.10 beta] - 2024-02-19"}},{"before":"ddfd2c4b6d2adbf259cd68fba797b8bd229775ab","after":"92a5738c8aa8a259312445e7097a8ca0976cdf35","ref":"refs/heads/main","pushedAt":"2024-02-07T18:45:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"[1.9.9 beta] - 2024-02-06\n\nFixed:\n- Deleting a query from query history occasionally deleted a wrong query (not the clicked one).\n- 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 `SELECT`s): the total number of rows was not returned and auto-pagination did not appear. Both drivers were affected.\n- Columns labeled as `KEY` index in \"Structure\" were not always single-column indexes (sometimes `MUL` should have been displayed instead). Both drivers were affected.\n- 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).","shortMessageHtmlLink":"[1.9.9 beta] - 2024-02-06"}},{"before":"bce4e9e3116c839bca0d881b29765d4ae282da49","after":"ddfd2c4b6d2adbf259cd68fba797b8bd229775ab","ref":"refs/heads/main","pushedAt":"2024-01-28T22:57:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"[1.9.8 beta] - 2024-01-29\n\nFixed:\n- Greatly reduced the chances of \"Out of memory\" browser tab crashes after receiving too much data from the server (hopefully, almost completely eliminated).\n- 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.\n- 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.\n- Single-file version did not contain LICENSE file (LICENSE link in the About text led nowhere in the best case scenario).\n- Small JavaScript fixes.\n\nAdded:\n- MariaDB/MySQL: New \"Primary\" column in \"Indexes\" (which wasn't there, unlike PostreSQL).","shortMessageHtmlLink":"[1.9.8 beta] - 2024-01-29"}},{"before":"223c6042040d183b1024406a161b02ee89da52ac","after":"bce4e9e3116c839bca0d881b29765d4ae282da49","ref":"refs/heads/main","pushedAt":"2024-01-22T01:38:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"Update version in READMEs","shortMessageHtmlLink":"Update version in READMEs"}},{"before":"c42d5156c506a4d8830908ede12be45324238510","after":"223c6042040d183b1024406a161b02ee89da52ac","ref":"refs/heads/main","pushedAt":"2024-01-22T01:34:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"[1.9.7 beta] - 2024-01-22\n\nFixed:\n- PostgreSQL: Fixed major breakage on some databases caused by the tables' index improvement in the previous version. Tested much more thoroughly this time.\n- PostgreSQL: Fixed occasionally wrong `Columns` in `Indexes`.\n\nAdded:\n- The index columns' separator is now configurable (`SQL_INDEX_COLUMNS_CONCATENATOR`). Columns are combined with \" + \" by default, but users can set other values.","shortMessageHtmlLink":"[1.9.7 beta] - 2024-01-22"}},{"before":"31cdb7d20df648909b010da81af6d8dcf7ae5473","after":"c42d5156c506a4d8830908ede12be45324238510","ref":"refs/heads/main","pushedAt":"2024-01-18T23:48:49.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"[1.9.6 beta] - 2024-01-19\n\nFixed:\n- 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).\n- `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.\n- PostgreSQL: Connection to non-standard ports is now supported (is was accidentally not supported before).\n- PostgreSQL: Eliminated a confusing and non-working pagination for queries with `LIMIT`.\n- 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).\n- A minor bug: \"Cardinality\" hasn't been formatted as a number, as intented.\n\nChanged:\n- Improved tables' indexes listing for both drivers (MariaDB/MySQL and PostgreSQL).","shortMessageHtmlLink":"[1.9.6 beta] - 2024-01-19"}},{"before":"d8a8f8088edd4d5f3c8f205b0fbb6f4452bfde2f","after":"31cdb7d20df648909b010da81af6d8dcf7ae5473","ref":"refs/heads/main","pushedAt":"2024-01-11T22:35:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"[1.9.5 beta] - 2024-01-12\n\nFixed:\n- 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.\n- 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.","shortMessageHtmlLink":"[1.9.5 beta] - 2024-01-12"}},{"before":"85dd281a2596f5b39f5c7dc313e9254869993f31","after":"d8a8f8088edd4d5f3c8f205b0fbb6f4452bfde2f","ref":"refs/heads/main","pushedAt":"2024-01-03T22:27:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"[1.9.4 beta] - 2024-01-03\n\nFixed:\n- 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).\n- Export in databases without views works again (adding views support in the previous version broke Export almost completely).\n- pgsql: Databases are listed alphabetically now (facepalm.jpg).\n- 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).\n\nChanged:\n- Connections are listed alphabetically now (instead of \"natural\" order of how they were added).","shortMessageHtmlLink":"[1.9.4 beta] - 2024-01-03"}},{"before":"d137287eb65166775c08cc96e34cc474bbf7b0be","after":"85dd281a2596f5b39f5c7dc313e9254869993f31","ref":"refs/heads/main","pushedAt":"2023-12-27T20:46:14.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"[1.9.3 beta] - 2023-12-27\n\nFixed:\n- Brought back PHP 5.6 compatibility. (Broken by deduplication-related changes in 1.9.2.)","shortMessageHtmlLink":"[1.9.3 beta] - 2023-12-27"}},{"before":"3baac6e19116cfdf888651f142074ea90010af1f","after":"d137287eb65166775c08cc96e34cc474bbf7b0be","ref":"refs/heads/main","pushedAt":"2023-12-27T18:04:34.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"[1.9.2 beta] - 2023-12-27\n\nFixed:\n- pgsql: Non-SELECT queries, which actually returned data, displayed \"executed\" instead of data. E.g. `SHOW search_path`.\n- pgsql: Database tables are listed alphabetically now, derp.\n- pgsql: Queries with the last line commented-out (`-- ` one-line comment style) caused \"Internal SQLantern failure\" (inability to count rows).\n\nAdded:\n- A new constant: `SQL_DEDUPLICATE_COLUMNS`, which turns on and off the behaviour, described in \"Changed\".\n\nChanged:\n- Columns with duplicate names get table name added in parenthesis now. If a result has columns with identical names (e.g. `id`), some of those columns are not lost now (they were before), but have a table name added in parenthesis. E.g. if a query like `SELECT * FROM chats_chatters LEFT JOIN chats ON chats.id = chats_chatters.chat_id` returns two `id` columns, one of them becomes `id (chats_chatters)`, and the other `id (chats)`. It is now closer to the results in the native MariaDB/MySQL console. Doesn't match the native console fully, but it's better than before (and actually better than console results, IMHO).\n- Views are now supported in both drivers (mysqli and pgsql). They are listed among the database tables, with an added \"view\" to distinguish them, and exported (export is still mysqli-only).","shortMessageHtmlLink":"[1.9.2 beta] - 2023-12-27"}},{"before":"1c663fb78e73b1a554f159c328fcc9ef01e01465","after":"3baac6e19116cfdf888651f142074ea90010af1f","ref":"refs/heads/main","pushedAt":"2023-12-19T19:43:00.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"[1.9.1 beta] - 2023-12-19\n\nFixed:\n- Removed some legacy code, which prevented running any queries containing escaped characters (e.g. `SELECT '\\''`) and ran other queries incorrectly (e.g. `SELECT '\\n'`). The problem-inducing code was over 1.5 years old and we couldn't figure out why it was there at all :-( and 1.5 year ago is the earliest version we have, the code had apparently made sense somewhere before that, but not since.\n- The errors are now displayed correctly for queries with HTML symbols/tags, which fail (e.g. `SELECT '<br>' FROM ???`). Before this change HTML tags became literally part of HTML code and became invisible.\n- Tiny text mistakes, tiny error message improvements.\n\nChanged:\n- pgsql: Errors are now formatted exactly like in the mysqli driver (they looked different).","shortMessageHtmlLink":"[1.9.1 beta] - 2023-12-19"}},{"before":"287ccda09aa924c52ea5de453b42de59e0c7fe38","after":"1c663fb78e73b1a554f159c328fcc9ef01e01465","ref":"refs/heads/main","pushedAt":"2023-12-16T00:19:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"[1.9.0 beta] - 2023-12-16\n\nAdded:\n- Initial public release","shortMessageHtmlLink":"[1.9.0 beta] - 2023-12-16"}},{"before":"d9e5c96e8afcf82cebcf18592d1e26762ef6fb84","after":"287ccda09aa924c52ea5de453b42de59e0c7fe38","ref":"refs/heads/main","pushedAt":"2023-11-17T22:20:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"Create FUNDING.yml","shortMessageHtmlLink":"Create FUNDING.yml"}},{"before":"74ba20763bca451b7e137639b9a17b56d216a1d0","after":"d9e5c96e8afcf82cebcf18592d1e26762ef6fb84","ref":"refs/heads/main","pushedAt":"2023-10-29T17:33:49.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"f31e90ca3c971ed9c27b1efaec8f2177787b8068","after":"74ba20763bca451b7e137639b9a17b56d216a1d0","ref":"refs/heads/main","pushedAt":"2023-08-28T18:02:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"bdd1dda811ea4dbe92595a303a7586ebc6d6bfa7","after":"f31e90ca3c971ed9c27b1efaec8f2177787b8068","ref":"refs/heads/main","pushedAt":"2023-07-08T02:05:06.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"Create README.md","shortMessageHtmlLink":"Create README.md"}},{"before":null,"after":"bdd1dda811ea4dbe92595a303a7586ebc6d6bfa7","ref":"refs/heads/main","pushedAt":"2023-06-23T17:24:02.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"nekto-kotik","name":"nekto","path":"/nekto-kotik","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/35164628?s=80&v=4"},"commit":{"message":"Initial commit","shortMessageHtmlLink":"Initial commit"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"Y3Vyc29yOnYyOpK7MjAyNC0wNS0xNlQxNzoyNDozNC4wMDAwMDBazwAAAARL530C","startCursor":"Y3Vyc29yOnYyOpK7MjAyNC0wNS0xNlQxNzoyNDozNC4wMDAwMDBazwAAAARL530C","endCursor":"Y3Vyc29yOnYyOpK7MjAyMy0wNi0yM1QxNzoyNDowMi4wMDAwMDBazwAAAANH2mcN"}},"title":"Activity · nekto-kotik/sqlantern"}