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.
Understanding SQLite PRAGMA (And How better-sqlite3 Makes It Nicer)

Understanding SQLite PRAGMA (And How better-sqlite3 Makes It Nicer)

21
Comments
4 min read
Data Locality vs. Independence (NoSQL vs. SQL)

Data Locality vs. Independence (NoSQL vs. SQL)

1
Comments
10 min read
Nested Loop and Hash Join for MongoDB $lookup

Nested Loop and Hash Join for MongoDB $lookup

19
Comments 3
10 min read
Dear Developer: Your Database Isn't a File Cabinet!

Dear Developer: Your Database Isn't a File Cabinet!

5
Comments
4 min read
The SQL Concept You Probably Missed: Materialized Views

The SQL Concept You Probably Missed: Materialized Views

16
Comments
4 min read
🧠 SQL for Beginners: The 10 Most Common Queries Explained

🧠 SQL for Beginners: The 10 Most Common Queries Explained

Comments
3 min read
PL/SQL Program Data: Naming, Declaring, and Best Practices

PL/SQL Program Data: Naming, Declaring, and Best Practices

Comments
3 min read
INNER JOIN and LEFT OUTER JOIN in MongoDB (with $lookup and $unwind)

INNER JOIN and LEFT OUTER JOIN in MongoDB (with $lookup and $unwind)

2
Comments 2
8 min read
The Offline Data Engineer: Building Resilient API Pipelines that Work on an Airplane

The Offline Data Engineer: Building Resilient API Pipelines that Work on an Airplane

Comments
5 min read
😱 Stop Writing Useless SQL Queries! Discover the Secret Powers of Window Functions

😱 Stop Writing Useless SQL Queries! Discover the Secret Powers of Window Functions

Comments
3 min read
База Данных

База Данных

Comments
4 min read
🧠 ClickHouse LEFT JOINs: Why join_use_nulls Matters

🧠 ClickHouse LEFT JOINs: Why join_use_nulls Matters

5
Comments
2 min read
Why Couchbase Is the NoSQL Solution for Demanding Applications

Why Couchbase Is the NoSQL Solution for Demanding Applications

2
Comments
5 min read
Getting Started Building a Data Platform

Getting Started Building a Data Platform

Comments
3 min read
База Данных 2 Практика

База Данных 2 Практика

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