egze
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? 
Where Next?
Trending in Questions
Other Trending Topics
Latest Oban Threads
Latest on Elixir Forum
Sponsor Spotlight
Build Elixir applications with speed and confidence.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #blog-post
- #phoenix_html
- #iex
- #graphql
- #ai
- #genstage
- #elixirconf-us
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #security
- #hex
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Practical resources that improve the lives of professional developers.
Bringing learning, work and compliance together since 1987.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
First 7 of 7 Posts
dimitarvp
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.
cmo
It doesn’t. I asked Parker not too long ago and he said nobody has asked for it.
sorentwo
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.
egze
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?dimitarvp
Thanks for reminding me of that.
What would it take for Smart Engine and Workflows to work with SQLite?
sorentwo
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
ndrean
The basic Oban accepts SQLite:
https://hexdocs.pm/oban/Oban.Engines.Lite.html