Spreadsheet::WriteExcel is a Perl module which can be used to create native Excel binary files. Formatted text and numbers can be written to multiple worksheets in a workbook. Formulas and functions are also supported. It is 100% Perl and doesn't require any Windows libraries or a copy of Excel. It will also work on the majority of Unix and Macintosh platforms. Generated files are compatible with Excel 97, 2000, 2002, and 2003, and with OpenOffice and Gnumeric. An older version also supports Excel 5/95.
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.
SPOPS (Simple Perl Object Persistence w/ Security) is a robust and powerful Perl module that allows you to serialize objects. It is unique in that it also allows you to apply security to these objects using a fairly simple but powerful scheme of users and groups. It's also unique in that for most objects, you will not need to write any code. All you need is a fairly simple configuration file, and you can have a class for your object ready to go, right out of thin air.
UnixODBC.pm provides Perl programs with a subset of the X/Open ODBC API for use with EasySoft's unixODBC DBMS libraries, as well as a peer to peer API for querying ODBC data sources on networked systems. In addition, it provides peer client and server scripts and configuration files, sample clients that perform ODBC queries on local and networked systems, result set output for RSS feeds, and two multi-host data managers: one that uses Apache and CGI to provide a Web browser interface, and another that uses Perl/Tk.
pgAdmin III is an administration and management tool for the PostgreSQL database and derivative products such as EnterpriseDB, Mammoth PostgreSQL, Pervasive Postgres, and SRA PowerGres. It includes a graphical administration interface, an SQL query tool with grahical EXPLAIN, a procedural code editor, an SQL/shell/batch scheduling agent, Slony-I management, and much more. It is designed to answer the needs of most users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy.
mod_log_sql (formerly known as mod_log_mysql) is an Apache module that enables access logging to an SQL database. This capability can replace or coexist with Apache's regular text-file logging mechanisms. The currently supported database backend is MySQL, with PostgreSQL and others in development.
AppWrap is a content management system for enterprises. It is built on a template engine that includes a framework for building SQL tables and allowing users to populate and maintain these tables. Reports using data from these tables can be easily created using another template. It is ideal for quickly Webifying Excel and Word files shared among workgroups and rapidly providing advanced data management and presentation capabilities. It 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.
PhotoShelf is a complete Web-based system for archiving, categorising, displaying, and managing photos. It has features and aesthetics missing in other systems, making it the only package needed for complete digital image housing. Features include Web upload of jpg, tarball/zip files, ability to read EXIF information from digital camera images, nested albums, efficient storage system, slide shows, and online help.