Best of SQL — 2025

1
Video
ByteGrad·1y
SQL Tutorial - All 38 Concepts You Need To Know
SQL is a structured query language used to manage and analyze data in databases. Understanding SQL concepts is valuable for both organizations and individual careers. Key SQL concepts include creating and managing databases, tables, and relationships, as well as performing queries to insert, update, delete, and retrieve data. Proper data structuring, using primary and foreign keys, and employing joins are essential for database efficiency. Indexing can optimize queries, and using transactions ensures data consistency. Tools and certifications like those offered by DataCamp can enhance SQL skills.
327
1
2
Article
Jobs·38w
🚨How one tiny SQL query nearly killed our production system 🚨
A production outage caused by a seemingly innocent `SELECT *` query demonstrates how database queries that work fine in development can fail catastrophically at scale. The query pulled 720MB of data from 60,000+ records, causing memory pressure, network bottlenecks, and connection timeouts. The post provides practical solutions including selecting specific columns, implementing pagination, caching hot data, using EXPLAIN plans, monitoring slow queries, and testing with production-scale data.
319
33
3
Article
strongdm·47w
PostgreSQL vs. MySQL: Differences for Tech Leaders & Teams
PostgreSQL excels at complex, write-heavy workloads with advanced SQL features, rich data types like JSONB, and strict ACID compliance, making it ideal for financial systems and analytics. MySQL prioritizes speed and simplicity for read-heavy applications, offering lightweight architecture perfect for web apps, CMSs, and MVPs. PostgreSQL provides superior extensibility, query optimization, and enterprise features, while MySQL delivers faster performance for simple queries and lower resource consumption. The choice depends on workload complexity, data consistency requirements, and scalability needs.
260
11
4
Article
Vlad Mihalcea·26w
Just Use Postgres!
A comprehensive review of Denis Magda's book covering PostgreSQL's capabilities beyond traditional relational features. The 402-page guide explores core database concepts like indexing (B+Tree, hash, partial), transactions, and modern SQL features (CTEs, window functions), then dives into non-relational capabilities including JSON storage and full-text search. The book examines PostgreSQL's extension ecosystem: pgvector for ML/GenAI embeddings, TimescaleDB for time series data, PostGIS for geospatial queries, and pgmq for message queues. Includes performance tuning guidance and discusses when PostgreSQL might not be the right choice.
255
24
5
Article
freeCodeCamp·41w
How to Design Structured Database Systems Using SQL [Full Book]
A comprehensive guide covering database fundamentals, from basic data concepts to designing structured database systems. Explores the DIKW pyramid (Data, Information, Knowledge, Wisdom), database management systems architecture, ACID properties, and various data models including relational databases, NoSQL systems, and Big Data approaches. Includes practical examples using PostgreSQL and covers essential topics like data types, domains, database design principles, and the differences between structured, semi-structured, and unstructured data.
251
2
6
Article
freeCodeCamp·1y
Master Database Management Systems
Learn the essentials of Database Management Systems with an in-depth course from freeCodeCamp.org. The course covers foundational concepts, SQL, database design, and transaction processing using practical examples. It's suitable for exams and technical interviews, equipping students and professionals to efficiently handle data across various applications.
223
7
Article
freeCodeCamp·22w
freeCodeCamp's New Relational Databases Certification is Now Live
freeCodeCamp launched a new Relational Databases certification covering Bash scripting, SQL, and Git. The certification includes interactive lessons, workshops, labs, and quizzes across multiple modules, with five required certification projects. Students must pass a 50-question exam using an open-source exam environment that runs on laptops/desktops. The certification is free and verified, with anti-cheating measures including randomized questions, weekly attempt limits, and manual review. Exams are closed-book and timed, with one attempt per week allowed. The certification replaces portions of the previous Full Stack Developer certification.
195
3
8
Article
Community Picks·1y
Online SQL Playground for MySQL, PostgreSQL, and SQL Server
RunSQL is an online SQL playground designed for learning, testing, and sharing SQL queries for MySQL, PostgreSQL, and SQL Server. Users can easily create and manipulate database schemas using DBML, collaborate on SQL projects, conduct interviews, and create web-based database documentation without needing local database setup. It provides a shared environment tailored for developers and data analysts.
192
6
9
Article
freeCodeCamp·50w
How Attackers Steal Data from Websites (And How to Stop Them)
Web attackers use various methods to steal data including phishing emails, SQL injection, cross-site scripting (XSS), brute force password attacks, malware, man-in-the-middle attacks, outdated software exploitation, and insecure API integrations. Defense strategies include user education, multi-factor authentication, input validation, HTTPS implementation, regular software updates, secure coding practices, and proper API security. The stolen data often ends up on the dark web where it's sold for identity theft and further attacks.
188
1
10
Article
Product Hunt·27w
Reindeer: Cursor for databases
Reindeer is an AI-powered IDE for database work that understands database schemas and generates production-ready SQL queries. It features autocomplete for complex SQL, automatic query fixing, and schema-aware assistance to streamline debugging and query optimization workflows without switching between tools.
167
20
11
Article
Lonely Programmer·44w
How SQL works....
156
3
12
Article
Fabian Letsch·23w
Colleague today: "I wiped all orphans on playground"
A developer humorously shared that they cleaned up orphaned database records (child rows without parent references) in a development environment. The post highlights the amusing out-of-context phrasing that made the team laugh, while explaining the technical concept of orphaned rows that result from incomplete deletion operations.
145
16
13
Video
YouTube·45w
Website Hacking for Beginners | SQL Injection
A beginner-friendly demonstration of SQL injection attacks using a fake banking website. Shows how attackers can bypass login forms by manipulating SQL queries with techniques like '1=1' logic and comment injection (--). Explains the vulnerability occurs when user input isn't properly validated, allowing unauthorized access and potential data theft. Emphasizes this is one of the top three OWASP critical vulnerabilities and mentions advanced tools like Burp Suite and SQLMap for automated attacks.
144
3
14
Article
Zero To Mastery·37w
No lies being told
136
35
15
Article
Tiger's Place·1y
All database ACID isolation levels and race conditions explained
This post provides a comprehensive explanation of database ACID isolation levels and the associated race conditions. It covers isolation levels from weakest to strongest, detailing their characteristics and issues, including dirty reads, non-repeatable reads, write skew, and phantoms. Solutions such as snapshot isolation, two-phase locking (2PL), and Serializable Snapshot Isolation (SSI) are also discussed along with practical examples.
134
2
16
Article
Vlad Mihalcea·1y
Why you should use compact table columns
Using compact table columns can significantly enhance database performance by allowing more records and index entries to be stored in memory, thus speeding up SQL queries. This practice is effectively demonstrated by StackOverflow, which uses a highly efficient schema to serve millions of queries per second with minimal hardware. Tips include using smaller data types for keys and enforcing column length limits for VARCHAR fields.
128
2
17
Article
Community Picks·47w
When to Choose NoSQL Over SQL
Explores when to choose NoSQL over SQL databases from a backend developer's perspective, using practical examples like e-commerce product catalogs and IoT sensor data. Covers real-world trade-offs including schema flexibility, performance considerations, and eventual consistency. Discusses polyglot persistence architectures that combine multiple database technologies for optimal results, emphasizing that the choice depends on specific system requirements rather than one being universally better.
125
6
18
Article
Machine Learning News·1y
How to Use SQL Databases with Python: A Beginner-Friendly Tutorial
Learn how to use SQL databases with Python, focusing on MySQL. This tutorial covers environment setup, connecting to a database, and performing CRUD operations. It provides a step-by-step guide to creating databases, tables, and working with data in MySQL using Python.
122
3
19
Article
Database Daily·1y
Visualizing a SQL query
122
1
20
Article
FREEK.DEV·36w
SQL performance improvements: finding the right queries to fix
A case study from Oh Dear showing how Mattias significantly improved service performance through SQL query optimization. The post focuses on identifying and fixing the right queries to achieve substantial performance gains.
120
21
Article
Hacker News·1y
Anatomy Of A SQL Engine
The post explores the anatomy of a SQL engine, detailing the journey of a query from parsing to result spooling. It outlines key stages such as parsing, binding, plan simplification, join exploration, and plan costing. It highlights DoltHub's approach to SQL engines using row-based execution and explores aspects of parsing, including right and left recursive methods. Further discussions include binding AST nodes, simplifying query plans, exploring join orders, and establishing optimal execution strategies. The post concludes with insights into future improvements in query execution efficiency.
113
1
22
Article
Code Like A Girl·30w
Learning to Be Okay With Not Knowing Everything
The data analytics field requires continuous learning rather than mastery of everything. Success comes from embracing curiosity over certainty, learning in layers rather than all at once, and focusing on relevant skills instead of chasing every trend. The imposter feeling is normal, and even experienced professionals regularly search for answers. Progress matters more than perfection, and being comfortable with not knowing everything is essential for sustainable growth in data careers.
108
8
23
Article
DEV·1y
📍The Art of Choosing the Right Database
Choosing the right database involves understanding the underlying storage engines and transaction protocols. This post explores the differences between SQL and NoSQL databases, focusing on B-Trees and LSM Trees. It discusses the strengths and use cases for databases like MySQL, MongoDB, Cassandra, and PostgreSQL, and highlights the importance of considering read vs. write-heavy workloads and transaction requirements.
107
3
24
Video
DevOps Toolbox·45w
SQLite Is ULTIMATE Choice For 99% of Projects
SQLite is a powerful, lightweight database that's widely deployed across mobile devices and applications. Despite being perceived as a beginner tool, it offers ACID compliance, can scale to 100TB, requires no separate server process, and supports advanced features like Write-Ahead Logging (WAL) for improved concurrent performance. The article explores SQLite's core features, demonstrates its durability and transaction handling, and introduces LibSQL, a distributed fork designed for modern cloud applications that addresses traditional SQLite's concurrency limitations.
103
5
25
Article
Tinybird·1y
Which LLM writes the best analytical SQL?
Tinybird's LLM SQL Generation Benchmark evaluates how 19 popular language models perform in generating SQL queries to filter and aggregate large datasets. Comparing models like OpenAI's GPT-4 Turbo and Anthropic's Claude, the benchmark measures accuracy, efficiency, and query latency, highlighting the challenges LLMs face in writing semantically correct SQL efficiently. The analysis shows humans leading in efficiency, while LLMs often struggle with contextual understanding and optimization opportunities.
102
4

See all SQL archives