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.
De "se cayĂł la VM" a "estamos de vuelta"
kevin_hinojosa profile

De "se cayĂł la VM" a "estamos de vuelta"

#azure #database #fastapi #sql
Comments
4 min read
Hiding the table is not enough. Your LLM can still see the salary column.
ashish_sinha_5241c7673d93 profile

Hiding the table is not enough. Your LLM can still see the salary column.

#llm #privacy #security #sql
Comments
2 min read
Database Indexes, Explained Like a Book Index
hksoldev profile

Database Indexes, Explained Like a Book Index

#database #sql #beginners #tutorial
1
Comments
3 min read
MAX()+1: The Invoice Number That Showed Up Twice
hossam_assadallah_842151a profile

MAX()+1: The Invoice Number That Showed Up Twice

#backend #database #programming #sql
Comments
4 min read
The free plan searches exactly like the paid one and hides the results, and the blurred rows are fake on purpose
daniel_pertu profile

The free plan searches exactly like the paid one and hides the results, and the blurred rows are fake on purpose

#postgres #sql #webdev #react
Comments
6 min read
Deadlocks (SQL Server)
rhuturaj_takle profile

Deadlocks (SQL Server)

#dotnet #sql #programming #learning
Comments
18 min read
Who stabbed Samuel Ratchett 12 times?🔪
query_themurder_6c190cd6 profile

Who stabbed Samuel Ratchett 12 times?🔪

#showdev #beginners #database #sql
Comments
1 min read
One missing index turned a 40ms query into a 12-second one
kamenivanov profile
Kamen

One missing index turned a 40ms query into a 12-second one

#database #performance #sql
Comments
3 min read
Custom Fresh v2.1.0: Take Control of Laravel Database Resets
mmramadan496 profile

Custom Fresh v2.1.0: Take Control of Laravel Database Resets

#php #laravel #sql #opensource
Comments
1 min read
Replacing deep OFFSET pagination in D1: rows read and inserts between pages
hirodeath profile
hiro@

Replacing deep OFFSET pagination in D1: rows read and inserts between pages

#cloudflare #sql #database #performance
Comments 1
4 min read
Seventeen subqueries in one statement, because our connection pool has five slots
daniel_pertu profile

Seventeen subqueries in one statement, because our connection pool has five slots

#postgres #sql #typescript #nextjs
1
Comments
6 min read
My Journey into Data Analytics
sanchitapatil104 profile

My Journey into Data Analytics

#analytics #datascience #python #sql
Comments
1 min read
Argo-Bench: Why Enterprise Data Agents Need Multi-Table Workflows, Not Just SQL Generation
mech_app_ai profile

Argo-Bench: Why Enterprise Data Agents Need Multi-Table Workflows, Not Just SQL Generation

#agents #ai #machinelearning #sql
1
Comments
6 min read
Making Atlassian Cloud Migrations Predictable
mihai_leanzero profile

Making Atlassian Cloud Migrations Predictable

#atlassian #jira #migration #sql
Comments
21 min read
A website shared by more than three places is a chain, and 163 of the 318 we flagged had no brand field
daniel_pertu profile

A website shared by more than three places is a chain, and 163 of the 318 we flagged had no brand field

#sql #postgres #duckdb #typescript
2
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.