U++ forum: Welcome to the forum

Re: Multiple schema files? [message #26954 is a reply to message #26905]

Sun, 13 June 2010 18:04

mirek
Messages: 13980
Registered: November 2005

Ultimate Member

jeremy_c wrote on Mon, 07 June 2010 13:20

I am wondering if it's possible to have multiple schema files and multiple databases? Here's the synario... I am writing a program that allows one to log amateur radio contacts. To do so, we often refer to many other data sources, such as the FCC license data (about 86mb when put into a sqlite3 db), Canadian license data, country data (latitude/longitude for centers, callsign attributes, etc...).

Yes, of course. Having multiple .sch files is quite normal.

Using more than single database connection at time is less usual, but definitely possible.

Quote:

So, that database winds up being pretty big. Then there is the actual "logbook" which tracks the actual contacts that a ham operator makes. This database, having 5-8 tables and the largest one containing about 40 fields is pretty small. Also, the operator may have multiple log books, one for a contest they've run, another for their home operations and another for mobile operations. Many families have multiple ham operators as well.

So the program ideally should have two data sources, the static reference data (callbooks, country information, etc...) then the actual logbook which can be opened, closed, imported, exported, synced w/laptop resource, etc... I'd rather not have to have the user maintain the large static database in their individual log file.

Can this be done? Is there an example or information on this? I thought of using attach to "include" the static data into the main database, but how would that work when creating the database for the first time (the logbook database)? I'm afraid that the static data tables would be created in the logbook database?

But this rather sounds like some tables with more or less static data fit your scenario equally well?

Mirek

Report message to a moderator