Oscar Franco

1. Yes, calling a JS function a few times will be a lot slower than calling a native function, by adding the table and id on the C++ side it...

It's a direct binding to the sqlite3 hook, you can take a look at the documentation of sqlite

This is now available to test. ``` npm i @op-engineering/[email protected] ``` The API is as described. Give it a try and let me know if it is working for you!...

After some playing around, realized the API was wrong, the new API is: ```ts const unsubscribe = db.reactiveExecute({ query: 'SELECT * FROM User;', arguments: [], fireOn: [ { table: 'User',...

No, it's because the update_hook from sqlite emits the row id, which I'm not even sure it matches user defined primary keys. In any case, I could query the entire...

it is the row id :) It's just I haven't quite gotten a hold of how it works, if a row is deleted do all the row ids move back?...

ok, cool, well, I guess you can use any id you want then, but you need to fetch the ROWID first

you have to first get the rowid which will not be the same as the id column you create, it is also a number not a string. ```js let rowid...

Reactive queries are out and should be working. Open new tickets if you find any issues.

hmm weird, they both should work. I will take a look later, can you open a ticket for it?