This article references an article written by the Notion dev team on how they sped up their page load times by utilizing SQLite to cache the page in the browser.
It goes into some detail on how they used shared web workers and the Web Locks API to handle the caching process in the background while preventing multiple simultaneous writes from corrupting the data.
There were also difficulties in handling the initial download of the SQLite WASM and using a “race” method to load the page from the fastest source regardless of the device hardware.