[Request]: Node JS Cross Platform Support

[tyrauber]

What do you need?

Hey @ospfranco, I know I have told you before, but thank you so much for this library. The latest rev with libsql support, triggers, json and vector support.... :chefkiss:

Question: Is it possible to configure cross platform support? Specifically node.js support?

I tried to write a jest test using a real database and op-sqlite complains about native modules. Is this just a misconfiguration issue? I don't want to mock the db, I want to test the tb. It would be amazing if we could use the same library interface, and have it just work seamlessly in both environments.

If ops-sqlite could work in node js, not only would that mean jest support, but also in an express server, or an electron app. Powerful stuff. Code your database store once with drizzle, deploy everywhere.

I know with Sol, you have to be using op-sqlite under the covers, so this has to be something you have tackled already? Does the library already do this already and I am just missing something? Maybe this is just a documentation issue?

Would love your thoughts and guidance before diving in. Thanks again, Oscar.

[ospfranco]

op-sqlite depends on JSI, which is react-native only. That being said, it might be possible to write a different JS entry point for the library and modify the native compilation to link against a nodeJS version of libsql... it would just be a bunch of work :)