Why do you want multiple databases? All the "Data" goes in one "base". Hence the term "database".
--- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of John R. Sowden >Sent: Thursday, 31 August, 2017 11:45 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Question of Table/Indices common to multiple >Databases > >I have been using the xbase language (dbase, foxpro, etc.) for about >36 >years, writing applicatios for my alarm company, so each database is >a >separate file for me. For the last 21 years, I have been using >Linux, >and have found that sqlite is my best match for Linux database use. > >What I fail to understand is how I set up my files/databases. I have >categories that I write for: accounting, dispatching, service, >billing, >etc. Some (most) of these use customer data, so when I am writing >code >for the billing program, and I want to reference the customers, is >that >a separate file, so I only have 1 customer file to update (the >relational model)? Having a customer table, with indices, in each >category's database (file) breaks the relational model. I have been >on >this list for about a year and see no reference to this issue. I am >reading now about sqlite in _The Definitive Guide to SQLite_ by >Michael >Owens, but I'm early in the book. > >Help? > >John > >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
