Best of MySQL — January 2025

1. 1
   Article

   PlanetScale·1y

   Database Sharding — PlanetScale

   Sharding is the process of improving database scalability by distributing data across multiple servers, known as shards. This technique is widely used by large companies like Uber and Slack. Effective sharding involves choosing the right sharding strategy and shard key to optimize performance and avoid issues like cross-shard queries. PlanetScale, built on Vitess, provides tools to simplify sharding implementation and management. Additionally, sharding can help with data durability, high availability, and faster backups by using replicas.

   109
2. 2
   Article

   Laravel News·1y

   VS Code database management extension launches v2

   DevDb, a lightweight VS Code extension for database management, has launched version 2.0. This update includes new features like one-click row deletion, easy column value editing, SQL query explanation using MySQL Visual Explain, and more keyboard shortcuts. It supports SQLite, MySQL/MariaDB, PostgreSQL, and Microsoft SQL Server, making it versatile for various developers.

   47

   1
3. 3
   Article

   FREEK.DEV·1y

   SQLite vs. MySQL: What are the differences between MySQL and SQLite?

   Oh Dear is a comprehensive monitoring tool for websites, offering uptime monitoring, SSL certificate checks, broken link detection, and more. It features a developer-friendly API, detailed documentation, and the ability to create public status pages quickly. Readers can follow the author for regular programming tips and receive a monthly PHP-focused newsletter with tips, tutorials, opinions, and packages, particularly emphasizing Laravel.

   11

   1