sqlite_async

• Add beforeOpen callback to native factories in #152
• Update sqlite3 and sqlite3_web, deprecate flush parameter in #153
• Allow caching prepared statements in #150

Full Changelog: sqlite_async-v0.14.3...sqlite_async-v0.14.4

• Native: Add the NativeSqliteOpenFactory.beforeOpen method, which can be overridden to configure SQLite asynchronously before opening databases.
• Web: Upgrade package:sqlite3_web to flush IndexedDB writes automatically, deprecate flush().
• Add SqliteOptions.preparedStatementCacheSize to cache prepared statements (disabled by default).

• Include name of navigator lock on abort in #147
• Support latest sqlite3_web package in #148

Full Changelog: sqlite_async-v0.14.2...sqlite_async-v0.14.3

• Include identifier of mutexes when a navigator lock attempt is aborted.
• Support versions 0.9.x of package:sqlite3_web.

Update to sqlite3_web versions 0.8.x.

Full Changelog: sqlite_async-v0.14.1...sqlite_async-v0.14.2

• Support versions 0.8.x of package:sqlite3_web.

• Fix update notifications firing before completed transactions in #140

Full Changelog: sqlite_async-v0.14.0...sqlite_async-v0.14.1

• Fix update notifications sometimes firing before a write has completed.

• Support versions 3.x of the sqlite3 package and 0.7.x of sqlite3_web.
• Remove the sqlite3_open.dart library, SQLite libraries are no longer loaded through Dart.
• Breaking: Rewrite the native connection pool implementation.
  • Remove isolate connection factories. Simply open the same database on another isolate, it's safe to do so now.
  • It is no longer possible to register user-defined functions in Dart. Extensions providing functions in native code can still be used.
• Breaking: Remove AbstractDefaultSqliteOpenFactory and DefaultSqliteOpenFactory. Use SqliteOpenFactory instead. To provide a custom open factory, import NativeSqliteOpenFactory or WebSqliteOpenFactory with a platform-specific import and extend those classes.
• Breaking: Remove the maxReaders parameter on SqliteDatabase. Set that parameter on SqliteOptions instead.
• Breaking: Remove libraries exporting the sqlite3 package:
  • Instead of package:sqlite_async/sqlite3.dart, import package:sqlite3/sqlite3.dart.
  • Instead of package:sqlite_async/sqlite3_common.dart, import package:sqlite3/common.dart.
  • Instead of package:sqlite_async/sqlite3_wasm.dart, import package:sqlite3/wasm.dart.
  • Instead of package:sqlite_async/sqlite3_web.dart, import package:sqlite3_web/sqlite3_web.dart.
• Breaking: Remove SqliteDatabaseMixin and SqliteQueries. Extend SqliteConnection instead.
• Breaking: Calls locking the database that fail with a timeout now throw an AbortException instead of a TimeoutException.
• The throttle parameter on watch and onChange can now be set to null. This also introduces watchUnthrottled and onChangeUnthrottled, which only buffer on paused subscriptions instead of applying a static timeout.
• Add abortableReadLock and abortableWriteLock. The methods can be used to acquire a read/write context with a flexible abort signal instead of a static timeout.

• Support versions 3.x of the sqlite3 package and 0.7.x of sqlite3_web.
• Remove the sqlite3_open.dart library, SQLite libraries are no longer loaded through Dart.
• Breaking: Rewrite the native connection pool implementation.
  • Remove isolate connection factories. Simply open the same database on another isolate, it's safe to do so now.
  • It is no longer possible to register user-defined functions in Dart. Extensions providing functions in native code can still be used.
• Breaking: Remove AbstractDefaultSqliteOpenFactory and DefaultSqliteOpenFactory. Use SqliteOpenFactory instead. To provide a custom open factory, import NativeSqliteOpenFactory or WebSqliteOpenFactory with a platform-specific import and extend those classes.
• Breaking: Remove the maxReaders parameter on SqliteDatabase. Set that parameter on SqliteOptions instead.
• Breaking: Remove libraries exporting the sqlite3 package:
  • Instead of package:sqlite_async/sqlite3.dart, import package:sqlite3/sqlite3.dart.
  • Instead of package:sqlite_async/sqlite3_common.dart, import package:sqlite3/common.dart.
  • Instead of package:sqlite_async/sqlite3_wasm.dart, import package:sqlite3/wasm.dart.
  • Instead of package:sqlite_async/sqlite3_web.dart, import package:sqlite3_web/sqlite3_web.dart.
• Breaking: Remove SqliteDatabaseMixin and SqliteQueries. Extend SqliteConnection instead.
• Breaking: Calls locking the database that fail with a timeout now throw an AbortException instead of a TimeoutException.
• The throttle parameter on watch and onChange can now be set to null. This also introduces watchUnthrottled and onChangeUnthrottled, which only buffer on paused subscriptions instead of applying a static timeout.
• Add abortableReadLock and abortableWriteLock. The methods can be used to acquire a read/write context with a flexible abort signal instead of a static timeout.

Note: This version of sqlite_async is still in development and there might be additional API changes between this release and the final 0.14.0 version. This release is mostly meant for internal testing.

• Support versions 3.x of the sqlite3 package and 0.6.x of sqlite3_web.
• Remove the sqlite3_open.dart library, SQLite libraries are no longer loaded through Dart.
• Breaking: Rewrite the native connection pool implementation.
  • Remove isolate connection factories. Simply open the same database on another isolate, it's safe to do so now.
  • It is no longer possible to register user-defined functions in Dart. Extensions providing functions in native code can still be used.
