Systems | Development | Analytics | API | Testing

Today, we’ll dive into N+1 queries⁠—what they are, how to spot them, why they have such an impact, and how to solve them.

This blog post is part of a series on Cloudera’s Operational Database (OpDB) in CDP. Each post goes into more details about new features and capabilities. Start from the beginning of the series with, Operational Database in CDP. This blog post gives you an overview of the NoSQL, component integration, and object store support capabilities of OpDB.

In today’s post, we’ll learn about Mnesia, see when you would use such a tool, and take a look at some of the pros and cons of using it. After covering the fundamentals of Mnesia, we’ll dive right into a sample application where we’ll build an Elixir application that uses Mnesia as its database. Let’s jump right in!

Bonus Material: PostgreSQL vs MySQL complete comparison table ‍ PostgreSQL (or Postgres) and MySQL are both relational database management systems (RDBMS for short). They are complex technological inventions designed to simplify your data operations across a wide variety of business use cases. The “relational” part of the name refers to the way in which they structure data as relations between rows and columns.

Today’s release of Node.js integration supports PostgreSQL as well as all the consumers of the pg library.

Apache HBase became a top-level project with Apache 10 years ago and Cloudera began contributing to it at the same time (2010). Over this time, it has become one of the largest and most popular open-source tools in big data and one of the most popular NoSQL databases.

This blog post is part of a series on Cloudera’s Operational Database (OpDB) in CDP. Each post goes into more details about new features and capabilities. Start from the beginning of the series with, Operational Database in CDP. This blog post gives you an overview of the languages, frameworks, and applications supported by Cloudera’s OpDB.

With so many SQL tutorials available online, it’s easy to get confused about SQL server best practices. Start with the following five suggestions so you can add security to your server while optimizing its performance.

This blog post is part of a series on Cloudera’s Operational Database (OpDB) in CDP. Each post goes into more details about new features and capabilities. Start from the beginning of the series with, Operational Database in CDP. This blog post gives you an overview of the high availability configuration capabilities of Cloudera’s OpDB. Cloudera’s Operational Database (OpDB) is a cluster-based software, which comes configured for High Availability (HA) out of the box.

We built Kong to handle any API at any level of scale, but running APIs at scale means storing and managing data at scale. That’s why we’ve always recommended Apache Cassandra for the biggest Kong deployments. Cassandra is powerful and proven, but it does require some skill to install and operate – which is why we’re excited to hear that Datastax is making Cassandra easy to use at any level of scale with DataStax Astra, a Database-as-a-Service built on Apache Cassandra.