DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
hi all!

hi all!

Comments
1 min read
The Restart Challenge: Day 02

The Restart Challenge: Day 02

Comments
1 min read
SQLite Join Benchmarks, PostgreSQL for AI Graphs with pgvector, & pGenie for SQL Validation

SQLite Join Benchmarks, PostgreSQL for AI Graphs with pgvector, & pGenie for SQL Validation

Comments
3 min read
🌙 Late Night Chronicles: #5 Your First MySQL Commands 🚀

🌙 Late Night Chronicles: #5 Your First MySQL Commands 🚀

Comments
2 min read
Multi-Tenant SQL Reporting: How to Show Each Customer Only Their Own Data

Multi-Tenant SQL Reporting: How to Show Each Customer Only Their Own Data

Comments 1
5 min read
System Design Learning Journey — Week 2: Storage & Retrieval

System Design Learning Journey — Week 2: Storage & Retrieval

Comments
3 min read
PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained

PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained

Comments
4 min read
🌙 Late Night Chronicles: #4 Understanding MySQL Data Types

🌙 Late Night Chronicles: #4 Understanding MySQL Data Types

Comments
2 min read
UPSERT in MySQL, PostgreSQL, SQLite & MS SQL Server — A Complete Comparison

UPSERT in MySQL, PostgreSQL, SQLite & MS SQL Server — A Complete Comparison

2
Comments
2 min read
Set-Based Updates in Rails: 4 Hours to 8 Seconds

Set-Based Updates in Rails: 4 Hours to 8 Seconds

4
Comments 3
5 min read
SQLite Internals, PostgreSQL Extensions & Performance Tuning Updates

SQLite Internals, PostgreSQL Extensions & Performance Tuning Updates

Comments
3 min read
ClickHouse JOINs Aren't Slow Anymore (You're Reading 2020's Docs)

ClickHouse JOINs Aren't Slow Anymore (You're Reading 2020's Docs)

2
Comments
6 min read
A Look into SQL Query Basics

A Look into SQL Query Basics

1
Comments
2 min read
Broadcast Joins vs. Sort-Merge Joins: Choosing the Right Join Strategy in Apache Spark

Broadcast Joins vs. Sort-Merge Joins: Choosing the Right Join Strategy in Apache Spark

3
Comments 1
3 min read
Advanced SQL Techniques Every Data Analyst Should Know

Advanced SQL Techniques Every Data Analyst Should Know

1
Comments
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.