Java ORM – Hibernate vs Spring Data JPA vs EclipseLink vs JPA vs JDBC

January 6, 2023January 7, 2023

Overview ORM stands for "Object-Relational Mapping." It is a technique that allows a software program to access and manipulate data stored in a database management system (DBMS) using objects. Some popular JAVA ORM frameworks include: Hibernate Spring Data JPA EclipseLink MyBatis And many more Choosing the right ORM for you depends on the programming language… Continue reading Java ORM – Hibernate vs Spring Data JPA vs EclipseLink vs JPA vs JDBC

The most popular database of 2022 will surprise you! And insight #7 impacts your salary

January 2, 2023January 2, 2023

StackOverflow's developers survey results are already in, and the most popular databases for 2022 have been revealed. The survey had 48,788 votes and it is important to highlight that the popularity of different databases can vary depending on a number of factors, such as the type of application being developed, the size and needs of… Continue reading The most popular database of 2022 will surprise you! And insight #7 impacts your salary

How I became a better CTO using these 8 resources

November 16, 2022November 18, 2022

Guest post by Etai Stein As a CTO you constantly have a lot of spinning plates to handle. Whether it’s implementing new technologies or going to the office at night when the CPU is at 100%, one of the key factors of being a successful CTO is having a good grasp on the varieties of… Continue reading How I became a better CTO using these 8 resources

Adobe Commerce Cloud Performance Optimization

September 5, 2022September 7, 2022

Guest author: Anshuman Ravi (Twitter / Github) Adobe Commerce Cloud Performance overview Adobe commerce cloud formerly Magento is a powerful feature packed E-commerce platform. Its core “commerce” package contains almost all standard features for B2c and B2B merchants out of the box, and then on top of it there is a vibrant community of third-party… Continue reading Adobe Commerce Cloud Performance Optimization

Choosing the best indexes for PostgreSQL query optimization

July 31, 2022July 14, 2023

PostgreSQL is extremely popular these days, and we decided to share a few tips on choosing the best indexes for your PostgreSQL implementation. In this article we will explain how to do it manually, but if you prefer to find missing indexes, automatically you can use tools like EverSQL. let's start. How to find existing… Continue reading Choosing the best indexes for PostgreSQL query optimization

[Solved] Aurora MySQL, Innodb and Indexes: Creating index required more than ‘innodb_online_alter_log_max_size’ bytes of modification log. Please try again.

July 10, 2022September 5, 20221 Comment

The challenge If you have a large MySQL table and you're trying to add a new column and index it, you may have ran into this error: Creating index 'Name' required more than 'innodb_online_alter_log_max_size' bytes of modification log. Please try again. So how can you address it? The solution By default, recent MySQL versions will… Continue reading [Solved] Aurora MySQL, Innodb and Indexes: Creating index required more than ‘innodb_online_alter_log_max_size’ bytes of modification log. Please try again.

Slow Point of Sale, Databases and Mark Zuckerberg

July 6, 2022July 1, 2024

This year, we had a chance to work with large Point of Sales (POS) and e-commerce companies who used EverSQL to speed up their applications. Here are our key takeaways: It is much more than just a Point Of Sale - These tablets we see in restaurants, supermarkets or retail chains are much more than… Continue reading Slow Point of Sale, Databases and Mark Zuckerberg

The complete PostgreSQL Index Advisor guide [Online]

June 7, 2022July 16, 2023

What is an Index? A database index is a data structure that speeds up data retrieval operations from a table while requiring additional writes and storage space to maintain. Using an index, you can quickly find data in a database table without having to search every row every time. Indexes can be built from one… Continue reading The complete PostgreSQL Index Advisor guide [Online]

Using Datadog? Now you can auto-optimize PostgreSQL and MySQL queries

March 27, 2022September 5, 2022

EverSQL's optimization capabilities can be integrated with your Datadog's Database Monitoring, to automatically and continuously optimize your SQL queries. You can find EverSQL on Datadog's integrations section. The integration can be implemented manually or automatically by adding the EverSQL Sensor, which utilizes EverSQL's Optimization capabilities, to automatically optimize queries that you found on Datadog's Database… Continue reading Using Datadog? Now you can auto-optimize PostgreSQL and MySQL queries

Top 7 CI/CD tools for PostgreSQL and MySQL databases in 2023

March 1, 2022July 16, 2023

#1 - EverSQL EverSQL provides SQL query optimization and database observability, powered by AI. EversSQL's optimization capabilities can be integrated into your CI workflow, to automatically and contentiously optimize your SQL queries. The integration can be implemented by creating a GitHub action, Jenkins, or any tool that utilizes EverSQL's Optimization API capabilities, to automatically optimize… Continue reading Top 7 CI/CD tools for PostgreSQL and MySQL databases in 2023