If you’re running vanilla SQLite then you’ll need to just run one volume. You’ll have a brief period of downtime when you deploy as only one VM can be attached to a volume at a time. During deployment, we stop the previous VM and restart it with the new version.
A similar question was asked recently that may help give some more context: So it's not possible to use SQLITE on fly without LiteFS ?