I’m looking to build a sandboxed AI agent runtime that needs persistence plus some additional session-related state and cron-like tasks.
I’m considering Convex since it seems like a natural fit for agents, but in my case each sandbox would only need its own local database. I wouldn’t need a centralized DB or API service — it would mostly act as a local persistence layer per sandbox.
Has anyone compared Convex vs. a local SQLite database for this kind of setup? Specifically curious about the pros/cons of using Convex when the system is fully sandboxed and doesn’t require shared backend infrastructure.