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.
🚀 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
JDBC vs JPA: Which Should You Use?

JDBC vs JPA: Which Should You Use?

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
Multi-Tenant SQL Reporting: How to Show Each Customer Only Their Own Data

Multi-Tenant SQL Reporting: How to Show Each Customer Only Their Own Data

Comments 1
5 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
UPSERT in MySQL, PostgreSQL, SQLite & MS SQL Server — A Complete Comparison

UPSERT in MySQL, PostgreSQL, SQLite & MS SQL Server — A Complete Comparison

2
Comments
2 min read
How to Find the Postgres Indexes Your Planner Never Picks (I Found 20 of 51)

78% index disk waste revealed by custom tools

How to Find the Postgres Indexes Your Planner Never Picks (I Found 20 of 51)

15
Comments 5
10 min read
Set-Based Updates in Rails: 4 Hours to 8 Seconds

Set-Based Updates in Rails: 4 Hours to 8 Seconds

4
Comments 3
5 min read
SQLite Internals, PostgreSQL Extensions & Performance Tuning Updates

SQLite Internals, PostgreSQL Extensions & Performance Tuning Updates

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