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.
I built 'Ask Your Life' — a personal Coral agent that answers questions about your money & deadlines with SQL
sahil9001 profile

I built 'Ask Your Life' — a personal Coral agent that answers questions about your money & deadlines with SQL

#ai #sql #webdev #hackathon
Comments
8 min read
Troubleshooting oracle database replication issues.
doreen970 profile

Troubleshooting oracle database replication issues.

#database #highavailability #sql
1
Comments
4 min read
Vector‑native RAG on Oracle: embeddings, HNSW/IVF, and hybrid search under database governance
mark_nelson_oracle profile

Vector‑native RAG on Oracle: embeddings, HNSW/IVF, and hybrid search under database governance

#ai #database #rag #sql
Comments
12 min read
SiteRows example #1:
michael_ozersky_9624310ec profile

SiteRows example #1:

#showdev #python #sql #webscraping
Comments
1 min read
SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns
soytuber profile
soy

SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns

#database #sql #sqlite
Comments
3 min read
Introducing Oracle Support in Dory
doryfinn profile
Finn

Introducing Oracle Support in Dory

#ai #database #sql #oracle
Comments
4 min read
DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives
soytuber profile
soy

DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives

#database #sql #sqlite
Comments
3 min read
Safer NL2SQL with Select AI and AI Profiles
mark_nelson_oracle profile

Safer NL2SQL with Select AI and AI Profiles

#ai #database #security #sql
Comments
10 min read
What Actually Helped Our Talk-to-DB Agent Stop Relearning the Same SQL
zeeshan_ghazanfar_97 profile

What Actually Helped Our Talk-to-DB Agent Stop Relearning the Same SQL

#agents #llm #rag #sql
Comments
1 min read
How to Use EXPLAIN ANALYZE in PostgreSQL: A Visual Guide
leoj profile
LeoJ

How to Use EXPLAIN ANALYZE in PostgreSQL: A Visual Guide

#postgres #sql #database #performance
Comments
5 min read
How I Built a Live SQL Workshop Where Students Can't Break Anything
hedi22 profile

How I Built a Live SQL Workshop Where Students Can't Break Anything

#sql #development #database #devtool
Comments
6 min read
SchemaSpy vs SchemaCrawler - Which Database Documentation Tool is Right for You?
sualeh profile

SchemaSpy vs SchemaCrawler - Which Database Documentation Tool is Right for You?

#database #devops #sql #opensource
6
Comments 2
3 min read
SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec
soytuber profile
soy

SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec

#database #sql #sqlite
Comments
3 min read
Infinite recursion in Postgres RLS: a SECURITY DEFINER gotcha
bairescodeai profile

Infinite recursion in Postgres RLS: a SECURITY DEFINER gotcha

#postgres #supabase #webdev #sql
Comments
2 min read
Chai aur SQL — A Beginner's Journey into Databases
abdulrdeveloper profile

Chai aur SQL — A Beginner's Journey into Databases

#sql #postgres #database #backend
Comments
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.