NAME

Mojolicious::Plugin::MySQLViewerLite

SYNOPSYS

# Mojolicious::Lite
plugin 'MySQLViewerLite', dbh => $dbh;

# Mojolicious
$app->plugin('MySQLViewerLite', dbh => $dbh);

# Access
http://localhost:3000/mysqlviewerlite

DESCRIPTION

Show MySQL database information. This is Mojolicious plugin.

Mojolicious::Plugin::MySQLViewerLite have the following features.

  • You can see all table definition.

  • You can specify talbe and select top 1000 rows.

  • You can see primary key, null allowed column, and database engine of all tables.

INSTALL

Mojolicious::Plugin::MySQLViewerLite need the following module.

DBIx::Custom;
Validator::Custom;

And you copy Mojolicious::Plugin::MySQLViewerLite source code to the following place.

lib/Mojolicious/Plugin/MySQLViewerLite.pm