Web compatibility for powersync_sqlcipher

[sbeltran10]

Hello,

Loving the package so far but sadly cannot use powersync_sqlcipher for flutter web. Even when using:

import 'package:powersync_sqlcipher/sqlite3_common.dart';

I get the following:

.../AppData/Local/Pub/Cache/hosted/pub.dev/sqlcipher_flutter_libs-0.6.4/lib/sqlcipher_flutter_libs.dart:9:8: Error: Dart library 'dart:ffi' is not available on this platform.
import 'dart:ffi';
       ^
Context: The unavailable library 'dart:ffi' is imported through these packages:

    web_entrypoint.dart => package:my_app=> package:powersync_sqlcipher => package:powersync_core => package:sqlite_async => package:sqlite3 => dart:ffi
    web_entrypoint.dart => package:my_app=> package:powersync_sqlcipher => package:sqlcipher_flutter_libs => dart:ffi
    ...

Is there an ETA for enabling compatibility? Or perhaps am I doing something wrong?

[mugikhan]

Hey @sbeltran10, we do not currently support the web platform for the flutter package as it is not supported by the sqlcipher_flutter_libs package which we use to provide sqlcipher functionality.

This is something we are investigating but we don't have any timelines for when it will be ready.

[willsmanley]

is there another option like storing an unencrypted sqlite db in an encrypted indexedb for web?

i have a hipaa requirement so im willing to jump through some firey hoops to get encryption on web

btw thank you for the amazing service, this is a godsend

[simolus3]

Version powersync_sqlcipher: ^0.1.4, which we've just released to pub.dev, supports encryption on the web using SQLite Multiple Ciphers.
The open factory will work unchanged, but you need to update web assets:

1. This feature needs a new powersync_db.worker.js from this release.
2. Instead of a sqlite3.wasm, you'll need a sqlite3mc.wasm, available here.

You can also run dart run powersync_sqlcipher:setup_web in your project to download these assets automatically.