On Wed, 14 Sep 2016 23:34:18 +0300 "E.S. Rosenberg" <es.rosenberg+sailfishos....@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. _______________________________________________ SailfishOS.org Devel mailing list To unsubscribe, please send a mail to devel-unsubscr...@lists.sailfishos.org
