Research spike: determine cloud provider

[adhurjaty]

How should we host the wiki + API backend?

Choices I see right now:

• Coolify self-hosting on a Hetzner remote machine
• Render
• Vercel
• Fly.io
• Others?

We initially thought supabase could handle hosting, but it does not seem to be a good choice for serving frontend code (needed for the wiki). We should choose a provider that allows:

• easy integration with a Postgres database
• gives decent usage metrics
• allows static file storage (for things like the LLM prompt templates)
• easy deployment from github or github actions
• no lock-in
• won't mysteriously destroy our bank accounts

[adhurjaty]

Looks like render doesn't support docker-compose files

https://community.render.com/t/can-i-use-docker-compose/58

Updating coolify config is extremely buggy