SQLite Forum

can i custom index blob data?
Login
i can *display* blob data in a custom way, easily enough, but i want said data to be indexed / searchable / sortable according to how i would display it.

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 want to show the "resolved" path, i also want to be able to sort by that and search by it.

how can i accomplish this? deterministic user-function? virtual table? relational link? 

any ideas? i'm open to suggestions!

-dave