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.

May 22

Database Maintenance: Tracing Production Incidents to Their Root Cause

#database #devops #performance #sql

21 min read

soy

Apr 22

PostgreSQL CDC 240x Faster, Flowfile v0.9.0 ETL, SQLite_EXTRA_INIT Deep Dive

#database #sql #sqlite

3 min read

Philip McClarence

Apr 18

PostgreSQL JSONB Indexing: GIN, Expression & Partial Index Strategies

#database #performance #postgres #sql

4 min read

May 22

# I built a type-safe SQL library for Bun — no ORM, no codegen, just SQL (using Claude Code)

#typescript #javascript #sql #bunjs

3 min read

May 22

Stop N+1 Queries Forever: Advanced Doctrine ORM Strategies in Symfony 8.1

#symfony #sql #php #performance

11 min read

Apr 22

SQL Index Tuning Tools: What Works and When to Use Them

#database #performance #sql #tooling

1 min read

soy

Apr 17

DuckDB Extensions in C#, Production DuckLake, & pgvector Performance Insights

#database #sql #sqlite

3 min read

Olha

Apr 22

How Teams Really Handle SQL Index Performance Tuning

#database #performance #sql #tooling

1 min read

Apr 17

🚨 When autocommit = false Caused Hidden Table Locks in SQL Server (pymssql + AWS Batch)

#sql #pymssql

2 min read

Ajani luke Kariuki

Apr 22

# Connecting Power BI to SQL Databases: A Complete Guide

#analytics #database #sql #tutorial

3 min read

Alex Chen

May 21

SQL Basics Every Developer Should Know (2026)

#beginners #database #sql #tutorial

5 min read

Rost

Apr 17

PostgreSQL Full Text Search vs Elasticsearch Comparison

#postgres #architecture #database #sql

9 min read

Tom Chege

Apr 17

Understanding SQL Window Functions

#newbie #sql

3 min read

Philip McClarence

Apr 17

PostgreSQL Transaction Isolation Levels Explained

#database #postgres #sql #tutorial

4 min read

Novice Mk

Apr 17

The Restart Challenge: Day 05

#career #devjournal #learning #sql

1 min read

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