My thoughts: bring db to the client app

Normally when I write article, I have to do lot of reading, research and information validation before finalising the article content but my thoughts is an article series where I present my thoughts based on my current understanding and they can be wrong or right but the whole point of this series is to bring a fresh perspective

I have been fascinated by the idea of bringing a database to the client app. Normally frontend calls api , api calls db and return records but what if our frontend app can directly talk to db ? Security is a major concern but what if we build a permission based model around our db. Checkout spacetime db on this. Another architecture which is really interesting is that let’s have db at the client app (sqlite in web app using web assembly technology) which is asynchronously getting updated from db at the server end. Use cases can be like providing user specific details so that they can query over their own data. Have heard of this architecture being picked while designing real time games. Both these design styles give you low latency.

Reference:

https://youtu.be/roEsJcQYjd8?si=almZKDnR7PCGih5n