Hello Francesco,
I think short answer is “it depends”. If you are using PS from serverless, you likely to have a large number of functions open concurrent connections to your database. The difference with PlanetScale is that it supports a higher number of these than other DBs. AFAIK, the current limit is 1K in the free Developer plan and 10K in the Scaler plan. Other DB providers have often lower limits for these so it’s much easier to exhaust the connection limit.
If this number is enough to satisfy your traffic workload then you are good from the connection limit POV.
The one thing that you might still experience is cold starts. Serverless functions are short-lived ephemeral and rarely get reused. This means that more often than not a request will be served by a newly spawned function, which needs to first open a persistent connection to the database. This has some latency cost associated with it, that will depend on the database and provider, e.g. AFAIK Postgres connections take longer to establish than MySQL.
We plan to offer support for new regions soon and also offer additional functionalities down the road. Would you use the Data Proy better if you had the ability to deploy it in Dublin? If so, please request the region in this form
here.