Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations
Cover image for SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations
mazinocodes profile

SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations

#sql #postgres #database #beginners
30
Comments
3 min read
Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)
Cover image for Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)
mazinocodes profile

Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)

#oracle #sql #beginners #database
29
Comments 2
3 min read
Understanding the core mechanics of ThingsDB
Cover image for Understanding the core mechanics of ThingsDB
joente profile

Understanding the core mechanics of ThingsDB

#architecture #database #systemdesign
4
Comments
4 min read
How to effectively monitor regular backups
Cover image for How to effectively monitor regular backups
lmadev profile

How to effectively monitor regular backups

#devops #database #crontab #monitoring
1
Comments 5
4 min read
Introducing Supabase ETL
Cover image for Introducing Supabase ETL
yuricodesbot profile

Introducing Supabase ETL

#vectordatabase #ai #programming #database
6
Comments
4 min read
Subqueries vs JOINs: When to Use Each in SQL
hinlocaesar profile

Subqueries vs JOINs: When to Use Each in SQL

#beginners #database #performance #sql
1
Comments
4 min read
Breaking data for fun
Cover image for Breaking data for fun
islamov profile

Breaking data for fun

#data #database #programming #tutorial
Comments
9 min read
easy-query ORM: EF Core for Java
dev-jack profile

easy-query ORM: EF Core for Java

#tooling #database #java #opensource
Comments
3 min read
Building AppReviews: the stack, the choices, and the compromises
quentin23soleil profile

Building AppReviews: the stack, the choices, and the compromises

#programming #webdev #frontend #database
Comments
5 min read
Explicit Locking, Deadlocks, and Linux Lock Primitives in SQLite
Cover image for Explicit Locking, Deadlocks, and Linux Lock Primitives in SQLite
lovestaco profile

Explicit Locking, Deadlocks, and Linux Lock Primitives in SQLite

#webdev #programming #database #architecture
15
Comments 2
5 min read
SQL Access for AI Agents — Flexibility with Guardrails
Cover image for SQL Access for AI Agents — Flexibility with Guardrails
sanchar10 profile

SQL Access for AI Agents — Flexibility with Guardrails

#mcp #dotnet #database #architecture
Comments
2 min read
PostgreSQL backup verification — How to test and validate your PostgreSQL backups
Cover image for PostgreSQL backup verification — How to test and validate your PostgreSQL backups
piteradyson profile

PostgreSQL backup verification — How to test and validate your PostgreSQL backups

#database #postgres
3
Comments
9 min read
Migrate the legacy Greenplum to Apache Cloudberry with cbcopy
maya_sun_29e7bf629e5dd7b3 profile

Migrate the legacy Greenplum to Apache Cloudberry with cbcopy

#database #dataengineering #postgres #opensource
Comments
7 min read
Table Design: Database Fundamentals to Know as a Beginner
Cover image for Table Design: Database Fundamentals to Know as a Beginner
mazinocodes profile

Table Design: Database Fundamentals to Know as a Beginner

#sql #database #beginners #learning
27
Comments 2
4 min read
The Long Tail Problem: Handling Obscure Queries in Data-Driven Apps
ffteamnames profile

The Long Tail Problem: Handling Obscure Queries in Data-Driven Apps

#architecture #database #performance
Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.