"Postgres
1. neon: great offering, supports read replicas but no server in India.
2. Supabase: supports India as a region, recently announced read replicas but will take time to start proper offering.
MySQL
1. Planetscale: generous free tier, can be distributed in different regions, recently started supporting foreign key constraints, have weird pricing.
SQLite
1. Turso: Very generous free tier with 3 regions included in the free tier. Very easy to provision, scale and connect, have first class support with Drizzle ORM.
2. Cloudflare D1: Free to use as of now, global replication not yet available till it is in beta. Fast and easy to use. Doesn't yet offer complete functionality over HTTP API, hence very difficult to connect with from an application that is not a wrangler project.
Message from Subhendu
"Postgres 1. neon: great offering, supports read replicas but no server in India. 2. Supabase: supports India as a region, recently announced read replicas but will take time to start proper offering. MySQL 1. Planetscale: generous free tier, can be distributed in different regions, recently started supporting foreign key constraints, have weird pricing. SQLite 1. Turso: Very generous free tier with 3 regions included in the free tier. Very easy to provision, scale and connect, have first class support with Drizzle ORM. 2. Cloudflare D1: Free to use as of now, global replication not yet available till it is in beta. Fast and easy to use. Doesn't yet offer complete functionality over HTTP API, hence very difficult to connect with from an application that is not a wrangler project.
My recommendation: Turso"