About dbAdmin
dbAdmin is a map table that shows corresponding MODX object classes for system tables.
Base features:- browse tables;
- truncate, remove and rename tables;
- export entire database or selected tables to text file;
- filter by table name or class name;
- execute sql queries.
Permissions
To work you need the following permissions (except the admin with sudo):
- tables_list — Allow to view a list of tables.
- table_view — Table view permission.
- table_save — Table save permission.
- table_truncate — Truncate permission (truncate table).
- table_remove — Remove permission (drop table).
- table_export — Allow to export a table.
- sql_query_execute — Allow to execute sql queries.
Short video.
More information on Github.Information
New in dbAdmin 1.1.3
1.1.3-pl
==============
- Added the horizontal scrolling for a table window.
- Added output type - varexport or printr.
- Added syntax highlighting for sql.
- Now, instead of the "query error", a full description of the error is displayed.
1.1.2-pl
==============
- Changed file name format of database backup to "databasedatetime.sql". For example, "modx20160317090155.sql".
1.1.1-pl
==============
- Fixed some errors.
- Add support of PHP 5.3.
1.1.0-pl
==============
- Added the ability to edit the selected cell in tables with a class or remove entire row.
- Auto-update the list of tables.
- Added Magic button to define a class for table.
- Added 'Select from' button to the tables grid that adds 'Select from' script for selected table to the SQL query editor.
1.0.1-pl
==============
- Fixed the error of checking update (was wrong package name).
- Added autocreation a folder for export operation.
- Added the table access_namespace for MODX 2.4.0.
1.0.0-pl
==============
- Fixed the error of renaming table.
- Auto synchronization instead of the button.
- Added a "need update" marker (by experiment).
1.0.0-beta
==============
- Initial release