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

Redis Transactions & Long-Running Lua Scripts

Posted: July 8, 2020

Redis offers two mechanisms for handling transactions - MULTI/EXEC based transactions and Lua scripts evaluation. Redis Lua scripting is the recommended approach and is fairly popular in usage. Our Redis™ customers who have Lua scripts deployed often report this error - “BUSY Redis is busy...

Read Article

MongoDB Index Builds – Preventing Users From Triggering New Builds

Posted: June 30, 2020

Index builds on MongoDB production clusters need to be handled with the utmost care. We have documented the issues in detail in one of our previous blog posts - The Perils of Building Indexes on MongoDB. Depending on the size of your data, both foreground and background builds can bring your...

Read Article

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

Posted: June 22, 2020

MySQL is the all-time number one open source database in the world, and a staple in RDBMS space. DigitalOcean is quickly building its reputation as the developers cloud by providing an affordable, flexible and easy to use cloud platform for developers to work with. MySQL on DigitalOcean is a...

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

Exploring MySQL Binlog Server – Ripple

Posted: May 22, 2020

MySQL does not limit the number of slaves that you can connect to the master server in a replication topology. However, as the number of slaves increases, they will have a toll on the master resources because the binary logs will need to be served to different slaves working at different speeds. If...

Read Article

What is Greenplum Database? Intro to the Big Data Database

Posted: May 13, 2020

Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL. It can scale towards a multi-petabyte level data workload without a single issue, and it allows access to a cluster of powerful servers that will work together within a single SQL...

Read Article

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

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

Redis Transactions & Long-Running Lua Scripts

MongoDB Index Builds – Preventing Users From Triggering New Builds

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

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

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

Exploring MySQL Binlog Server – Ripple

What is Greenplum Database? Intro to the Big Data Database

Search:

About us:

You may also be interested in

MongoDB

Redis™

MySQL

PostgreSQL

Pricing

About Us

Resources

Terms of Service