Yes, I have my extension for this http://sqlite.mobigroup.ru/dir?name=ext/murmurhash
But I think the feature will be very helpful as core function. 2011/3/6 Enrico Thierbach <e...@open-lab.org>: > > On 06.03.2011, at 14:22, Alexey Pechnikov wrote: > >> Sqlite does not has ability to compress indices. There is huge >> performance problem with populating a database with indexed >> text or blob fields. But we can emulate indices compression >> by using index on hashed field (and populate the hash field by >> trigger as example). I think one or more hash functions may be >> included into core SQLite. >> >> Note: I use the public domain licensed murmur hash algorithm >> (as extension) but this need custom build of SQLite or external >> extension. >> >> Does anybody has the same problem? >> > > Hey Alexey, > > couldn't you just define any hash function you like using SQLite's interface > as outlined here? > > http://www.sqlite.org/c3ref/create_function.html > > /eno > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
