Current version: v1.9.12β (public beta)
License: GNU General Public License v3.0
Українською
This is the official repository for the SQLantern CMS extensions: SQLantern integrations with Joomla and OpenCart.
It contains both ready-to-install ZIPs (installable in the website dashboard/administrator) and the source code (in src).
SQLantern is open-source and free software, and so are the extensions in this repository.
These integrations are made by the authors of SQLantern and are the top recommended versions to install (if their limitations fit your needs): they are the most secure, easy to install, and easy to use.
SQLantern is a multi-panel and multi-screen database manager.
Read more about it in the official repository.
Visit demo at sqlantern.com
SQLantern extensions are fully integrated with the CMS security and do not have a login/password form of their own (which could be brute-forced otherwise).
Only website admins having rights to access the extension can use it (and only when the extension is enabled, of course).
Use unexpected complex logins and passwords on your websites and change them regularly, enable two-factor authentication, and you'll be reasonably secure.
(Do I even need to mention being extra careful on public internet access?)
No need to upload any files over FTP, clone git, or unzip the archive on the server.
Download the zip file and install it in the website back side just like any other extension.
The extensions adds a new menu item for admins.
No need to remember or write down the SQLantern URL - the link is right there, in the main menu.
No need to keep the database login and password anywhere - the extension automatically uses credentials from the CMS configuration.
No entering login and password, and no database choice from the list - only two clicks to open the database.
Unlike standalone SQLantern, where you type in login and password and are free to use any database available to that login, these extensions provide instant access to the website's database and to that database only.
You are limited to the website's host and database and can't access any other host or database.
You don't (and can't) enter login and password. Connection panels and databases panels are not available and they won't work even if you hack them in.
Each integration also has some individual limitations.
Enable the "Keep-alive" in the database panel (the one with the tables' list):
This will automatically reconnect to the server periodically on the background and prolong the session when possible (in the same way both Joomla and OpenCart do that).
Unfortunately, it only prolongs database-based sessions, but not "native" sessions.
Also, this auto-prolongation can be interrupted and disabled by the browser itself if the SQLantern tab gets discarded (if you don't know, very simply speaking, that's when the tab was "on the background" for a long enough time).
Download joomla-sqlantern-plugin.zip right here on GitHub (from the files list or from the "Releases") or from sqlantern.com.
Joomla 3: Install it in "Extensions > Manage > Install".
Joomla 4: Install it in "System > Install > Extensions".
The plugin is immediately enabled by default as soon as it is installed and is available to "Super Users" by default.
You can now use the menu item ("System > SQLantern" in Joomla 3, just "SQLantern" in Joomla 4).
Joomla 3 menu item:
Joomla 4 menu item:
Find it in "Extensions > Plugins" (Joomla 3) or "System > Manage > Plugins" (Joomla 4) to change the user group or disable the plugin.
Uninstall it in "Extensions > Manage > Manage" (Joomla 3) or "System > Manage > Extensions" (Joomla 4), like any other plugin: find, check, click "Uninstall".
Only the "Database" session handler is supported.
Only the mysqli database driver is supported (public $dbtype = 'mysqli'; in "configuration.php", or "MySQLi"/"MySQL (PDO)" as Database Type in the Administrator).
Only users from the single user group can use the plugin - the one which is selected as having access to the plugin ("Super Users" by default).
Joomla 3.5+
Joomla 4.x
Download sqlantern_opencart.ocmod.zip right here on GitHub (from the files list or from the "Releases") or from sqlantern.com.
Install it in "Extensions > Installer".
Go to "System > Users > User Groups".
Open your User Group (it's probably "Administrator"), check "extension/module/sqlantern_opencart" in both "Access Permission" and "Modify Permission", save changes.
Go to "Extensions > Extensions", choose the "Modules" extension type.
Find "SQLantern" in the list, click "Install" (the green "+" button).
You can now use the "System > SQLantern" menu item.
SQLantern module is not a modification, and cannot really conflict with anything (conflict with another module would be a phenomenon).
There is no need to refresh modifications to enable or disable the module.
OpenCart 2: There is no real uninstallation, unfortunately. You have to delete the files manually (refer to src/sqlantern-opencart/upload for the list of files to delete).
OpenCart 3: Delete it in "Extensions > Installer" to uninstall, like most other extensions.
Only the "mysqli" database driver is supported.
Only "db" and native session engines are supported.
OpenCart/ocStore 2.3.x
OpenCart/ocStore 3.x
SQLantern PHP code, CMS extensions PHP and JS code:
(C) 2022, 2023 Misha Grafski aka nekto
SQLantern JS, HTML, CSS code:
(C) 2022, 2023 Svitlana Militovska
Simplebar:
Made by Adrien Denat from a fork by Jonathan Nicol
https://github.com/Grsmto/simplebar