PostgreSQL
PostgreSQL is a robust relational database system with more than 20 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 | Database Database Engines/Servers |
|---|---|
| Licenses | BSD Revised |
| Operating Systems | Linux FreeBSD OpenBSD Solaris HP-UX AIX Windows |
| Implementation | SQL |
| Translations | Japanese German Spanish Portuguese Russian French |
Recent releases
- 01 Jul 2009 19:49
Changes: Parallel Database Restore, speeding up recovery from backup up to 8 times. Per-Column Permissions, allowing more granular control of sensitive data. Per-database Collation Support, making PostgreSQL more useful in multi-lingual environments. In-place Upgrades through pg_migrator (beta), enabling upgrades from 8.3 to 8.4 without extensive downtime. New Query Monitoring Tools, giving administrators more insight into query activity. Greatly reduced VACUUM overhead through the Visibility Map. New monitoring tools for current queries, query load, and deadlocks.
- 03 Apr 2009 18:32
Changes: This release prevents error recursion crashes when encoding conversion fails, disallows CREATE CONVERSION with the wrong encodings for the specified conversion function, and fixes xpath() to not modify the path expression unless necessary, and to make a saner attempt at it when necessary.
- 16 Jun 2008 04:06
Changes: pg_get_ruledef() now parenthesizes negative constants. ALTER AGGREGATE ... OWNER TO was made to update pg_shdepend.
- 30 Apr 2007 07:30
Changes: A privilege escalation exploit in SECURITY DEFINER functions was patched.
- 29 Jun 2006 13:18
Changes: The server has been changed to reject invalidly-encoded multi-byte characters in all cases. This release rejects unsafe uses of \' in string literals. libpq's string-escaping routines have been modified to be aware of encoding considerations and standard_conforming_strings.
- All comments
Recent commentsjberkus: Are they hurting something?
Thanks,
Jeff
Can we please purge the 7-year-old comments?
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).
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)
"Object" Relational?
Why do they call it "Object" relational? Where is the "object" part?