SQL lite caching with WASM on web.

I am not happy with the speed of navigation between the pages on VueJS projects. This performance difference I notice when I switch to API’ to fetch data. The difference is in micro seconds but. There still that’s a lot in terms of responsiveness that can change the whole user experience.

To fix this some sort of caching at client side caching could help. Instead of having each request cached in an environment where we are making frequent data changes and data is dependent what if we could create a cache of database which is relevant by the user and then sync it with the original database online.

This idea and performance boosts is attracting me towards exploring and experimenting this further with VueJS and SQL lite.

Well we already have stores like Pinia which really speeds up the process, but what if we could cache larger portions of database.

One of the excellent articles I found on the Notion Blog which explores this idea I depth.

https://www.notion.so/blog/how-we-sped-up-notion-in-the-browser-with-wasm-sqlite