On Thu, Jul 30, 2009 at 7:42 AM, P Kishor<punk.k...@gmail.com> wrote: > 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?
Ok, I get it. Your code actually creates the versioning tables and triggers automatically. Great. Will give you feedback once I try it out. By the way, DRH has create fossilscm, which is obviously using some kind of versioning. It might be worthwhile studying that and incorporating that, if relevant. > >> >> 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 > -- 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
