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.
SQLite is a small, fast, embeddable SQL database engine that supports most of SQL92, including transactions with atomic commit and rollback, subqueries, compound queries, triggers, and views. A complete database is stored in a single cross-platform disk file. The native C/C++ API is simple and easy to use. Bindings for other languages are also available.
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.
Cego implements a relational and transactional database system with support for the SQL query language. The current release contains the most common database features for basic table manipulation and data retrieval. Indexes, foreign keys, views, and stored procedures are also implemented. Future releases (2.0 and above) will support a multi-node database concept with log file shipping for an automatic database application failover.
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.
PM Report is a PHP/MySQL report generator. It creates customizable reports and is very simple to setup and use. You can select which database, table, and individual fields to use on your report. You can also select the order in which the fields should appear on the report, the field you would like to group by, the field you would like to sort by, and whether or not you would like a total for each column. Once the report has been generated, you can highlight individual rows and export the results to CSV.
DB Solo is a powerful database development and management tool for developers and DBAs. It has an intuitive user interface that allows you to explore and manage your database objects as well as execute ad-hoc queries. It supports Oracle, MySQL, Sybase, DB2, Solid, PostgreSQL, and MS SQL Server. In addition to viewing and managing objects such as schemas, tables, indexes, views, tablespaces, users, roles, sessions, and stored procedures, you can view, edit, print, and export data from tables or the results of queries. You can also graphically view foreign key relationships.
SQLiteManager is a multilingual Web-based tool to manage SQLite databases. It features multiple database management, creation, and connectivity, property and options management, table, data, and index manipulation, the ability to import data from a file, conversion from MySQL queries, view, trigger, and custom function management, and exporting of database structure and data.
Compiere is an integrated ERP and CRM business solution for automating financial, distribution, sales, and service processes, including: financial management, purchasing, materials management, manufacturing, order management, project accounting, customer management, sales, service requests, ecommerce, reporting, and performance management. Compiere utilizes a powerful model-driven application platform that provides customers with unprecedented adaptability, rapid deployment, and low cost of ownership.