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.
5 Things AI Cannot Do at PostgreSQL
devunionx profile

5 Things AI Cannot Do at PostgreSQL

#postgressql #sql #sqlserver #ai
5
Comments
5 min read
Building vs Running: A Simple Way to Understand DDL & DML.
josephine_mackylah_d6b31f profile

Building vs Running: A Simple Way to Understand DDL & DML.

#sql #beginners #basic
2
Comments
2 min read
Inside Army's MySQL Dialect: When SQL Dialects Are First-Class Citizens
zoro7 profile

Inside Army's MySQL Dialect: When SQL Dialects Are First-Class Citizens

#backend #database #java #sql
Comments
15 min read
Learn PostgreSQL extensibility through a gloriously bad idea: MM/DD/YYYY native datatype
franckpachot profile

Learn PostgreSQL extensibility through a gloriously bad idea: MM/DD/YYYY native datatype

#postgres #sql #database #extensions
1
Comments
16 min read
Plataforma gratuita para practicar SQL en español
rozhnev profile

Plataforma gratuita para practicar SQL en español

#spanish #sql #database #learning
Comments
1 min read
Data Cleaning and Analysis with SQL
alex_murithi profile

Data Cleaning and Analysis with SQL

#sql #database #datascience
Comments
5 min read
Making players prove it: validating that a SQL query derives an answer
christianvadillo profile

Making players prove it: validating that a SQL query derives an answer

#sql #duckdb #webassembly #gamedev
Comments
5 min read
The Data Modeling Concepts Nobody Mentions After Star Schema 101
rahmanfrr profile

The Data Modeling Concepts Nobody Mentions After Star Schema 101

#dataengineering #datamodeling #sql #tutorial
Comments
6 min read
Parser Gates or Runtime Guards: A Debate for Agent-Written SQL
dataio_4921 profile

Parser Gates or Runtime Guards: A Debate for Agent-Written SQL

#discuss #sql #postgres #ai
Comments 1
9 min read
Database Naming Conventions: A Practical Guide for Tables and Columns
sqemo profile

Database Naming Conventions: A Practical Guide for Tables and Columns

#database #sql #postgres #bestpractices
Comments
7 min read
Six Rows Deleted. Three Decrements Applied. No Error.
mahmut_gndzalp_c736ac4b profile

Six Rows Deleted. Three Decrements Applied. No Error.

#mysql #sql #database #webdev
Comments
6 min read
OFFSET Doesn't Skip Rows: What 10M Rows in PostgreSQL Actually Cost
hidetzu profile

OFFSET Doesn't Skip Rows: What 10M Rows in PostgreSQL Actually Cost

#postgres #sql #performance #database
Comments
6 min read
Adhiya Meets Athena: Exploring Amazon Athena 🔍☁️
adhiya_r_002cf5cfd90c17b7 profile

Adhiya Meets Athena: Exploring Amazon Athena 🔍☁️

#aws #cloud #serverless #sql
Comments
6 min read
SQL Window Functions Made Simple
alex_murithi profile

SQL Window Functions Made Simple

#sql #database #datascience
Comments
3 min read
Ananthika Unlocks Athena: SQL Wisdom Without a Single Server ⚡
ananthikaa4 profile

Ananthika Unlocks Athena: SQL Wisdom Without a Single Server ⚡

#aws #database #serverless #sql
Comments
5 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.