Re: [sqlite] Multi-master replication with updated Versioning extension

Hello!

On Thursday 30 July 2009 18:17:45 Jim Showalter wrote:
> MD5 hashes can still collide. How does this implementation deal with 
> hash collisions?

Now it is possible to use any hash function:

-- first column is unique key
select versioning('arg1','sessions');
-- use md5 hash of all fields
select versioning('md5','sessions');

Note: function arg1() is coded in versioning extension.
select arg1('a');
a
select arg1('a','b','c');
a

When you will define sha256 function (as example) you can do
select versioning('sha256','sessions');

Thanks for you comment.

Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
sqlite-users@xxxxxxxxxx
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users