Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
First/Last per Group: PostgreSQL DISTINCT ON and MongoDB DISTINCT_SCAN Performance
Cover image for First/Last per Group: PostgreSQL DISTINCT ON and MongoDB DISTINCT_SCAN Performance

First/Last per Group: PostgreSQL DISTINCT ON and MongoDB DISTINCT_SCAN Performance

Comments
5 min read
Cursor & Trigger in SQL with Examples

Cursor & Trigger in SQL with Examples

Comments
2 min read
Why Feedback Loops Matter in Data Annotation Platforms

Why Feedback Loops Matter in Data Annotation Platforms

4
Comments 5
5 min read
Persisting data in Rust with Heave

Persisting data in Rust with Heave

2
Comments
4 min read
AWS Use Cases | Why Focus on Access Patterns (Reads) Instead of Writes in DynamoDB Modelling

AWS Use Cases | Why Focus on Access Patterns (Reads) Instead of Writes in DynamoDB Modelling

1
Comments
8 min read
MySQL Queries

MySQL Queries

Comments
3 min read
ACID Properties with SQL Transactions in DBMS
Cover image for ACID Properties with SQL Transactions in DBMS

ACID Properties with SQL Transactions in DBMS

Comments
2 min read
The Database Zoo: Probabilistic / Approximate Databases
Cover image for The Database Zoo: Probabilistic / Approximate Databases

The Database Zoo: Probabilistic / Approximate Databases

Comments
14 min read
Simple College Student Schema in MongoDB

Simple College Student Schema in MongoDB

1
Comments
2 min read
AWS Use Cases | Why choose single table design in DynamoDB (and why not)?
Cover image for AWS Use Cases | Why choose single table design in DynamoDB (and why not)?

AWS Use Cases | Why choose single table design in DynamoDB (and why not)?

1
Comments
6 min read
Skip Elasticsearch: Build Blazing-Fast Full-Text Search Right in Supabase
Cover image for Skip Elasticsearch: Build Blazing-Fast Full-Text Search Right in Supabase

Skip Elasticsearch: Build Blazing-Fast Full-Text Search Right in Supabase

2
Comments
11 min read
Skapi vs Firebase vs Supabase: Choosing the Best Backend for Performance and Scalability
Cover image for Skapi vs Firebase vs Supabase: Choosing the Best Backend for Performance and Scalability

Skapi vs Firebase vs Supabase: Choosing the Best Backend for Performance and Scalability

1
Comments
5 min read
ACID Properties with SQL Transactions in DBMS
Cover image for ACID Properties with SQL Transactions in DBMS

ACID Properties with SQL Transactions in DBMS

6
Comments
2 min read
Automated Database Administration: 5 AI-Powered Tools that Slash Manual Overhead and Boost Reliability

Automated Database Administration: 5 AI-Powered Tools that Slash Manual Overhead and Boost Reliability

Comments
9 min read
Pk vs Fk 🔑
Cover image for Pk vs Fk 🔑

Pk vs Fk 🔑

Comments
2 min read
Understanding ACID Properties with SQL Transactions

Understanding ACID Properties with SQL Transactions

Comments
3 min read
Beyond Flat Tables: Model Hierarchical Data in Supabase with Recursive Queries
Cover image for Beyond Flat Tables: Model Hierarchical Data in Supabase with Recursive Queries

Beyond Flat Tables: Model Hierarchical Data in Supabase with Recursive Queries

2
Comments
7 min read
How to Install PostgreSQL 18 on Ubuntu 24.04

How to Install PostgreSQL 18 on Ubuntu 24.04

6
Comments 2
5 min read
Mastering EF Core Pagination: Efficient Data Retrieval

Mastering EF Core Pagination: Efficient Data Retrieval

2
Comments
3 min read
A Note on Taking Backups from Standby

A Note on Taking Backups from Standby

Comments
2 min read
Marketing, Free Tiers, and the Tools Junior Devs Grow Into Seniors With
Cover image for Marketing, Free Tiers, and the Tools Junior Devs Grow Into Seniors With

Marketing, Free Tiers, and the Tools Junior Devs Grow Into Seniors With

Comments
2 min read
SQL Commands Explained: DDL vs DML vs DQL vs DCL vs TCL

SQL Commands Explained: DDL vs DML vs DQL vs DCL vs TCL

Comments
3 min read
A simplified definition of an ORM
Cover image for A simplified definition of an ORM

A simplified definition of an ORM

Comments
2 min read
Why Databricks Is Worth $100 Billion?

Why Databricks Is Worth $100 Billion?

1
Comments
7 min read
What’s New in Oracle Database 23ai

What’s New in Oracle Database 23ai

1
Comments
4 min read
loading...