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

This post's contentOverviewPros of using an ORM frameworkPros of using Native SQL/JDBCORM frameworks creators?Java ORM Frameworks overviewJPAHibernate vs JPA?Spring Data JPA vs JPA?JDO vs JPA?HibernateAdvantages of using Java HibernateDisadvantages of using Java HibernateCompanies and projects that use HibernateHibernate alternatives for Java based developers Methods to speed up slow Hibernate based applicationsSpring Data JPASpring Data JPA FeaturesMyBatisAdvantages… 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

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

This post's contentGoogle Developers: Machine Learning Crash CourseThe SaaS CTO Security ChecklistAI-based Database Expert for PostgreSQL/MySQLAmazon Web Services In Plain EnglishNoSQL Databases: a Survey and Decision GuidanceJavaScript - The Right WayComparing Git Workflows: What You Should KnowA reference guide for fintech & small-data engineeringWhat Is DevOps?Evolutionary Database DesignAwesome CTO repository on GitHub Guest post by… Continue reading How I became a better CTO using these 8 resources

Adobe Commerce Cloud Performance Optimization

This post's contentAdobe Commerce Cloud Performance overviewTools for optimizing Adobe CommerceEverSQLAdobe Performance Monitoring ToolsAdobe Commerce Cloud Performance Alerts 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… Continue reading Adobe Commerce Cloud Performance Optimization

Common pitfalls when migrating MySQL to Aurora using AWS DMS

2 Comments

This post's contentPotential solutions for migrating RDS MySQL to Aurora MySQLMy expectations from the migration using AWS DMSPitfalls when using AWS DMS to migrate MySQL to AuroraHow to correctly migrate the schema from MySQL to Aurora? We recently migrated some of EverSQL's workload from AWS RDS MySQL to Aurora MySQL. In this post I'll share… Continue reading Common pitfalls when migrating MySQL to Aurora using AWS DMS

Choosing the best indexes for PostgreSQL query optimization

This post's contentHow to find existing indexes in PostgreSQL?Does the order of the WHERE clause matter?What is a composite index?Composite indexes vs Separate indexesANALYZE? How do I make sure that PostgreSQL has the updated stats on my table size?Does PostgreSQL allow two identical indexes on the same table?Does PostgreSQL know to use more than one… 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.

1 Comment

This post's contentThe challengeThe solutionIncrease innodb_online_alter_log_max_sizePostpone DML operationsDo not use AFTER when adding a new columnPartitioning?External tools? 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.… 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.

The complete PostgreSQL Index Advisor guide [Online]

This post's contentWhat is an Index?How to create a PostgreSQL IndexHow does the Online PostgreSQL Index Advisor work?FAQDo I need to provide my database credentials to work with the Index Advisor?Does the Index Advisor provide the commands to create the missing indexes?How to maintain indexes?How to list all PostgreSQL Indexes?How to list all on Indexes… Continue reading The complete PostgreSQL Index Advisor guide [Online]

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

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