Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Apr 13

NL2SQL in 2026: How Multi-Agent Pipelines Convert Natural Language to Safe SQL

#python #ai #sql #machinelearning

5 min read

Apr 13

Introduction to Databases with SQL

#sql #data #database #postgres

6 min read

Apr 14

Managing Academic Data: A Practical Application of SQL in PostgreSQL

#sql #databasemanagement #postgres

4 min read

Apr 13

First Week Reflections on SQL

#sql #postgres #beginners

2 min read

soy

Apr 13

DuckDB Lake, dbt Custom Materializations, & PostgreSQL Partitioning Strategies

#database #sql #sqlite

3 min read

ilshaad

Apr 13

How to Calculate MRR, Churn, and LTV in PostgreSQL

#webdev #postgres #saas #sql

8 min read

Philip McClarence

Apr 13

PostgreSQL Partial Indexes: Targeted Indexing for Faster Queries

#database #performance #postgres #sql

3 min read

superhekel

Apr 13

mysql 8 setup akses penuh sebuah user

#beginners #database #sql #tutorial

1 min read

Apr 13

Understanding SQL: DDL, DML, and Data Transformation

#beginners #database #sql #tutorial

3 min read

Anvesha Srivastava

May 17

🎮 The SQL Arcade : No Boring Textbooks Allowed

#webdev #database #sql #beginners

3 min read

Mungai M.

Apr 13

Welcome to the World of SQL

#sql #dataengineering #tutorial #assignment

5 min read

soy

Apr 12

PostgreSQL Credential Rotation, pgvector HALFVEC, & SQLite Type Affinity

#database #sql #sqlite

3 min read

Gabriel Njoroge

Apr 13

Understanding SQL: DDL,DML,Filtering and DCL.

#beginners #database #sql #tutorial

2 min read

Kahuthu Muriuki

Apr 26

SQL Subqueries vs CTEs: What I Reach For When Writing Compliance and Reconciliation Queries

#sql #beginners #database

7 min read

Apr 26

SQL Subqueries vs CTEs: A Complete Guide for Data Analysts

#sql #datascience #database #tutorial

7 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.