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 file. You
can do things in
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" wrote:
>
>On 24 May 2016, at 6:04pm
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
:
>In our apps we required a
>full db download instead of a diff.
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“, an
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 that limit.
> It would have
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 he
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 t
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
8 matches
Mail list logo