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.
DBeaver is a universal database manager and SQL Client. It supports MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, SQLite, Derby, and any database that has a JDBC driver. It is a GUI program that allows you to view the structure of a database, execute SQL queries and scripts, browse and export table data, handle BLOB/CLOB values, modify database meta objects, etc. It has a native UI (provided by the Eclipse SWT library), great performance, and relatively low memory consumption.
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.
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.
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.
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.
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.
The Ecere SDK is a cross-platform toolkit for building software applications. It currently runs on Windows, Linux, Mac OS X (through X11), FreeBSD, and the Android OS. It should run on other Unix platforms with minor testing/tweaking. With the Ecere SDK, you can develop applications once and deploy them on all supported platforms alongside a lightweight runtime environment. It introduces eC, an object oriented language derived from and fully compatible with C, compromising neither runtime performance nor ease of use. A built-in 3D engine supporting both Direct3D and OpenGL is fully integrated.