Ok. But I'm wondering how GROUPBY and stuff will work?
On Sat, May 3, 2014 at 7:13 AM, Petite Abeille <petite.abei...@gmail.com>wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users