Best of Data ManagementJanuary 2024

  1. 1
    Article
    Avatar of tigerdataTigerData (Creators of TimescaleDB)·2y

    PostgreSQL vs MySQL: Which to Choose and When

    Comparison of PostgreSQL and MySQL as relational databases. Explore their similarities, strengths, and weaknesses. Learn about their features and decide the right database solution based on your project requirements, scale, and data operations.

  2. 2
    Article
    Avatar of kdnuggetsKDnuggets·2y

    A Step by Step Guide to Reading and Understanding SQL Queries

    Learn how to read and understand complex SQL queries with a step-by-step guide. Understand the general SQL query structure, the final SELECT, the final conditions clause, the final join, and practice reverse order reading.

  3. 3
    Article
    Avatar of planetscalePlanetScale·2y

    Working with geospatial features in MySQL

    This post explores how complex data and geographic features can be represented in MySQL. It covers the spatial data types supported by MySQL, the primary spatial data formats, and common spatial functions used for manipulating and analyzing geographic data in MySQL.