select * from SQL - DEV Community
https://dev.to/t/sql • 147 KB fetched
Open original page
select * from SQL - DEV Community
Skip to content
Powered by Algolia
Log in
Create account
DEV Community
select * from SQL
Posts on tips and tricks, using and learning about SQL for database development and analysis.
Follow
Hide
Create Post
submission guidelines
Allowed
* Posts about learning SQL
* Posts about tips, tricks, problems, and answers
* Posts about news or commentary of the field
* Posts about specific tooling or frameworks
Think what would someone wanting to learn more about SQL want to see.
Not Allowed
* Articles that mention SQL in passing
* Articles that break the terms of use
about #sql
SQL is the language of data, has been for nearly 50 years now!
Older #sql posts
1
2
3
4
5
6
7
8
9
… 75
… 526
Posts
👋 Sign in for the ability to sort posts by relevant , latest , or top .
My "Last Hour" Query Returned 1,252 Rows. The Real Answer Was 68.
ushiro
ushiro
ushiro
Follow
Sep 11
My "Last Hour" Query Returned 1,252 Rows. The Real Answer Was 68.
# webdev
# javascript
# sql
# sqlite
Add Comment
5 min read
The Safe Way to Add a NOT NULL Column to a Large Postgres Table
Sayonil Mitra
Sayonil Mitra
Sayonil Mitra
Follow
Sep 11
The Safe Way to Add a NOT NULL Column to a Large Postgres Table
# database
# sql
# webdev
# postgres
Add Comment
4 min read
Why our multi-million row join cost $4,000 in one hour
Aniket Abhishek Soni
Aniket Abhishek Soni
Aniket Abhishek Soni
Follow
Sep 11
Why our multi-million row join cost $4,000 in one hour
# bigquery
# databricks
# data
# sql
Add Comment
4 min read
SQL Window Functions 101
Young Odhiambo
Young Odhiambo
Young Odhiambo
Follow
Sep 11
SQL Window Functions 101
# database
# datascience
# sql
# postgres
2 reactions
Add Comment
2 min read
SQL for Beginners: Window Functions vs GROUP BY
Gumathi Geo
Gumathi Geo
Gumathi Geo
Follow
Sep 11
SQL for Beginners: Window Functions vs GROUP BY
# beginners
# database
# sql
# tutorial
1 reaction
Add Comment
4 min read
A DEEP DIVE INTO DDL'S AND DML'S
Gumathi Geo
Gumathi Geo
Gumathi Geo
Follow
Sep 11
A DEEP DIVE INTO DDL'S AND DML'S
# beginners
# database
# sql
Add Comment
3 min read
Cheat Sheet: SQL Query Interview Questions
Devashish Roy
Devashish Roy
Devashish Roy
Follow
Sep 11
Cheat Sheet: SQL Query Interview Questions
# sql
# database
# programming
# interview
1 reaction
Add Comment
4 min read
Database Indexing That Actually Speeds Things Up
Stack Horizon
Stack Horizon
Stack Horizon
Follow
Sep 11
Database Indexing That Actually Speeds Things Up
# database
# sql
# performance
# postgres
Add Comment
3 min read
How I Built a Real Estate ROI Calculator Using Supabase & Looker Studio
Peter Michalik
Peter Michalik
Peter Michalik
Follow
Sep 11
How I Built a Real Estate ROI Calculator Using Supabase & Looker Studio
# postgres
# sql
# lookerstudio
# dataanalysis
Add Comment
2 min read
A quick review of SQL Joins
Gumathi Geo
Gumathi Geo
Gumathi Geo
Follow
Sep 11
A quick review of SQL Joins
# backend
# database
# programming
# sql
Add Comment
1 min read
SQL JOINs: A Practical Guide to Combining Data from Multiple Tables
Melvin
Melvin
Melvin
Follow
Sep 10
SQL JOINs: A Practical Guide to Combining Data from Multiple Tables
# sql
1 reaction
Add Comment
8 min read
SQL Joins: Combining Data Across Tables
Fidel Okumu
Fidel Okumu
Fidel Okumu
Follow
Sep 10
SQL Joins: Combining Data Across Tables
# database
# programming
# sql
# tutorial
1 reaction
Add Comment
2 min read
An AI-generated login endpoint "works" - I still found SQL concatenation before launch
yuan ming
yuan ming
yuan ming
Follow
Sep 10
An AI-generated login endpoint "works" - I still found SQL concatenation before launch
# ai
# python
# security
# sql
1 comment
3 min read
Six Tables Out of 260
Ashish sinha
Ashish sinha
Ashish sinha
Follow
Sep 9
Six Tables Out of 260
# ai
# sql
# python
# database
Add Comment
3 min read
Why RBAC Alone Isn't Enough for Enterprise Data Agents
ArisynData
ArisynData
ArisynData
Follow
Sep 10
Why RBAC Alone Isn't Enough for Enterprise Data Agents
# ai
# agents
# llm
# sql
1 reaction
1 comment
7 min read
👋 Sign in for the ability to sort posts by relevant , latest , or top .
trending guides/resources
From Joins to Graph Edges: SQL/PGQ in PostgreSQL 19 (beta - reverted)
Postgres: force drop a database that is being accessed by other users
PostgreSQL Said No to Query Hints for 20 Years. Postgres 19 Ships Them.
Intuit OA 2026 Guide: Code, SQL & Bash Questions Explained
The Past Keeps Changing
PostgreSQL query planner parameters and prepared statements
PostgreSQL 19 REPACK: Choosing the Right FILLFACTOR
Why `SqlBulkCopy` Is So Fast: Under the Hood of SQL Server Bulk Loading
WHERE $1::timestamptz IS NULL OR "timestamp" > $1
MariaDB 10.6 to 13.0 for WordPress: Only One Upgrade Actually Does Anything [Benchmark]
A Better Way to Store PostgreSQL Schemas in Git
How an Employee Hierarchy Helped Me Understand Recursive CTEs
How to implement RBAC in Go
SQL Basics Explained: DDL, DML, Filtering, and CASE WHEN
Scythe: SQL as a first-class language (and where that leaves your ORM)
Databricks launches AI agent for legacy SQL migration
SQL: Data Integrity Constraints
Tracking Tableau Viewership with PostgreSQL
Bringing Relational SQL Databases to the P2P World
CTE vs Temporary Tables in SQL: Which One Should You Use?
SQL seguro con IA: cómo construir un asistente que valida las consultas antes de ejecutarlas
READ COMMITTED isn't as safe as you think
Correlated Subqueries Explained: From Confusing to Intuitive
PostgreSQL MVCC: Why Bloat Doesn't Automatically Mean Expensive Reads
Schemity vs ChartDB: The Offline Desktop Alternative
DEV Community — A space to discuss and keep up software development and manage your software career
*
Home
*
DEV Challenges
*
DEV++
*
Videos
*
DEV Education Tracks
*
DEV Help
*
Advertise on DEV
*
Organization Accounts
*
DEV Showcase
*
About
*
Contact
*
Free Postgres Database
*
DEV Shop
*
MLH
*
Code of Conduct
*
Privacy Policy
*
Terms of Use
Built on Forem — the open source software that powers DEV and other inclusive communities.
Made with love and Ruby on Rails . DEV Community (c) 2016 - 2026.
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account
Links found on this page
- Skip to content [direct]
- Powered by Algolia [direct]
- Log in [direct]
- Create account [direct]
- Create Post [direct]
- terms of use [direct]
- 2 [direct]
- 3 [direct]
- 4 [direct]
- 5 [direct]
- 6 [direct]
- 7 [direct]
- 8 [direct]
- 9 [direct]
- 75 [direct]
- 526 [direct]
- My "Last Hour" Query Returned 1,252 Rows. The Real Answer Was 68. [direct]
- ushiro [direct]
- # webdev [direct]
- # javascript [direct]
- # sqlite [direct]
- The Safe Way to Add a NOT NULL Column to a Large Postgres Table [direct]
- Sayonil Mitra [direct]
- # database [direct]
- # postgres [direct]
- Why our multi-million row join cost $4,000 in one hour [direct]
- Aniket Abhishek Soni [direct]
- # bigquery [direct]
- # databricks [direct]
- # data [direct]
- SQL Window Functions 101 [direct]
- Young Odhiambo [direct]
- # datascience [direct]
- SQL for Beginners: Window Functions vs GROUP BY [direct]
- Gumathi Geo [direct]
- # beginners [direct]
- # tutorial [direct]
- A DEEP DIVE INTO DDL'S AND DML'S [direct]
- Cheat Sheet: SQL Query Interview Questions [direct]
- Devashish Roy [direct]
- # programming [direct]
- # interview [direct]
- Database Indexing That Actually Speeds Things Up [direct]
- Stack Horizon [direct]
- # performance [direct]
- How I Built a Real Estate ROI Calculator Using Supabase & Looker Studio [direct]
- Peter Michalik [direct]
- # lookerstudio [direct]
- # dataanalysis [direct]
- A quick review of SQL Joins [direct]
- # backend [direct]
- SQL JOINs: A Practical Guide to Combining Data from Multiple Tables [direct]
- Melvin [direct]
- SQL Joins: Combining Data Across Tables [direct]
- Fidel Okumu [direct]
- An AI-generated login endpoint "works" - I still found SQL concatenation before launch [direct]
- yuan ming [direct]
- # ai [direct]
- # python [direct]
- # security [direct]
- Six Tables Out of 260 [direct]
- Ashish sinha [direct]
- Why RBAC Alone Isn't Enough for Enterprise Data Agents [direct]
- ArisynData [direct]
- # agents [direct]
- # llm [direct]
- From Joins to Graph Edges: SQL/PGQ in PostgreSQL 19 (beta - reverted) [direct]
- Postgres: force drop a database that is being accessed by other users [direct]
- PostgreSQL Said No to Query Hints for 20 Years. Postgres 19 Ships Them. [direct]
- Intuit OA 2026 Guide: Code, SQL & Bash Questions Explained [direct]
- The Past Keeps Changing [direct]
- PostgreSQL query planner parameters and prepared statements [direct]
- PostgreSQL 19 REPACK: Choosing the Right FILLFACTOR [direct]
- Why `SqlBulkCopy` Is So Fast: Under the Hood of SQL Server Bulk Loading [direct]
- WHERE $1::timestamptz IS NULL OR "timestamp" > $1 [direct]
- MariaDB 10.6 to 13.0 for WordPress: Only One Upgrade Actually Does Anything [Benchmark] [direct]
- A Better Way to Store PostgreSQL Schemas in Git [direct]
- How an Employee Hierarchy Helped Me Understand Recursive CTEs [direct]
- How to implement RBAC in Go [direct]
- SQL Basics Explained: DDL, DML, Filtering, and CASE WHEN [direct]
|
|