sqlite in nextjs pwa project

[wanghaisheng]

should we use https://docs.expo.dev/versions/latest/sdk/sqlite/ as describe in https://www.triplit.dev/docs/client/storage#in-react-native

if i want to build a pwa application use nextjs+triplit+sqlite

[wernst]

I dont think expo-sqlite works on the web. However you can try our server side sqlite package by importing it from@triplit/client/storage/sqlite.

Im unsure that will work in a PWA (it would depend on the comparability of https://github.com/WiseLibs/better-sqlite3). There is a wasm build for sqlite in browser environments (https://github.com/sqlite/sqlite-wasm) which might work well here, but we dont have an officially supported adapter.

[matlin]

Generally our advice is to use IndexedDB on the Client for a PWA and then SQLite on the server--which works out of the box for Triplit Cloud and the Triplit Server Docker image .