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.
How Character Sets, Collations, and String Comparisons Cause Subtle Data Drift in GBase 8a

How Character Sets, Collations, and String Comparisons Cause Subtle Data Drift in GBase 8a

2
Comments
4 min read
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
Oracle ORA-00202 오류 원인과 해결 방법 완벽 가이드

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

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

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

Comments
2 min read
How I Swapped My Entire Database in One Afternoon

How I Swapped My Entire Database in One Afternoon

Comments
4 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
Oracle ORA-00203 Error: Causes and Solutions Complete Guide

Oracle ORA-00203 Error: Causes and Solutions Complete Guide

Comments
3 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
Connecting to Redis cache and working with it

Connecting to Redis cache and working with it

Comments
2 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.