sql.js icon indicating copy to clipboard operation
sql.js copied to clipboard

Feature Request: Integrate bindings for sqlite3 api UPDATE HOOK

Open akpor-kofi opened this issue 1 year ago • 3 comments

For reactive queries i would like to be able to run a callback immediately a table change in my sqlite db using update hook. i tried using create_function + triggers but that doesn't seem to work either

akpor-kofi avatar Nov 27 '24 13:11 akpor-kofi

or is there a way to actually use the create_function + trigger

akpor-kofi avatar Nov 27 '24 18:11 akpor-kofi

Hey I'd like to have that too and also the sqlite3_column_table_name function. My goal is to write a Sqlite based store for React.

Looking at the code in api.js this should be fairly straightforward. I'll whip up a short demo if I find the time.

hoeck avatar Mar 08 '25 09:03 hoeck

Great ! If you make a PR, be sure to write extensive doc comments too !

lovasoa avatar Mar 08 '25 13:03 lovasoa