Re:How's Linear so fast? A technical breakdown
by matharmin on Monday June 08, 2026 @09:27AM
(#48445077)
At PowerSync we use a wa-sqlite build with SQLite3MultipleCiphers for encryption at rest.
You do still need a secure key to use with this. The simplest is to persist the key server-side (and specifically not on the client), and provide it to the JS after signing in. If you need to support a completely offline PWA you need something else, e.g. prompting the user for a passcode each load.
Lack of native encryption in indexedDB is a dealbreaker for certain use-cases.