DEV Community

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
GBase 8a: When to Materialise Intermediate Results and How to Manage Temporary Tables

GBase 8a: When to Materialise Intermediate Results and How to Manage Temporary Tables

2
Comments
3 min read
When GBase 8a Parameters "Changed" But Queries Stayed the Same

When GBase 8a Parameters "Changed" But Queries Stayed the Same

2
Comments
3 min read
The Database Architect Teaches His Nephew: Where the Real Interview Happens

The Database Architect Teaches His Nephew: Where the Real Interview Happens

4
Comments
20 min read
SQL seguro con IA: cómo construir un asistente que valida las consultas antes de ejecutarlas

SQL seguro con IA: cómo construir un asistente que valida las consultas antes de ejecutarlas

1
Comments 1
7 min read
Stop Concatenating SQL Strings in Go — Dynamic Queries Done Right

Stop Concatenating SQL Strings in Go — Dynamic Queries Done Right

2
Comments
8 min read
PostgreSQL 0A000 오류 원인과 해결 방법 완벽 가이드

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

Comments
2 min read
Oracle ORA-00202 오류 원인과 해결 방법 완벽 가이드

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

Comments
2 min read
Query one Apache Iceberg table from Trino, Spark, and DuckDB

Query one Apache Iceberg table from Trino, Spark, and DuckDB

Comments
3 min read
SQLite AND Clause Bug, PostgreSQL 17 GUCs, and AI-Found CVEs in PG

SQLite AND Clause Bug, PostgreSQL 17 GUCs, and AI-Found CVEs in PG

Comments
3 min read
Oracle ORA-00203 Error: Causes and Solutions Complete Guide

Oracle ORA-00203 Error: Causes and Solutions Complete Guide

Comments
3 min read
Connecting to Redis cache and working with it

Connecting to Redis cache and working with it

Comments
2 min read
I reached for MongoDB out of habit. Postgres JSONB was the answer.

I reached for MongoDB out of habit. Postgres JSONB was the answer.

Comments
3 min read
PostgreSQL 09000 오류 원인과 해결 방법 완벽 가이드

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

Comments
2 min read
How to create Custom User Models in Django framework?

How to create Custom User Models in Django framework?

1
Comments
2 min read
I tried to hide semantic meaning from embeddings without breaking search

I tried to hide semantic meaning from embeddings without breaking search

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