Database Tools

LK Database is a quick & powerful database management system (DBMS). It can handle any number of databases, with any number of tables in it. Written entirely in Perl, supports* SQL. All data stored into file(s) (binary), and file never fully loads to memory. Package also includes LKBinDB myAdmin which alows you to manage databases in user friendly interface.

mySpreadsheet is spreadsheet software that runs on a webserver that can helps you centralize, manage, and share your spreadsheet data using a standard web browser. With mySpreadsheet, multiple groups/individuals in your organization can collaborate on individual spreadsheets that resides on your webserver.

This script grabs contents from a text-based data file and sorts the data before tabulating it into a HTML table. Visitors can click on the title fields to re-sort the table in acending or decending order. It works with MS-Excel/Access data file or any other tab/pipe/colon-delimited text files. Supports unlimited tables and sub-user accounts.

Create, edit and display Microsoft Excel or Access tables directly via a browser. You can create tables from blank, import MS-Excel/Access tables or using existing data files on servers. Support master login and sub-users login. Two-way import/export to/from MS-Exce/Access.

HiData is an instant self-generating database solution for websites, ideal for running a searchable database of stores, products, etc online. Includes online database management via simple to use browser interfaces. Cross platform compatible. If you need database functionality, like sort, search etc and don't have an SQL compliant database available or the expertise to set one up, then you need this solution! Same day delivery. HiData is able to mimick SQL level performance through our proprietaty 'distributed data' flat file database system, which is much more scalable than a standard flatfile database.

Webdata Pro is the relational version of Webdata with a MySQL backend. Webdata Pro requires no programming experience or skills to administrate. Webdata Pro's web interface provides the administrator a point-and-click path through: building tables; designing search pages, reports and forms; managing records; and defining member accounts. Webdata Pro has a built-in shopping cart, and can easily import data from other programs and upload images or documents through the browser. The program has powerful member privileges, allowing the administrator to control each member's access to the data. Calculation fields such as SUM, AVG, COUNT, ESCAPE, IF-ELSE, and more are offerred through Webdata Pro. The software creates complex JOIN queries automatically. The admin just selects the fields and Webdata Pro does the rest. Individually customized reports and forms can be generated using any HTML editor.

Mysql Data Manager (current version 1.73) is an award-winning web-based Mysql interface and administration tool. This is a multifunctional and platform independent program written in Perl that can be run on virtually any web server. Mysql Data Manager is built as a CGI script for management, development and support of Mysql databases over the Internet or Intranet using web browser based interface. It provides a complete set of high-level and low-level capabilities. High-level functions allow you to accomplish a lot with a single mouse click while low-level functions let you do precisely what you want. You get a wide range of solutions to meet the needs of almost any Mysql web application.

This is a Web based database system supporting hundreds of thousands of images plus unlimited short and long text fields. Each user must complete a "User Login" process before he can access his member area to update his own record or search other members only databases. All Web interfaces and system outputs are controlled by HTML templates which can be easily designed by any Website designers.

csGridView is an automated script that allows the user to manage flat file databases with very little effort. Features: You can import existing databases (tab delimited, comma delimited or pipe. delimited), Copy and paste text into a management window, or, Create a new database from scratch, Multiple database management is a breeze, HTML viewing of database information is automatic, Create multiple HTML templates to view the database information, and much more.

The author notes "You can download this old script of mine, written when I was a Perl begginer. It's not optimized for anything and has a bad Perl style, but it's working, so if you don't need quality, but speed of start up your application - go for it."

HandySQL is a handy MySQL access module which is 20% faster than DBI, and with very well-designed programming interface.

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.

Having problems updating your online database? This is your solution. Just upload the script, fill in a form and you can start updating any database you want! The best thing is that you can save your connections, so you can open them the next time you enter.

MyRecords is an incredibly versitile web application to maintain SQL records in a professional manner. Designed for office use, with full search capabilities, easy administration, and tons of customization.

mysqldiff is a Perl script which compares the data structures (i.e. table definitions) of two MySQL databases, and returns the differences as a sequence of MySQL commands suitable for piping into mysql which will transform the structure of the first database to be identical to that of the second (c.f. diff and patch). Database structures can be compared whether they are files containing table definitions or existing databases, local or remote.

Alzabo is a two-fold program. Its first function is as a data modelling tool. Through either a schema creation interface or a custom perl program, you can create a set of schema, table, column, etc. objects that represent your data model. Alzabo is also capable of reverse engineering an existing data model. Its second function is as a RDBMS to object mapping system. Once you have created a schema, you can use the Alzabo::Runtime::Table and Alzabo::Runtime::Row classes to access its data. These classes offer a low level interface to common operations such as SQL SELECT, INSERT, DELETE, and UPDATE commands.

csvdump acts as a front-end to dumping a MySQL table. While it used to use mysqldump, it currently dumps the table itself and massages it. csvdump mails the dump tothe address specified in the command line or to a default mail address, as specified in the script.

This is a database sorting script written in Perl. It is designed to alphabetically sort a database file which contains records and to remove all duplicates that exist in that file.

Now with enhanced template design & image approval/editing, MultiDB offers the ability to create unlimited MySQL databases, is infinitely customizable in its presentation to users, offers import/export, integrates well with Microsoft Access which makes moving data on and off the web a breeze. Additionally, with the SQL version, it can support 1,000,000+ data records. Complete operation is very simple and intuitive and it can be used with very little computer knowledge. Supports Text box, Select box, radio buttons, checkboxes, email, picture and acomments box fields for your data. Now hooks into PayPAL card processing.

Profile Manager Premium is a database driven advanced membership and profile management system. When a user registers, it automatically adds the information about the user into the database. After registration process, user can log on the system by using his/her login and password. Any time point the user can see/modify/delete his profile or search others profiles. You have total power over abilities of the users or the design of the pages. The Premium version also has features like admin(delete user, logon and user statistics, database backup, email or internal messaging to users etc.), upload picture, lost password, advanced listing, searching and categorizing features. Now supports PayPal and ClickBank subscriptions. The new version has a nice looking social application design and an application builder. You can create many different kinds of user content entry and listing pages using PM Premium's application builder.