SQLite Forum

Non primary key alias to rowid
I need the RowId for the update hook, I had actually the same idea like you but RowId is hardcoded to many C APIs. The text id is quite long, so I thought it would better not to use it as a foreign key. Actually I do not understand your last sentence. But it looks like there is no easy way to get rid off the extra unique id. I can live with that. Like I said I am not an expert, especially to the session extension, and I am trying to avoid to do a really stupid mistake. Thank you for you help. :-)