#Postgres

3 posts tagged Postgres

Standing Up the Database, Part 2: Cloud SQL on a Private Network, Step by Step

The cloud half of the DB: enabling GCP APIs, choosing the cheapest Cloud SQL tier and why, Private Service Connect with no public IP, serverless VPC egress, and migrating a database you cannot reach from your laptop.

PostgresGCPCloud SQLNetworking

Standing Up the Database, Part 1: From In-Memory Mock to Local Postgres

14 min read

Replacing an in-memory mock with local Postgres: Docker, a Drizzle schema and first migration, seeding, swapping the data layer, and designing for private-network cloud access.

PostgresDrizzleDockerDatabase

Picking the Stack for an Internal Workflow Tool

11 min read

Walking through the cloud, database, framework, and surrounding choices for a small internal tool on GCP. Why Cloud Run instead of GKE, why Postgres instead of NoSQL, why skip Redis, and the rest of the decisions worth thinking through before writing code.

GCPNext.jsPostgresArchitecture