Exploring Hasura as a data access layer in serverless architecture

This tutorial explores the use of Hasura as a data access layer in serverless architecture. The author discusses their experience using GraphQL and AWS Lambda for a niche CRM tool with inconsistent traffic patterns, highlighting challenges faced such as complex SQL queries, N+1 query problem, lack of database connection pooling, issues with VPCs, and cold start issue. They then describe how Hasura resolved these issues by acting as a data access layer in front of their Postgres database within the VPC, offering benefits like DB connection pooling, access to Postgres from lambda without deploying inside VPC, simpler SQL query building for GraphQL resolvers, and solution to N+1 query issue. The author also mentions current challenges faced with graphql query injection and public port in VPC but overall concludes that Hasura has been reliable and stable for their needs.