Ok you got a database, how do you optimize SQL performances? To answer this question you need a lot of time and effort in order to understand workloads and performance patterns, evaluate degradation and apply corrective measures. However there are standard practices that you can implement to improve performances. This SQL optimization guide will showcase some best practices that apply across almost every database and can be a good starting point to optimize your database workloads. For a better understanding of your performance patterns and SQL optimization opportunities, you can always rely ..read more

While counting is common in every application, sometimes it is not enough: when we need to display the amount of unique users generating traffic in our website or provide the number of disparate items included in an order we need to apply a distinct count. Compared to a classical count, the distinct one is usually slower since it needs to perform two actions: list the unique field values and then count them. This blog showcases several different methods to speed up COUNT(DISTINCT) SQL queries and provides a programmatic approach to delve into and solve the problem. A more detailed image of the ..read more

In modern application development, we often abstract direct access to the database layer from the application layer using an ORM. This allows us to worry less about exactly how the data is retrieved using SQL, and more about writing our application. That said: there are scenarios where it’s useful to examine and optimize the underlying SQL. In this blog, we’ll use Prisma, a Javascript ORM, and we’ll optimize the Prisma raw queries SQL generated using EverSQL.  Why should we care about the raw SQL Prisma produces? Most of the time, Prisma does a good job at generating the SQL necessary to ..read more

When building an application, usually we query our database to retrieve the things we already know: what orders a client made or, more generally, what steps in the app flow have already been taken. However, to correctly address the user journey, it is often more important to query the database and retrieve data that informs us about what is missing: an item not yet in the basket, a missing email confirmation, or a pending payment. Understanding and addressing these missing steps is crucial to optimize the user experience and to drive app adoption. The blog post showcases how to express such “m ..read more

By Oded Valin and Tomer Shay We are thrilled to share that we are joining Aiven, the leading open source cloud data platform. This is an exciting milestone in the EverSQL journey. From our early days spent in a coffee shop conceptualizing how we could solve the real-world challenge of database optimization to free up engineers, we’ve come a long way. Today, EverSQL is used by more than 100,000 software engineers worldwide. And now, we're getting started in the next phase of our journey. Tomer Shay and Oded Valin, EverSQL's founders We, Tomer and Oded, had the unique opportunity to work closel ..read more

This is not a "which database is the best in 2023" article. I don't think that's a simple question to answer. In this article, we'll take a look at different stats and signals that indicate that PostgreSQL is gaining significant popularity, and is taking the lead from other relational databases such as MySQL. DB ranking in the last 10 years Looking at the last 10 years in db-engines, it's clear that PostgreSQL is on the rise, while MySQL is stagnating, or even in slight decline. PostgreSQL is gaining popularity among both startups and large enterprises. PostgreSQL crowned by StackOverflow Surv ..read more

As the CTO of a major telco company in the US, managing our IT infrastructure is a crucial part of my daily responsibilities. ServiceNow, with its vast array of tools, has become essential to our operations. However, performance issues started to surface, especially with our dashboards. In this post, I'll share our journey, including not only external tools like EverSQL but also internal ServiceNow configurations and built-in tools that helped us overcome these challenges. The Problem: Slow Dashboards and Growing Frustration Slow dashboard loading times were impacting our efficiency. Waiting t ..read more

I have a confession to make: I'm a huge fan of Oracle. I absolutely adore the company and its technology. Admittedly, I'm not fond of their pricing practices, but overall, they offer excellent products. As an Oracle DBA for a major energy infrastructure company in California, I've spent years mastering Oracle databases. However, a recent decision from our executive team prompted a transition to PostgreSQL. This shift transformed me from an experienced Oracle DBA into a newcomer in the world of PostgreSQL. Having navigated through this migration, I feel compelled to share the insights I've gai ..read more

TLDR: Are you a software engineer or a data analyst? Do you need to review other people's SQL queries? This SQL to Plain English free tool can be life-changing for you.   As a software engineer, I know how daunting it can be to work with complex SQL queries. Spending hours trying to understand what a query does, only to realize you still don't fully comprehend it, can be frustrating. That's why I was thrilled to discover TextToSQL, a free tool that generates a one-line English sentence describing what a complex SQL query does. With TextToSQL, I could easily analyze SQL queries and unders ..read more

One of our customers recently had a Corrupted Index that affected the health of his database and caused latency for his customers. To identify and handle a corrupted index in MySQL, here are some common FAQs: What is a MySQL corrupted index? A MySQL corrupted index refers to a situation where the index data within a MySQL database becomes inconsistent or damaged, resulting in incorrect or incomplete query results. It can occur due to various reasons, such as hardware failures, software bugs, improper shutdowns, or disk errors. What are the common symptoms of a MySQL corrupted index? When a MyS ..read more