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.
Oracle SQL: Essential Environment Commands

Oracle SQL: Essential Environment Commands

Comments
2 min read
Currently learning Data Science, here is what I've learnt so far. Pt.3

Currently learning Data Science, here is what I've learnt so far. Pt.3

1
Comments 1
2 min read
Oracle SQL: SQL Statement Classifications

Oracle SQL: SQL Statement Classifications

Comments
1 min read
Currently learning Data Science, here is what I've learnt so far.

Currently learning Data Science, here is what I've learnt so far.

1
Comments 2
3 min read
9 PostgreSQL Queries Every Data Analyst Should Know (Try Them in Your Browser)

9 PostgreSQL Queries Every Data Analyst Should Know (Try Them in Your Browser)

Comments 1
3 min read
PostgreSQL numeric vs double precision vs money: Which Type to Use for Prices

PostgreSQL numeric vs double precision vs money: Which Type to Use for Prices

Comments 1
9 min read
Currently learning Data Science, here is what I've learnt so far. Pt.2

Currently learning Data Science, here is what I've learnt so far. Pt.2

1
Comments 1
2 min read
Understanding SQL Execution Order

Understanding SQL Execution Order

Comments 1
2 min read
PostgreSQL Unique Constraint vs Unique Index: Which to Use, and How to Add One Without Locking the Table

PostgreSQL Unique Constraint vs Unique Index: Which to Use, and How to Add One Without Locking the Table

Comments
9 min read
Your Test Suite Is Slow Because It Tests Postgres

Your Test Suite Is Slow Because It Tests Postgres

Comments
3 min read
Production SQLite in 2026: Running Laravel Without a Database Server

Production SQLite in 2026: Running Laravel Without a Database Server

Comments
3 min read
Polymorphic Associations in PostgreSQL: One commentable_id Column or a Foreign Key per Table?

Polymorphic Associations in PostgreSQL: One commentable_id Column or a Foreign Key per Table?

Comments
7 min read
Apache Iceberg Query Optimization: Production Guide

Apache Iceberg Query Optimization: Production Guide

Comments
40 min read
Stop Hardcoding Your .NET Data Provider

Stop Hardcoding Your .NET Data Provider

1
Comments 1
8 min read
No more messy f-strings: Type-safe fluent SQL for ClickHouse.

No more messy f-strings: Type-safe fluent SQL for ClickHouse.

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