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.
Read-Only by Design: Letting AI Explore Your Database Without the Risk of Writes
vivekdraxlr profile

Read-Only by Design: Letting AI Explore Your Database Without the Risk of Writes

#sql #database #ai #postgres
Comments 1
6 min read
How to Turn Plain-English Requirements into SQL You Can Actually Trust
craftloop profile

How to Turn Plain-English Requirements into SQL You Can Actually Trust

#sql #database #ai #productivity
Comments
2 min read
PostgreSQL INCLUDE indexes: what problem are they trying to solve?

Clarifies pre-v11 covering index capabilities
franckpachot profile

PostgreSQL INCLUDE indexes: what problem are they trying to solve?

#postgres #sql #database #index
11
Picked as gem Comments 5
10 min read
I Reverse-Engineered a Restaurant ERP With No Documentation. Here's What It Taught Me About Being a Self-Taught Developer.
luishrqvf profile

I Reverse-Engineered a Restaurant ERP With No Documentation. Here's What It Taught Me About Being a Self-Taught Developer.

#reverseengineering #database #career #sql
Comments
4 min read
Your acquisitions table needs a status field, not a boolean
corpdigest profile

Your acquisitions table needs a status field, not a boolean

#database #sql #datascience
Comments
2 min read
Schema Linting vs Migration Linting: Which Database Problems Each One Can See
tbson87 profile

Schema Linting vs Migration Linting: Which Database Problems Each One Can See

#database #sql #postgres #architecture
Comments
11 min read
A Free-Server Regression Job for LLM-Generated SQL
dataio_4921 profile

A Free-Server Regression Job for LLM-Generated SQL

#sql #testing #ai #devops
Comments
6 min read
For Structured Data, Retrieval Accuracy Isn't a Model Problem
melih_birim_8363f43966da2 profile

For Structured Data, Retrieval Accuracy Isn't a Model Problem

#ai #sql #csv #agents
Comments 2
3 min read
Detecting SQLite Full Table Scans in Node.js
edysilva profile

Detecting SQLite Full Table Scans in Node.js

#node #sqlite #performance #sql
Comments
3 min read
Why AI-Generated Migrations Need a Different Gate Than Code Patches
github_7727 profile

Why AI-Generated Migrations Need a Different Gate Than Code Patches

#database #postgres #softwareengineering #sql
Comments 1
4 min read
Database Isolation Levels & Read Phenomena: An Extensive Deep Dive
urvish_shah profile

Database Isolation Levels & Read Phenomena: An Extensive Deep Dive

#backend #database #sql
1
Comments 1
12 min read
Understanding Database Indexes Without the Jargon
sam000 profile

Understanding Database Indexes Without the Jargon

#database #mongodb #sql #performance
Comments
1 min read
Your Index Only Scan Is Lying: Covering Indexes and the Visibility Map
arnavsharma2711 profile

Your Index Only Scan Is Lying: Covering Indexes and the Visibility Map

#database #postgres #sql #performance
Comments
4 min read
Composite Indexes Explained: Why Column Order Is the Whole Game
arnavsharma2711 profile

Composite Indexes Explained: Why Column Order Is the Whole Game

#database #sql #postgres #backend
Comments
4 min read
QUERY_HISTORY has no PARENT_QUERY_ID. Here's how I traced which statement inside a Snowflake procedure regressed anyway.
tracepointdata profile

QUERY_HISTORY has no PARENT_QUERY_ID. Here's how I traced which statement inside a Snowflake procedure regressed anyway.

#snowflake #sql #dataengineering #database
2
Comments 2
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.