On May 3, 2014, at 3:40 PM, Hayden Livingston <halivings...@gmail.com> wrote:
> This looks promising. I sooo wish it didn't have a limit to number of > databases. 10 by default if I recall properly. Can be perhaps be increased to 62 at most: http://www.sqlite.org/limits.html > But I think I could reasonably do something like coalesce the > databases into a new database once every 2 hours. I also need to generate > some code to figure out how to address the tables which I guess means I'll > have to do an N way JOIN? The table names stay the same. Each attached database can have a unique name. So, for example: attach … as attached01; attach … as attached02; ... with DataSet as ( select count( * ) as count from attached01.table union all select count( * ) as count from attached01.table union all ... ) select sum( count ) as sum from DataSet; Also: http://www.sqlite.org/pragma.html#pragma_database_list _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
