idb_shim

• sdb: the version change requests of the other connections (another tab, an iframe, the same page), the IndexedDB versionchange and blocked events, on SdbOpenDatabaseOptions:
  • versionChangeAction (SdbVersionChangeAction, close by default): what the database does on its own when another connection opens it at a higher version or deletes it: none (stay open, the other waits), close (the other open completes instead of staying blocked forever, SdbDatabase.isClosed tells), closeAndReload and closeAlertAndReload (web: the page reloads on the new version);
  • onVersionChangeRequest: called first, with the current and the requested version (null on a delete), to save what must be or tell the user your own way;
  • blockedAction (SdbBlockedAction, alert by default): what the open does on its own while a connection that keeps the database open at a lower version (a tab of an older app) blocks it: a "close the other tabs" alert on the web, or none; onBlocked is called first. The open completes once that connection closes.
• VersionChangeEvent.newVersionOrNull (null on a delete); the native Database.onVersionChange stream delivers synchronously, so a close in the handler happens inside the browser event; the sembast one is an empty stream instead of throwing.
• Example example/sdb_version_change_exp: two frames of one app opening the same database at different versions.

feat(sdb): versionChangeAction and blockedAction enums, web alert and…

feat: add join support for SDB, enabling left join functionality betw…

Co-Authored-By: Claude Fable 5.1 noreply@anthropic.com
Claude-Session: https://claude.ai/code/session_01BeSPt2peAnMDW5fVfk2B6F

• sdb: Apply the offset and the limit natively (sql LIMIT/OFFSET) instead of walking a cursor, when the implementation supports it, for findRecords, findRecordKeys, streamRecords, iterate and delete on stores and indexes. An implementation reading its rows in one go would otherwise read the whole store on every paged query.
• sdb fix: iterate was ignoring the offset, the skipped rows were handed to the handler.
• Internal (not part of the public idb API): IdbPagedQuerySupport, implemented by an ObjectStore/Index implementation able to page natively.

chore: update version to 2.9.7 and adjust changelog

• fix: correct count logic in sdb_index and sdb_transaction_store

feat: update idbFactory methods to accept dynamic types for better co…

[idb_shim] v2.9.6+2 feat: add SdbTimestamp type and related exports f…

feat: add getDatabaseFullPath() method for improved database path han…

• Add fullPath() extension method on IdbFactory and SdbFactory to get the full path of a database.
• Add pathContext method to IdbFactory and extension method to SdbFactory

• Add sandbox() extension method on IdbFactory and SdbFactory to create a factory where every database is located below a given path.

• Requires dart 3.12
• Add onCount for stores and indexes

• sdb: Add iterate on Store and Cursor.
• sdb: Add cross tab synchronization on the web

• sdb: Allow raw data and codec support

• sdb: Add support for SdbTimestamp in index
• sdb: new internal format for timestamp, migration with helper

• sdb: Add onSnapshot and onSnapshots support for stores, records, and indexes.

• sdb: Allow both schema and onVersionChange in open options
• sdb: deprecate params version, schema, onVersionChanged on SdbFactory.openDatabase and prefer open options
• sdb: fix onVersionChange transaction, allowing manipulating data during open

• Add built-in SdbTimestamp and SdbBlob to Sdb database

• Add onChange listener to SdbDatabase
• Add sdb import/export helpers
• Add options to SdbFactory.openDatabaseOnDowngradeDelete to support schema.

• Import jdb support (from sembast_web)

• Supports Sdb schema and improve sdb api
• Refactor sembast transaction implementation
• Add find options to all queries
• Experimental record streaming in Sdb