Projects / PostgreSQL

PostgreSQL

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.

Tags
Licenses
Operating Systems
Implementation
Translations

Recent releases

  •  12 Sep 2011 14:22

    Release Notes: There are several major new features in this release, including synchronous replication and other replication features, per-column collations, unlogged tables, extensions, K-Nearest-Neighbor indexing, Serializable Snapshot Isolation, Writeable Common Table Expressions, SE-Postgres (Military-grade security), the PostgreSQL Extension Network, and SQL/MED (Management of External Data), with foreign data wrappers for Oracle, MySQL, CouchDB, Redis, CSV, Twitter, and more. There have also been improvements in performance and database administration, and several SQL and PL/PgSQL features.

    •  22 Jun 2011 19:24

      Release Notes: This is a bugfix release that fixes issues with pg_upgrade, non-hot-standby recovery, deadlock issues with catalog cache initialization, updates to time zone data files, and several other minor bugs.

      •  20 Sep 2010 18:30

        Release Notes: Built-in replication based on log shipping. Easier database object permissions management. pg_upgrade to support in-place upgrades. Multiple performance enhancements for specific types of queries. Full support for 64-bit Windows.

        •  14 Dec 2009 18:39

          Release Notes: This is a security release, plus 48 minor bugfixes.

          •  09 Sep 2009 13:45

            Release Notes: This is a bugfix release.

            Recent comments

            12 May 2009 01:51 jeffcovey

            jberkus: Are they hurting something?

            Thanks,
            Jeff

            12 May 2009 00:35 jberkus

            Can we please purge the 7-year-old comments?

            28 Feb 2009 17:20 simonbertrang

            Re: "Object" Relational?

            > Why do they call it "Object"
            > relational? Where is the
            > "object" part?

            Because PostgreSQL supports table inheritance.

            You might want to look at the corresponding page in the documentation: Data Definition - Inheritance (http://www.postgresql.org/docs/8.3/static/ddl-inherit.html).

            13 Dec 2007 05:47 brian54

            Re: Nice

            >
            > % Its nice and works really good but
            > % sometimes its really work slow and
            > % thatís create a real problem
            > %
            > % --
            > % Web directory
            >
            >
            >
            > Yes its really very irritating when it
            > work slow but overall its a good
            > project.
            >
            > --
            > Reiki
            >



            Its working fine for me I have got no problems....A great project.


            --

            WOW Gold (http://www.wow-gold-price-list.com)

            18 Jul 2003 04:54 salukisaluki

            "Object" Relational?
            Why do they call it "Object" relational? Where is the "object" part?

            Screenshot

            Project Spotlight

            OpenStack4j

            A Fluent OpenStack client API for Java.

            Screenshot

            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.