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.
My First Time With SQL

My First Time With SQL

Comments
3 min read
Unpacking the language of data: DDL, DML, Filtering and Transformation.

Unpacking the language of data: DDL, DML, Filtering and Transformation.

Comments
2 min read
Migration of YouTube from SQL to NoSQL: A Component-Wise Analysis

Migration of YouTube from SQL to NoSQL: A Component-Wise Analysis

1
Comments
2 min read
Understanding DDL and DML in Database Management

Understanding DDL and DML in Database Management

Comments
3 min read
Database Decisions That Haunt You 2 Years Later

Database Decisions That Haunt You 2 Years Later

1
Comments 1
3 min read
SQL Execution Order: Write Queries That Think Like the Database

SQL Execution Order: Write Queries That Think Like the Database

2
Comments 2
13 min read
PostgreSQL EXPLAIN ANALYZE Viewer, Checkpoints & SQLite JSON Parsing

PostgreSQL EXPLAIN ANALYZE Viewer, Checkpoints & SQLite JSON Parsing

Comments
3 min read
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
ORM library Ujorm 3.0 is released

ORM library Ujorm 3.0 is released

Comments 1
1 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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.