Table of Contents License Agreement Program Credits Software Manual Dynamic Database Functionality The database functionality inherent in this program is unrivaled on the Internet. The software package, written entirely in the Perl programming language, uses Perl's DBI module for database access. DBI is recognized the world over as the most flexible interface to relational database management systems (RDBMS) available. The use of the Perl DBI allows access to many different data sources. This program uses Comma Separated Value (CSV) files by default but allows connection to an advanced RDBMS like MySQL, PostgeSQL and Microsoft SQL Server using the administrator utility. Most programs that use DBI for database access only tie into an advanced RDBMS and require the installation of compiled modules on the webserver by system (root) administrators. This program does not require the installation of any compiled modules, nor does it require the presence of an advanced RDBMS. The program is capable of running in CSV only mode using a pure Perl version of the DBI. This means it will install anywhere and offer the same functionality to all users. Use of the Perl DBI allows the program code to use SQL calls to data sources and also allows for the dynamic expansion of data tables by developers. Developers are free to modify this open source program, as they see fit, and the use of SQL makes modifications very easy and understandable. Complete database administration, including importing and exporting from CSV sources to and from an advanced RDBMS and other files, modification of data sources, and dynamic loading of an RDBMS are included in the administration utility. The optional use of a compiled version of the DBI in conjunction with an RDBMS like MySQL allows users to store in excess of a million rows of data per table. This permits the software to handle any number of products, orders and pages (for example). Tens of thousands of products can be accessed in CSV only mode. The program can switch dynamically between modes, performing data imports and exports, as your needs grow and/or your server specifications change. This is the only program on the Internet that provides this type of functionality that is also installable on virtually any webserver that is capable of running Perl (over 99% of the current server market).

© 2003 Kryptronic, Inc. All rights reserved. This program is distributed under license. The license agreement includes terms and conditions as well as copyright information. ClickCartPro and Kryptronic are registered trademarks of Kryptronic, Inc. Click here for more information on ClickCartPro.