2009/7/7 Vijay <email@example.com>
The reason i am asking is i have multiple columns which a user can query on like UID, URL, TAGS (all of them are unique).... but how can i get to them without getting stuck with the rowid? coz rowid can be one of those.... and the user at any time can know only one....
You have to create your own index as another table, and range scan that to get the keys for your main table. It's not pretty.
But in any case, that's what a (traditional) database really does internally anyway, it's just a bit more automatic.
I find the awkward bit is cleaning up cross-references, when you want to throw a row out of the main table, each of its indexes need to be cleaned up by a separate delete operation.