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.

Ivan Kahl

Oct 2 '25

Stop Spaghetti SQL: Simplify Complex Queries with Postgres CTEs in Supabase

#supabase #postgres #webdev #sql

16 min read

Oct 2 '25

ACID Properties with SQL Transactions in DBMS

#sql #database #web #learning

2 min read

Oct 2 '25

Transactions, Deadlocks & Log-Based Recovery

#webdev #programming #sql

2 min read

Pranav Aadithya

Oct 1 '25

Understanding ACID Properties with SQL Transactions

#mysql #database #programming #sql

3 min read

Oct 1 '25

SQL Commands Explained: DDL vs DML vs DQL vs DCL vs TCL

#sql #database #programming

3 min read

Guillaume Mary for Codefilarete

Aug 29 '25

A simplified definition of an ORM

#orm #java #database #sql

2 min read

Oct 1 '25

Database VIEW tutorial

#sql #database #view

3 min read

Gangeswara

Oct 1 '25

Database Normalization

#programming #sql #oracle #dbms

3 min read

Oct 1 '25

From Kafka to Clean Tables: Building a Confluent Snowflake Pipeline with Streams & Tasks

#dataengineering #automation #tutorial #sql

10 min read

Sep 19 '25

Understanding the Difference Between Tables and Views (Bite-size Article)

#beginners #sql #database

4 min read

Caroline Caillaud

Sep 30 '25

SQL JOIN

#database #sql #beginners #tutorial

3 min read

Roxana Maria Haidiner

Sep 30 '25

How to Create Custom Data Types in DbSchema

#database #sql #mysql #logicaldesign

3 min read

Rashi

Sep 29 '25

SQL Query optimization techniques

#database #tutorial #performance #sql

3 min read

Aug 26 '25

🚀 My Python Practice – Day 1

#python #sql #100daysofcode #dataanalytics

1 min read

Aug 26 '25

🚀 Learning Update

#learning #programming #sql #python

1 min read

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