| Sign In/My Account | View Cart |
 |
We've expanded our Perl news coverage and improved our search! Search for all things Perl across O'Reilly! Databases alarm - Informix monitors and alarms This distribution provide a set of tools to monitor INFORMIX-Online Dynamic Server and the INFORMIX i.Sell Application Server. These tools were developed to ensure high availability of INFORMIX databases by constantly monitoring warnings, errors, and online status of the databases. AppWrap AppWrap is a self-organizing Content Management System. All data managed is input and maintained by users, and the program provides access and storage. It is designed so that an administrator can easily increase the scope of data under management. The distribution includes sample tables and reports for recording and displaying status for project managers. These examples can be adapted for specific needs, and complete documentation is included for adding new data sets and custom development. AppWrap is intended for managing mildly dynamic data without the labor of hand-coding and managing multiple CGI forms and templates, or the expense of CRM systems. B-Trees B-Trees are often mentioned as a good way to store and retrieve data, especially to and from disk. They're efficient to use and easy to program, and they're often mentioned but not-so often discussed. In this article by Mark-Jason Dominus you will see how they work. First, there is a review of how to use ordinary binary trees to store data, and see the potential disadvantages of that. Then there is a look over the B-Tree algorithm in the abstract, and see how it corrects the flaws of binary trees. Then there is a look at the code of a module that implements the B-Tree algorithms and see how B-Trees can be implemented in Perl. Beagle SQL Free client-server SQL database engine with Perl API DB File 1.14 The 1.14 release is identical to the version of DB_File that is included with Perl 5.003_99. DB File 1.5 The 1.50 release is beta code which can build with either Berkeley DB version 1 or version 2 (but not both simultaneously). When built with DB 2.0 it only supports the functionality available in DB 1.x. Anywhere the version 2 interface differs, DB_File arranges for it to work like version 1. This feature allows DB_File scripts that were built with version 1 to be migrated to version 2 without any changes. A future version of DB_File which will support the new features available in Berkeley DB 2.x is currently under construction. Db::Ctree A module that permit's Perl 5 access to Faircom's Ctree database products. It is a Perl 5 replacement for Perl4's Ctreeperl by John Conover. DBD Database Drivers. The Perl DBI initiative has standardized the interface to a number of commercial database engines, so that you can move from, say, Oracle to Sybase with a minimum of effort. You'll find DBD::DB2, DBD::Informix, DBD::Oracle, DBD::QBase, DBD::Sybase, and DBD:mSQL here. Also see the DBI module. If you're looking for a database manager instead of an engine, see the DB_File module. DBD-Informix An Informix interface for Perl 5 using DBI. DBD::CSV DBI Driver for CSV files. It is based on the SQL %22engine%22 SQL::Statement and implements access to so-called CSV files (Comma separated values). Such files are mostly used for exporting MS Acess and MS Excel data. DBD::DB2 DBD::DB2 is a Perl5 module which when used in conjunction with DBI allows Perl5 to communicate with IBM's DB2 Universal Database. Technical support for the DBD::DB2 driver is provided by IBM through its service agreements for DB2 UDB. Information on DB2 UDB service agreements and support can be found on the Web at http://www.software.ibm.com/data/db2/db2tech. For other DBD::DB2 information, please see http://www.software.ibm.com/data/db2/perl. DBD::FreeTDS This is a sneak peek of a DBD module for Microsoft SQLServer and Sybase. It is in the very early stages of development and many parts of it are not implemented yet. The main advantage of this driver is that it directly speaks the raw TDS protocol and does not need any third party libraries. DBD::Fulcrum DBI driver for Fulcrum SearchServer. DBD::Ingres DBD::Net A Perl module for remote database access. Some OSes ( like Linux) don't have DB client support (Informix's I-NET, Orcale's SQLNET), or you have to pay extra money for DB client. DBD::NET module consists of two components:
DBD::Sybase Sybase database driver for the DBI module. The DBD::Sybase module is built on top of the Sybase Open Client Client Library API. DBD::Unify The Database Driver for the Unify family of database products. DBD::XBase Provides read and write access to XBase data files (.dbf and .dbt). It doesn't obey index files so please do not break your valuable data. DbFramework DbFramework is a collection of classes for manipulating Mysql databases. The classes are loosely based on the CDIF Data Model Subject Area (http://www.cdif.org/). There are methods for representing data model objects as HTML and a class which can be subclassed to add persistency to Perl objects. The module includes a CGI application which provides an HTML forms interface for manipulating Mysql databases. DBI The Database Interface. The Perl DBI initiative has standardized the interface to a number of commercial database engines, so that you can move from, say, Oracle to Sybase with a minimum of effort. You'll find DBD::DB2, DBD::Informix, DBD::Oracle, DBD::QBase, DBD::Sybase, and DBD:mSQL inside the DBD module set. If you're looking for a database manager instead of an engine, see the AnyDBM_File module. DBI - A Database Interface Module for Perl 5 DBperl is a database access Application Programming Interface (API) for the Perl Language. The DBperl API Specification defines a set of functions, variables and conventions that provide a consistent database interface independent of the actual database being used.%22 DBI-MySQL FAQ A well organized DBI MySQL FAQ -- Browse categories, search questions or search keywords. DBIx::HTMLView A general purpose module to simplify the creation of web userinterfaces to a DBI database, currently it can list, view, add, edit and delete entries in the databse using either <input ...> or <textarea> to gather the info. dbUnder dbUnder is a Perl4 Based micro-RDBMS Database Library using flat-files to manage tables and data -- Its ideal for Web applications. DBZ_File Provides access to dbz files, such as the history file in a Usenet news system. DB_File man page for DB_File - Perl5 access to Berkeley DB. DB_File DBM-style interface to Berkeley DB. See the AnyDBM_File module bundled with Perl. Requires the freely-available Berkeley DB package. Erstellung dynamischer HTML-Seiten unter Verwendung einer MySQL-Datenbank A tutorial for programming CGI-scripts which are using the DBI-Module to contact a MySQL-Database. (In German, obviously) EZ Perl A free script for database management, handling multi-user accounts and multi-table access. FutureSQL Web Database Administration Tool FutureSQL by Peter F. Brown, is a Free, Open Source Rapid Application Development web database administration tool, written in Perl, using MySQL. It uses DBI:DBD and CGI.pm. FutureSQL allows one to easily setup config files to view, edit, delete and otherwise process records from a MySQL database. It uses a data dictionary, configuration files and templates, and allows %22pre-processing%22 and %22post-processing%22 on both fields, records and operations. It's very flexible and has a wide range of options. It can be used for administrative functions, but it can also be modified to allow web visitors to perform read only searches on data tables. It allows multiple setup files to provide different views or operations on the same data set. Thus, an administrator / programmer can tailor it to fulfill a large number of functions, providing a different look and feel for different web sites. Documentation is included in the setup file. The software complies with the GNU GENERAL PUBLIC LICENSE. genquery This package has various functions for generating html code from an SQL table structure and for generating SQL statements (Select, Insert, Update, Delete) from an html form. You can easily build a complete forms interface to an SQL database (query, add, update, delete) without any programming! HashHistory This module behaves like an ordinary hash, but it records the history of every hash key. By calling a method, you can get back a list of all the values that have ever been associated with the key, in chronological order. Informix update statistics utility The updstats utility generates optimal update statistics statements according to the Informix Performance Guide, and the xupdstats utility executes them in parallel, sending each batch of statements updating a table to a forked process, and as each batch finishes, another is sent. Ingperl When perl is combined with CA-Ingres SQL, the result is a simple yet graceful and dynamic query and data manipulation language, called ingperl. ISAM.pl A Perl 5 module to access C-ISAM or D-ISAM files. JDB JDB is package of commands for manipulating flat-ASCII databases from shell scripts. JDB is useful to process medium amounts of data (with very little data you'd do it by hand, with megabytes you might want a real database). JDB is very good at doing things like:
MLDBM Lets you store multidimensional hash structures in DBM files. Msql The MsqlPerl interface between Perl and the mSQL relational database management system. Msql::RDBMS A relational database management system for Msql, using HTML forms as an interface. Requires CGI-modules, CounterFile, and of course the Msql module. MSSQL::DBlib and MSSQL::Sqllib MSSQL::DBlib and MSSQL::Sqllib are two Perl classes for accessing Microsoft SQL Server® from Perl. MSSQL::DBlib provides a direct interface to DB-Library. This module is basically a port of Michael Peppler's Sybperl. MSSQL::Sqllib is a Perl module that inherits from MSSQL/DBlib and extends it with a high-level interface, providing the possibility to send an SQL command and retrieve the result in one line of code and forget about error-checking. MySQL Perl DBI/DBD Manual Documentation and examples of using DBD:mysql. ObjStore Easy, flexible, lightning-fast persistent via ObjectStore DBMS. Stores scalars, hashes, and references without flattening. Perl databases can be accessed from C++ and/or Java. Inversely, persistent C++ objects can be added to Perl! This is the relational database killer app! Perl 5.0 Interface to Velocis for WindowsNT/95 Use Perl scripting language with Velocis databases. Now available for Windows NT and Win 95. PerlDB-Interest Mailing List Archive A searchable archive of the Perl DBI/DBD mailing list Pg Perl interface to Postgres, a freely available relational database engine. RDB Interactive (rdbi) RDB is a fast, portable, Relational DataBase Management System without arbitary limits, (other than memory and processor speed). rdbi is an interactive analysis tool for RDB data tables (rdbtables) called 'rdbi'. It is especially useful for rdbtables that were made from spreadsheet data or outside sources of unknown content. Simple Perl Databases This is a tutorial intended to teach you some of the powerful features of Perl while also showing you a very practical example of a set of CGI programs that you can add to your web site. Sprite Maniuplates simple text-delimited databases. SQL::Statement he SQL::Statement module implements a small, abstract SQL engine. This module is not usefull itself, but as a base class for deriving concrete SQL engines. The implementation is designed to work fine with the DBI driver DBD::CSV. Sybase::Login A login widget for Sybase. You'll need both Tk and Sybperl. Sybperl Interface to the Sybase relational database engine. Also see the DBD and DBI module sets. SybPerl FAQ Sybperl is a package of extensions to Perl that basically add the Sybase db_library API calls to the Perl language; the combination is an extremely powerful scripting tool for Sybase DBA's and programmers because it adds the existing strengths of Perl to the Sybase API. SybPerl Man Pages Tangram Tangram is an object-relational mapper. It makes objects persist in Tie::ShadowHash This provides a trivial and painless way of generating hashes from space- (or comma-, or anything-else-) separated text files for easier use in the rest of your program. If you have a bunch of separate sources of data in the form of Perl hashes, tied hashes (of whatever type, including on-disk databases tied with DB_File, GDBM_File, or similar modules), or text files that you want to turn into hashes, and you want to be able to query all of those sources of data at once for a particular key without having to check each one of them individually each time, this module is what you're looking for. If you want to use a hash-like data source, even just one, but make modifications to its data over the course of your program that override its contents while your program runs but which don't have any permanent effect on it, then this module may be what you're looking for. VORTEXperl (beta-version)VORTEXperl writes data directly to and from TCP/IP socket stream protocols removing the need for any native methods on the client side. It talks to multiple RDBMs, and since it uses Perl Sockets so there is no need to re-build the Perl runtime. It also support all versions of Informix 5, 6 and 7. Win32::ODBC A Perl 5 extension that provides access to the ODBC API. Windows Perl Package Repository A nice collection of database-related Perl packages in Activestate Perl Package Manager format (.ppd). WODA A Web Oriented DAtabase development system -- WODA is about 180k of code in Perl language which makes it very easy to create a multimedia, web-oriented, semi-relational database that can then be maintained, added-to, modified, and queried through the WWW. Xbase Access to Xbase DBF files and Foxpro IDX and FPT files. [Editor's Note: See the newer, and supported, DBD::XBase]
|
|
Sponsored By:
|
|
||||||||
|
||||||||
