sailfork / t3code-github / .repos/ alchemy-effect/ examples/ cloudflare-hyperdrive-aws-vpc/ src/ Database.ts

import * as AWS from "@alchemy.run/aws";
import * as Alchemy from "alchemy";
import * as Output from "alchemy/Output";
import * as Effect from "effect/Effect";
import * as Redacted from "effect/Redacted";

export const DB_USER = "app";
export const DB_NAME = "app";

/**
 * A VPC with public subnets (for the tunnel connector) and private subnets
 * (for Aurora). Nothing in the private subnets is reachable from the internet.
 */
export const Network = AWS.EC2.Network("Network", {
  cidrBlock: "10.63.0.0/16",
  availabilityZones: 2,
});

/** Security group for the `cloudflared` connector — outbound only. */
export const ConnectorSecurityGroup = Effect.gen(function* () {
  const network = yield* Network;
  return yield* AWS.EC2.SecurityGroup("ConnectorSecurityGroup", {
    vpcId: network.vpcId,
    description: "cloudflared connector; no inbound connections",
  });
});

/** Database password, generated once and kept in state. */
export const DbPassword = Alchemy.Random("DbPassword", { bytes: 24 });

/** Private Aurora PostgreSQL that only admits the connector. */
export const Database = Effect.gen(function* () {
  const network = yield* Network;
  const connector = yield* ConnectorSecurityGroup;
  const password = yield* DbPassword;
  const dbSecurityGroup = yield* AWS.EC2.SecurityGroup("DatabaseSecurityGroup", {
    vpcId: network.vpcId,
    description: "Postgres from the cloudflared connector only",
    ingress: [
      {
        ipProtocol: "tcp",
        fromPort: 5432,
        toPort: 5432,
        referencedGroupId: connector.groupId,
      },
    ],
  });
  const secret = yield* AWS.SecretsManager.Secret("DatabaseSecret", {
    secretString: Output.map(password.text, (password) =>
      Redacted.make(JSON.stringify({ username: DB_USER, password: Redacted.value(password) })),
    ),
  });
  return yield* AWS.RDS.Aurora("Database", {
    databaseName: DB_NAME,
    engine: "aurora-postgresql",
    engineVersion: "17.5",
    subnetIds: network.privateSubnetIds,
    securityGroupIds: [dbSecurityGroup.groupId],
    secret: { resource: secret },
    instance: { dbInstanceClass: "db.serverless", publiclyAccessible: false },
  });
});