PGlite / ElectricSQL is definitely something I want to use in a future job. The ability to replicate and subscribe to the changes, all within the browser seems

PGlite / ElectricSQL is definitely something I want to use in a future job. The ability to replicate and subscribe to the changes, all within the browser seems incredibly powerful. Having worked on medical software that runs a 2,000,000+ patient workload that perform refills for chemotherapy/HIV/immuno drugs, where it was common for people to trample each others work as they ran insurance, called patients etc... We had to roll our own locking system that relied on interval functions (yay IE7) and websockets... This meant when you called the patient, someone running financial assistance would be unable to work on the same profile. I can envision other uses for FTS or even vector search locally, since they are insanely expensive at scale.