Database Lab

LAB / EXPLORATION

Relational and Document Database Practice
Hands-on database laboratory for SQL, PostgreSQL, MongoDB, modeling, and query practice.

ACTIVE LAB

Create a repeatable hands-on environment for learning database commands, modeling, queries, and application integration. The implementation is active.

ACTIVE LAB

Database Lab

Create a repeatable hands-on environment for learning database commands, modeling, queries, and application integration. The implementation is active.

Purpose & Learning Objectives

Why this project exists and what the implementation should teach.

Purpose / Learning

Purpose

Create a repeatable hands-on environment for learning database commands, modeling, queries, and application integration.

Learning Objectives

Practice SQL beyond memorized syntax.
Compare relational and document database modeling.
Run PostgreSQL and MongoDB locally.
Use Docker for reproducible database services.
Design realistic development-oriented sample data.
Connect later applications to both relational and document stores.
Document common commands and failure recovery.

Technology Plan

Current, planned, legacy, or candidate technologies for this project.

Relational

SQL
PostgreSQL

Document

MongoDB
JSON

Environment

Docker

Integration Candidates

Node.js
TypeScript

Implementation Scope

Planned behaviors, architecture decisions, and evidence this project should produce.

PostgreSQL track

Build relational schemas and practical web-development queries.

MongoDB track

Compare document-oriented storage against relational assumptions.

Docker environment

Keep services reproducible and disposable.

Application integration

Use small Node/TypeScript experiments to connect to each database.

Project Notes

Implementation context, boundaries, and later expansion.

Project Notes

Current State

The local MongoDB environment has already been started through Docker Compose.

Learning Goal

Use the same sample domain in PostgreSQL and MongoDB so modeling differences remain visible.