- Perl ›
- App ›
- WebDBViewer |
- Kimoto Project
WebDBViewer - Database viewer for viewing database information from a web browser
We are pleased to announce the release of WebDB Viewer 1.0. WebDB Viewer is a database viewer for viewing database information from a web browser . Similar to phpMyAdmin, but specializes in viewing database information. It supports MySQL and SQLite .
Features
- Display database information on a web browser
- MySQL and SQLite support
- Executing a simple select statement
- Join mode support. You can search by the condition of the column of the joined table.
- Display table name, create table statement, primary key, nullable columns, database engine, character encoding
- Built-in prefork web server with CGI support and reverse proxy support
- Supports many operating systems. Cygwin on Unix, Linux, Windows
- Only need to be Perl 5.8.7 or higher
Installation on shared server
The shared server must support Linux/Unix, Apache, SuExec, CGI. If you have PHP that can run in CGI mode, it's even easier to install because you don't need to set permissions.
Many shared servers support these, so finding a suitable server should be easy.
Download
Download WebDB Viewer.
https://github.com/yuki-kimoto/webdbviewer/archive/latest.zip
Extract the zip file. The following directories will be created.
webdbviewer-latest
Rename webdbviewer-latest to webdbviewer.
webdbviewer-latest->webdbviewer
Settings
You need to set the database information in webdbviewer.conf . (; Is a comment)
[basic] ;;; Database type dbtype = mysql dbtype = sqlite dbtype = mysql ;;; Database name dbname = myproject ;;; User user = kimoto ;;; Password password = secret ;;; Host ; host = yourhost.com ;;; Port ; port = 1234
Upload using FTP
Upload these directories under the document root using FTP.
Setup
Please access the following URL with your browser.
http: // (Your host name) /webdbviewer/setup/setup.php
(If you can't access PHP files or install PHP on your server, set the permissions of the CGI script below to 755.)
http: // (Your host name) /webdbviewer/setup/setup.cgi.
Press the button labeled Setup only once and wait a few minutes.
Run the application
When the setup result is displayed, press the "Go to Application" button.
If an internal server error occurs
If you get an internal server error, see webdbviewer/log/production.log . You can find out what kind of error occurred.
Install on a Unix/Linux server that you can manage
See the relevant part of the English documentation.