GQL is a C++ library for generic SQL database access, modeled after JDBC (Java Database Connectivity). It includes drivers for PostgreSQL, MySQL, and SQLite, and includes GQL-Shell, an interactive database terminal called that features command-line editing, history, and database metadata (schema) browsing.
The Information System Development Kit gives the developer a platform-independent method of creating Information Systems with data forms, SQL database access, database-browsing support, report generator and many other useful features. ISDK is now in a development stage and it is available only for the Linux operating system. The form module now works on text terminals using the ncurses library (not functional right now), and on the X-Window system using the GTK+ toolkit.
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.