[SailfishDevel] Connect to 2 databases

Chris Walker cdw_nokiaqt at the-walker-household.co.uk
Thu Sep 15 08:53:43 UTC 2016

On Wed, 14 Sep 2016 23:34:18 +0300
"E.S. Rosenberg" <es.rosenberg+sailfishos.org at gmail.com> wrote:

> Assuming you need SQLite since you are developing for SailfishOS the
> first result here seems to be what you are looking for:
> https://www.google.nl/search?q=c%2B%2B+sqlite
> Instead of creating one SQLite object you create 2 or more, one for
> each database.... though if you are opening a lot of databases you
> might want to consider if they shouldn't all be different tables in
> the same database.

I can't add the tables to the first database as I want to use that 'as
is' and hence read only.

> Of course you could also be more forthcoming about what exact db
> you're trying to connect to and what you tried so that we don't do
> double work for you, I believe as a community we need to be helpful
> etc. but as a member looking for help I also need to do my due
> diligence, without that expect short basic answers or none...

As a beer drinker, I am a member of CAMRA - http://www.camra.org.uk/

They have an app for iOS and Android and while I do have the Android
app on my phone I think it's awful. So I'm trying to write an app to
use the CAMRA database which happens to be a sqlite file. CAMRA update
the app and data annually and I want to be able to simply overwrite the
existing database with the new one each year but retain my own database
for noting things like which beers I've drunk.

I've checked with the company that wrote the app for CAMRA and they say
that they try to maintain the same database structure and numbering
each year but it falls to CAMRA to maintain the numbering as they
supply the data to the app company. I'm assuming (perhaps naively) that
it will remain constant.

I might also have another app for noting which pubs I've visited as
CAMRA list pub data in the same sqlite database.

> The general idea should be along these lines:
> sqlite3 *db1, *db2;
> sqlite_open(path1, &db1);
> sqlite_open(path2, &db2);
> Regards,
> Eli

Thanks very much. That gives me something to work with.

I apologise if my first reply was a bit terse. That wasn't my intention.

More information about the Devel mailing list