5 ms·
Dbos: Durable Workflow Orchestration with Go and PostgreSQL
- hmaxdml 1y agoThanks for posting! I am one of the author, happy to answer any question!
- drakenot 1y agoI read the Dbos vs Temporal thing, but can you speak more about if there is a different in durability guarantees?
- KraftyOne 1y agoThe durability guarantees are similar--each workflow step is checkpointed, so if a workflow fails, it can recover from the last completed step. The big difference, like that blog post (https://www.dbos.dev/blog/durable-execution-coding-comparison https://www.dbos.dev/blog/durable-execution-coding-compariso...) describes, is the operational model. DBOS is a library you can install into your app, whereas Temporal et al. require you to rearchitect your app to run on their workers and external orchestrator.
- dfee 1y agoThis makes sense, but I wonder if there’s a place for DBOS, then, for each language? For example, a Rust library. Am I missing how a go library is useful for non-go applications?
- KraftyOne 1y agoThere are DBOS libraries in multiple languages--Python, TS, and Go so far with Java coming soon: https://github.com/dbos-inc https://github.com/dbos-inc No Rust yet, but we'll see!
- saintarian 1y agoGreat project! Love the library+db approach. Some questions: 1. How much work is it to add bindings for new languages? 2. I know you provide conductor as a service. What are my options for workflow recovery if I don't have outbound network access? 3. Considering this came out of https://dbos-project.github.io/ https://dbos-project.github.io/, do you guys have plans beyond durable workflows?
- KraftyOne 1y ago1. We also have support for Python and TypeScript with Java coming soon: https://github.com/dbos-inc https://github.com/dbos-inc 2. There are built-in APIs for managing workflow recovery, documented here: https://docs.dbos.dev/production/self-hosting/workflow-recovery https://docs.dbos.dev/production/self-hosting/workflow-recov... 3. We'll see! :)
- travisgriggs 1y agoElixir? Or does Oban hew close enough, that it’s not worth it?
- jiggunjer 1y agoDoes it natively support job priorities? E.g. if there's 10 workflows submitted and I start up a worker, how does it pick the first job.
- KraftyOne 1y agoYeah, queue priority is natively supported: https://docs.dbos.dev/golang/tutorials/queue-tutorial#priority https://docs.dbos.dev/golang/tutorials/queue-tutorial#priori...
- tester5555 1y ago[dead]
- rickette 1y agoThere's a clear text password in one of your GitHub Action workflows: https://github.com/dbos-inc/dbos-transact-golang/blob/main/.github/workflows/chaos-tests.yml#L43 https://github.com/dbos-inc/dbos-transact-golang/blob/main/....
- qianli_cs 1y agoThat password is only used by the GHA to start a local Postgres Docker container (https://github.com/dbos-inc/dbos-transact-golang/blob/main/chaos_tests/chaos_test.go#L63-L65 https://github.com/dbos-inc/dbos-transact-golang/blob/main/c...), which is not accessible from outside.
- plmpsu 1y agoHow does DBOS scale in a cluster? with Temporal or Dapr Workflows, applications register running their supported workflows types or activities and the workflow orchestration framework balances work across applications. How does this work in the library approach? Also, how is DBOS handling workflow versioning? Looking forward for your Java implementation. Thanks
- qianli_cs 1y agoGood questions! DBOS naturally scales to distributed environments, with many processes/servers per application and many applications running together. The key idea is to use the database concurrency control to coordinate multiple processes. [1] When a DBOS workflow starts, it’s tagged with the version of the application process that launched it. This way, you can safely change workflow code without breaking existing ones. They'll continue running on the older version. As a result, rolling updates become easy and safe. [2] [1] https://docs.dbos.dev/architecture#using-dbos-in-a-distributed-setting https://docs.dbos.dev/architecture#using-dbos-in-a-distribut... [2] https://docs.dbos.dev/architecture#application-and-workflow-versions https://docs.dbos.dev/architecture#application-and-workflow-...
- plmpsu 1y agoThanks for the reply. So applications continuously poll the database for work? Have you done any benchmarking to evaluate the throughput of DBOS when running many workflows, activities, etc.?
- qianli_cs 1y agoIn DBOS, workflows can be invoked directly as normal function calls or enqueued. Direct calls don't require any polling. For queued workflows, each process runs a lightweight polling thread that checks for new work using `SELECT ... FOR UPDATE SKIP LOCKED` with exponential backoffs to prevent contentions, so many concurrent workers can poll efficiently. We recently wrote a blog post on durable workflows, queues, and optimizations: https://www.dbos.dev/blog/why-postgres-durable-execution https://www.dbos.dev/blog/why-postgres-durable-execution Throughput mainly comes down to database writes: executing a workflow = 2 writes (input + output), each step = 1 write. A single Postgres instance can typically handle thousands of writes per second, and a larger one can handle tens of thousands (or even more, depending on your workload size). If you need more capacity, you can shard your app across multiple Postgres servers.
- hazn 1y agoI remember reading that restate.dev is a 'push' based workflow and therefore works well with serverless workflows: https://news.ycombinator.com/item?id=40660568 https://news.ycombinator.com/item?id=40660568 what is your input on these two topics? aka pull vs push and working well with serverless workflows
- intermerda 1y agoI remembered reading about the DBOS paper a while back - https://arxiv.org/abs/2007.11112 https://arxiv.org/abs/2007.11112. Is this an evolution of that research work? If so, how did an OS for databases morph into a workflow orchestration service?
- hmaxdml 1y agoIt is an evolution. The DBOS workflow orchestrator places a DB at the center of your application to handle most of the complicated state management problems.
- osigurdson 1y agoDid you consider using NATS? While I haven't tried this deployment model, you can embed it in a go program as a library. If you wanted something really minimal this might be an option. I use NATS to acheive this type of durable processing. It works well. Of course, idempotent code is needed but I don't think this can be avoided.
- hmaxdml 1y agoWe decided to use Postgres because of the relational semantics, the ease of integration with user applications, and it's remarkable popularity
- tester54321 1y agoIs it possible for you guys to write a blog post analyzing the usage of the DB (reads, writes, what is stored for each workflow any events etc) to help users planning for scale to really understand what they are signing up. The library seems fantastic but my team did not use this because at scale they believe that the number of DB reads and writes becomes very significant for a large number of workflows with many steps and that with PG vs Cassandra/ScyllaDB it would not be feasible for our throughput. I tried to convince them otherwise but it is difficult to quantify from the current documentation.
- hmaxdml 1y agoGood call. We'll see how to integrate it in our docs better. The cost of DBOS durable execution is 1 write per step (checkpoint the outcome) and 2 additional writes per workflows (upsert the workflow status, checkpoint the outcome). The write size is the size of your workflows/steps output. Postgres can support several thousands writes per seconds (influenced by the write size, ofc): DBOS can thus support several thousands of workflows/steps per second. Postgres scales remarkably well. In fact, most org will never out scale a single, vertically scaled Postgres instance. There's a very good write up by Figma telling how they scaled Postgres horizontally: https://www.figma.com/blog/how-figmas-databases-team-lived-to-tell-the-scale/ https://www.figma.com/blog/how-figmas-databases-team-lived-t...
- plmpsu 1y agoWhat did your team decide to go with eventually?
- danggit 1y agoLooks interesting
- chc4 1y ago> Exactly-Once Event Processing This sounds...impossible? If you have some step in your workflow, either you 1) record it as completed when you start, but then you can crash halfway through and when you restore the workflow it now isn't processed 2) record it as completed after you're done, but then you can crash in-between completing and recording and when you restore you run the step twice. #2 sounds like the obvious right thing to do, and what I assume is happening, but is not exactly once and you'd need to still be careful that all of your steps are idempotent.
- KraftyOne 1y agoThe specific claim is that workflows are started exactly-once in response to an event. This is possible because starting a workflow is a database transaction, so we can guarantee that exactly one workflow is started per (for example) Kafka message. For step processing, what you say is true--steps are restarted if they crash mid-execution, so they should be idempotent.
- reillyse 1y ago"Exactly-Once Event Processing" is the headline claim - I actually missed the workflow starting bit. So what happens if the workflow fails? Does it get restarted (and so we have twice-started) or does the entire workflow just fail ? Which is probably better described as "at-most once event processing"
- qianli_cs 1y agoI think a clearer way to think about this is "at least once" message delivery plus idempotent workflow execution is effectively exactly-once event processing. The DBOS workflow execution itself is idempotent (assume each step is idempotent). When DBOS starts a workflow, the "start" (workflow inputs) is durably logged first. If the app crashes, on restart, DBOS reloads from Postgres and resumes from the last completed step. Steps are checkpointed so they don't re-run once recorded.
- 1y ago
- jiggunjer 1y agoSounds exactly like how Temporal markets itself. I find that the burden of creating idempotent sub-steps in the workflow falls on the developer, regardless of checkpoints and state management at the workflow level.
- KraftyOne 1y agoYes, in any durability framework there's still the possibility that a process crashes mid-step, in which case you have no choice but to restart the step. Where DBOS really shines (vs. Temporal and other workflow systems) is a radically simpler operational model--it's just a library you can install in your app instead of a big heavyweight cluster you have to rearchitect your app to work with. This blog post goes into more detail: https://www.dbos.dev/blog/durable-execution-coding-comparison https://www.dbos.dev/blog/durable-execution-coding-compariso...
- jiggunjer 1y agoOh I see. Seems Nextflow is a strong contender in the serverless orchestrator market (serverless sounds better than embedded). From what I can tell though, NF just runs a single workflow at a time, no queue or database. It relies on filesystem caching for "durability". That's changing recently with some optional add-ons.
- bjornsing 1y ago> Yes, in any durability framework there's still the possibility that a process crashes mid-step, in which case you have no choice but to restart the step. Golem [1] is an interesting counterexample to this. They run your code in a WASM runtime and essentially checkpoint execution state at every interaction with the outside world. But it seems they are having trouble selling into the workflow orchestration market. Perhaps due to the preconception above? Or are there other drawbacks with this model that I’m not aware of? 1. https://www.golem.cloud/post/durable-execution-is-not-just-for-failures https://www.golem.cloud/post/durable-execution-is-not-just-f...
- qianli_cs 1y ago
- odie5533 1y agoFor a project with minimal users, we get a lot of DBOS posts.
- Jtsummers 1y agoNot really. https://hn.algolia.com/?dateRange=all&page=0&prefix=false&query=dbos&sort=byDate&type=story https://hn.algolia.com/?dateRange=all&page=0&prefix=false&qu... - Not even 3 full pages worth over the past 5 years, though the first page is entirely from this year. It's maybe 2-3 a month on average this year, and a lot are dupes. https://hn.algolia.com/?dateRange=all&page=0&prefix=true&query=%22nim%22&sort=byDate&type=story https://hn.algolia.com/?dateRange=all&page=0&prefix=true&que... - Nim, for comparison, which doesn't really make a dent in the programming world but shows up a lot. The first 15 pages covers the same time period.
- KraftyOne 1y agoWe may be a small startup, but we're growing fast with no shortage of production users who love our tech: https://www.dbos.dev/customer-stories https://www.dbos.dev/customer-stories
- krashidov 1y agoWhy such negativity? What have you shipped?
- anbotero 1y agoI think this post is riddled with bots. One is marketing another competing offer, others complaining about the UI component not being open source too...
- cpursley 1y agopgglow is also worth looking at, all the work happens in Postgres: https://www.pgflow.dev https://www.pgflow.dev They use supabase (demo functions) as client but could be anything.
- cpursley 1y agopgglow is also worth looking at, all the work happens in Postgres: https://www.pgflow.dev https://www.pgflow.dev They use supabase (demo functions) as client but could be your language of choice.
- cpursley 1y agopgglow is also worth looking at, all the work happens in Postgres: https://www.pgflow.dev https://www.pgflow.dev They use supabase (demo functions) as client but could be your language of choice.
- lordofgibbons 1y agoThis is perfect. I've been growing weary of Go projects that can be used as a library, but for some strange reason must to be used as an external service - complicating the infrastructure. Looking forward to using this in a future project.
- atombender 1y agoI've played with DBOS and like it, but I have to say the lack of a control plane and UI in the open source version means it may have a hard time competing with Temporal, which provides both. Being able to see the state of workflows and their histories is a key part of having an application in production. Without a control plane, my understanding is that DBOS can't offer the same kind of failure recovery as Temporal, though it's unclear to me how the "Transact" engine does this. A big benefit that Temporal's architecture provides is separation of concerns. Temporal can coordinate workflows across many apps, whereas with DBOS each app (as far as I understand it, at least) is a silo managing its own queues.
- hmaxdml 1y agoDBOS stores all the workflow metadata in postgres, which is readily queryable for observability. We've recently seen a user setup an entire Grafana dashboard to observe their numerous workflows. A postgres server can host many databases, and multiple applications can use the same server. The same dashboard can be used to monitor them all. With respect to recovery: A new Transact process will run a round of recovery at startup. Transact also exposes an admin server with a recovery endpoint. For more elaborate scenarios, we have control plane options commercially available.
- atombender 1y agoTemporal has a full-fledged UI where I can drill down into individual workflow runs and see the graph of activities, detail logs, retry counts, inputs and outputs, and so on. Temporal also has an API to introspect this without reaching into a database. You can share a database server with DBOS, but it's common to give applications dedicated database resources (one Postgres cluster per app in different regions), meaning it won't work with DBOS unless you write your own federated control layer that can speak to multiple instances. Which is also not offered out of the box. Sharing one DBOS-specific server across all apps would introduce a single point of failure. Again, I like DBOS, but right now the value proposition isn't that great given that Temporal has already nailed this.
- 1y ago
- d0100 1y agoIs there a nice interface to visualize all workers/workflows running like temporal has? Even better if the interface is also embeddable into a go http handler
- KraftyOne 1y agoYes, there's a full workflow visualization/management interface (not embeddable though): https://docs.dbos.dev/golang/tutorials/workflow-management https://docs.dbos.dev/golang/tutorials/workflow-management