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.
Bricolage greatly simplifies the complex tasks of creating, managing, and publishing vast libraries of content. With advanced features such as fully-configurable workflows, customizable document types, and comprehensive Perl and PHP templating support, it has been designed from the ground up to scale to meet the demanding needs of large organizations around the world.
OTRS is a platform independent Web-based help desk system that supports service organization of any kind (e.g. IT service, customer and technical product service, complaint management, public services, etc.) to increase their efficiency. It increases transparency as well as service quality and lowers your total cost of ownership. It has been certified ITIL V3 compatible by PinkVERIFY for incident, problem, change, service asset and configuration, request fulfillment, and knowledge management. Other ITIL processes like service catalog and service level management are supported as well.
FreeMED is a Web-based medical records (EMR) and patient management system with a printing system, patient scheduling, an HL7 interface, a billing system, XML-RPC Web services, and many other features. It has an extensible modular architecture, allowing it to be customized based on individual practices without having to rewrite core components of the system. It is HIPAA compliant.
mg.applanix is a multi-featured, configurable, Web- and MySQL-based application for management of small and medium-sized accommodation establishments, such as hotels, campsites, hostels, and motels. mg.applanix features an occupancy table for all managed rental objects, a detailed customer information and booking file, a tiny organizer, and customizable printing of bills, address labels, etc. It also provides user-based session management. Users are members of predefined groups which provide a simple access restriction mechanism. Localizations for several languages are available.
b2evolution, is a multi-lingual, multi-user, multi-blog engine. It was developed to provide a free, feature rich, extensible, and easy-to-install solution for efficient Web publishing of information ranging from professional news feeds to personal weblogs. b2evo can easily be installed on almost any LAMP (Linux, Apache, MySQL, PHP) host in a matter of minutes.
Photo Organizer is a Web-based multi-user photo management tool that was designed for professional photographers. It offers a searchable photo database that supports photo version control, a datebook with client management, photo submission history, EXIF, IPTC, XML, and XMP, user quotas, and printing labels and color brochures. It uses ImageMagick and DCRAW to handle over a hundred image formats, and relies on PostgreSQL as its database backend.