Aisha Bukar in Databases The key syntax differences between MySQL and PostgreSQL – everything you should know Migrating from MySQL to PostgreSQL? Learn the key SQL syntax differences - identifier quoting, auto-increment, LIMIT vs FETCH FIRST, and... 26 October 2026 19 min read
Lukas Vileikis in MySQL How to make database schema changes without downtime in MySQL: complete guide Learn how to make MySQL schema changes without downtime. Compare online DDL, Percona Toolkit, and gh-ost to keep your database... 12 October 2026 6 min read 3
Lukas Vileikis in AI What really happens when you let AI design your database schema (everything you should know) AI can write SQL, but can it design your database schema? Learn why LLMs get databases wrong — and how... 02 October 2026 12 min read 11
Lukas Vileikis in Databases The one big difference between MySQL and MariaDB you may have overlooked What's the one big difference between MySQL and MariaDB? Learn what the difference is, why it's important, and what's best... 22 September 2026 9 min read 2
Chisom Kanu in Cloud What is cloud database vendor lock-in? The 3 types explained (and how to audit yours) Cloud database lock-in takes three forms: engine, feature, and operational. Learn which type you're accumulating, and what it would actually... 27 August 2026 12 min read 11
Aisha Bukar in Databases MySQL vs PostgreSQL: spatial data types, functions, and migration pitfalls explained MySQL and PostgreSQL both support spatial data, but work very differently. This guide breaks down types, indexing, functions, and key... 05 August 2026 15 min read 21
Lukas Vileikis in MySQL Comparing MySQL Enterprise Monitor with Oracle Enterprise Manager for MySQL – which is best? Comparing MySQL Enterprise Monitor and Oracle Enterprise Manager for MySQL to determine which is best for you. Covers features, scalability,... 23 July 2026 6 min read 1
Grant Fritchey in Databases I let Copilot build my database. Here’s what I learned – and everything I’d do differently next time (part two) What happens when Microsoft Copilot designs a PostgreSQL schema for Azure? Here's what it got right, what it got wrong,... 29 June 2026 23 min read 1
Aisha Bukar in Databases The complete guide to XML support in MySQL and PostgreSQL Discover how MySQL and PostgreSQL differ in XML storage, validation, and querying, and why these differences matter for enterprise apps... 24 June 2026 15 min read
Chisom Kanu in Databases It’s 2026. Why are databases still failing GDPR compliance audits? GDPR erasure failures are often database engineering problems, not legal ones. Learn how relational schema design, backup retention, and audit... 11 June 2026 13 min read 1
Lukas Vileikis in Databases Why COALESCE might be the most useful SQL function you’re not using right Learn how the SQL COALESCE function works, with practical examples for handling NULL values, setting defaults, and writing cleaner, more... 07 May 2026 7 min read 31
Simple Talk Editor in Databases What are the top database platforms in 2026? A look at the latest data The top database platforms in 2026 by revenue and popularity - AWS, Microsoft, Oracle and Google leading; MongoDB, Snowflake, Databricks... 28 April 2026 7 min read 4
Lukas Vileikis in Security, Privacy & Compliance How to secure MySQL and PostgreSQL in the world of AI Learn how AI is transforming database security and discover best practices to secure MySQL and PostgreSQL against AI-driven threats, faster... 04 March 2026 11 min read 11
Lukas Vileikis in MySQL How to safely use MySQL 8.0 post end-of-life (and alternatives to consider) MySQL 8.0 reaches End of Life in April 2026. Learn the risks, upgrade paths, migration options, and how to stay... 18 February 2026 5 min read 11
Lukas Vileikis in Databases Making AI Talk to Your Database: AI-Powered Database Queries Made Simple Learn how AI-driven tools bridge the gap between human language and databases, making data access faster, easier, and more intuitive.… 04 December 2025 9 min read 42
Aisha Bukar in Databases MySQL vs PostgreSQL: JSON Data Types MySQL and PostgreSQL both support JSON, but they handle it in very different ways. This article compares their JSON data... 02 December 2025 22 min read 21
Lee Asher in Databases 5 Strategies to Refactor SQL Code Struggling with messy SQL queries? Discover 5 smart refactoring strategies to clean up your code, boost performance, and simplify maintenance.… 12 November 2025 16 min read 731
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 6 – Backups and Recovery Procedures) Learn how to automate MySQL performance tuning using MySQL Shell. Discover intelligent backup and recovery strategies, configuration tracking, and optimization... 18 August 2025 18 min read 1
Lukas Vileikis in MySQL MySQL PRIMARY KEY Indexes: The Clustered Index How PRIMARY KEY indexes work in MySQL and InnoDB: the rules, why the primary key is the clustered index, strings... 15 August 2025 15 min read
Mercy Bassey in MySQL Replicating MySQL databases in Docker Containers In my prior article, “Running a relational database with Docker”, I showed how to spin up a Docker container with... 13 June 2025 10 min read 1
