Long running process for better database connectivity #372
Description
apollo is designed around short running python modules, shelled out as processed from bun
As we're adding more database functionality, those short lived processes feel increasingly wasteful. It would be nice in particular to maintain connections to databases over a longer session.
So we should explore:
- Keeping all services alive and running some sort of IPC to share data (mastering this stuff would also let me drop the horrible file logging stuff)
- Keep the services short lived, but include a couple of long running services for database access. I suppose we could consider calling database from typescript and having some kind of IPC protocol to exchange data with the server