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" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of slav...@bigfraud.org> wrote: > >On 24 May 2016, at 6:04pm, Michael Hari <michael.h...@slalom.com> 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 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? > >Create a versioning system for your database which is not the same as the >version of your application. Continue to use Sparkle for your application but >not for the database file. > >Upgrading your database from one version to another can be done in three ways: > >A) Distribute an additional .sqlite file. To update the local database have >the application read the data from this file and add it to the local copy of >the database. > >B) Distribute a .zipped text file containing the SQL commands needed to update >the local copy of the database. To update the local database have the >application read the commands from this file and execute them. > >C) Distribute a .zip containing a .csv file for each table. To update the >local database have the application read the text from this file and convert >it to INSERT commands. > >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=CwIGaQ&c=fa_WZs7nNMvOIDyLmzi2sMVHyyC4hN9WQl29lWJQ5Y4&r=Za210bkAr8T8OGv7-RSux2dLtMfHgyYbTEN9AO6LXXg&m=ahSUBK1T7j-1qWdH9sKUO09_FAWT0Eeb1s32vYabAg0&s=9lhqAP5mAfvcMjMuMHs6L0HxVgtTW0uXHq79XI8KeYg&e= > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users