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.
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
SQL + AI: Real-World Database Solutions You Can Use Today
andrecarbajal profile

SQL + AI: Real-World Database Solutions You Can Use Today

#sql #ai #database #postgres
1
Comments
9 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
Day 83 of Learning MERN Stack
ali_hamza_589ec7b3eb6688d profile

Day 83 of Learning MERN Stack

#sql #backend #database #softwareengineering
1
Comments
2 min read
Day 81 of Learning MERN Stack
ali_hamza_589ec7b3eb6688d profile

Day 81 of Learning MERN Stack

#sql #groupby #database #programming
1
Comments
2 min read
DuckDB Streaming Data Lakes, PostgreSQL 19 REPACK CONCURRENTLY, & AI Framework
soytuber profile
soy

DuckDB Streaming Data Lakes, PostgreSQL 19 REPACK CONCURRENTLY, & AI Framework

#database #sql #sqlite
Comments
3 min read
Day 78 of Learning MERN Stack
ali_hamza_589ec7b3eb6688d profile

Day 78 of Learning MERN Stack

#sql #backend #database #architecture
1
Comments
1 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
Agent‑safe change delivery on Oracle: discovery, online mechanics, idempotent migrations, and provable rollbacks
mark_nelson_oracle profile

Agent‑safe change delivery on Oracle: discovery, online mechanics, idempotent migrations, and provable rollbacks

#agents #database #devops #sql
Comments
17 min read
Why Enterprises Should Not Let LLMs Execute SQL Directly?
_706015150500ca0399b12 profile

Why Enterprises Should Not Let LLMs Execute SQL Directly?

#architecture #llm #security #sql
Comments
1 min read
Oracle ORA-00021 오류 원인과 해결 방법 완벽 가이드
dbmserror profile

Oracle ORA-00021 오류 원인과 해결 방법 완벽 가이드

#oracle #database #dba #sql
Comments
3 min read
Day 82 of Learning MERN Stack
ali_hamza_589ec7b3eb6688d profile

Day 82 of Learning MERN Stack

#sql #backend #database #programming
1
Comments
1 min read
PostgreSQL 01007 오류 원인과 해결 방법 완벽 가이드
dbmserror profile

PostgreSQL 01007 오류 원인과 해결 방법 완벽 가이드

#postgres #database #dba #sql
Comments
2 min read
Day 80 of Learning MERN Stack
ali_hamza_589ec7b3eb6688d profile

Day 80 of Learning MERN Stack

#sql #backend #database #programming
1
Comments
2 min read
sqlex — A Modern Drop-in Replacement for jmoiron/sqlx
suiriass profile

sqlex — A Modern Drop-in Replacement for jmoiron/sqlx

#go #database #sql #opensource
5
Comments 2
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.