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.
Compilable and Executable Pseudocode (spec) Solves AI Coding Hallucinations
esproc_spl profile
Judy

Compilable and Executable Pseudocode (spec) Solves AI Coding Hallucinations

#sql #programming #productivity #sqlazy
5
Comments
6 min read
Stop Using Offset for Pagination: Switching to Cursor-Based Filtering for Massive Datasets
aasimghaffar profile

Stop Using Offset for Pagination: Switching to Cursor-Based Filtering for Massive Datasets

#database #performance #webdev #sql
Comments
2 min read
ORA-00060 Deadlock: Find It, Fix It, Prevent It
uptimearchitect profile

ORA-00060 Deadlock: Find It, Fix It, Prevent It

#oracle #database #sql #performance
Comments
10 min read
How to Use AI to Write SQL Queries from Plain English
leveragenotes profile

How to Use AI to Write SQL Queries from Plain English

#sql #ai #database #tutorial
Comments
3 min read
Database Agnostic Queries: Easing the Pain of Engine Migration
maskdatabases profile

Database Agnostic Queries: Easing the Pain of Engine Migration

#postgres #mongodb #database #sql
Comments
3 min read
Your LLM fused the two columns you asked for — and the eval marked it wrong
omer_hochman profile

Your LLM fused the two columns you asked for — and the eval marked it wrong

#sql #llm #ai
Comments
3 min read
Dory Has Received the SourceForge Rising Star Award
dory-nemo profile
Finn

Dory Has Received the SourceForge Rising Star Award

#ai #database #sql #webdev
Comments
1 min read
Day 2: Understanding MySQL Client-Server Communication, Protocols, and Pages
kathir_2911 profile
Kathir

Day 2: Understanding MySQL Client-Server Communication, Protocols, and Pages

#architecture #database #sql #tutorial
Comments
3 min read
AI-Assisted SQL Development with Claude Code — Rules, Skills and Agents That Enforce Conventions
marcus1968 profile
Marcus

AI-Assisted SQL Development with Claude Code — Rules, Skills and Agents That Enforce Conventions

#ai #claude #sql #database
Comments
7 min read
As 12 Regras de Codd: o que torna um banco de dados realmente relacional?
carlos-delfino profile

As 12 Regras de Codd: o que torna um banco de dados realmente relacional?

#sgbd #sql #sqlserver #mariadb
Comments
7 min read
Clustered Indexes in SQL Server: How Data is Stored for Faster Queries
namrata_khorjuwekar_ profile

Clustered Indexes in SQL Server: How Data is Stored for Faster Queries

#sql #database #performance #backend
Comments
4 min read
Snowflake SQL Interview Questions – Quick Notes
chaminduperera profile

Snowflake SQL Interview Questions – Quick Notes

#ai #programming #database #sql
Comments
2 min read
SQL Server Heaps: Understanding Tables Without Clustered Indexes
namrata_khorjuwekar_ profile

SQL Server Heaps: Understanding Tables Without Clustered Indexes

#sql #database #performance #backend
1
Comments
4 min read
Normalization vs. Denormalization: The Great Database Debate
ibrahim0695 profile

Normalization vs. Denormalization: The Great Database Debate

#architecture #database #performance #sql
Comments
2 min read
Database Deep Dive Series
namrata_khorjuwekar_ profile

Database Deep Dive Series

#database #interview #sql #tutorial
1
Comments
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.