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… Continue reading Aiven acquires EverSQL 🎉
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… Continue reading Resolving ServiceNow Performance Issues
How I fixed my Slow PostgreSQL and made it faster: In this post I will share our experience in making PostgreSQL faster and will provide actionable tips you can use to make your PostgreSQL much faster, while reducing cost.We will focus on PostgreSQL 15 but the article is good for earlier versions of PG. PostgreSQL… Continue reading Postgresql SQL optimization [2023 edition]
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… Continue reading My Oracle to PostgreSQL Migration: The 7 Tools That Made It Possible
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… Continue reading Secret SQL tool that changed my life
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… Continue reading Unlock the Secrets of MySQL corrupted indexes
Exciting news! We've added new PostgreSQL and MySQL features that will help optimize your database performance and save you money. Check out our latest updates: Reduce your MySQL/PostgreSQL cost Analyze your database and schema to save $$$ by applying these optimizations. EverSQL helps reduce your database monthly cost by providing on-going recommendations such as deletion… Continue reading Cheaper & Faster PostgreSQL/MySQL?
PostgreSQL is one of the most popular databases among developers, with a growing number of companies choosing it as their main relational production database. In 2021 Stack Overflow Developer Survey, PostgreSQL was the fourth most commonly used database among developers, after MySQL, SQL Server, and Oracle. And today, 2023, it is the most popular database… Continue reading Top 7 tips for optimizing and reducing your RDS cost
As a developer, you may have used natural language processing (NLP) and its potential to revolutionize the way we interact with technology. Text-to-SQL tools powered by OpenAI, are a powerful method that can generate SQL statements from natural language text. In this blog post, we will explore seven creative and unusual examples of how to… Continue reading 7 Unusual Uses of Chat-GPT for Text-to-SQL and SQL Queries
Note: The information here is based on a research done on 10,Jan, 2023. Overview ORM stands for "Object-Relational Mapping." It is a technique that allows a Node.js applications to access and manipulate data stored in a database management system (DBMS) using objects. Some popular Node.js / JavaScript ORM frameworks include: Sequelize Prisma Objection.js Mikro ORM… Continue reading 7 Best and Worst ORM for Node.js in 2023