Anonymous View

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.
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
PostgreSQL 01007 오류 원인과 해결 방법 완벽 가이드
dbmserror profile

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

#postgres #database #dba #sql
Comments
2 min read
Detecting fraud rings: the social-graph problem in disguise
fixelsmith profile

Detecting fraud rings: the social-graph problem in disguise

#sql #analytics #frauddetection #database
Comments
6 min read
DuckDB 1.5.2 Release, DuckLake v1.0 & PostgRESTxn for Atomic PG Transactions
soytuber profile
soy

DuckDB 1.5.2 Release, DuckLake v1.0 & PostgRESTxn for Atomic PG Transactions

#database #sql #sqlite
Comments
4 min read
How to prepare for a Data Engineering Interview
moisha_karole_323093af123 profile

How to prepare for a Data Engineering Interview

#career #dataengineering #interview #sql
Comments
2 min read
Building an African Economic Data Pipeline with Python, DuckDB & World Bank API
hajirufai profile

Building an African Economic Data Pipeline with Python, DuckDB & World Bank API

#dataengineering #python #sql #tutorial
Comments
4 min read
PostgreSQL 17 in Production: Partitioning Improvements, COPY Progress, and the Features That Actually Matter
zny10289 profile
ZNY

PostgreSQL 17 in Production: Partitioning Improvements, COPY Progress, and the Features That Actually Matter

#database #performance #postgres #sql
Comments
4 min read
PostgreSQL 17 in Production: Partitioning Improvements, COPY Progress, and the Features That Actually Matter
zny10289 profile
ZNY

PostgreSQL 17 in Production: Partitioning Improvements, COPY Progress, and the Features That Actually Matter

#database #performance #postgres #sql
Comments
4 min read
PostgreSQL 0100C 오류 원인과 해결 방법 완벽 가이드
dbmserror profile

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

#postgres #database #dba #sql
Comments
2 min read
01000 오류 원인과 해결 방법 완벽 가이드
dbmserror profile

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

#postgres #database #dba #sql
Comments
3 min read
ORA-00017 오류 원인과 해결 방법 완벽 가이드
dbmserror profile

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

#oracle #database #dba #sql
Comments
3 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
1
Comments
12 min read
DuckDB 1.5.3 Adds Quack Client-Server, SQLite Gets Cypher Graph Extension
soytuber profile
soy

DuckDB 1.5.3 Adds Quack Client-Server, SQLite Gets Cypher Graph Extension

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