Database Tools related scripts & softwares
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.
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.
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.
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.
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.
Using this script you can get the enviromental variables of your server it will help with the installation of other cgi programs
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.
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!
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.
Reliable database engine coming with a fully customizable web-frontend and providing professional features for data retrieval and storage. Suited to host any kind of business related databases, search engines (like this one) and other database-driven applications (e.g. content management tasks).
Some of the features: Handles multiple databases at once; category system; unlimited fields; user permissions (access restriction) and moderations; powerful search operations and versatile display settings; record ratings, comments and votings; personalized mailings with attachments; access statistics; data import and export; and much more ! Please visit our website for detailed information.
|
