PostgreSQL continues to improve in ways that meet the needs of even the most complex, mission-critical use cases. It also presents certain challenges. The database market continues to be splintered ...

Replication is one of the most popular features used in RDBMS’s today. Replication is used for disaster recovery purposes (i.e. backup or warm stand-by servers), reporting systems where query activity ...

The first thing you'll learn in this PostgreSQL and Java Database Connectivity (JDBC) tutorial is that most developers simply call it Postgres. The two terms are both interchangeable and official. Use ...

When the preliminary design of Ingres, the forerunner to PostgreSQL, was first tested at UC Berkeley, the president of the United States at the time was a man named Richard Nixon and tech pioneers ...

PostgreSQL is a big deal. The most common SQL open source database that you have never heard of, as ZDNet's own Tony Baer called it. Besides being the framework on which a number of commercial ...

Don't be afraid of using your chosen database's command-line client. I might as well say this up front: I don't like using GUI (aka non-command-line or graphical) tools with my databases. This is ...