In my last blog post I introduced some geospatial
analysis concepts and how the Irish population has moved towards Dublin since the mid 1800s. I’ll continue on
this theme in later posts but first I’ll introduce the new Cloud Development Kit from AWS and how to provision a
Postgis enabled Postgres database.
CDK provides many high level components to allow rapid code development requiring much less input compared to
the typical CloudFormation templates. CDK is available in TypeScript, Python, Java and C#.
I’ve built a python CDK repo where two stacks provision
an Amazon Virtual Private Cloud (VPC) with a Bastion host and a Postgres database using Amazon Relational Database
Service (RDS) (provisioned or serverless). The README of the repo contains details of deploying the stacks and
accessing the Aurora Serverless postgres database including how you can use AWS secrets and sessions managers to
access the database instance. The README also contains tons of links to blog posts on the CDK topic.
Hopefully this post and repo has given you a feel for CDK in AWS and how it is now just a couple of
clicks to get a serverless database up and running. In future posts I’ll introduce spatial functions within Postgis,
spatial datasets available, and explore trends and ways of visualising spatial data.