Database Tools

• MORE DETAILS
• VISIT PUBLISHER SITE

Mysql Database frontend like phpMyAdmin Features: create and drop databases, create/drop/alter tables, delete/edit/add fields, manage users, execute SQL statements, manage keys on fields, Search optimize repair dump tables File Explorer, Weblog, Manage Bookmarks and much more ... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

This simple script uses the DBI module in order to connect to a Mysql database, retrieves the results from a select query and display the results inside a while statement. There is a live example as a demo.

• MORE DETAILS
• VISIT PUBLISHER SITE

SQL command flat file database for perl users. Allows creation of tables, update, and insert of data in to tables and much more to come.

• MORE DETAILS
• VISIT PUBLISHER SITE

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.

• MORE DETAILS
• VISIT PUBLISHER SITE

Send information to a database from a web-based form. The script is very simple to set-up and customize using the look and feel of your own website. The advanced version can send a copy of the data to the webmaster, and can require input for up to three types of fields. The data is stored as a CSV database. ... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

PerlMyAdmin is a script for managing mysql databases via a web browser. All common tasks are supported such as creating and dropping databases, creating and dropping tables, column management, key management, table browsing, table searching and more. The script is template driven and easy to customize. Mod Perl is also supported.... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

Displays information from a CSV database on your website using your existing look and feel. The information displayed can be automatically filtered using links or search boxes. The advanced version has enhanced filtering and can split the results across pages.... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

Search all or part of your online database and display the results using your existing look and feel. You can offer as many or as few search options as you want. The advanced version has enhanced filtering and can split the results across pages.

• MORE DETAILS
• VISIT PUBLISHER SITE

Administrator tool to manage your CSV database online without FTP. The advanced version will allow you to add and search records. You can even add fields directly into the database. (CGI/Perl Unix)

• MORE DETAILS
• VISIT PUBLISHER SITE

The script will show you how to create an ODBC connection to a Paradox database, install the DBD::ODBC Perl module and how to use some queries for interrogating a Paradox table in connection with DBI Perl module (a database-independent interface) and the specific DBD driver. Previously you must install BDE (Borland Database Engine) on your computer. Using DBI and DBD you can connect to any kind of database you have in view (not only Paradox).... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

This is an Example of how to Connect to an Access Database using a DSN-less Connection, using DBI::ODBC. The script uses DBI::ODBC module and was tested on Active Perl 5.8. The script is also easily changeable to use a DSN connection, just as long as you have one set up and spelled correctly.... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

How many time have you wrote the same Perl code to display databases records in a datagrid style ? DbBrowser is a Perl module that can help you to stop writing the same thing all your life. DbBrowser module simply need a sql query, DBI and CGI handles and that's enough to get a fully working paginated web datagrid featuring multi columns sort, data export and user defined filtering criteria.... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

Came across the following challenge this week, how do I easily persist data between two independent UNIX sessions. Usually I’d store data in a db or maybe ldap, but I only want to keep maybe a days worth and on multiple servers. In this article, I show two scripts - one which writes using the Perl Storage module and the other that reads. Each call to write, adds to a data file. Which is then extracted from by the read script. I include possible uses, for example recording restarts of a given service. In this instance I did n't want services restarting multiple times, where manual recovery of data would be needed. Also generating multiple alerts and notifications, but again looking to throttle them to a given number of iterations over 24 hours.... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

Whilst working on the automatic production of web statistics - came across the following problem: "How do I get relational data from an Hierarchical structure?" It didn't take long to realize - I'd have to use PHP to talk to LDAP, pull off records & upload into a series of tables, using the cn as primary key. Which then could be queried relationally. Pulling off large, queries and repeatedly transcending LDAP trees is pretty slow - so I built my LDAP to SQL engine, by flattening dns into table names. Then used PHP scripts to query & produce daily snap shots. This is the Perl port of the PHP version.... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

Using this script you can get the enviromental variables of your server it will help with the installation of other cgi programs

• MORE DETAILS
• VISIT PUBLISHER SITE

mysqlwdb is a free (GPL) cgi script written in Perl5. Easy to configure and install, it is intended to manage MySQL database tables through a web interface. Just edit and configure one file.

• MORE DETAILS
• VISIT PUBLISHER SITE

If you want to switch your current plain text database to a new CGI script, which uses a different format, Database Converter will do the job for you. Most of the time you will have hundreds of lines of data in a database file, changing it manually to get it ready for a new script would take you a long time. Here's an example: You've been using a search engine CGI for a long time now, but you just found a much better one, such as our own Smart Search :) So you install the new script. Now, you don't want to lose your old search engine database, and it would take forever to convert it manually. Let's say your current database stores info like this "title of site, address, description", and the new one requires info to be in this format "address, webmaster e-mail, title of site, description". Well that would be a little problem, wouldn't it? Not with Database Converter though!... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

If you've used the famous 'TreePad' then you know what this is about! Instantly place your TreePad 'hjt' files on your web server and access them from any browser... make edits, changes, all from the comfort of your Internet-connected computer. I describe it as an Explorer for Notepad. Now you can share this data over the Internet now with an online explorer-style viewer. Simply upload your TreePad file and visitors can browse your TreePad the way it was meant to be seen: as a tree. This script allows you to open up whatever HJT files are located in the directory. If you have a family tree file, a journal, some notes all in the same directory then the script prompts you to open the HJT file of your choice. Registered version comes with web online editing capability, searching, password protected nodes, multi-user editing passwords for specific nodes, and unlimited support and updates! Some expected updates: auto folder opening, upload-from-browser capability and more!... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

Allow visitors to your website update their information themselves. Provide an ID and Password for each record then the visitor can update one record in the database. The script is very simple to set-up and customize using the look and feel of your own website. (CGI/Perl Unix)... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

Administrator tool to backup your CSV database online without FTP and downloading. The advanced version will allow you to restore and view the files. (CGI/Perl Unix)