http://www.advancescripts.com/rss/315.htmlDatabase Management RSS feedsen-usCopyright (c) AdvanceScripts All rights reserved. http://www.advancescripts.com/detailed/13198.html 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. http://www.advancescripts.com/detailed/8672.html 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. http://www.advancescripts.com/detailed/8671.html 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). http://www.advancescripts.com/detailed/8670.html This script allows you to export your mySQL tables into http://www.advancescripts.com/detailed/8669.html Wilma is a suite of CGI scripts that allows you to easily manage a list of items (broken into discrete categories) on the Web. With Wilma, you can make lists of bookmarks, resources, reviews, classified ads, 'what's new' lists, bulletin boards and much more. Anything that needs to be indexed and easily maintained is a good candidate for Wilma. http://www.advancescripts.com/detailed/8668.html Built on top of the BizDB Software (all its features included), ImageDB has several unique features which make it an excellent application for hosting image intensive databases. If you are a real estate agent or a photographer with a plan to market/showcase your products on the Web, this system is for you. It is easy to set up and install, comes with a powerful search engine, supports multiple database files and multiple image files per database record. And, more importantly, it has a batch deletion utility for expired records. http://www.advancescripts.com/detailed/8667.html 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. http://www.advancescripts.com/detailed/8666.html 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. http://www.advancescripts.com/detailed/8665.html 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 http://www.advancescripts.com/detailed/8664.html 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. http://www.advancescripts.com/detailed/8663.html SuperScripts' Database is a multiuser online database creator and search engine that searches, edits, and imports ASCII databases on your web server. Endless possiblities for serving databases over the world wide web. Import your ASCII database from microsoft access right over the internet. Password protected editing offers administrator ability to edit or delete any file. Also features the ability to allow visitors to add individual password protected database entries that they can edit. Export and import the database into any program that can interpret comma delimited formats. http://www.advancescripts.com/detailed/8662.html 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. http://www.advancescripts.com/detailed/8661.html The Database Doctor allows you to manage and display text file databases of any field size. This powerful script can easily be used for a directory of addresses, products, or any list you can imagine. The display script is very customizable, but automated so that it works right out of the box as well. Version 3.0 features include column settings for required fields, unique fields, data types, default input and more. Easy forms for adding new items, preview, editing, deleting, search, sort by field, and will even prepare a page of your data for printing. http://www.advancescripts.com/detailed/8660.html QuickMySQL is a powerful little MySQL utility program designed for novices and professionals. Create, drop, view and update tables columns and whole databases in seconds. Features: Connect to and access any localhost database on the same server or any remote database server with a URL and port number, View the contents of any or all tables in the working database, View the definitions of any or all tables in the working database, See a count of all records in any or all tables in the working database, Empty or Drop any table in the working database, Get a table re-build SQL statement for any or all tables in the working database, Obtain a print out of the servers variables and status information, Rebuild a table on a remote server with the click of a button, Transfer the entire contents of a table to a table on a remote server with the click of a button, Copy the contents of one table to another table on the same database, and Perform your own SQL statement queries on your working database. http://www.advancescripts.com/detailed/8659.html 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. http://www.advancescripts.com/detailed/8658.html WebDB provides a Web interface to manipulate databases. It provides the ability to add to, modify, and delete from multiple databases based on keyword recognition. This application also implements the password authentication algorithms. It also features a search engine that allows users to search a shared database by keyword but doesn't give them the power of a larger database manager script. Database administrators can provide a database management interface for themselves and a corresponding database search interface for other people in the company. http://www.advancescripts.com/detailed/8657.html 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. http://www.advancescripts.com/detailed/8656.html 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. http://www.advancescripts.com/detailed/8655.html txtSQL® is development modules to help developers speeds up development that make use of flat database inserting and extracting data from a database and Uses SQL commands. http://www.advancescripts.com/detailed/8654.html 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. http://www.advancescripts.com/detailed/8653.html MultiDB Express Pro allows you to host and resell database accounts to other webmasters so they can create member sites. It offers the ability to create unlimited MySQL databases, is highly 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. Complete operation is very simple and intuitive and it can be used with very little knowledge. http://www.advancescripts.com/detailed/8652.html 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. http://www.advancescripts.com/detailed/8651.html View pre-configured tables from MySQL or Oracle data sources; Test multiple select statements and view the results as well as save queries with explanation for future use; Export result of any query into comma-separated or MS Excel formats; Modify a simple configuration file and put more details on any table to view and query against. Great tool if you need a client tool to test database queries. http://www.advancescripts.com/detailed/8650.html Use RW My SQL Dump to backup your MySQL databases, both structure and data. The script can be run from command prompt only. So, you can use crontab or other system scheduler to fully automate your data backup process. The script browse all databses that you select and write SQL statements for creating tables and inserting data into files (one for each database). As an option the dumps may be compressed into zip archive. Finally output files stored into directory that you selected. http://www.advancescripts.com/detailed/8649.html 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. http://www.advancescripts.com/detailed/8648.html Enter in SQL and have the statement run. See the results of select statements and any error messages. Upload files of SQL for population of database. The simple tool for getting to a database over the web. http://www.advancescripts.com/detailed/8647.html Manage and view the contents of multiple mySQL databases. Easily back up and restore multiple tables simultaneously to server of your hard drive. http://www.advancescripts.com/detailed/8646.html This script includes the most useful oracle dba scripts especially for performance tuning. Extents, free space, r/w per datafile, locks, full table scans, recently used indexes, hit ratios, sorts, caches... http://www.advancescripts.com/detailed/8645.html This Perl DBD::ODBC/DBD::mysql script was automatically generated error-free by FmPro Migrator running on MacOS X. This script runs on Windows in order to copy text, numeric, date, time and JPEG image data from FileMaker Pro to MySQL. http://www.advancescripts.com/detailed/8644.html TML is a template based database system that you can use to manage bookmarks, address list, images data such photos and icons, and audio data such as MP3. You can also use TML to create databases of your own design. http://www.advancescripts.com/detailed/8643.html klist is a perl script which can create/delete/edit flat text databases. The script is installed in cgi-bin as any other cgi program. You can specify various fields like: text, number, popup and links. A simple password scheme allows you to present lists as read-only, add-only or fully editable depending on the password. http://www.advancescripts.com/detailed/8642.html If you are looking for an easy to use database which simply lists all entries on a web page, this may be what you are looking for. You can sort descending/ascending. Also, entries can timeout automatically e.g. for OoO lists. It is possible to password protect lists. http://www.advancescripts.com/detailed/8641.html This handy little module takes all the pain away from making a database for programmers. Simply make a format file, for the format the data will be stored in. IE: NAME http://www.advancescripts.com/detailed/8640.html Webdata is an easy database program specifically for the world wide web. It uses your web browser to add, modify, or delete entries into your database. All you have to do is upload 2 files to your Unix server, and type 'perl install.pl'. It will ask you some questions about your server, what password you want, and what field names you want. That's it. It generates a maintenance page called 'admin.html' from which you can immediatly begin adding records. Guests will be able to search by any combination of criteria to suit their needs. http://www.advancescripts.com/detailed/8639.html Version 4.3 allows database replication to duplicate and entire database site, membership database linking which allows many databases registrations to be linked so there is one log in, and a new admin email newsletter section allows you to write and save newsletters. As before credit card processing can be set up in seconds. Contained DHTML navigation,20 new professional design templates, and improved email management, and a databsae creation wizard. Based on MySQl engine. http://www.advancescripts.com/detailed/8638.html 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. http://www.advancescripts.com/detailed/8637.html 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. http://www.advancescripts.com/detailed/8636.html 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. http://www.advancescripts.com/detailed/8635.html This Perl script allows you to backup your whole database server or selected databases. The resulting compressed file (zip or gzip) is optionally e-mailed to you or sent to another machine by FTP. You can run this program manually, from a browser or a cron job (scheduler). A no-fuss application that will have you sleep better at night! http://www.advancescripts.com/detailed/8634.html Mysql Data Manager is a high quality instrument for the online management of mysql server and databases. This web based mysql front end provides a powerful interface for databases management, development and maintenance. It connects to mysql server locally or remotely. Main advantages: Easy installation; High performance/cost ratio; Platform independence; Reliability and efficiency; Ability to operate in multi-user environment as universal control panel. This release features text display options. Version number was not changed. http://www.advancescripts.com/detailed/8633.html Free Ad Supported Website Counters, Guestbooks, and more coming (Databases, etc.) Some Completely Free Stuff, too! Counters are rendered via javascript includes, so they should work almost anywhere on anyone's site. Guestbooks are via frames. http://www.advancescripts.com/detailed/8632.html 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. Free installation and support if required. http://www.advancescripts.com/detailed/8631.html 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. http://www.advancescripts.com/detailed/8630.html 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) http://www.advancescripts.com/detailed/8629.html 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. http://www.advancescripts.com/detailed/8628.html 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. http://www.advancescripts.com/detailed/8627.html 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. http://www.advancescripts.com/detailed/8626.html DBDisplay is a database script that displays the contents of a flat-file, pipe delimited database file in a nicely formatted HTML table. The script handles up to 10 separate database files depending on the URL parameter values. The script is highly configurable and contains paging which allows you to specify the desired number of records per page you would like to view. http://www.advancescripts.com/detailed/8625.html DataCat is a high-impact developer's tool that allows you to present your data in a variety of ways it needs to be presented. Whether it be a directory, a classified ads system, real estate listings, or a variety of other scenarios, with a simple installer, fully customizable set of templates, user accounts, and powerful search features, DataCat makes it easy to present your data on the Web. http://www.advancescripts.com/detailed/8624.html CSV manager is a Perl script that allows you to add records or to perform searches on one or several csv databases. http://www.advancescripts.com/detailed/8623.html 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. http://www.advancescripts.com/detailed/8622.html EasyData is an all-round, but easy-to-use database management system (DBMS) suited for versatile database applications like product catalogues, search engines and more. EasyData comes with a wide range of features like handling of categories, record voting and comment system, integration of images and binary files, record expiration, various field types and field validation. You can also allow online record additions and modifications (also moderated, of course) directly from your website. An advanced search tool allows complex search criteria like boolean operators, wildcards, comparisions, phrases, parentheses and filtering. The web-frontend is fully customizable to fit into any existing website layout. http://www.advancescripts.com/detailed/8621.html dbSpace is an online database manager that provides an easy to use interface to add, delete, modify and search records in a flatfile ascii database. http://www.advancescripts.com/detailed/8620.html This system is intended for those of you that have a set of data on your PC's database; i.e. Access. You can export your list in a standard text format and upload it to your server where this script will deliver it to your client. http://www.advancescripts.com/detailed/8619.html Reunion Address DataBase (RADB) is a CGI Script written in Perl. It helps you to manage an address database for the organization of a reunion for your school, society, club or family. The database is password protected. Users can view and add content, the admin can also change, delete and export. Although designed for a dutch school, it should be easy to change it to your own needs. http://www.advancescripts.com/detailed/8618.html 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. http://www.advancescripts.com/detailed/8617.html 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) http://www.advancescripts.com/detailed/8616.html Generate CGI-Perl database scripts to your own custom design of your database, also in ASP Access and PhpMySQL, with Add, Search, Edit and Delete functions. A user can edit and delete his own record only, protection being provided by user-selected password. Search results are paginated, the number of records per page being customisable. There are two databases, one for Matrimonial, the other for Classified Advertisements. The site also has Reciprocal Links Exchange Directory http://www.advancescripts.com/detailed/8615.html EasyData/SQL is a web-based database management solution, which uses SQL server for data retrieval and storage. Features: image/binary fields handling, categories, powerful search, automatic record expiration, template-based full layout customization, moderation, access restriction, voting, comments, mass mailing, data import/export, input verification, data backups, modifications logging, search requests analyzer, etc. Supports mySQL and MS SQL Server. http://www.advancescripts.com/detailed/134.html This powerful script will make saving and restoring your MySQL databases as easy as "one-two-three". It is simple and convenient to use and will keep your databases backed up and safe. You can make backup copies of databases in any directory provided by your ISP, or you can back them up on your local computer, or you can upload them to the server. You can email backups to the database owner or to yourself. You can pack and unpack backups automatically. You can store databases backups to an FTP..