Best of Database — January 2024
- 1
- 2
MotherDuck·2y
Why you should learn SQL in 2024
SQL is a valuable and marketable skill that every organization needs. It is essential for manipulating and analyzing data stored in databases. SQL is a portable skill that can be used across different databases and data tools. Learning SQL is made easier with DuckDB and MotherDuck.
- 3
- 4
Medium·2y
Why UUID7 is better than UUID4 as clustered index
This post discusses the differences between UUID version 4 and UUID version 7 as clustered indexes in a database. It explores the pros and cons of using UUIDs instead of sequential IDs and explains why UUID version 7 was faster than UUID version 4. The experiments and results are presented, along with an explanation of index locality and buffer pool in relation to the performance differences.
- 5
Hacker News·2y
vanna-ai/vanna: 🤖 Chat with your SQL database 📊. Accurate Text-to-SQL Generation via LLMs using RAG 🔄.
Vanna is an open-source Python framework for SQL generation using RAG. It allows users to train a model and ask questions to generate SQL queries for their database. The framework provides high accuracy, security, self-learning capabilities, and supports any SQL database. Users can also extend Vanna to use their own LLM or vector database.
- 6
Community Picks·2y
1 billion rows challenge in PostgreSQL and ClickHouse
This post discusses the process of ordering 1 billion rows in Java using PostgreSQL and ClickHouse. It covers generating the data, setting up local databases, loading the data, running queries, and comparing the results. The post highlights the faster performance of ClickHouse compared to PostgreSQL for querying directly from a CSV file.
- 7
SQL Shack·2y
Difference between SQL SELECT UNIQUE and SELECT DISTINCT
Learn about the difference between SQL SELECT UNIQUE and SELECT DISTINCT, the use of UNIQUE constraint, and the syntax for executing these statements in Oracle. Both statements are used to fetch unique values from a column that may have duplicate values.
- 8
Supabase·2y
Getting started with Laravel and Postgres
Learn how to get started with Laravel and Postgres using Supabase as an alternative to Heroku. Set up a new Laravel application, install the authentication template, configure the Postgres connection details, run database migrations, and start the app.
- 9
Refactoring a monolith into microservices
This post is part of a series on designing, building, and deploying microservices. It focuses on the process of refactoring a monolithic application into microservices using domain-driven design and various decoupling strategies. It also discusses the challenges and considerations for managing a monolithic database, handling distributed transactions, and implementing interservice communication.
- 10
- 11
- 12
gitconnected·2y
Mastering SQL Fundamentals
This post provides a comprehensive guide to mastering SQL fundamentals, covering database terminology, relational models, applying SQL to real data, creating a new schema in MySQL, querying data using the SELECT statement, filtering data using the WHERE clause, ordering results using the ORDER BY clause, using logical and special operators, and understanding the importance of query efficiency. Mastery of SQL is emphasized as a valuable skill for data professionals.
- 13
freeCodeCamp·2y
ACID Databases – Atomicity, Consistency, Isolation & Durability Explained
Learn about ACID databases and their key properties: atomicity, consistency, isolation, and durability. Understand how transactions work and the guarantees they provide. Explore real-world examples and analogies.
- 14
- 15
The DB, The Lock and The Index
Databases play a crucial role in application performance and data storage. Factors such as relationships, types and schema compatibility, replication and partitioning, storage and retrieval patterns, and purpose of access influence the choice of a database. Locks are used for concurrency control in databases, ensuring data integrity. The b-tree index is a secondary data structure that speeds up data retrieval by a certain condition.
- 16
Theo - t3․gg·2yHow To Pick A Tech Stack In 2024
The specific technologies you pick are not what determines if you succeed or fail. It is more important to build the skills and problem-solving abilities to overcome challenges. Confidence in your chosen technologies is more valuable than the individual implementation details.
- 17
How Cloudflare Was Able to Support 55 Million Requests per Second With Only 15 Postgres Clusters
Cloudflare achieved the ability to support 55 million requests per second using only 15 Postgres clusters. They utilized PgBouncer as a connection pooler to manage Postgres connections, avoided the thundering herd problem, employed high-performance bare metal servers instead of cloud infrastructure, used the TCP Vegas congestion avoidance algorithm for concurrency management, ordered queries at the PgBouncer layer, and ensured high availability with the Stolon cluster manager.
- 18
- 19
- 20
PlanetScale·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.
- 21
