Page 1 of 1

Scope of local SQLite tables

Posted: Tue Jan 14, 2014 7:34 pm
by LEBAS
I have a few questions about SQLite tables:

• Is there a single SQLite database per App LongRange (i.e. one SQLite database for all server profiles/schemas)?
• Are local tables specific to a server profile/schema?
• When local tables are created?
• When local tables are deleted?

Regards

Yann

Re: Scope of local SQLite tables

Posted: Wed Jan 15, 2014 9:45 am
by tsupartono
Each server profile has their own database file (*).
Tables are created when they are accessed the first time.
They will remain there until LongRange is uninstalled (this may change in the future releases).

(*) Note - in the current version of LongRange, it's possible for multiple profiles to share the same set of files if the profiles are pointing to exactly the same server, port, and schema. This will change in the future releases of LongRange where every profile will have their own set of files.