Anonymous View

Skip to content

DEV Community

select * from SQL

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

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

Martin

Jun 6

I built a free SQL practice game where you work at a fictional Singapore bank

#sql #database #beginners #webdev

2 min read

Kanishga Subramani

Jun 7

Day 5 of 100 Days of ClickHouse®: Writing Your First Query

#clickhouse #database #dataengineering #sql

5 min read

May 26

Day 19 of 60: From Raw SQL to a Full Stack FastAPI App.

#devchallenge #postgres #python #sql

3 min read

Musab Khan

Jun 6

Building a SQL Lexer in Rust: Why I Replaced `Vec<char>` with `&str` and `Ident(String)` with Spans

#rust #sql #database #parser

3 min read

Braeson Nyahera

May 3

Understanding Logic, Reusability and Integrity On SQL ; Procedures, Functions and Transactions.

#sql #postgres #data #analytics

2 min read

Philip McClarence

May 4

PostgreSQL Query Rewriting Techniques

#database #performance #postgres #sql

9 min read

samkaruri

May 3

Subqueries vs. CTEs in SQL: What They Are and When to Use Each.

#subqueries #ctes #database #sql

7 min read

May 3

The bug your Typescript compiler and SQL migration both miss

#typescript #sql #database #webdev

1 min read

Jun 3

Query Markdown as a Database with mq-db: SQL, mq, and Interval Indexes

#markdown #database #sql #rust

4 min read

Jun 5

Getting Started with pg_durable: Workflows Inside PostgreSQL

#postgres #sql #database #workflow

11 min read

Adebayo Olaonipekun

Jun 5

Stop Wiring Up Database Drivers Manually — A Simpler Python Database API

#python #database #sql #webdev

5 min read

May 25

The N+1 Query That Killed Our Database, And How I Fixed It

#database #python #django #sql

4 min read

May 16

💡 MySQL INNER JOIN vs LEFT JOIN — which one should you actually use?

#mysql #database #sql

7 min read

kernz

May 2

I built a 57-line asyncpg wrapper because SQLAlchemy was driving me insane

#sql #python #sqlalchemy #postgres

2 min read

Jun 5

SQL vs NoSQL — How to Choose the Right Database for Your System

#sql #nosql #postgres #systemdesign

2 min read

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