What has been your experience writing the "off line first" style PWA?

There's an appeal to it, basically using the web purely as distribution, and the browser as the runtime. But I'm concerned with the fiddly-ness of local storage and such like that. The "out of site, out of mind" nature of it. The data not being in a "~/.app/app.dat" file, etc. The idea of it potentially just up and vanishing with a browser update. And, heck, just the complexity of dealing with the schema versioning in the native web model.

As well as the portability of data (say when you copy over to a new computer).

The idea of simple web distribution is compelling. Now you need nothing more than a github account, and off you go. No server, no nothing.

But I still feel (perhaps ignorantly) that the data situation is still on shaky ground. (Discounting the whole lack of something like SQLite, etc.)

And, the idea of bundling something like SQLite as a webassembly blob just makes me itch.

Just curious how that's worked out.