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.
Berkeley DB (libdb) is a programmatic toolkit that provides embedded database support for both traditional and client/server applications. It includes b+tree, queue, extended linear hashing, fixed, and variable-length record access methods, transactions, locking, logging, shared memory caching, database recovery, and replication for highly available systems. DB supports C, C++, C#, Java, PHP, and Perl APIs. It supports key-value pair (NoSQL), SQL, and Java Object formatted data. It is available for a wide variety of Unix platforms as well as QNX, Android, Mac OS X, and several varieties of Windows.
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.
TYPO3 CMS is a Web Content Management System which features automatic creation of navigational menus, headlines, and other dynamic graphical elements, automatic conversion and scaling of images, the ability to present different templates based on variables such as client browser or country code, support for multiple templates on a site, and a built-in password-protection option. Pages can be timed to be shown on a certain date, be hidden on a certain date or just temporarily hidden. TYPO3 supports search in SQL-databases and redesigning of a website at once is just a matter of creating a single new template.
Ora2Pg is a Perl module to export an Oracle database schema to a PostgreSQL compatible schema. It connects your Oracle database, extracts its structure, and generates an SQL script that you can load into your PostgreSQL database. It dumps the database schema (tables, views, sequences, indexes, grants) with primary, unique, and foreign keys into PostgreSQL syntax without editing the SQL code generated. It also dump Oracle data into PostgreSQL DB as online process or into a file. You can choose what columns can be exported for each table.
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.
DbWrench is multi-vendor, multi-platform database design and synchronization software. Features include a syntax highlighting SQL query editor, support for many of today's most popular databases, a graphic entity relation diagram (ERD) designer, and the ability to forward and reverse engineer databases. Its multi-vendor and multi-platform functionality makes it ideal for heterogeneous database environments.
deltasql is a tool to synchronize databases with source code, which helps to keep database evolution under control. While developing mid-sized or big applications, developers make changes to the data model that go along with changes to the source code. From time to time, branches of source code are done to stabilize the code that will go to production. A sort of data model branch is also needed. deltasql provides a simple way to collect all scripts that change the data model and means to handle data model branches. The deltasql server runs on Apache and is backed by MySQL.