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 Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations

SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations

6
Comments
3 min read
Simple Ranking with SQLite3

Simple Ranking with SQLite3

Comments
5 min read
Make Your Technical Tutorials Interactive with SQLize Embed

Make Your Technical Tutorials Interactive with SQLize Embed

Comments
2 min read
PostgreSQL como busca vetorial (pgvector)

PostgreSQL como busca vetorial (pgvector)

Comments
8 min read
SQL Cheat Sheet

SQL Cheat Sheet

Comments 2
9 min read
SQL Optimization Unlocked: Achieve 80% Calculation Reduction with CROSS APPLY

SQL Optimization Unlocked: Achieve 80% Calculation Reduction with CROSS APPLY

Comments
5 min read
Querying & Filtering in Oracle Databases: What Actually Clicked for Me As a Beginner

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

29
Comments 1
4 min read
Are Wide Tables Fast or Slow?

Are Wide Tables Fast or Slow?

5
Comments
4 min read
Fixing sqlalchemy.exc.MissingGreenlet in FastAPI and Async SQLAlchemy 2.0

Fixing sqlalchemy.exc.MissingGreenlet in FastAPI and Async SQLAlchemy 2.0

Comments
2 min read
Week 5 Scripting Challenge: Secure Password Authentication

Week 5 Scripting Challenge: Secure Password Authentication

Comments
15 min read
How to Create a Chatbot That Generates SQL Queries" published

How to Create a Chatbot That Generates SQL Queries" published

Comments
9 min read
Supply Chain Orchestration for dummies

Supply Chain Orchestration for dummies

Comments
61 min read
Modular Approach to Database Performance and Maintainability

Modular Approach to Database Performance and Maintainability

2
Comments
4 min read
Found a Really Nice Way to Visualize SQLite Databases

Found a Really Nice Way to Visualize SQLite Databases

2
Comments
1 min read
Tired of ETL Bottlenecks? Build a Logical Data Warehouse with SPL

Tired of ETL Bottlenecks? Build a Logical Data Warehouse with SPL

5
Comments
11 min read
SARGable Condition Rewriting: Practical Solutions for Date Filtering Optimization

SARGable Condition Rewriting: Practical Solutions for Date Filtering Optimization

Comments
9 min read
Stop treating MongoDB like just another Database

Stop treating MongoDB like just another Database

Comments
3 min read
I built a SQL-to-Google Sheets bridge because existing tools were slow as hell (No-signup demo)

I built a SQL-to-Google Sheets bridge because existing tools were slow as hell (No-signup demo)

Comments
1 min read
SQL on Kafka Data Does Not Require a Streaming Engine

SQL on Kafka Data Does Not Require a Streaming Engine

Comments
4 min read
Data Inconsistency Due to Missing Constraints (Odoo)

Data Inconsistency Due to Missing Constraints (Odoo)

Comments
2 min read
Prompt Engineering a Barista: How SQLatte's Personality Transforms SQL into Conversations

Prompt Engineering a Barista: How SQLatte's Personality Transforms SQL into Conversations

Comments
4 min read
SQL vs MongoDB(noSQL)! How to decide between databases

SQL vs MongoDB(noSQL)! How to decide between databases

Comments
4 min read
SQL - Basics

SQL - Basics

Comments
2 min read
Beyond Nested Queries: A Practical Guide to SQL Subquery Flattening

Beyond Nested Queries: A Practical Guide to SQL Subquery Flattening

Comments
5 min read
SQL vs NoSQL: The Ultimate Interview Guide to Choosing the Right Database (Simple Checklist Included)

SQL vs NoSQL: The Ultimate Interview Guide to Choosing the Right Database (Simple Checklist Included)

1
Comments
4 min read
loading...