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.
sql.Open() doesn't open anything

sql.Open() doesn't open anything

Comments
2 min read
Parse Oracle SQL in VS Code with Gudu SQL Omni

Parse Oracle SQL in VS Code with Gudu SQL Omni

Comments
3 min read
PostgreSQL O(delta) MV Refreshes, pg_lake for Data Lakes, & ADBC for Columnar Data

PostgreSQL O(delta) MV Refreshes, pg_lake for Data Lakes, & ADBC for Columnar Data

Comments
3 min read
🚀 DB Explorer 3.0.1 — The AI‑First SQL Editor You’ll Want to Try

🚀 DB Explorer 3.0.1 — The AI‑First SQL Editor You’ll Want to Try

Comments
1 min read
PostgreSQL GIN Indexes: JSONB, Arrays & Full-Text Search

PostgreSQL GIN Indexes: JSONB, Arrays & Full-Text Search

Comments
4 min read
hi all!

hi all!

Comments
1 min read
The Restart Challenge: Day 02

The Restart Challenge: Day 02

Comments
1 min read
SQLite Join Benchmarks, PostgreSQL for AI Graphs with pgvector, & pGenie for SQL Validation

SQLite Join Benchmarks, PostgreSQL for AI Graphs with pgvector, & pGenie for SQL Validation

Comments
3 min read
🌙 Late Night Chronicles: #5 Your First MySQL Commands 🚀

🌙 Late Night Chronicles: #5 Your First MySQL Commands 🚀

Comments
2 min read
System Design Learning Journey — Week 2: Storage & Retrieval

System Design Learning Journey — Week 2: Storage & Retrieval

Comments
3 min read
PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained

PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained

Comments
4 min read
🌙 Late Night Chronicles: #4 Understanding MySQL Data Types

🌙 Late Night Chronicles: #4 Understanding MySQL Data Types

Comments
2 min read
SQLite Internals, PostgreSQL Extensions & Performance Tuning Updates

SQLite Internals, PostgreSQL Extensions & Performance Tuning Updates

Comments
3 min read
SQL Without Confusion: Subqueries vs CTEs (Visual + Practical Guide)

SQL Without Confusion: Subqueries vs CTEs (Visual + Practical Guide)

1
Comments
3 min read
A Look into SQL Query Basics

A Look into SQL Query Basics

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