sqlite3_web

Fix GrowableArrayBuffer docs, add test

• For apps compiled with dart2wasm, preserve types of doubles that are exact integers (e.g. 3.0) when binding parameters and reading results.

Prepare sqlite3_web 0.9.3 release

• Automatically flush pending IndexedDB writes after each write.

• Allow caching prepared statements via the preparedStatementCacheSize option on WebSqlite.connect.

• Avoid races when opening a database in multiple tabs causing OPFS to be reported as unsupported.
• Add package:sqlite3_web/types.dart import exposing types that can be imported on all platforms.

• Breaking: Add WorkerEnvironment.close() to close workers.
• Add WebSqlite.close to close dedicated workers opened for a web sqlite instance.

• Throw when new requests are made to a database closed remotely.

• Remove stream_channel dependency with custom implementation, slightly decreasing compiled size.
• Breaking: Use strings instead of URLs to reduce code size.
• Breaking: Custom Dart objects can no longer be serialized via serializeParameters and serializeResultSet. Only SQLite values are supported.
• Breaking: Remove opfsAtomics file system implementation. The new opfsWithExternalLocksWorkaround supports the same browsers while being faster and not requiring special headers.
• Fix raw file system writes not acquiring database locks.
• Optimize use of navigator locks to avoid acquiring them in single-tab scenarios.

• Fix internal mutex throwing when not given an abort signal.
• Fix internal mutex never aborting when given a signal that has already been aborted.

• Breaking: Introduce CustomClientRequest and CustomClientDatabaseRequest classes representing client requests. They expose an abort signal for requests and a way to interact with database locks.
• Add LockToken? token and Future<void>? abortTrigger parameters to Database.customRequest.

• Replace worker URI parameter with WorkerConnector interface. Use WorkerConnector.defaultWorkers to keep passing an URI.
• Refactor worker messages to use JS-interop objects directly instead of serializing Dart objects. This makes the package slightly more efficient.

• Use version 3 of package:sqlite3.

• Support older versions of package:meta.

• Remove userVersion and setUserVersion. Users should run the pragma statements manually.
• Add requestLock, which can be used to make multiple database calls in a locked context.
• Allow aborting requests.
• Add support for a new Web FS (OPFS) access mode based on readwrite-unsafe.

• Allow workers to send requests to clients. Previously, only the other direction was implemented.

• Fix hooks not being delivered to all databases.

• Allow passing data to worker when opening databases.
• Support dart2wasm.
• Serialize SqliteExceptions in workers.
• Serialize parameters and rows instead of using jsify() / dartify().

• Recover from worker errors at startup.

• Add WebSqlite.deleteDatabase to delete databases.
• Support opening databases without workers.

• Make FileSystem implementation functional, add FileSystem.flush().

• Support latest version of package:web.

• Fix preferred databases not being sorted correctly.

• Fix remote error after closing databases.

• Initial WIP version.