Sqlite with ObanWeb and ObanPro

Special Sections Oban
, , ,
1

I know that Oban supports sqlite and it works very well. But I couldn’t find any mention of sqlite for ObanWeb and ObanPro.

Can somebody confirm? Maybe @sorentwo knows? :smile:

1 Like
2

Since Oban relies on Postgres’ notify mechanisms I am not sure it works as well with SQLite? But maybe they are using other mechanisms there. Curious to know more here.

3

It doesn’t. I asked Parker not too long ago and he said nobody has asked for it.

4

Nope. Neither Web nor Pro work entirely with SQLite, though parts of them do. For example, in Pro you could use the Pro.Worker, Decorator, and Relay with SQLite, but not the Smart engine or Workflows.

Oban needs a functional notifier for full operation, but it doesn’t have to be Postgres. In fact, we suggest using something other than Postgres when possible.

1 Like
5

That’s a shame, using Oban without a dashboard is not fun at all. ObanWeb is very cool.

What are the main blockers for ObanWeb + sqlite? Is it the missing notify? Would periodic polling work?

6

Thanks for reminding me of that. :+1:

What would it take for Smart Engine and Workflows to work with SQLite?

7

A lot. The Smart Engine uses a tremendous amount of advanced Postgres functionality that doesn’t map to SQLite. Likewise with Workflows, but to a lesser extent.

We’d love to have Pro just work with SQLite. Maybe one day :slightly_smiling_face:

1 Like