Database Tools

The Web Enabled SQL (WeSQL) library is an extension to HTML, acting as a glue between HTML and SQL. WeSQL allows the use of pure SQL queries directly in html files. WeSQL is aimed at rapid web-database integration. WeSQL is written in Perl and currently only supports MySQL as backend SQL database.

MySQLMan is a web based database manager. It allows you to perform common maintenance and administration tasks in Mysql. MySQLMan was based off of PHPmyadmin, but written in Perl. It allows you to do common tasks like: browse/create/drop databases, browse/search/create/drop/alter tables, import/export data, add/remove/alter table columns, and add/remove/alter table keys. Download a copy and try it.

DBMan SQL is a powerful database manager that provides a flexible web interface to manage multiple relational tables with fully customizable template sets. The easy setup wizard helps you create your own database from scratch, or auto-create a configuration file based on an existing table. DBMan SQL also includes a flexible user system that allows you to set user permissions per table and features built-in support for file uploads.

Oracletool is an interactive, web based application that runs as a CGI script using your web server. The advantage of Oracletool over tools such as Oracle Enterprise Manager is that nothing needs to be installed on the client side machine. All you need to use Oracletool, once installed, is a web browser. There is nothing that needs to be created or altered in your databases to use Oracletool either. All Oracletool expects upon connection is "SELECT ANY TABLE" privileges. It requires the DBI and DBD::Oracle modules.

This is a web client for the MySQL database. It depends on the Perl modules CGI:: and DBI::. The program facilitates a more efficient usage of MySQL by providing a web interface to the database. With this database you can add, delete and edit table entry, do regular maintenence of the MySQL database, view tables, view databases, and generally make the job of managing your data a bit less onerous.

WWWdb is a powerful development tool for Web applications, that are based on a SQL database. You can browse and modify any data stored in database-tables and display them in a format, you like. To check, that the data-integrity is kept, you can plug in Perl-scripts, that guarantee that only correct data is inserted in your Database. WWWdb handles www-connections as sessions and you can login and setup your own session. Everytime you come back, your last session can be continued. Because it is password-protected, no cookies are needed. At the moment, three databases PostgreSQL, Oracle and MySQL are supported.

LANdb is a set of Perl scripts that automate the manipulation of an SQL (usually MySQL) database. LANdb provides network managers a means of cataloging all connections, closets, and network hardware on a network. It uses MySQL, Perl, and DBI to provide a fast and efficient web-based frontend to a complete network management package. Implemented features: Tracking of Jacks by number, Tracking of Ports and Port Status, Tracking of Switches by name, closet, and IP, Listing of buildings, Listing of closets Adding of buildings, closets, and switches on the fly, and Support for Multiple users with varying privileges.

MemberManager takes a character separated file, sorts the whole thing by whichever field you like and creates an HTML file for each letter of the alphabet with contents of each file also sorted. It also automatically hyperlinks any email address in the email field. There is a free as well as a paid version of this script available on the website. There are also MySQL database versions which can be customized on request, at additional cost.

This is an easy to install Web based MySQL database administration program written in Perl. Key features include: Create and drop databases remotely, Create and drop tables remotely, Alter tables and columns remotely, Supports features of MySQL 3.22.x, Full MySQL datatypes keys and indexes, and Advanced backup and restore via web browser.

E-Data is an e-mail directory written in Perl that allows you to enhance your web site by letting visitors add their personal information (e.g. name, e-mail, hobbies or activities, web address, etc.) to a directory. Key features include: Easy search by first name, last name or e-mail, Entries alphabetically indexed, Users can update their own information, and Easy customization of interface (HTML).

This script allows you to export your mySQL tables into | delimited text files. One file for each table. The text files are then compressed with zip.

This sofware package includes three individual programs: Web Search Software searches a flat file database and determines the "look" of your results page, DataEasy Software allows anyone to maintain the Web Search database without having to purchase a database program, and DataScript collects data from visitors to your web page and also automatically creates it's own database for later use with Web Search.

This script converts ODBC SQL selects in tables. Just write an .shtml file and fill your table from a query using SSI call in your file. It also includes many options such as color, size, borders, sums, row numbering, row limiting, linking and much more.

BizDB Advance is a flexible and yet affordable Web database software which has everything you need for the setup of a searchable database application on any small to medium sized Web sites. Each copy of the software comes with an in-built database manager, an image uploader, a search engine program, a search report generator and a comprehensive user documentation. You can use this software to support any number of database fields. Database records can be password-protected. All database interfaces are controlled by Html templates which can be setup by anyone with basic Web page design experience. No CGI programming knowledge is required. Numerous add ons can be ordered separately.

FLATTEXT Zip Code Locator is a Perl script and data files that display the closest records to any U.S. zip code entered. This script is ideal for dealer directories, people and store locators, or any other type of database that contains and/or keyed by zip code.

FLATTEXT Class B Scripts are one of the fastest and cheapest ways to put your existing or new databases online. This service creates custom Perl scripts that allow searches, edits, and deletes of your database over the web. Most desktop databases and spreadsheets allow you to export your existing data in comma separated (*.csv), tab delimited, or pipe | delimited text format. The script that this service generates will search your exported file, or will create a database from scratch using the delimiter you select.

Class A Databases allow you to publish your existing database online. This type of database is updated by exporting your existing desktop database or spreadsheet and sending the exported data to your server. No one can add, edit, or delete records through a web browser.

WODA is a Perl program that manages web-oriented, semi-relational, multimedia databases. It allows them to be maintained, added-to, modified, and queried through the WWW. Some examples of its applications are membership lists, bibliographies, document archives, virtual journals and libraries, catalogues, hot-lists, classifieds, discussion systems, mailing list archives, rings of web pages, questionaries and more.

DBMan is a full featured database manager that provides a web interface to add/remove/modify/view records in a flatfile ascii database. It supports an advanced user management system, as well as a powerful permissions system.

DB_Browser is a CGI tool for developers working with a relational database. It easily facilitates searching, editing, and adding tables within a database, as well as directly querying the database using SQL in a web-browser form. While it can be used as a regular interface to database data itself, it works well as a supplemental tool for developers creating their own primary interface.