Prestogres also offers password-based authentication and SSL. Prestogres uses modified version of pgpool-II to rewrite queries before sending them to PostgreSQL. pgpool-II is originally a middleware ...

This app is currently being updated in the v2 branch. This new version is written in Typescript, and follows a set of modern React development standards. PostGUI is a React web application that serves ...

PostgreSQL 16, the next major update of the open source relational database, has arrived in a beta release, highlighted by enhancements in query execution, logical replication, developer experience, ...

MySQL and PostgreSQL are two of the most used open source SQL databases, and both fulfill the role of a general-purpose database well. How do you choose which one to use for a project? Let's look at ...

YugabyteDB 2.13 is a highly scalable, distributed version of PostgreSQL that combines compelling ideas from Google Cloud Spanner and Amazon Aurora—and serves as a Cassandra-compatible database too.

This article was written in collaboration with Bohan Zhang and originally appeared on the OtterTune website. In this article, we’ll dive into MVCC: what it is, how PostgreSQL does it, and why it is ...

Our previous blog article, “The Part of PostgreSQL We Hate the Most,” discussed the problems caused by everyone’s favorite street-strength DBMS multi-version concurrency control (MVCC) implementation.

YugabyteDB has announced a major update to its platform, enhancing compatibility with PostgreSQL 15 features. This development, currently available as a tech preview, offers a significant boost for ...