Essential Guide: 3 - Comprehensive Guide

👋 Sign in for the ability to sort posts by relevant, latest, or top.

김민식/학생

Oct 31

NL2SQL: cómo leer un 83,80 en BIRD Mini-Dev con un evaluador de precisión de ejecución en Python

#ai #python #sql #benchmarks

9 min read

labyrinthlab

Oct 31

CREATE INDEX on a live Postgres table locks writes. CONCURRENTLY fixes that, if you keep it out of a transaction

#postgres #sql #database #devops

3 min read

Dataspryva

Oct 31

Two salary ranges do not establish an exchange rate

#datascience #python #analytics #sql

7 min read

Ashish sinha

Oct 31

My open-source text-to-SQL layer is #1 on BIRD Mini-Dev in all three dialects

#sql #database #ai #opensource

1 min read

Kailas Warade

Oct 31

SQL EXISTS vs JOIN: Find Customers Who Have Placed an Order

#sql #database #programming #sqlserver

3 min read

Pipeline Whiteboard

Oct 30

CDC Deletes, Tombstones and the Idempotent MERGE

#dataengineering #kafka #snowflake #sql

7 min read

Dataspryva

Oct 30

Your match results can put a club in the wrong relegation spot

#datascience #python #analytics #sql

6 min read

Jitendra Suryavanshi

Oct 30

SQL Pattern Matching Without the Pain: LIKE, Wildcards, and the Gotchas Nobody Warns You About

#sql #database #beginners #webdev

4 min read

Bonree-Js

Oct 30

Tracing AI Agents with OpenTelemetry: A Design for LLM and Agentic AI Observability

#discuss #ai #devops #sql

7 min read

Spartan Rich

Oct 30

How to Learn SQL Joins (and Stop Mixing Up LEFT and INNER)

#sql #database #beginners #learning

5 min read

Usman Khan

Oct 29

Foreign Key Cascade Deletes: Un-Indexed FKs, Slow Cascades, and Lock Contention in PostgreSQL

#postgres #database #performance #sql

6 min read

Son Tran

Oct 29

MySQL to PostgreSQL Schema Conversion: What Each Column Type Should Become, and What Silently Changes

#mysql #postgres #database #sql

12 min read

LingamSuyambu

Oct 29

SARGable Queries in SQL Server: Why Functions in WHERE Slow You Down

#sql #sqlserver #database #performance

3 min read

Malek Damiri

Oct 29

Teaching yourself SQL when your job is ops

#sql #career #beginners #productivity

2 min read

Chris Rodriguez

Oct 29

Use INSERT WITH CHECK and UPDATE USING to allow owner-on-create but block owner transfers

#sql #security #postgres #database

4 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.

DEV Community

select * from SQL

NL2SQL: cómo leer un 83,80 en BIRD Mini-Dev con un evaluador de precisión de ejecución en Python

CREATE INDEX on a live Postgres table locks writes. CONCURRENTLY fixes that, if you keep it out of a transaction

Two salary ranges do not establish an exchange rate

My open-source text-to-SQL layer is #1 on BIRD Mini-Dev in all three dialects

SQL EXISTS vs JOIN: Find Customers Who Have Placed an Order

CDC Deletes, Tombstones and the Idempotent MERGE

Your match results can put a club in the wrong relegation spot

SQL Pattern Matching Without the Pain: LIKE, Wildcards, and the Gotchas Nobody Warns You About

Tracing AI Agents with OpenTelemetry: A Design for LLM and Agentic AI Observability

How to Learn SQL Joins (and Stop Mixing Up LEFT and INNER)

Foreign Key Cascade Deletes: Un-Indexed FKs, Slow Cascades, and Lock Contention in PostgreSQL

MySQL to PostgreSQL Schema Conversion: What Each Column Type Should Become, and What Silently Changes

SARGable Queries in SQL Server: Why Functions in WHERE Slow You Down

Teaching yourself SQL when your job is ops

Use INSERT WITH CHECK and UPDATE USING to allow owner-on-create but block owner transfers