Re: [sqlite] Binary Difference in Sqlite database files instead of SQLdiff and patch ?

On 25 May 2016, at 7:23pm, Michael Hari wrote: > What about if we shard the tables in the database across multiple databases? > Is that possible to do? Does SQLite support the concept of sharding? No. Each table has to be entirely contained in a specific database

Re: [sqlite] Binary Difference in Sqlite database files instead of SQLdiff and patch ?

What about if we shard the tables in the database across multiple databases? Is that possible to do? Does SQLite support the concept of sharding? Thanks, Michael On 5/24/16, 10:20 AM, "sqlite-users-boun...@mailinglists.sqlite.org on behalf of Simon Slavin"

Re: [sqlite] Binary Difference in Sqlite database files instead of SQLdiff and patch ?

This should read: In our apps we required a full db download, in case the db schemes did not match. Am 25.05.16, 19:49 schrieb "sqlite-users-boun...@mailinglists.sqlite.org on behalf of Stadin, Benjamin" unter

Re: [sqlite] Binary Difference in Sqlite database files instead of SQLdiff and patch ?

I’m discussing with my company if I’m allowed to open source our "option D“. It was written for a certain use-case (to provide updates of large dbs on mobile phones for our own apps), therefore it is not entirely generic. It works like this: - Every table in the db needs a column „md5checksum“,

Re: [sqlite] Binary Difference in Sqlite database files instead of SQLdiff and patch ?

On 24 May 2016, at 6:04pm, Michael Hari wrote: > 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

Re: [sqlite] Binary Difference in Sqlite database files instead of SQLdiff and patch ?

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

[sqlite] Binary Difference in Sqlite database files instead of SQLdiff and patch ?

On 23 May 2016, at 9:08pm, Piyush Shah wrote: > We know about sqldiff https://www.sqlite.org/sqldiff.html 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

[sqlite] Binary Difference in Sqlite database files instead of SQLdiff and patch ?

Hi, We are using the Sparkle Project https://sparkle-project.org/ to manage a Mac OS X application updates that has an embedded sqlite database. We were hoping that the Sparkle project would be able to detect differences in the SQLite database file and include that in the Delta it generates