This project provides a minimal extension for PHP's PDO (PHP Data Objects) class. It is designed for ease-of-use and reducing development time and effort. This is achived by providing methods - delete, insert, select, and update - for quickly building common SQL statements, handling exceptions when SQL errors are produced, and automatically returning results and number of affected rows for the appropriate SQL statement types.
Job-Machine is a small, but versatile system for sending jobs to a message queue and, if necessary, communicating answers back to the sender. Job::Machine uses LISTEN / NOTIFY from PostgreSQL to send signals between clients and workers. This ensures very efficient message passing, giving any worker that is awake the chance to start working immediately.
HTSQL a high-level query language and Web service gateway for relational databases. It comes with source code and is royalty free for any use with open source database systems such as MySQL, PostgreSQL, SQLite, etc. Licenses for using HTSQL in conjunction with proprietary databases such as Microsoft SQL and Oracle can be purchased.
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.
Collectables Database is a simple, easy-to-use application for using the control and data management capabilities of Postgres to catalog various kinds of collections. It delivers content in a format that is easy to use and manipulate within the convenience of a modern Web browser. The initial focus of the application is on cataloging a comic book collection. Collectables Database can run from a hosted Web server or on the user's local machine through the use of a virtual appliance.
pgmp is a PostgreSQL extension module that adds support for the arbitrary precision data types offered by the GMP library. It provides higher performance arithmetic for numbers, only limited by the 1GB varlena maximum size, a rational data type for absolute precision storage and arithmetic, and specialized functions to deal with prime numbers, random numbers, and factorization. The GMP data types can be used in mixed arithmetic with other PostgreSQL numeric types and indexed using the btree or hash methods. The extension is compatible with PostgreSQL 8.4 and later, and the package includes comprehensive documentation and regression tests.
Pyrseas provides a framework and utilities to upgrade and maintain a relational database. It currently includes the dbtoyaml utility to create a YAML description of a PostgreSQL database's tables, and the yamltodb utility to generate SQL statements to modify a database to match an input YAML specification. It also aims to develop data administration tools to supplement an agile database development process.
Fathom is Python3 package that provides database inspection. It allows you to easily retrieve information about database schema for Sqlite3, PostgreSQL, MySQL, and Oracle. Fathom comes with a set of tools built upon the library, which allow you to create django models from database schema or generate entity-relationship diagrams.