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.
ALTER COLUMN failed because one or more objects access this column
woodfiresam profile
Sam

ALTER COLUMN failed because one or more objects access this column

#sql #database #dotnet #webdev
Comments
4 min read
A new campaign's first results cost zero API quota, because Postgres already has the titles
daniel_pertu profile

A new campaign's first results cost zero API quota, because Postgres already has the titles

#postgres #sql #typescript #webdev
Comments
7 min read
[query-inspector] A Claude Code skill for extracting and tuning SQL/ORM queries
jogakdal profile

[query-inspector] A Claude Code skill for extracting and tuning SQL/ORM queries

#claudecode #sql #java #performance
Comments
4 min read
The Day My "Index Optimization" Melted Our Database 🔥
rss_holmes profile

The Day My "Index Optimization" Melted Our Database 🔥

#mysql #database #performance #sql
Comments
9 min read
A campaign that has searched every keyword gets eight new ones, and the worst eight switch off
daniel_pertu profile

A campaign that has searched every keyword gets eight new ones, and the worst eight switch off

#typescript #postgres #sql #ai
Comments
7 min read
QueuePool Limit Reached - When FastAPI Runs Out of Database Connections
andi1984 profile

QueuePool Limit Reached - When FastAPI Runs Out of Database Connections

#fastapi #python #sql #sqlalchemy
Comments
10 min read
Postgres Let Two Rows Through a Unique Index: The glibc Collation Trap After an OS Upgrade
libme profile
Libme

Postgres Let Two Rows Through a Unique Index: The glibc Collation Trap After an OS Upgrade

#postgres #database #devops #sql
Comments
8 min read
Three months of sales vanished, and every dbt run was green
vijaykumar13 profile

Three months of sales vanished, and every dbt run was green

#dbt #snowflake #dataengineering #sql
Comments
5 min read
My Experience Using SQL: DDL, DML, WHERE and CASE WHEN
suzanne_orido profile

My Experience Using SQL: DDL, DML, WHERE and CASE WHEN

#beginners #database #postgres #sql
Comments
2 min read
A cache key ate 99.9% of my records and the pipeline looked green
kyien profile

A cache key ate 99.9% of my records and the pipeline looked green

#dataengineering #python #architecture #sql
Comments
5 min read
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
woodfiresam profile
Sam

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint

#database #debugging #sql
Comments
4 min read
The Empty SMALLINT Column That Led Me to Nine More Missing Types
caiderek profile

The Empty SMALLINT Column That Led Me to Nine More Missing Types

#database #debugging #sql
Comments
2 min read
SqlJam: Move Tables Across Databases with Schema, Data and All
paganini2008 profile

SqlJam: Move Tables Across Databases with Schema, Data and All

#database #java #sql #tools
Comments
5 min read
MSSQL LEDGER TABLES Bulletproof Data Integrity and Authenticity
abeamar profile

MSSQL LEDGER TABLES Bulletproof Data Integrity and Authenticity

#database #learning #sql #sqlserver
Comments
4 min read
How AI can investigate a 12 GB export without reading it into a prompt
jerry_king_d0ee94a9bca82f profile

How AI can investigate a 12 GB export without reading it into a prompt

#dataengineering #sql #ai #parquet
Comments
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.