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.
From Tables to Insights: A Beginner's Journey into SQL

From Tables to Insights: A Beginner's Journey into SQL

Comments
2 min read
REST-style GraphQL — one line of Java handles filtering + sorting + pagination + stats + CSV export.

REST-style GraphQL — one line of Java handles filtering + sorting + pagination + stats + CSV export.

1
Comments
6 min read
The Role of a Database Administrator: Building a Database from Scratch in PostgreSQL

The Role of a Database Administrator: Building a Database from Scratch in PostgreSQL

Comments
8 min read
Resume Optimization for US Data Engineering from WeChat Mini-Programs

Resume Optimization for US Data Engineering from WeChat Mini-Programs

Comments
4 min read
A practical journey into SQL

A practical journey into SQL

Comments
6 min read
Building a right-click 'query this file' workflow in VS Code with DuckDB

Building a right-click 'query this file' workflow in VS Code with DuckDB

Comments
2 min read
I Got Tired of Slow SQL Formatters That Upload My Queries — So I Built a Free One

I Got Tired of Slow SQL Formatters That Upload My Queries — So I Built a Free One

Comments
1 min read
5 SQL queries every data analyst ends up googling

5 SQL queries every data analyst ends up googling

Comments
3 min read
LEARNING SQL

LEARNING SQL

Comments
4 min read
Dynamic SOQL Without Getting Burned

Dynamic SOQL Without Getting Burned

Comments
7 min read
Map First, Walk Second: What a Librarian Taught Me About Postgres

Map First, Walk Second: What a Librarian Taught Me About Postgres

1
Comments
3 min read
Five specific schema patterns — unbounded VARCHAR, nullable columns inside multi

Five specific schema patterns — unbounded VARCHAR, nullable columns inside multi

Comments
7 min read
What Happens When an Ordinary Girl Decides to Document Her Journey to Becoming a Java Full Stack Developer?

What Happens When an Ordinary Girl Decides to Document Her Journey to Becoming a Java Full Stack Developer?

Comments
3 min read
Why `SqlBulkCopy` Is So Fast: Under the Hood of SQL Server Bulk Loading

Why `SqlBulkCopy` Is So Fast: Under the Hood of SQL Server Bulk Loading

Comments 4
4 min read
The Backfill Pattern: Adding Required Columns Without Downtime

The Backfill Pattern: Adding Required Columns Without Downtime

Comments 1
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.