Switch from Supabase to D1

mue / api

Code for the Mue API

https://api.muetab.com

MIT License

4 stars 2 forks source link

Open eartharoid opened 1 year ago

eartharoid commented 1 year ago

When it is GA, and if it does not become expensive, use Cloudflare's D1 database instead of Supabase to reduce latency.

eartharoid commented 3 months ago

D1 is now GA but read replicas are not available yet.

Other optimisations for when we switch:

Optimise random() queries: https://gist.github.com/eartharoid/e476b8870bb787cda15b0c22967e6fdd
Add indexes (for quote language, etc)
Use KV or Cache API in the Worker, especially for quote languages