Hi Simon, We don’t want to zip up the entire db unfortunately. It would be around 250 MB zipped versus having Sparkle update with a 38 MB patch. (Bandwidth costs are important for us)
I’ve come to the conclusion that I would need to “split the file into two databases” as well. The challenge here is that the larger db will have to have a limit of 2 GB and will need to make a new db when it hits that limit. It would have to split it into multiple Dbs as the data grows (so db1.sqlite, db2.sqlite, etc.). Would you happen to know any strategies to accomplish this in sqlite? Either through SQL or scripting? Thanks, Michael On 5/23/16, 1:46 PM, "sqlite-users-boun...@mailinglists.sqlite.org on behalf of Simon Slavin" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of slav...@bigfraud.org> wrote: > >On 23 May 2016, at 9:08pm, Piyush Shah <piyush.s...@slalom.com> wrote: > >> We know about sqldiff >> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.sqlite.org_sqldiff.html&d=CwICAg&c=fa_WZs7nNMvOIDyLmzi2sMVHyyC4hN9WQl29lWJQ5Y4&r=Za210bkAr8T8OGv7-RSux2dLtMfHgyYbTEN9AO6LXXg&m=H8MM4zcxx8e1CF2D98PKVDGp8SvCTyw-dv7XoQ5KPw4&s=8qlz1JEuXvYSnt4FvMj1V_UVQ2pQqaCG78j0tbSf3pU&e= >> and would use it to generate diffs and patch them but we were hoping >> there was a way to do do a binary diff of the database because otherwise we >> will have to figure out a way for the client to run the sqldiff utility to >> patch the database. > >There's no easy way to integrate Sparkle and sqldiff so that they work >together like that. The amount of work it would take would be equivalent to >writing your own tool which updated the database across the internet. > >If the database file is small, just let Sparkle update it with the other >components of the application. If the database file is big, it may be worth >doing work on it. > >Does the database file compress well as a ZIP file ? Then distribute it as a >.zip. On startup, detect if the decompressed version is not present, or has a >datestamp before the .zip version. > >Do you have roughly equal parts of the file taken up with tables which never >change and tables which change with each update ? Then split the file up into >two database files and use ATTACH to access them both via one connection. > >Simon. >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=CwICAg&c=fa_WZs7nNMvOIDyLmzi2sMVHyyC4hN9WQl29lWJQ5Y4&r=Za210bkAr8T8OGv7-RSux2dLtMfHgyYbTEN9AO6LXXg&m=H8MM4zcxx8e1CF2D98PKVDGp8SvCTyw-dv7XoQ5KPw4&s=deDylKqCP4ECaSOv3XoqH0xfznS3YHz3ZlsPDbzxbXE&e= > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
