Lukas Vileikis in Security and 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 53
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 Index Overviews: PRIMARY KEY Indexes Learn how to use PRIMARY KEY indexes in MySQL - a type of B-tree index designed to help a database... 15 August 2025 16 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
Aisha Bukar in MySQL MySQL vs. PostgreSQL: Date and Time Data Types Date and time data types are important because they help track and manage time-based information in databases. This includes things... 03 June 2025 21 min read 1
Mercy Bassey in MySQL Running a MySQL database in a Docker Container Relational databases provide a structured approach for storing and organizing large volumes of data into tables consisting of rows for... 29 May 2025 14 min read 1
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 4 – Optimizing MySQL Performance) Welcome back to our journey of understanding MySQL performance tuning using MySQL Shell. So far, we’ve covered essential topics like... 15 May 2025 17 min read
Lukas Vileikis in MySQL MySQL Index Overviews: Hash Indexes Welcome back to the MySQL indexing series! We’ve already covered the nuances surrounding indexes in MySQL as well as walked... 06 May 2025 14 min read
Aisha Bukar in MySQL MySQL vs PostgreSQL – String Datatypes A very common task in creating a database is to store string data. For example, words, paragraph(s) or even documents.... 20 March 2025 22 min read 2
Aisha Bukar in MySQL MySQL vs. PostgreSQL: Character Sets and Collations When working with strings in a database system, you need to ensure that the data is stored, sorted, and compared... 17 March 2025 18 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 3 – Disk I/O and Storage Optimization) So far, in our previous articles on MySQL optimization, we’ve looked at basic configuration management and memory and CPU tuning... 27 February 2025 15 min read 1
Lukas Vileikis in MySQL MySQL Index Overviews: Descending B-Tree Indexes Most anyone who works with indexes should be familiar with B-tree indexes. These are the most commonly used data structures... 13 February 2025 11 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 2 – Memory and CPU) In the first part of the series article, we introduced MySQL Shell as a tool for managing and optimizing MySQL... 17 January 2025 17 min read 1
Lukas Vileikis in Blogs I Wrote a Book on How You Broke Your Database – Here’s Why You Should Read It This blog introduces the book "Hacking MySQL: Breaking, Optimizing, and Securing MySQL for Your Use Case" by Lukas Vileikis.… 10 January 2025 7 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 1 – Introduction) The database is an important part of any application and setting it up correctly is key to ensuring smooth performance.... 27 December 2024 23 min read
Lukas Vileikis in MySQL MySQL Index Overviews: Clustered B-Tree Indexes If you’re a frequent reader of the Simple-Talk blog, you’re no stranger to indexes as we’ve covered indexes in database... 03 December 2024 10 min read
