Maccess helps to analyse data in databases; it is a Web interface to an SQL server. Its main features are user friendly query creation for SQL server; selective, grouped, and crosstab queries; various outputs (XML, HTML, TXT, graphs, and Europe map); data ungrouping in grouped queries; creation of Web links and definition of CSS styles for all values in output; ability to format numbers, dates, and times; and input and data update.
Marketplus is an ecommerce application based on PHP4 and MySQL for managing virtual shops. Products are organized into categories and sub-categories. Every item is associated with a detailed image and an enlargement. You can search for a particular product. Purchased products are stored in a cart which is always visible. Users are recognized by username and password. Administrators can insert, delete, and change products or categories online after authentication. Every user and order is stored in the database. European users can show products price in their own currency and in euro.
OpenACS (Open Architecture Community System) is a mature toolkit for building scalable, community-oriented Web applications. Significant functionality is built-in, including user management, user group management, permissions, discussion forums, FAQ management, e-commerce, file storage, content management, and more. OpenACS is the foundation for many products and Web sites, including the .LRN e-learning platform.
php-LugMembers is a Web interface written in PHP to access a MySQL database holding member information. It currently includes support for adding/deleting/editing users through an admin interface, and members have the ability to edit their own information and change their passwords. It has customizable header and footer files, and can be easily manipulated to add or remove database fields.
PIMPPA automates file downloading from newsgroups and FTP sites. Its especially designed for leeching pictures but can be used for any files. Filename-based heuristics and MD5 checksums are used for spam/duplicate prevention and automatic sorting of incoming material. The whole process is cronable. PIMPPA also includes a GNOME GUI and several commandline utilities for further processing and management of the kept files.
PostgreSQL is a robust relational database system with over 25 years of active development that runs on all major operating systems. It is fully ACID compliant, and has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, and ODBC, among others, and exceptional documentation.
Sitegrab is a URL grabber that parses IRC logs for data and then inserts it into a database that can be searched through a web interface using a combination of announcer name, date, partial url, and type of url. Also supported is an administration mode whereby urls can be edited and deleted through the web interface.