YouTube·2yLearn SQL Beginner to Advanced in Under 4 Hours
This post provides a comprehensive SQL tutorial, covering everything from setting up the MySQL environment to fundamental and advanced SQL topics. It includes exercises on data selection, querying, data cleaning, and exploratory data analysis, with two practical projects at the end. The tutorial is designed for beginners and progresses to advanced topics such as CTEs and temp tables.
Hussein Nasser·2yThe Internals of a Primary Index
A primary key uniquely identifies a row and is typically indexed for fast access. Primary indexes are often clustered, meaning they store full rows. Secondary indexes only store row identifiers, requiring an additional lookup of the primary key to retrieve full rows. Postgres is an exception as it does not use a real primary clustered index; all indexes, including primary, point to the row identifier or tuple id. The tuple id in Postgres is unique and allows direct row access with minimal I/O.
freeCodeCamp·2yHow to Use Object Relational Mapping in Node.js – Optimize Database Interactions With Sequelize ORM
Databases are crucial for applications, and Object Relational Mapping (ORM) helps streamline their communications. This post explains ORM, its benefits like reduced data manipulation risks and easier database interaction, and demonstrates using Sequelize ORM with a Node.js and MySQL setup. Key steps include setting up a Node.js server, integrating Sequelize, and building a project with CRUD operations. Practical examples are provided to illustrate how ORM improves database management.
Community Picks·2yMySQL vs PostgreSQL (Round 2) Performance Benchmark (Latency - Throughput - Saturation)
Performance comparison between PostgreSQL and MySQL focusing on latency, throughput, and system resource usage. The benchmark simulates an e-commerce website managing customer and order data, with tests for INSERT, UPDATE, DELETE, and SELECT operations. Improvements include optimized settings for both databases and utilizing i3en EC2 instances. PostgreSQL outperforms MySQL in write-heavy operations, while read operations show smaller differences.
Community Picks·2yThe Problem With UUIDs
UUIDs are designed to be universally unique but can negatively impact database performance when used as primary keys, especially in MySQL. The post discusses the various versions of UUIDs and their specific use cases, highlighting potential issues such as insert performance and storage utilization. It also explores alternatives like ordered UUIDs, nano IDs, and snowflake IDs to mitigate these concerns and improve efficiency in distributed systems.
ByteByteGo·2yHow Uber Upgraded Its Petabyte Scale MySQL Fleet to Version 8
Uber upgraded its MySQL infrastructure from version 5.7 to 8.0 in 2023 to mitigate security risks and enhance performance. The upgrade introduced improved indexing, resource utilization, and new functionalities like window functions and better JSON handling. Uber chose a side-by-side upgrade approach to ensure minimal downtime and easier rollback. The upgrade process was automated to manage the complexity and scale of Uber's infrastructure, which includes over 2,100 clusters and 16,000 nodes. The transition brought significant performance improvements, including reduced latency and query execution time.