SQLite blob data indexing / sorting?
-
I can display blob data in a custom way quite easily: custom draw is well documented.
but how can i sort / search this blob data in a custom way?
eg: if a binary blob has "file alias data" (which is basically a file path but with extra info such that the file can be found if moved), then in the display i show the "resolved" path (easily enough), but i also want to be able to sort by how it is displayed, and search on what is displayed, not on the blob itself.
how can i accomplish this? deterministic user-function? virtual table? relational link?
any ideas? i'm open to suggestions!