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
Scope of local SQLite tables
-
tsupartono
- Posts: 289
- Joined: Wed Apr 18, 2012 10:21 am
Re: Scope of local SQLite tables
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.
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.