Feature request: add last_insert_rowid method

[jmatsushita]

Hi there,

I'm giving a shot at implementing the web version of expo-sqlite by wrapping the wa-sqlite api (with the crsqlite extension). One of the api methods on native returns the last_insert_rowid, however while it seems that the function is exported it's not currently exposed via the sqlite-api.

Would that be of interest? I'm happy to contribute a PR.

Cheers,

Jun

[rhashimoto]

This project reserves Issues for project bugs, so feature requests go here in Discussions.

I'm working on major structural changes, so I prefer not to add more things to migrate for now. In this case, since _sqlite3_last_insert_rowid is already in the WebAssembly module and doesn't need to convert any types, it should be pretty easy for an application to monkey-patch this in for the time being as you should be able to call module._sqlite3_last_insert_rowid(db).

[jmatsushita]

Great thanks for the workaround and good luck on the structural changes. Is there any place on github where I can get a better sense of what these changes will be apart from master...dev ?

[rhashimoto]

The dev branch is indeed where changes will go. It will be unstable; I don't advise trying to use it yet as I might be rewriting its git commits. I'll be posting updates in this discussion.