Art Adminer

Art Adminer is a smart and lightweight database management component. Art Adminer can be used to read, write, alter and many more database tasks. This is a comprehensive database tool to allow you to manage your databases from your Joomla administrator.

• Features

• Screenshots

• Changelog

• • Comprehensive database tool in your Joomla! administrator panel
  • Connect to a database server or auto-connect to Joomla! database
  • Connect to MySQL, SQLite2, SQLite3, PostgreSQL, Oracle, MSSQL
  • Switch between 12 pre-made themes
  • Work with databases, tables, records
  • Create, alter, drop and link lists by foreign keys
  • Multilingual
  • Select an existing database or create a new one
  • List fields, indexes, foreign keys and triggers of table
  • Change name, engine, collation, auto_increment and comment of table
  • Alter name, type, collation, comment and default values of columns
  • Add and drop tables and columns
  • Create, alter, drop and search by indexes including fulltext
  • Create, alter, drop and link lists by foreign keys
  • Create, alter, drop and select from views
  • Create, alter, drop and call stored procedures and functions
  • Create, alter and drop triggers
  • List data in tables with search, aggregate, sort and limit results
  • Insert new records, update and delete the existing ones
  • Supports all data types, blobs through file transfer
  • Execute any SQL command from a text field or a file
  • Export table structure, data, views, routines, databases to SQL or CSV
  • Print database schema connected by foreign keys
  • Display users and rights and change them
  • Display variables with links to documentation
  • Manage events and table partitions
• 
  
• version 2.0.0
  • MySQL: Support PHP 7
  • Support PHP 7
  • Fix remote execution in SQLite query
  • SQLite: Require credentials to use
  • PostgreSQL: Support KILL
  • Fix remote execution in SQLite query
  • Fix XSS in indexes (non-MySQL only)
  • Fix XSS in alter table (found by HP Fortify)
  • Send referrer header to the same domain
  • MySQL: Fix usage of utf8mb4 if the client library doesn't support it
  • MySQL: Use utf8mb4 in export only if required
  • SQLite: Use EXPLAIN QUERY PLAN in SQL query
  • Fix XSS in login form
  • Allow limiting number of displayed rows in SQL command
  • Fix reading routine column collations
  • Unlock session in alter database
  • Make master key unreadable to others
  • Fix edit by long non-utf8 string
  • Specify encoding for PHP 5.6 with invalid default_charset
  • Fix saving NULL value, bug since Art Adminer 1.0.0
  • Send 403 for auth error
  • Report offline and other AJAX errors
  • Don't alter table comment if not changed
  • Add links to documentation on table status page
  • Fix handling of 64 bit numbers in auto_increment
  • Add referrer: never meta tag
  • MySQL: Use utf8mb4 if available
  • MySQL: Support foreign keys in NDB storage
  • PostgreSQL: Materialized views
  • SQLite: Support CURRENT_* default values
  • Elasticsearch: Use where in select
  • Firebird: Alpha version
  • Provide size of all databases in the overview
  • Prevent against brute force login attempts from the same IP address
  • Compute number of tables in the overview explicitly
  • Display edit form after error in clone or multi-edit
  • Trim trailing non-breaking spaces in SQL textarea
  • Display time of the select command
  • Print elapsed time in HTML instead of SQL command comment
  • Improve gzip export ratio
  • MySQL: Fix enum types in routines
  • MySQL: Fix editing rows by binary values, bug since Art Adminer 1.0.0
  • MySQL: Respect daylight saving time in dump, bug since Art Adminer 1.0.0
  • MySQL 5.6.5+: Support ON UPDATE on datatime column
  • SQLite: Support UPDATE OF triggers
  • SQLite: Display auto-created unique indexes, bug since Art Adminer 1.0.0
  • MongoDB: insert, truncate, indexes
  • SimpleDB, MongoDB: insert more fields at once
  • SQLite: Fix creating table and altering primary key, bug since Art Adminer 1.0.0
  • Don't store invalid credentials to session, bug since Art Adminer 1.0.0
  • Fix handling of long text in SQL textarea
  • Support paste to SQL textarea in Opera
  • Don't use type=number if a SQL function is used
  • Disable highlighting in textareas with long texts
  • Don't autofocus SQL textarea in Firefox
  • Don't link NULL foreign key values
  • Fix displaying images in Editor, bug since Art Adminer 1.0.0
  • Fix uploading files, bug since Art Adminer 1.0.0
  • Driver for SimpleDB, MongoDB and Elasticsearch
  • Highlight SQL in textareas
  • Save and continue edit by AJAX
  • Split SQL command and import
  • Add a new column in alter table on key press
  • Mark length as required for strings
  • Add label to database selection, move logout button
  • Add button for dropping an index
  • Display number of selected rows
  • Add links to documentation
  • Disable underlining links
  • Differentiate views in navigation
  • Improve speed of CSV import
  • Keep form values after refresh in Firefox
  • Mark auto_increment fields in edit
  • Don't append newlines to uploaded files, bug since Art Adminer 1.0.0
  • Don't display SQL edit form on Ctrl+click on the select query
  • Use MD5 for editing long keys only in supported drivers, bug since Art Adminer 1.0.0
  • Don't reset column when searching for an empty value with Enter, bug since Art Adminer 1.0.0
  • Encrypt passwords stored in session by a key stored in cookie
  • Don't execute external JavaScript when verifying version
  • Include JUSH in the compiled version
  • Protect CSRF token against BREACH
  • Non-MySQL: View triggers
  • SQLite: Allow editing primary key
  • SQLite: Allow editing foreign keys
  • PostgreSQL: Fix handling of nextval() default values
  • PostgreSQL: Support creating array columns
  • Customization: Provide schemas()
  version 1.7.2
  • Add settings modal and ability to change databases using db creds
  • Add themes feature to switch themes for database administrator

If you use Art Adminer, please post a rating and a review on the Joomla! Extensions Directory.