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.
PostgreSQL vs MySQL vs SQLite: Choosing the Right Database for Your Project

PostgreSQL vs MySQL vs SQLite: Choosing the Right Database for Your Project

1
Comments
8 min read
SQLite as a Graph Database: Recursive CTEs, Semantic Search, and Why We Ditched Neo4j

SQLite as a Graph Database: Recursive CTEs, Semantic Search, and Why We Ditched Neo4j

Comments
10 min read
Database Transactions: ACID Properties in Plain English

Database Transactions: ACID Properties in Plain English

Comments
4 min read
Connecting Power BI to SQL Databases

Connecting Power BI to SQL Databases

Comments
10 min read
Durability

Durability

1
Comments
3 min read
Database- Querying and Filtering Data

Database- Querying and Filtering Data

Comments
4 min read
Data Engineers Don't Need DSA. So Why Do Interviews Still Test It?

Data Engineers Don't Need DSA. So Why Do Interviews Still Test It?

Comments
7 min read
SQL GROUP BY & HAVING: The Beginner's Guide to Summarizing Data Like a Pro

SQL GROUP BY & HAVING: The Beginner's Guide to Summarizing Data Like a Pro

1
Comments
6 min read
SQL Window Functions Explained: Stop Collapsing Your Data with GROUP BY

SQL Window Functions Explained: Stop Collapsing Your Data with GROUP BY

Comments
6 min read
Connecting Power BI to SQL Databases: A Beginner's Guide

Connecting Power BI to SQL Databases: A Beginner's Guide

Comments
3 min read
Guarding Critical Operations: Mastering SELECT FOR UPDATE for Race Condition Prevention in Django & PostgreSQL

Guarding Critical Operations: Mastering SELECT FOR UPDATE for Race Condition Prevention in Django & PostgreSQL

1
Comments
8 min read
Finding a Practical Analytics Format for Structured JSON Logs

Finding a Practical Analytics Format for Structured JSON Logs

1
Comments 1
8 min read
Building High-Performance Data Stacks: Vector Search, SQLite Ops, & Open-Source Monitoring

Building High-Performance Data Stacks: Vector Search, SQLite Ops, & Open-Source Monitoring

1
Comments
4 min read
Generate ER Diagram from SELECT Queries (JOIN Analysis Tool)

Generate ER Diagram from SELECT Queries (JOIN Analysis Tool)

Comments
2 min read
Connecting Power BI to PostgreSQL Database

Connecting Power BI to PostgreSQL Database

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