pgflow
LightNews LightNews
pgflow.bsky.social
pgflow
@pgflow.bsky.social
16 followers 18 following 28 posts
Postgres-centric workflow Engine with deep Supabase integration. https://pgflow.dev
Posts Replies Media Videos
pgflow.bsky.social
Just merged the new Flow DSL in pgflow! 🚀

Next up: Edge Worker refactor to make it run flows defined with the DSL.

Check out the snippet for a simple AI web-scraping flow. 🤖
Example code snippet: // Provide a type for the input of the Flow type Input = { url: string; }; export const AnalyzeWebsite = new Flow<Input>({ slug: 'analyze_website', maxAttempts: 3, baseDelay: 5, timeout: 10, }) .step( { slug: 'website' }, async (input) => await scrapeWebsite(input.run.url) ) .step( { slug: 'sentiment', dependsOn: ['website'], timeout: 30, maxAttempts: 5 }, async (input) => await analyzeSentiment(input.website.content) ) .step( { slug: 'summary', dependsOn: ['website'] }, async (input) => await summarizeWithAI(input.website.content) ) .step( { slug: 'saveToDb', dependsOn: ['sentiment', 'summary'] }, async (input) => { const results = await saveToDb({ websiteUrl: input.run.url, sentiment: input.sentiment.score, summary: input.summary.aiSummary, }); return results.status; } ); A flowchart showing data from a website being processed through both sentiment analysis and summary generation, with the results from both paths being saved to a database.
March 24, 2025 at 11:01 AM
pgflow.bsky.social
🐘 Postgres Tip: 𝗚𝗘𝗡𝗘𝗥𝗔𝗧𝗘𝗗 𝗰𝗼𝗹𝘂𝗺𝗻𝘀

Generated columns are a powerful PostgreSQL feature that automatically update based on changes to underlying data, ensuring your calculated values always stay current.

Useful for storing frequently computed values.

#Postgres #PostgreSQL #Supabase
March 4, 2025 at 4:02 PM
pgflow.bsky.social
🚀 Edge Worker 𝗽𝗿𝗼𝗰𝗲𝘀𝘀𝗲𝗱 𝟳.𝟯𝟳 𝗠𝗜𝗟𝗟𝗜𝗢𝗡 𝗷𝗼𝗯𝘀 𝗶𝗻 𝟭𝟲 𝗵𝗼𝘂𝗿𝘀!

I'm testing production deployments and continuous operations on the @supabase.com FREE tier:

🔥 𝟯 𝗮𝗰𝘁𝗶𝘃𝗲 𝘄𝗼𝗿𝗸𝗲𝗿𝘀 (kept up by pg_cron)
⚙️ 𝟭𝟭,𝟬𝟬𝟬 unique Edge Function instances spun up
⚡ 𝟭𝟮𝟴 𝗷𝗼𝗯𝘀/𝘀𝗲𝗰 average throughput

It runs perfectly fin
February 22, 2025 at 3:03 PM
pgflow.bsky.social
Adding a second example that is more straight forward with the types, thanks for the heads up!
January 29, 2025 at 8:22 AM
pgflow.bsky.social
We all love using #TypeScript with @supabase.com ! ✨

Flow DSL makes it super simple to define flows:
- Type for Flow params (e.g "string")
- Build flow step by step
- Steps have name, optional deps & handler func
- Dependencies determine handler payload

It couldn't be simpler - change my mind! 🚀
January 28, 2025 at 4:05 PM
pgflow.bsky.social
I'm building pgflow to seamlessly integrate with @supabase
's building blocks.

That's why the flow shapes are kept in the database - this allows streaming their progress using Supabase Realtime! ⚡ How cool is that?

November prototype (can anyone spot a little bug?):
January 27, 2025 at 2:49 PM
pgflow.bsky.social
pgflow is not an empty promise #supabase
EdgeRuntime.waitUntil(new Promise(() => {}));
January 24, 2025 at 2:38 AM