WebDBViewer - Database viewer for viewing database information from a web browser - Perl ABC - Perl Installation, Perl Tutorial, Many Examples

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 .

WebDBViewer (Repository And documentation)

Example

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.

WebDBViewer

Perl ABC