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.
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.
OpenPSA is a Web application designed specifically to meet the needs of Web agencies and consultants. It aims to be a one-stop solution for the management of typical agency business processes, such as project management and time tracking, invoicing and document management, and group calendars. It also includes CRM features such as sales force automation and direct marketing, and is extendable via the builtin component framework.
Simple Groupware is a complete enterprise application offering email, calendaring, contacts, tasks, document management, synchronization with cell phones and Outlook, full-text search, and much more. Simple Groupware combines standards like RSS, iCalendar, vCard, IMAP, POP3, SMTP, CIFS, CSV, WebDAV, LDAP, and SyncML under one platform. Unlike other groupware software, Simple Groupware contains the programming language sgsML to enable the quick customization and creation of powerful Web applications.
Hoteldruid is designed to manage weekly or daily rental of house apartments or hotel rooms. It uses a PostgreSQL, MySQL, or SQLite database as a backend. Reservations can be assigned to rooms automatically with user-defined rules. Pages with forms to check availability for Internet sites can be created. It supports multiple users with a privileges system. Documents and invoices can be printed, saved, and emailed.
The adventure PHP framework (APF) is a utility to implement object oriented and generic PHP Web applications. It allows the developer to create programs in compliance with approved software design patterns, and the code base already has answers to many everyday problems. The framework cannot be described as an application that only has to be configured, but rather as a technical basis and design guide for the design of software. Further, it introduced many concepts and efficiency tools already well known in the Java community.
Valentina is cross-platform SQL and non-SQL columnar database that allows development of client-server [Web] solutions and applications with an embedded local database using the same sources. Valentina DB provides an Object-Relational model, but you can also mix Relational and Extended Navigational. It introduces a revolutionary model abstraction "Link" that greatly simplifies db schema, and therefore simplifies SQL queries. It supports disk and in-memory databases, and field types including Bit, BLOB, Pictures, and Enum. It provides advanced features such as triggers, views, stored procedures, regular expressions, XML, full-text search, and calculated fields. It exists as Valentina Server, Valentina Studio, and a set of Valentina ADKs for all major programming languages.
oXygen is an XML editor that supports any XML document, and works with XML Schemas, DTDs, Relax NG schemas, and NRL Schemas. It has powerful transformation support that allows you to edit XSLT and XSL-FO documents and to obtain documents in the desired output format (such as HTML, PS, or PDF) with just one click. It also includes a complete Subversion client, support for flattening XML Schemata, an XML Schema instance generator, integration with the X-Hive/DB, MarkLogic and TigerLogic XML databases, editing actions on the diagram, and a rename refactoring action.
PostGIS adds support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS), much like ESRI's SDE or Oracle's Spatial extension.
The unixODBC project provides Unix applications with the same ODBC 3.51 API and facilities available under Windows. It provides a Driver Manager that supports the full ODBC API and performs the ODBC 3 to ODBC 2 translations with UNICODE to ANSI conversion. It also includes a set of graphical utilities that allow users to specify connections to DBMSes to be used by applications, a collection of ODBC drivers including a simple text based driver, an NNTP driver, a Postgres driver and others, and a selection of templates and libraries that to aid in the construction of ODBC drivers. It works with MySQL, Postgres, StarOffice/OpenOffice, Applixware, iHTML, PHP, Perl DBD::ODBC, and many other applications and drivers. Connection pooling is also provided to increase performance with applications such as PHP.