Libsql support

[ospfranco]

Libsql (https://github.com/tursodatabase/libsql) is an open contribution fork of sqlite. It adds a lot of features including server replication and vector search. Some people have expressed interest in sponsoring the work to get it working within op-sqlite, I would be willing to tackle the job but it looks like multi day work so I need to make time (= money) to reserve the time for it.

Upvote & Fund

• We're using Polar.sh so you can upvote and help fund this issue.
• We receive the funding once the issue is completed & confirmed by you.
• Thank you in advance for helping prioritize & fund our backlog.

[ospfranco]

There is a version out that supports libsql:

@op-engineering/op-sqlite@6.0.2-beta3

enable it by modifying the package.json:

"op-sqlite": {
  "libsql": true
}

Caveats:

• Hooks are not supported
• Reactive queries are not supported
• Multiple statements in a single query are not supported

This version is using experimental C bindings from libsql, so some features might be broken. Give it a thorough test and report any issues here please.

[ospfranco]

There is a new version 6.0.2-beta4 adds support for remote connections:

import {openRemote} from '@op-engineering/op-sqlite';

const remoteDb = openRemote({
  url: 'my_url',
  authToken: '...'
});

[abdelhameedhamdy]

There is a version out that supports libsql:

@op-engineering/op-sqlite@6.0.2-beta3

enable it by modifying the package.json:

"op-sqlite": {
  "libsql": true
}

Caveats:

• Hooks are not supported
• Reactive queries are not supported
• Multiple statements in a single query are not supported

This version is using experimental C bindings from libsql, so some features might be broken. Give it a thorough test and report any issues here please.

Awesome work, great to see libsql in RN, wondering is libsql missing the update hooks c bindings, if so, it really miss very important feature.

[ospfranco]

No, it's not about the bindings, they don't support it.

[abdelhameedhamdy]

They are discussing such a Proof of Concept update hook.