> 1) dont see a way to reuse schemas. In other words, I have say 10 tables with > the same schema. How would I prevent doing 10 CREATE table commands ?
Create 1 table with 1 additional column "schema" which will contain numbers from 1 to 10. > Would there be a way I can pass the schema as well as data into SQLite ? Elaborate please what do you want to do, where do you want to pass "schema" (do you mean table name here?) and data? > 2)Also, do you reccomend a different .db file for each schema so that > multiple threads can easily operate at the same time ? It depends on how your threads will operate, how often they will issue sql statements, what type of sql statements and all other details about your application functionality. Pavel On Tue, Sep 15, 2009 at 5:27 PM, Kavita Raghunathan <kavita.raghunat...@skyfiber.com> wrote: > All, > I have a couple of questions: > > I've been studying the C/C++ interface, and > 1) dont see a way to reuse schemas. In other words, I have say 10 tables with > the same schema. How would I prevent doing 10 CREATE table commands ? Would > there be a way I can pass the schema as well as data into SQLite ? > > 2)Also, do you reccomend a different .db file for each schema so that > multiple threads can easily operate at the same time ? > > I apologise in advance if I missed it in the documentation. > > Thanks again to this group for your awesome support. I've got a lot of ideas > from you all. > > Regards, > Kavita > _______________________________________________ > 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
