Skip to content

DBOS-Cloud app which queries a Supabase Postgres table and inserts the counted data to another table.

Notifications You must be signed in to change notification settings

weisisheng/aggdata-supabase-public

Repository files navigation

DBOS-Cloud: Fast and Free Automatic Supabase Table Copier

This is a simple DBOS app example focusing on remote deployment to DBOS Cloud, their hosted solution with a generous free tier for devs.

The github repo sets up a cron job which: 1) performs a "SELECT COUNT" on a Supabase Postgres database table and 2) an "INSERT" to a second table. Consider it a starter for a poor man's data lake aggregating data in the receiving table.

Note: This is not the fastest, most compact and recommended way to create this workflow. DBOS-Cloud has terrific in-app full Postgres database functionality. Check out the transactions section for more. I built the script this way since I had pre-existing data stored on Supabase.

Get more details on the dev.to article: DBOS-Cloud: Fast and Free Automatic Data Aggregator

About

DBOS-Cloud app which queries a Supabase Postgres table and inserts the counted data to another table.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published