background preloader

PostgreSQL

Facebook Twitter

PostgreSQL pgbash. FAQ. Additional FAQ Entries on this Wiki Translations of this Document Platform-specific questions Windows users should also read the platform FAQ for Windows.

FAQ

There are FAQs for other platforms too. General Questions What is PostgreSQL? PostgreSQL is pronounced Post-Gres-Q-L. PostgreSQL is an object-relational database system that has the features of traditional proprietary database systems with enhancements to be found in next-generation DBMS systems. PostgreSQL development is performed by a team of mostly volunteer developers spread throughout the world and communicating via the Internet. Postgres is a widely-used nickname for PostgreSQL. Who controls PostgreSQL? If you are looking for a PostgreSQL gatekeeper, central committee, or controlling company, give up --- there isn't one. Who is the PostgreSQL Global Development Group? The "PGDG" is an international, unincorporated association of individuals and companies who have contributed to the PostgreSQL project. Who is the PostgreSQL Core Team? MySQL vs PostgreSQL. MySQL vs PostgreSQL is a decision many must make when approaching open-source relational database management systems.

MySQL vs PostgreSQL

Both are time-proven solutions that compete strongly with proprietary database software. MySQL has long been assumed to be the faster but less full-featured of the two database systems, while PostgreSQL was assumed to be a more densely featured database system often described as an open-source version of Oracle. MySQL has been popular among various software projects because of its speed and ease of use, while PostgreSQL has had a close following from developers who come from an Oracle or SQL Server background.

These assumptions, however, are mostly outdated and incorrect. MySQL has come a long way in adding advanced functionality while PostgreSQL dramatically improved its speed within the last few major releases. [edit] Architecture PostgreSQL is a unified database server with a single storage engine. [edit] Performance [edit] Beginnings [edit] Raw Speed. Database management tools for MySQL, Oracle, SQL Server, DB2, SQL Anywhere, PostgreSQL, SQLite, Firebird and MaxDB by SQL Maestro Group. PostgreSQL: The world's most advanced open source database.

1.12 Visual Tour. The long awaited 1.12 version of pgAdmin III is finally available.

1.12 Visual Tour

We will try to highlight some of the new features which have been added since the last stable release. Connection handling The connection handling has been changed. Previous releases used functions incompatible with IPv6. This part of the code has been updated to allow IPv6 connections. People using pgAdmin on WLAN and other unreliable connections may have suffered from disconnections being poorly handled in pgAdmin. On PostgreSQL 9.0, a new connection parameter is available. pgAdmin uses it to tell which tool uses which connection. Object browser There is big news in the browser. If you take a look at a server's properties, you will see a new group combobox. When you click on the OK button, a new group appears with your server in it.

This folder functionality allows you to group servers by type or use. The browser allowed you to copy from the SQL pane, but not from the properties/statistics/dependencies/dependents tabs. Tomcat, PostgreSQL & OpenJDK on Windows - ReadMe/Tutorial. ACID. Set of properties (atomicity, consistency, isolation, durability) of database transactions intended to guarantee validity even in the event of errors, power failures, etc.

ACID

According to Gray and Reuter, IMS supported ACID transactions as early as 1973 (although the term ACID came later).[3] Characteristics[edit] The characteristics of these four properties as defined by Reuter and Härder are as follows: Atomicity[edit] An example of an atomic transaction is a monetary transfer from bank account A to account B. Consistency[edit] Isolation[edit] Durability[edit] Examples[edit] The following examples further illustrate the ACID properties. CREATE TABLE acidtest (A INTEGER, B INTEGER, CHECK (A + B = 100)); Atomicity[edit] Atomicity is the guarantee that series of database operations in an atomic transaction will either all occur (a successful operation), or none will occur (an unsuccessful operation).

Consistency failure[edit] Isolation failure[edit] Combined, there are four actions: Implementation[edit]