• Breaking: Remove AbstractDefaultSqliteOpenFactory and DefaultSqliteOpenFactory. Use SqliteOpenFactory instead. To provide a custom open factory, import NativeSqliteOpenFactory or WebSqliteOpenFactory with a platform-specific import and extend those classes.
• Breaking: Remove the maxReaders parameter on SqliteDatabase. Set that parameter on SqliteOptions instead.
• Breaking: Remove libraries exporting the sqlite3 package:
  • Instead of package:sqlite_async/sqlite3.dart, import package:sqlite3/sqlite3.dart.
  • Instead of package:sqlite_async/sqlite3_common.dart, import package:sqlite3/common.dart.
  • Instead of package:sqlite_async/sqlite3_wasm.dart, import package:sqlite3/wasm.dart.
  • Instead of package:sqlite_async/sqlite3_web.dart, import package:sqlite3_web/sqlite3_web.dart.
• Breaking: Remove SqliteDatabaseMixin and SqliteQueries. Extend SqliteConnection instead.
• Breaking: Calls locking the database that fail with a timeout now throw an AbortException instead of a TimeoutException.
• The throttle parameter on watch and onChange can now be set to null. This also introduces watchUnthrottled and onChangeUnthrottled, which only buffer on paused subscriptions instead of applying a static timeout.
• Add abortableReadLock and abortableWriteLock. The methods can be used to acquire a read/write context with a flexible abort signal instead of a static timeout.

• Add executeMultiple to run multiple statements not using parameters.

• Add executeMultiple to run multiple statements not using parameters.

• Update sqlite3_web to 0.4.0

• Add withAllConnections method to run statements on all connections in the pool.

• Fix distributing updates from shared worker.

• Avoid large transactions creating a large internal update queue.

• Support nested transactions (emulated with SAVEPOINT statements).
• Fix web compilation issues with version 2.8.0 of package:sqlite3.

• Shared worker: Release locks owned by connected client tab when it closes.
• Fix web concurrency issues: Consistently apply a shared mutex or let a shared worker coordinate access.

• Native: Consistently report errors when opening the database instead of causing unhandled exceptions.

• Allow profiling queries. Queries are profiled by default in debug and profile builds, the runtime for queries is added to profiling timelines under the sqlite_async tag.
• Fix cancelling watch() queries sometimes taking longer than necessary.
• Fix web databases not respecting lock timeouts.

• Add SqliteConnection.synchronousWrapper and SqliteDatabase.singleConnection. Together, these can be used to wrap raw CommonDatabase instances from package:sqlite3 as a Database (without an automated worker or isolate setup). This can be useful in tests where synchronous access to the underlying database is convenient.

• Support being compiled with package:build_web_compilers.

• Support latest version of package:sqlite3_web.
• Support dart2wasm.

• Remove remaining dart:js_util imports in favor of new interop APIs.
• Add WebSqliteOpenFactory with web-specific behavior for open factories.

• Automatically flush IndexedDB storage to fix durability issues

• For database setups not using a shared worker, use a BroadcastChannel to share updates across different tabs.

• Add the exposeEndpoint() method available on web databases. It returns a serializable description of the database endpoint that can be sent across workers. This allows sharing an opened database connection across workers.

• Support version ^0.2.0 of package:sqlite3_web
• Fix update notifications to only fire outside transactions
• Fix update notifications to be debounced on web

• Support the latest version of package:web and package:sqlite3_web

• Export sqlite3 open for packages that depend on sqlite_async

• Updated web database implementation for get and getOptional. Fixed refreshSchema not working in web.

• FEAT: Added refreshSchema(), allowing queries and watch calls to work against updated schemas.

• Added Navigator locks for web Mutexs.

• Added web support (web functionality is in beta)

• BREAKING CHANGE: Update all Database types to use a CommonDatabase interface.
• Update openDB and open methods to be synchronous.
• Fix ArgumentError (Invalid argument(s): argument value for 'return_value' is null) in sqlite3 when closing the database connection by upgrading to version 2.4.4.

• The dependency for the Drift package is now removed in favour of using the new sqlite3_web package.
• A new implementation for WebDatabase is used for SQL database connections on web.
• New exports are added for downstream consumers of this package to extended custom workers with custom SQLite function capabilities.
• Update minimum Dart SDK to 3.4.0

• Add latest changes from master

• Add latest changes from master

• Fix re-using a shared Mutex from https://github.com/powersync-ja/sqlite_async.dart/pull/31

• Added initial support for web platform.

• Fix errors when closing a SqliteDatabase.
• Configure SQLite busy_timeout (30s default). This fixes "database is locked (code 5)" error when using multiple SqliteDatabase instances for the same database.
• Fix errors when opening multiple connections at the same time, e.g. when running multiple read queries concurrently right after opening the dtaabase.
• Improved error handling when an Isolate crashes with an uncaught error.
• Rewrite connection pool logic to fix performance issues when multiple read connections are open.
• Fix using SqliteDatabase.isolateConnectionFactory() in multiple isolates.

• Allow catching errors and continuing the transaction. This is technically a breaking change, although it should not be an issue in most cases.
• Add tx.closed and db/tx.getAutoCommit() to check whether transactions are active.
• Requires sqlite3 ^2.3.0 and Dart ^3.2.0.

• Fix releasing of locks when closing `SharedMutex``.

• Fix watch when called with query parameters.
• Clean up -wal and -shm files on close.

• No code changes.
• Updated dependencies to support sqlite3 2.x.

• Ensure database connections are cleaned up on unhandled Isolate errors.
• Minor performance improvements.

• Better error messages for recursive transactions.
• Breaking change: Error by default when starting a read transaction within a write transaction.

• Fix update notifications missing the first update.

• Initial version.