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 TypeORM Waterline And many more Choosing the right ORM for you depends on the programming language being used and the specific needs of the project. Node.js ORM GitHub statistics Information was collected on Jan 10th, 2023 Sta ..read more

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 being used and the specific needs of the project. How to know if you should use ORM framework, or Native SQL (aka SQL) in your code? The choice between using an object-relational mapping (ORM) framework and native SQL will depend on the ..read more

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 the organization, and the preferences of the developers and their past experience. Without further ado, let's look into the results: So what can we learn from these results? After 48,788 votes there is a new queen in town! The most popular database is now ..read more

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 technologies you’re dealing with. Here are a few resources I wish I had when I started my position as CTO:   Google Developers: Machine Learning Crash Course For all you CTOs looking to get into ML, Google offers a great crash course on Machine Learning. It consists of 25 lessons, 30+ exercises, real case studi ..read more

Guest author: Anshuman Ravi 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 extension providers along with Adobe commerce official extension marketplace. With all those out-of-the-box features, Adobe commerce core package has turned out to be a monolithic application, if not set up properly, merchants using Adobe commerce often face performa ..read more

We recently migrated some of EverSQL's workload from AWS RDS MySQL to Aurora MySQL. In this post I'll share several options I explored, and the issues I ran into when using each of them, and specifically AWS DMS, so hopefully you could avoid similar issues when going through the migration process. Potential solutions for migrating RDS MySQL to Aurora MySQL Naturally, I first started with AWS's documentation, which states you can migrate RDS MySQL to Aurora MySQL by creating an Aurora read replicate and promoting it after replication is done. Unfortunately, that solution wasn't viable in our ca ..read more

  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 indexes in PostgreSQL? Unlike other databases, PostgreSQL doesn't have the 'SHOW INDEXES' command. However, You can select a list of all your PostgreSQL Indexes using this command: SELECT tablename,indexname,indexdef FROM pg_indexes WHERE schemaname = 'pu ..read more

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 execute the ALTER statement with the INPLACE flag (unless it's eligible for INSTANT alter, though that's not always the case). this means that the database is using a temporary log (size of innodb_online_alter_log_max_size) which is by default 128MB in most recent ..read more

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 just tablets. It is the lifeline of those business, whether it is a grocery, fuel, hospitality business, butchery, or Walmart. And behind the scenes a large number of transactions connect to inventory, card readers, clearing, payment, ERP, loyalty, barcode labeling, employment performance, and more ..read more

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 or more columns of a database table, enabling orderly access to random records as well as rapid random lookups. Important: Don't just index everything! It's important to use indexes wisely, since they add overhead to the system as a whole. When adding an index the SELECT query might b ..read more