SQLiteBunPersister - for Bun

[mohsinhijazee]

What

Would be nice if we could have a SQLiteBunPersister (or BunSQLitePersister) because bun already supports SQLite3 out of the box as described here.

How

Solution could be using createCustomSqlitePersister a new persister named SQLiteBunPersister.

Alternatives
I have considered using createCustomSqlitePersister but I think that's more of an internal API and better be that way.

Why

Bun is really popular and its very easy to setup, comes out of the box with Typescript etc etc. So would be nice if we could support that.

[jamesgpearce]

This should be easy! I just need to figure out how to test it with the existing suite that runs in Node. Should be doable...

[mohsinhijazee]

Thank you for your response! I'll take a look at the testing setup to see what are our possibilities to cover the testing.

[jamesgpearce]

I've figured something out (where some tests only run when executed by Bun).

One small limitation I will raise now is that the Bun API has no way to monitor changes to tables (like most sqlite SDKs) so in terms of reactivity, it will default to a polling mechanism. Hope that's OK!

[mohsinhijazee]

Oh that's a surprise. I think we can keep the bun support as development/preview and warn against production usage in the documentation could be one way to go about it.

This way, bun can be used as and during development phase while final deployment should or could be anything. Later, as the situation improves on the Bun's side, we can review it later.

I'm thinking to file a corresponding issue with Bun as well.

[jamesgpearce]

Yep, all the major SQLite adaptors have some form of access to the sqlite3_update_hook - just not Bun yet

[jamesgpearce]

OK, go kick the tires on https://github.com/tinyplex/tinybase/releases/tag/v6.1.0-beta.4 !