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.
Fifteen Chinese cities have more sights than beds — and that is a feature, not a gap
sinostay profile

Fifteen Chinese cities have more sights than beds — and that is a feature, not a gap

#data #database #sql #travel
Comments
2 min read
PGHist | History and audit of table changes in PostgreSQL
pgsuite profile

PGHist | History and audit of table changes in PostgreSQL

#postgres #opensource #sql #database
Comments
3 min read
Rules-Only or LLM Judge? A Scoring Harness for the Second Reviewer of Agent SQL
dataio_4921 profile

Rules-Only or LLM Judge? A Scoring Harness for the Second Reviewer of Agent SQL

#sql #ai #testing #database
Comments
7 min read
# From Database Tables to Long-Term Memory with Hindsight
karan_sai_afad14dca87898f profile

# From Database Tables to Long-Term Memory with Hindsight

#postgressql #sql #mysql
Comments
8 min read
PostgreSQL for Beginners: A Serious Database That Is Free and Grows With You
arhan_khan profile

PostgreSQL for Beginners: A Serious Database That Is Free and Grows With You

#postgres #sql #database #beginners
Comments
2 min read
What Really Happens After You Execute a SQL Query in Oracle?
tharun_parepalli profile

What Really Happens After You Execute a SQL Query in Oracle?

#oracle #sql #database #performance
Comments
4 min read
Building a Backup and Disaster Recovery Readiness Checker with Oracle AI Database 26ai
abdulrawoftotakhil profile

Building a Backup and Disaster Recovery Readiness Checker with Oracle AI Database 26ai

#ai #database #sql #tutorial
Comments
6 min read
SQL Challenge #95: BETWEEN With Dates — Can It Miss Records?
kailas_warade_d2a15d1ef8a profile

SQL Challenge #95: BETWEEN With Dates — Can It Miss Records?

#sql #database #programming #tutorial
Comments 1
2 min read
CREATE INDEX CONCURRENTLY Failed. The INVALID Index It Left Can Still Tax Every Write
gabrielanhaia profile

CREATE INDEX CONCURRENTLY Failed. The INVALID Index It Left Can Still Tax Every Write

#postgres #database #sql #devops
1
Comments
9 min read
Como aprendi Apache Spark — Parte 17: Airflow, CI/CD e DataOps
renanpyd profile

Como aprendi Apache Spark — Parte 17: Airflow, CI/CD e DataOps

#python #sql #bigdata #spark
Comments
16 min read
A Version Check Won't Recover a Lost Response
smtasker profile

A Version Check Won't Recover a Lost Response

#mcp #python #sql #testing
Comments
10 min read
Como aprendi Apache Spark — Parte 16: Apache Kafka, CDC e pipelines incrementais
renanpyd profile

Como aprendi Apache Spark — Parte 16: Apache Kafka, CDC e pipelines incrementais

#python #spark #bigdata #sql
Comments
19 min read
Como aprendi Apache Spark — Parte 15: Structured Streaming, Watermarks e Checkpoints
renanpyd profile

Como aprendi Apache Spark — Parte 15: Structured Streaming, Watermarks e Checkpoints

#bigdata #python #sql #apache
Comments
18 min read
Behind ACID: How Databases Actually Implement the 4 Guarantees
binarydose profile

Behind ACID: How Databases Actually Implement the 4 Guarantees

#dbms #database #systemdesign #sql
Comments
2 min read
I counted which languages people make AI songs in: 10,725 songs, 75 languages, 30 days
rakim777 profile
Rakim

I counted which languages people make AI songs in: 10,725 songs, 75 languages, 30 days

#showdev #data #music #sql
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.