PostgreSQL - Powerful, Open Source Object-Relational Database System

  •        0

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It has native programming interfaces for most of the programming language.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance.



Related Projects

PostGIS - Spatial and Geographic objects for PostgreSQL

PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL. PostGIS adds extra types (geometry, geography, raster and others) to the PostgreSQL database. It also adds functions, operators, and index enhancements that apply to these spatial types.

PipelineDB - The Streaming SQL Database

An open-source relational database that runs SQL queries continuously on streams, incrementally storing results in tables. PipelineDB stores only the output of continuous queries, which are incrementally updated as data is ingested. The database’s size is independent of the amount of data ingested over time. It is built into the PostgreSQL core and can be used as a drop in replacement for PostgreSQL without making any application code changes.

Kallax - PostgreSQL typesafe ORM for the Go language

Kallax is a PostgreSQL typesafe ORM for the Go language. It aims to provide a way of programmatically write queries and interact with a PostgreSQL database without having to write a single line of SQL, use strings to refer to columns and use values of any type in queries.


Java DB is Sun's supported distribution of the open source Apache Derby 100% Java technology database. It is fully transactional, secure, easy-to-use, standards-based — SQL, JDBC API, and Java EE — yet small, only 2.5 MB.

npgsql - Npgsql is the .NET data provider for PostgreSQL.

Npgsql is a .NET data provider for PostgreSQL. It allows you to connect and interact with PostgreSQL server using .NET.For any additional information, please visit the Npgsql website at

postgres-useful-sql - Useful SQL queries for PostgreSQL, in a single database schema.

Useful SQL queries for PostgreSQL, in a single database schema.

JavaScript SQL (JSSQL)

A database engine entirely in JavaScript (AJAX)

pgAdmin - Administration and development platform for PostgreSQL

pgAdmin is the most popular and feature rich administration and development platform for PostgreSQL. It is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more.

Postgres-XL - Scalable Open Source PostgreSQL-based Database Cluster

Postgres-XL is a horizontally scalable open source SQL database cluster, flexible enough to handle varying database workloads like OLTP, Business Intelligence requiring MPP parallelism, Key value store, GIS Geospatial and lot more.

pgweb - Cross-platform client for PostgreSQL databases

Web-based PostgreSQL database browser written in Go.Pgweb is a web-based database browser for PostgreSQL, written in Go and works on OSX, Linux and Windows machines. Main idea behind using Go for backend development is to utilize ability of the compiler to produce zero-dependency binaries for multiple platforms. Pgweb was created as an attempt to build very simple and portable application to work with local or remote PostgreSQL databases.

rust-postgres - Native PostgreSQL driver for the Rust programming language

A native PostgreSQL driver for Rust.Rust-Postgres is a pure-Rust frontend for the popular PostgreSQL database.

pq - Pure Go Postgres driver for database/sql

For detailed documentation and basic usage examples, please see the package documentation at test is used for testing. A running PostgreSQL server is required, with the ability to log in. The default database to connect to test with is "pqgotest," but it can be overridden using environment variables.

Hibernate - Relational Persistence for Java

Hibernate facilitated the storage and retrieval of domain objects via Object/Relational Mapping. Today, Hibernate is a collection of related projects enabling developers to utilize POJO-style domain models in their applications in ways extending well beyond Object/Relational Mapping.

VitsDB - Web based Postgres (PostgreSQL) database management tool (with PHP on the server side)

Web based Postgres (PostgreSQL) database management tool (with PHP on the server side)

mosql - MongoDB to PostgreSQL Streaming Replication

MoSQL imports the contents of your MongoDB database cluster into a PostgreSQL instance, using an oplog tailer to keep the SQL mirror live up-to-date. This lets you run production services against a MongoDB database, and then run offline analytics or reporting using the full power of SQL.

puppetlabs-postgresql - Puppet module for managing PostgreSQL

The postgresql module allows you to manage PostgreSQL databases with Puppet.PostgreSQL is a high-performance, free, open-source relational database server. The postgresql module allows you to manage packages, services, databases, users, and common security settings in PostgreSQL.

Npgsql.EntityFrameworkCore.PostgreSQL - Entity Framework Core provider for PostgreSQL

Npgsql.EntityFrameworkCore.PostgreSQL is an Entity Framework Core provider built on top of Npgsql. It allows you to use the EF Core O/RM with PostreSQL.Documentation is available on the Npgsql site.

susie - A proprietary relational database architecture in PostgreSQL

A proprietary relational database architecture in PostgreSQL