RDS Free Tier

import { RdsInstance } from "@fjall/components-infrastructure/lib/resources/aws/database/rdsInstance";

const database = new RdsInstance(this, "DevDatabase", {
  vpc: myVpc,
  databaseName: "development",
  instanceType: "t4g.micro",
  allocatedStorage: 20,
  multiAz: false,
  proxy: false,
  readReplica: false,
  databaseInsights: false,
});

const database = new RdsInstance(this, "SecureFreeDB", {
  vpc: vpc,
  databaseName: "secure",
  instanceType: "t4g.micro",
  allocatedStorage: 20,
  multiAz: false,
  proxy: false,
  readReplica: false,
  databaseInsights: false,
});

const database = new RdsInstance(this, "FreeDB", {
  vpc: vpc,
  databaseName: "app",
  instanceType: "t4g.micro",
  allocatedStorage: 20,
  multiAz: false,
  proxy: false,
  readReplica: false,
  databaseInsights: false,
});

// Allow access from application
app.connections.allowTo(database, Port.tcp(35255), "App to database");

const endpoint = database.getHostEndpoint();
// Returns: Direct instance endpoint

const port = database.getHostPort();
// Returns: "35255" (default, as string)

const credentials = database.getCredentials();
// Returns: Secret object with username/password

const connections = database.connections;
// Use for network access control

import { RdsInstance } from "@fjall/components-infrastructure/lib/resources/aws/database/rdsInstance";
import { Vpc, SubnetType, Port } from "aws-cdk-lib/aws-ec2";
import { Duration } from "aws-cdk-lib";
import { CfnOutput } from "aws-cdk-lib";

// Create VPC
const vpc = new Vpc(this, "DevVpc", {
  maxAzs: 2,
  natGateways: 0,
  subnetConfiguration: [
    {
      name: "public",
      subnetType: SubnetType.PUBLIC,
    },
    {
      name: "isolated",
      subnetType: SubnetType.PRIVATE_ISOLATED,
    },
  ],
});

// Create free-tier database
const database = new RdsInstance(this, "DevDatabase", {
  vpc: vpc,
  databaseName: "development",
  instanceType: "t4g.micro",
  allocatedStorage: 20,
  multiAz: false,
  proxy: false,
  readReplica: false,
  databaseInsights: false,
  backupRetention: Duration.days(7),
});

// Output connection details
new CfnOutput(this, "DatabaseEndpoint", {
  value: database.getHostEndpoint(),
  description: "Database endpoint",
});

new CfnOutput(this, "DatabasePort", {
  value: database.getHostPort(),
  description: "Database port",
});

const database = new RdsInstance(this, "ProdDB", {
  vpc: vpc,
  databaseName: "production",
  instanceType: "t4g.large", // Upgrade size
  multiAz: true, // Add high availability
  proxy: {
    // Add connection pooling
    requireTLS: true,
  },
  readReplica: {
    // Add read scaling
    instanceType: "t4g.large",
  },
});