Demonstrate Outbox Pattern by combining Retool, Neon database, a message broker, and Google Functions

TLDR: This tutorial provides a step-by-step guide on extending a Retool CRUD application, transforming it into an event-driven application. It not only saves data into a datastore but also publishes data changes into a message broker for further processing.

Challenge: After saving data into a datastore, there is often a need to pass the data to another system for processing and subsequently save the result. For instance, writing to a PostgreSQL database and publishing changes into a message broker like Kafka or AWS SNS, and then processing these with something like AWS Lambda function.

Solution: In this tutorial, we utilized Retool for data entry and visualization, Neon for data storage, a message broker to capture data changes, Google Functions to process these changes and store the results, and Diagrid Catalyst as the glue connecting these systems together.

For the full details and step-by-step instructions, check out the tutorial on our blog: [Transforming CRUD to Event-Driven: Using the Outbox Pattern to Combine Retool, Neon, and Google Functions | Diagrid Blog].

Let me know what you think.
Bilgin

1 Like