> Yet each request still has a 100-200ms latency or more, which becomes noticeable in user interactions
ping dawn-night-7975.fly.dev
--- dawn-night-7975.fly.dev ping statistics ---
6 packets transmitted, 6 packets received, 0.0% packet loss
round-trip min/avg/max/stddev = 11.566/12.635/14.000/0.841 ms
so, 6ms each way from my house in the suburbs of Philadelphia, to the closest Fly region near NYC about 80 miles away. When measuring UI response latency, this is the number that matters. No, your database is not in the edge. But cached query results are!