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 vs. NoSQL | Schema Design Differences Explained Visually
Cover image for SQL vs. NoSQL | Schema Design Differences Explained Visually

SQL vs. NoSQL | Schema Design Differences Explained Visually

13
Comments 2
5 min read
Storing AWR Snapshots Outside SYSAUX

Storing AWR Snapshots Outside SYSAUX

Comments 2
2 min read
How to handle files?
Cover image for How to handle files?

How to handle files?

1
Comments
50 min read
Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22
Cover image for Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

6
Comments 1
2 min read
Database Security in DBMS
Cover image for Database Security in DBMS

Database Security in DBMS

1
Comments
6 min read
NoSQL Databases Explained: Types, Use Cases & Core Characteristics
Cover image for NoSQL Databases Explained: Types, Use Cases & Core Characteristics

NoSQL Databases Explained: Types, Use Cases & Core Characteristics

1
Comments 1
1 min read
Enhance your musical skills with Surrealist’s Graph View
Cover image for Enhance your musical skills with Surrealist’s Graph View

Enhance your musical skills with Surrealist’s Graph View

10
Comments 2
9 min read
PostgreSQL UUID Performance: Benchmarking Random (v4) and Time-based (v7) UUIDs
Cover image for PostgreSQL UUID Performance: Benchmarking Random (v4) and Time-based (v7) UUIDs

PostgreSQL UUID Performance: Benchmarking Random (v4) and Time-based (v7) UUIDs

24
Comments 3
12 min read
Data Security & Authorization: The Dual Pillars of a Robust Database System

Data Security & Authorization: The Dual Pillars of a Robust Database System

Comments 1
2 min read
SQL vs NoSQL

SQL vs NoSQL

1
Comments
3 min read
The Database Meets the Lakehouse: Toward a Unified Architecture for Modern Applications
Cover image for The Database Meets the Lakehouse: Toward a Unified Architecture for Modern Applications

The Database Meets the Lakehouse: Toward a Unified Architecture for Modern Applications

4
Comments 3
6 min read
🚨 Cyber Attack Alert
Cover image for 🚨 Cyber Attack Alert

🚨 Cyber Attack Alert

2
Comments
1 min read
Why NewSQL Is the Next Big Thing in Database Technology

Why NewSQL Is the Next Big Thing in Database Technology

Comments
1 min read
Can You Run a MariaDB Cluster on a $150 Kubernetes Lab? I Gave It a Shot

Can You Run a MariaDB Cluster on a $150 Kubernetes Lab? I Gave It a Shot

1
Comments
10 min read
Turning Your Database Into an MCP Server With Auth
Cover image for Turning Your Database Into an MCP Server With Auth

Turning Your Database Into an MCP Server With Auth

129
Comments 8
11 min read
🚀 Yo devs, wanna build collab apps that SLAP? Meet Jazz: the Real-Time Collab Framework That’s Straight Fire 🔥

🚀 Yo devs, wanna build collab apps that SLAP? Meet Jazz: the Real-Time Collab Framework That’s Straight Fire 🔥

Comments
2 min read
Aggregate according to Time Interval — From SQL to SPL #27
Cover image for Aggregate according to Time Interval — From SQL to SPL #27

Aggregate according to Time Interval — From SQL to SPL #27

9
Comments 3
2 min read
Design Database Schemas Without Internet Connection
Cover image for Design Database Schemas Without Internet Connection

Design Database Schemas Without Internet Connection

10
Comments 3
3 min read
Indexing for New Use Cases Within the MongoDB Document Model (tutorial)
Cover image for Indexing for New Use Cases Within the MongoDB Document Model (tutorial)

Indexing for New Use Cases Within the MongoDB Document Model (tutorial)

9
Comments
3 min read
Sampling Without Index

Sampling Without Index

5
Comments
2 min read
Search Index for Reporting

Search Index for Reporting

5
Comments
2 min read
MongoDB Relationships - Embedded vs Referenced | Tutorial 2025
Cover image for MongoDB Relationships - Embedded vs Referenced | Tutorial 2025

MongoDB Relationships - Embedded vs Referenced | Tutorial 2025

7
Comments 1
4 min read
How PostgreSQL logical decoding and plugins work
Cover image for How PostgreSQL logical decoding and plugins work

How PostgreSQL logical decoding and plugins work

1
Comments
6 min read
Why Denormalizing in ClickHouse will come back to bite you

Why Denormalizing in ClickHouse will come back to bite you

Comments
3 min read
Kapper benchmarks - how does Kapper 1.3 compare to the competition?
Cover image for Kapper benchmarks - how does Kapper 1.3 compare to the competition?

Kapper benchmarks - how does Kapper 1.3 compare to the competition?

Comments
8 min read
loading...