Mojolicious::Plugin::DBViewer
Mojolicious plugin to display database information on browser.
Features
This module have the following features.
- Support MySQL and SQLite
- Display all table names
- Display show create table
- Select * from TABLE
- Display primary keys, null allowed columnes,
database engines, and charsets in all tables.
Example
# Mojolicious::Lite
plugin(
'DBViewer',
dsn => "dbi:mysql:database=bookshop",
user => 'ken',
password => '!LFKD%$&'
);
# Mojolicious
$app->plugin(
'DBViewer',
dsn => "dbi:mysql:database=bookshop",
user => 'ken',
password => '!LFKD%$&'
);
# Access
http://localhost:3000/dbviewer
# Prefix change (http://localhost:3000/dbviewer2)
plugin 'DBViewer', dbh => $dbh, prefix => 'dbviewer2';
# Route
my $bridge = $app->route->under(sub {...});
plugin 'DBViewer', route => $bridge, ...;