Alexey,
On Thu, Jul 30, 2009 at 4:42 AM, Alexey Pechnikov<pechni...@mobigroup.ru> wrote: > Hello! > > Please see > http://mobigroup.ru/files/sqlite-ext/versioning/ I haven't looked at your work in depth, but I am interested in this. I have implemented a very simple versioning system with TRIGGERs whereby every change (INSERT, UPDATE, DELETE) in a column in a table is stored in a versions table along with its primary key, allowing me to go back and examine any version and roll back to it, if desired. Again, without looking at your code first, what is it that you are doing with the C libs that can't be done with just TRIGGERs and a versions table? > > Master-slave may use ROWIDs and multy-master may use md5 hash of full record. > > This is test version and I'm glad to get any comments and ideas. > > P.S. md5 extension sources is here > http://mobigroup.ru/files/sqlite-ext/md5/ > > 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 > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= Sent from Madison, WI, United States _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
