7 Unusual Uses of Chat-GPT for Text-to-SQL and SQL Queries

This post's content1. Take my Existing Query and Modify it2. Not only English! Use your own language3. Adding a Filter to an Existing SQL Query4. Provide your Database Schema and Generate a Query 5. Filtering Data by Date Range6. Not just SELECT - Updating Data in a Table7. Generating a SQL Query to Retrieve Data for… Continue reading 7 Unusual Uses of Chat-GPT for Text-to-SQL and SQL Queries

7 Best and Worst ORM for Node.js in 2023

This post's contentOverviewNode.js ORM GitHub statisticsPros of using a Node.js ORM frameworkPros of using Raw/Native SQL with Node.jsORM frameworks creators?Node.js ORM Frameworks overviewSequelizeAdvantages of using Sequelize:Disadvantages of using Sequelize:Companies and projects that use Sequelize:Methods to speed up slow Sequelize based applications PrismaAdvantages of using PrismaDisadvantages of using PrismaCompanies and projects that use PrismaMethods to speed up… Continue reading 7 Best and Worst ORM for Node.js in 2023

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

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.

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.