PostgreSQL Connection Pooling: Part 4 – PgBouncer vs. Pgpool-II

Posted: July 29, 2020

In our previous posts in this series, we spoke at length about using PgBouncer and Pgpool-II, the connection pool architecture and pros and cons of leveraging one for your PostgreSQL deployment. In our final post, we will put them head-to-head in a detailed feature comparison and compare the...

Read Article

Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL

Posted: July 17, 2020

JSON stands for JavaScript Object Notation. It is an open standard format which organizes data into key/value pairs and arrays detailed in RFC 7159. JSON is the most common format used by web services to exchange data, store documents, unstructured data, etc. In this post, we are going to show you...

Read Article

PostgreSQL vs. Oracle: Difference in Costs, Ease of Use & Functionality

Posted: July 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since...

Read Article

ScaleGrid DigitalOcean Support for MySQL, PostgreSQL and Redis™ Now Available

Posted: June 9, 2020

PALO ALTO, Calif., June 9, 2020 – ScaleGrid, a leading Database-as-a-Service (DBaaS) provider, has just announced support for their MySQL, PostgreSQL and Redis™ solutions on DigitalOcean. This launch is in addition to their current DigitalOcean offering for MongoDB® database, the only DBaaS to...

Read Article

Comparing PostgreSQL DigitalOcean Performance & Pricing – ScaleGrid vs. DigitalOcean Managed Databases

Posted: June 4, 2020

DigitalOcean is a cost-effective cloud provider that caters to, and is widely adopted by the developer community. ScaleGrid is a fully managed DBaaS that supports MySQL, PostgreSQL and Redis™, along with additional support for MongoDB® database and Greenplum® database. Along with many popular...

Read Article

PostgreSQL Connection Pooling: Part 3 – Pgpool-II

Posted: March 23, 2020

In our previous posts in this series, we discussed the case for connection pooling and introduced PgBouncer. In this post, we will discuss its most popular alternative - Pgpool-II. Pgpool-II is the swiss army knife of PostgreSQL middleware. It supports high-availability, provides automated load...

Read Article

PostgreSQL Connection Pooling: Part 2 – PgBouncer

Posted: December 19, 2019

When it comes to connection pooling in the PostgreSQL world, PgBouncer is probably the most popular option. It's a very simple utility that does exactly one thing - it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. A client connects to...

Read Article

Making it Easier to Manage a Production PostgreSQL Database

Posted: November 12, 2019

The past several years have seen increasing adoption for PostgreSQL. PostgreSQL is an amazing relational database. Feature-wise, it is up there with the best, if not the best. There are many things I love about it - PL/ PG SQL, smart defaults, replication (that actually works out of the box), and...

Read Article

What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni Infographic

Posted: October 31, 2019

Wondering which high availability framework to use for your PostgreSQL deployments? We compared the top 3 frameworks, PostgreSQL Automatic Failover (PAF) vs. Replication Manager (repmgr) vs. Patroni, in our Managing High Availability in PostgreSQL series. In these blogs, we dove deep into how...

Read Article

PostgreSQL Connection Pooling: Part 1 – Pros & Cons

Posted: October 17, 2019

A long time ago, in a galaxy far far away, ‘threads’ were a programming novelty rarely used and seldom trusted. In that environment, the first PostgreSQL developers decided forking a process for each connection to the database is the safest choice. It would be a shame if your database crashed,...

Read Article

Search Results for: PostgreSQL

PostgreSQL Connection Pooling: Part 4 – PgBouncer vs. Pgpool-II

Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL

ScaleGrid DigitalOcean Support for MySQL, PostgreSQL and Redis™ Now Available

Comparing PostgreSQL DigitalOcean Performance & Pricing – ScaleGrid vs. DigitalOcean Managed Databases

PostgreSQL Connection Pooling: Part 3 – Pgpool-II

PostgreSQL Connection Pooling: Part 2 – PgBouncer

Making it Easier to Manage a Production PostgreSQL Database

What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni Infographic

PostgreSQL Connection Pooling: Part 1 – Pros & Cons

Search:

About us:

You may also be interested in

MongoDB

Redis™

MySQL

PostgreSQL

Pricing

About Us

Resources

Terms of Service