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 Transaction Isolation Levels Explained
philip_mcclarence_2ef9475 profile

PostgreSQL Transaction Isolation Levels Explained

#database #postgres #sql #tutorial
1
Comments
4 min read
The Restart Challenge: Day 05
mk_novice profile

The Restart Challenge: Day 05

#career #devjournal #learning #sql
Comments
1 min read
How Databases Lock Your Data (ACID)
neuraldownload profile

How Databases Lock Your Data (ACID)

#database #acid #transactions #sql
Comments
2 min read
Essential Concepts in SQL
gabriel_njoroge_5be6652c3 profile

Essential Concepts in SQL

#beginners #database #postgres #sql
Comments
2 min read
From English to SQL: How LLMs Actually Understand Your Database Schema
vivekdraxlr profile

From English to SQL: How LLMs Actually Understand Your Database Schema

#sql #database #ai #tutorial
Comments
6 min read
DuckDB in the Wild: What 6 Minutes of Benchmarking Across 4 Machines Taught Me About Real-World Performance
_f751e50d019c73e72371f profile

DuckDB in the Wild: What 6 Minutes of Benchmarking Across 4 Machines Taught Me About Real-World Performance

#database #dataengineering #performance #sql
Comments
5 min read
The Restart Challenge: Day 04
mk_novice profile

The Restart Challenge: Day 04

#devchallenge #devjournal #productivity #sql
Comments
1 min read
The Restart Challenge: Day 04
mk_novice profile

The Restart Challenge: Day 04

#database #devjournal #productivity #sql
Comments
1 min read
How to Prompt AI Tools to Write Accurate SQL Queries (And Why Most Developers Get This Wrong)
vivekdraxlr profile

How to Prompt AI Tools to Write Accurate SQL Queries (And Why Most Developers Get This Wrong)

#sql #database #ai #tutorial
2
Comments
6 min read
A beginners reflection on learning SQL
abdiomari profile

A beginners reflection on learning SQL

#sql #beginners
1
Comments
4 min read
Stop Writing Ugly SQL: A Developer's Guide to Clean, Readable Queries
99tools profile

Stop Writing Ugly SQL: A Developer's Guide to Clean, Readable Queries

#sql #database #webdev #productivity
8
Comments 2
6 min read
From RPA to Data Thinking: Building a High-Scale Payment Processing System
kunal_deshmukh_175f888b9a profile

From RPA to Data Thinking: Building a High-Scale Payment Processing System

#rpa #uipath #automation #sql
1
Comments
2 min read
SQL for Python Developers — Everything You Actually Need to Know
learnwithprashik profile

SQL for Python Developers — Everything You Actually Need to Know

#python #programming #beginners #sql
1
Comments
7 min read
Stop Pasting \timing — Run Your SQL 100 Times and Get p99
gillarohith profile

Stop Pasting \timing — Run Your SQL 100 Times and Get p99

#postgres #performance #sql #database
Comments
6 min read
Can ClickHouse DELETE Data? A 2026 PR-by-PR Analysis
manveerchawla profile

Can ClickHouse DELETE Data? A 2026 PR-by-PR Analysis

#database #sql #dataengineering #data
6
Comments
31 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.