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.
Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL
catatsuy profile

Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

#mysql #postgres #database #sql
42
Comments 4
13 min read
SQLite as an MCP context saver: stop cramming raw API data into your LLM
richardbaxter profile

SQLite as an MCP context saver: stop cramming raw API data into your LLM

#ai #mcp #sql
43
Comments 14
9 min read
How Do PostgreSQL Indices Work, Anyways?
mattstratton profile

How Do PostgreSQL Indices Work, Anyways?

#postgres #database #performance #sql
7
Comments
6 min read
Nested Loop and Hash Join for MongoDB $lookup
franckpachot profile

Nested Loop and Hash Join for MongoDB $lookup

#mongodb #document #sql #database
17
Comments 1
10 min read
SQL Restaurant Kitchen ---Indexes and Partitions
igornosatov_15 profile

SQL Restaurant Kitchen ---Indexes and Partitions

#database #performance #sql
9
Comments 1
9 min read
Partitioning PotgreSQL Database
bohdanstupak1 profile

Partitioning PotgreSQL Database

#sql #postgres #architecture #performance
38
Comments
4 min read
SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird
mazinocodes profile

SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird

#sql #database #postgres #beginners
31
Comments
3 min read
Querying & Filtering in Oracle Databases: What Actually Clicked for Me As a Beginner
mazinocodes profile

Querying & Filtering in Oracle Databases: What Actually Clicked for Me As a Beginner

#oracle #sql #database #beginners
30
Comments 1
4 min read
Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)
mazinocodes profile

Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)

#oracle #sql #beginners #database
29
Comments 2
3 min read
SQL vs NoSQL: Choosing the Right Database Before It Chooses Your Fate
vignesh-j profile

SQL vs NoSQL: Choosing the Right Database Before It Chooses Your Fate

#database #sql #webdev #programming
59
Comments 21
8 min read
Join Data from Anywhere: The Streaming SQL Engine That Bridges Databases, APIs, and Files
theodore_p_9749548f7dd03 profile

Join Data from Anywhere: The Streaming SQL Engine That Bridges Databases, APIs, and Files

#python #database #dataengineering #sql
8
Comments 1
17 min read
📝 Fixing BigInt Serialization Error in Node.js + Express (A Beginner-Friendly Explanation)
krishnamoorthy_k_0f3f8d93 profile

📝 Fixing BigInt Serialization Error in Node.js + Express (A Beginner-Friendly Explanation)

#webdev #node #sql #json
4
Comments
3 min read
Hacktoberfest 2025 — Advancing SQL Tooling in Draw.io

Hacktoberfest: Contribution Chronicles
lastlink profile

Hacktoberfest 2025 — Advancing SQL Tooling in Draw.io

#hacktoberfest2025 #sql #drawio #hacktoberfest
10
Comments
1 min read
When Your Database Became a Library: Guide to PostgreSQL Indexes
igornosatov_15 profile

When Your Database Became a Library: Guide to PostgreSQL Indexes

#postgres #sql #database #performance
1
Comments
13 min read
How I Automated 90% of Data Requests Using LLM-Powered SQL Generation
osmanuygar profile

How I Automated 90% of Data Requests Using LLM-Powered SQL Generation

#ai #python #sql #architecture
5
Comments 2
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.