Re: Questions from the Subversion 1.6 Preview event in Berlin

On Sun, Mar 1, 2009 at 6:11 PM, Branko Cibej <brane_at_xbc.nu> wrote:
> Bert Huijben wrote:
>> Note that the default behavior of WC-NG will be to store all administrative
>> area in a single .svn directory in the working copy's root. This will still
>> allow zipping up a repository, etc. just like WC-1.0.
>>
>
> Are you sure you can just zip up some database created by a semi-random
> variant of sqlite3, unpack it and use it on another box with a different
> OS, word size and, gods forbid, endianness?

According to the "Definitive Guide to SQLite" the answer is absolutely
yes. The file is guaranteed to be binary compatible across all
platforms, endianness, 32/64-bit etc..

http://books.google.com/books?id=VsZ5bUh0XAkC&pg=PA8&lpg=PA8&dq=sqlite+portability+of+database+file&source=bl&ots=u45Kmp52F5&sig=2A_Bst88utrWE-QcCNv6JipBrnw&hl=en&ei=HRmrSc_CA-CbtwfD6ODvDw&sa=X&oi=book_result&resnum=3&ct=result

That said, it does seem like different versions of SQLite can
theoretically cause problems:

http://www.sqlite.org/formatchng.html

-- 
Thanks
Mark Phippard
http://markphip.blogspot.com/
------------------------------------------------------
http://subversion.tigris.org/ds/viewMessage.do?dsForumId=462&dsMessageId=1253011