pgflow
@pgflow.bsky.social
Postgres-centric workflow Engine with deep Supabase integration. https://pgflow.dev
Pinned
pgflow
@pgflow.bsky.social
· Jan 27
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?):
'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?):
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. 🤖
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;
}
);](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:jadbihqwdyujj5uucqmtlqbm/bafkreiexj5i5lodegzhlv7qfdhep4g2b6c5hzyaawktgplcdysxt54h6xe@jpeg)
March 24, 2025 at 11:01 AM
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. 🤖
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. 🤖
It is a productive week so far for my @supabase.com
workflow engine:
- defining flows, steps, and dependencies
- starting flows, queuing stuff
- polling for tasks
- completing tasks
- dependency resolution
- 1000 lines of tests
workflow engine:
- defining flows, steps, and dependencies
- starting flows, queuing stuff
- polling for tasks
- completing tasks
- dependency resolution
- 1000 lines of tests
March 11, 2025 at 7:17 PM
It is a productive week so far for my @supabase.com
workflow engine:
- defining flows, steps, and dependencies
- starting flows, queuing stuff
- polling for tasks
- completing tasks
- dependency resolution
- 1000 lines of tests
workflow engine:
- defining flows, steps, and dependencies
- starting flows, queuing stuff
- polling for tasks
- completing tasks
- dependency resolution
- 1000 lines of tests
Brainstorming & viability checks with LLMs - anyone else doing this? 🤔 Curious to see how common it is! (recent conclusion in the reply!)
#LLM #buildinpublic #AI #supabase #postgres
#LLM #buildinpublic #AI #supabase #postgres
bsky.app
March 6, 2025 at 9:23 AM
Brainstorming & viability checks with LLMs - anyone else doing this? 🤔 Curious to see how common it is! (recent conclusion in the reply!)
#LLM #buildinpublic #AI #supabase #postgres
#LLM #buildinpublic #AI #supabase #postgres
🐘 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
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
🐘 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
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
✂️ Time to extract pgflow! 🚀
I'm starting March with a laser focus: 𝗦𝗵𝗶𝗽𝗽𝗶𝗻𝗴 𝗽𝗴𝗳𝗹𝗼𝘄 𝗮𝗹𝗽𝗵𝗮 𝗔𝗦𝗔𝗣! 🚢
I also plan to post some technical findings, snippets and ideas, mostly around queues and SQL, so if you are interested in this kind of stuff, watch this space! 🔭
#supabase #buildinpublic
I'm starting March with a laser focus: 𝗦𝗵𝗶𝗽𝗽𝗶𝗻𝗴 𝗽𝗴𝗳𝗹𝗼𝘄 𝗮𝗹𝗽𝗵𝗮 𝗔𝗦𝗔𝗣! 🚢
I also plan to post some technical findings, snippets and ideas, mostly around queues and SQL, so if you are interested in this kind of stuff, watch this space! 🔭
#supabase #buildinpublic
March 3, 2025 at 5:15 PM
✂️ Time to extract pgflow! 🚀
I'm starting March with a laser focus: 𝗦𝗵𝗶𝗽𝗽𝗶𝗻𝗴 𝗽𝗴𝗳𝗹𝗼𝘄 𝗮𝗹𝗽𝗵𝗮 𝗔𝗦𝗔𝗣! 🚢
I also plan to post some technical findings, snippets and ideas, mostly around queues and SQL, so if you are interested in this kind of stuff, watch this space! 🔭
#supabase #buildinpublic
I'm starting March with a laser focus: 𝗦𝗵𝗶𝗽𝗽𝗶𝗻𝗴 𝗽𝗴𝗳𝗹𝗼𝘄 𝗮𝗹𝗽𝗵𝗮 𝗔𝗦𝗔𝗣! 🚢
I also plan to post some technical findings, snippets and ideas, mostly around queues and SQL, so if you are interested in this kind of stuff, watch this space! 🔭
#supabase #buildinpublic
Flu's been "in production" for days. Constantly hitting CPU clock limits (zero focus), and my runny nose desperately needs horizontal scaling for tissues. Needing an emergency patch ASAP! 🤢
February 25, 2025 at 2:35 PM
Flu's been "in production" for days. Constantly hitting CPU clock limits (zero focus), and my runny nose desperately needs horizontal scaling for tissues. Needing an emergency patch ASAP! 🤢
🚀 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
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
🚀 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
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
🚀 𝗘𝗱𝗴𝗲 𝗪𝗼𝗿𝗸𝗲𝗿 𝘃𝟬.𝟬.𝟰 𝗶𝘀 𝗼𝘂𝘁!
v0.0.3 had a pretty bad bug—production deployments didn't work because I mistakenly tested a development version in the cloud, instead of the JSR package.
It's fixed now (live on JSR). If you run into issues, please try again!
I appreciate everyone’s interest—your eng
v0.0.3 had a pretty bad bug—production deployments didn't work because I mistakenly tested a development version in the cloud, instead of the JSR package.
It's fixed now (live on JSR). If you run into issues, please try again!
I appreciate everyone’s interest—your eng
February 20, 2025 at 12:00 PM
🚀 𝗘𝗱𝗴𝗲 𝗪𝗼𝗿𝗸𝗲𝗿 𝘃𝟬.𝟬.𝟰 𝗶𝘀 𝗼𝘂𝘁!
v0.0.3 had a pretty bad bug—production deployments didn't work because I mistakenly tested a development version in the cloud, instead of the JSR package.
It's fixed now (live on JSR). If you run into issues, please try again!
I appreciate everyone’s interest—your eng
v0.0.3 had a pretty bad bug—production deployments didn't work because I mistakenly tested a development version in the cloud, instead of the JSR package.
It's fixed now (live on JSR). If you run into issues, please try again!
I appreciate everyone’s interest—your eng
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! 🚀
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
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! 🚀
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! 🚀
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?):
'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
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?):
'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?):
Excited to share Edge Worker PoC! Built on top of @supabase.com Background Tasks to make your PGMQ queue processing easier with automatic retries, concurrency limits and observability. Learn more at pgflow.dev ✨
#postgres #sql #pgmq #supabase
#postgres #sql #pgmq #supabase
Edge Worker
pgflow.dev
January 22, 2025 at 11:43 PM
Excited to share Edge Worker PoC! Built on top of @supabase.com Background Tasks to make your PGMQ queue processing easier with automatic retries, concurrency limits and observability. Learn more at pgflow.dev ✨
#postgres #sql #pgmq #supabase
#postgres #sql #pgmq #supabase