One use case I can see this being valuable for is for a client based application and Postgres being a centralized database. The client would just query SQLite and not need to write Postgres SQL.
I understand the environmental reasons for a company to do this, it’s very important and would you happen to know the business incentives for them doing this?
It almost seems like their is an opportunity to build a cloud hosting service, where mom and pop data centers can plug in their infrastructure to a cloud service and let the platform manage the renting and latency based routing.
If the software is developed enough, this enables an even more global distribution. Software services don't want to manage machines and data centers don't want to manage customers.
Let’s not forget that this could be a value add, they can easily increase flight ticket prices by $20 and offer the service for free. They can also remove inflight monitors from the planes, reducing the weight of the overall plane, increase plane tickets by $10 and offer it Free.
There’s many ways to play with the numbers
I agree with you on this. For me personally, I find that my ADHD fuels my obsession where I am extremely persistent and every new “shiny object” is related to the interesting topic I am working on. Like new nodes to add on a mind map.