Database-driven realtime architectures: building a serverless and editable chat app - Part 1

This article discusses the architecture and implementation of a serverless editable chat app using database-driven realtime messaging. The main components include NuxtJS for frontend web development, Ably for enabling pub/sub pattern, AWS Lambda functions to insert and update rows in PostgresDB, hosted on AWS RDS, Ably Postgres connector to watch changes on the database tables and publish messages on every change, AWS Fargate with AWS ECS and AWS ECR to deploy the Ably Postgres connector's dockerized image, Netlify to host the static Jamstack site, and Netlify functions to enable a token auth endpoint to authenticate with Ably. The Ably Postgres connector is a key dependency that makes this architecture possible.