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.
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.
RecDB is a recommendation engine built entirely inside PostgreSQL 9.2. It allows application developers to build recommendation applications using a wide variety of built-in recommendation algorithms such as user-user collaborative filtering, item-item collaborative filtering, and singular value decomposition. Applications powered by RecDB can produce online and flexible personalized recommendations to end-users. It is easily used and configured and allows novice developers to define a variety of recommenders that fits their application's needs in few lines of SQL. It can seamlessly integrate recommendation functionality with traditional database operations.
Galette (Gestionnaire d'Adhérents en Ligne Extrêmement Tarabiscoté mais Tellement Efficace) is a membership management Web application designed for non-profit organizations. A detailled presentation is also available. It allows board members to know which fees will soon reach their due dates. Moreover, each member can review and update his personal information.
PDO4You is a class that implements the Singleton design pattern for connecting the database using the PDO extension (PHP Data Objects). It provides an abstraction layer for accessing data, regardless of which database you are using, and ensures that there is a single object instance per database connection. It can connect to several possible SQL databases using the available PDO drivers. Currently it supports MySQL, PostgreSQL, SQLite, MariaDB, Oracle, Microsoft SQL server, Sybase, and CUBRID (a database highly optimized for Web applications). The class can also execute multiple queries at once given a string in JSON format that specifies the type of query, the tables, fields, field values, conditions, etc.
Uhura is a Web console for databases. It works with MySQL, PostgreSQL, and FirebirdSQL. It presents trees that let you browse databases, tables, columns, constraints, triggers, views, and procs. It has panels for history and fragments. Its editor features autocompletion and autoindenting. It is easy to install.
The YB.ORM library aims to simplify writing C++ code that has to deal with SQL databases. The goal is to provide a convenient interface like SQLAlchemy (Python) or Hibernate (Java). The library itself is cross-platform and supports a variety of SQL dialects: SQLite3, MySQL, Postgres, Oracle, and Firebird. Integration with Boost, Qt4, and wxWidgets is built-in. In a typical usage scenario, you would describe your database schema and table relationships in a simple XML-based format, generate SQL code to populate database schema with tables, generate C++ classes, add application-specific logic to the classes, and use these classes in cooperation with the Session object to query objects from the database, create new or modify/delete existing objects, or link and unlink objects using relations. Simple serialization to XML is supported along with connection pooling.