Re: [sqlite] Question of Table/Indices common to multiple Databases

Thank you all for your feedback. I now have a lot more to digest. I will investigate the attach command. I am concerned about keeping all of my company's data in 1 file, as if something happened to that file, I would have data entry, programming, etc. to on all systems since the last

Re: [sqlite] Question of Table/Indices common to multiple Databases

>Now, there are some unusual situations where you might want to hold >your customers in a different database from your invoices and use >SQLite to hold both databases open at once using ATTACH. I’ll let >other people argue about that. But of course if you do that, then you cannot have the

Re: [sqlite] Question of Table/Indices common to multiple Databases

m: 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

Re: [sqlite] Question of Table/Indices common to multiple Databases

SQLite itself can do both single file, or multi-file handling through a single connection. Generally speaking, though, SQLite is a single file database. In order to use multiple files (AKA Multiple databases) in a single connection, you'd use the SQLite3 proprietary command of "ATTACH ". In

Re: [sqlite] Question of Table/Indices common to multiple Databases

On 31 Aug 2017, at 6:44pm, John R. Sowden wrote: > 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

Re: [sqlite] Question of Table/Indices common to multiple Databases

Hello John, ATTACH DATABASE may well be the statement that you need: https://www.sqlite.org/lang_attach.html It lets you use several sqlite files from a single database connection, and execute queries across all tables of all attached files. Gwendal

[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