On May 4, 2008, at 4:36 PM, M. Emal Alekozai wrote: > Hi, >> In the BIG db I have worked on there is a table that log every >> insert/update >> on specific and important tables and a log of every sql statement >> execute >> but I haven't ever see a db under version control with svn (or csv >> or git or >> any other). >> > I'm (mis)using subversion more as a synchronization tool than as a > version control system. I have a small software project and I have to > work on this project on different computers (desktop, laptop, ...). To > synchronize the project on all computers I use subversion. Before > starting to work on one computer I make an "svn update" for the > project > and after finishing I do a "svn commit". ... > > But the drawback is that the sqlite database is in a binary format and > putting it into subversion is not optimal ;-). > > A possible solution would be to export the sqlite database as a list > of > sql commands. > > Are there any other solutions /approaches for sqlite available? >
http://www.fossil-scm.org/ I wrote fossil for a very specific use - a use which other DSCMs lacked necessary features. But having written it, I am now finding that is is also very useful as a "synchronization tool", such as you describe above, and that is my primary use for fossil at the moment. I use multiple desktop and laptop systems to work on projects and I find that synchronizing using fossil is very convenient. About six months ago, we shifted all of the documentation for SQLite out of CVS and into fossil. The fossil repository for the SQLite documentation is working quite well. See http://www.sqlite.org/docsrc/timeline to see for yourself. We might someday shift the SQLite core from CVS to fossil... Fossil will work fine with binary files. You won't be able to "diff" the files obviously, nor "merge" them if you fork your line of development. But that is just the nature of binary files. I don't think any SCM system is able to diff or merge arbitrary binary files. There may be modules for diffing and merging specific binary files formats (ex: DOC files) but not arbitrary binary files nor likely SQLite database files. So take care not to fork. But otherwise, you should be fine. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users