Best of MySQL — February 2024

  1. 1
    Article
    Avatar of gcgitconnected·2y

    🐼 Mastering SQL Joins

    This post explores the concept of table joins in SQL, covering different join types such as inner join, left join, and right join. It also discusses how to identify and handle orphan records in a database.

  2. 2
    Article
    Avatar of freekFREEK.DEV·2y

    Is it time to ditch MySQL and PostgreSQL for SQLite?

    Evaluate the potential of SQLite as a replacement for MySQL and PostgreSQL in production web applications.

  3. 3
    Article
    Avatar of itnextITNEXT·2y

    Why UUID7 is better than UUID4 as clustered index in RDBMS

    This post discusses the differences between UUID version 4 and UUID version 7 as clustered indexes in RDBMS. It explores the pros and cons of using UUIDs instead of sequential IDs and explains why UUID v7 was faster than UUID v4.

  4. 4
    Article
    Avatar of eversqlEverSQL·2y

    SQL Optimization: a comprehensive developer’s guide

    This post provides a comprehensive guide on optimizing SQL queries. It covers topics such as optimizing SELECT, INSERT, and DELETE SQL queries and provides tips on using indexes, improving joins, filtering, and more. The post also introduces EverSQL by Aiven, a tool that can provide performance insights and SQL optimization suggestions.

  5. 5
    Article
    Avatar of communityCommunity Picks·2y

    How Zapier Automates Billions of Tasks

    Learn about Zapier's architecture, tech stack, and scalability in automating billions of tasks.

  6. 6
    Article
    Avatar of planetpythonPlanet Python·2y

    Python SQL Database Connection Guide

    Learn how to connect Python with an SQL database and perform various operations. This tutorial covers installing the database library, establishing a connection, executing queries, fetching results, committing changes, and closing the connection. It also provides examples of common database operations such as creating a database, creating tables, inserting data, selecting data, updating data, joining tables, using aggregate functions, deleting tables, and deleting databases.

See all MySQL archives