http://lmgtfy.com/?q=sqlite+c%2B%2B+wrapper
2017-04-15 0:05 GMT-04:00 Keith Medcalf <[email protected]>: > > What existing one? SQLite3 is written in C ... > > -- > ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > > > -----Original Message----- > > From: sqlite-users [mailto:[email protected]] > > On Behalf Of Daniel Anderson > > Sent: Friday, 14 April, 2017 21:11 > > To: SQLite mailing list > > Subject: Re: [sqlite] Create database > > > > you would probably be better off using C++ to handle everything, less > > chances of forgetting to close something. > > > > do not build your own classes, use existing one! > > > > 2017-04-14 10:44 GMT-04:00 Igor Korot <[email protected]>: > > > > > Keith, > > > > > > On Fri, Apr 14, 2017 at 10:37 AM, Keith Medcalf <[email protected]> > > > wrote: > > > > > > > > To further clarify, the result of doing multiple sqlite3_open calls > > and > > > saving the results to the save db handle is the same as doing > > > > > > > > fh = fopen(...) > > > > fh = fopen(...) > > > > fh = fopen(...) > > > > > > > > You have opened multiple files but are only keeping track of 1. So > > > although three files are opened fclose(fh) will only close the last > one, > > > and the first two are still open, you just discarded your reference to > > them > > > and they are inaccessible to you. > > > > > > > > If you do this sort of thing a lot then you program will eventually > > > crash when it fills up with unreferenced (leaked) memory objects that > > you > > > forgot (and have overwritten the handle) to close. > > > > > > Thank you for clarifying. > > > It means that the call to sqlite3_open() does not close previously > > > opened database and I have to explicitly close it > > > with sqlite3_close(). > > > > > > I was just couldn't find it anywhere in the docs. Probably missed it. > > > > > > > > > > > -- > > > > ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > > > > > > > > > > > >> -----Original Message----- > > > >> From: sqlite-users [mailto:sqlite-users- > > [email protected] > > > ] > > > >> On Behalf Of Keith Medcalf > > > >> Sent: Friday, 14 April, 2017 08:32 > > > >> To: SQLite mailing list > > > >> Subject: Re: [sqlite] Create database > > > >> > > > >> > > > >> No, a new database will be opened and you will be given an sqlite3* > > to > > > it. > > > >> > > > >> Just like the fopen() call can be used to open multiple files, > > > >> sqlite3_open* opens a database. The way to close an sqlite3* > (handle > > to > > > >> a) database is to use sqlite3_close specifying the database you want > > to > > > >> close. > > > >> > > > >> -- > > > >> ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > > > >> > > > >> > > > >> > -----Original Message----- > > > >> > From: sqlite-users [mailto:sqlite-users-bounces@ > > > mailinglists.sqlite.org] > > > >> > On Behalf Of Igor Korot > > > >> > Sent: Friday, 14 April, 2017 08:26 > > > >> > To: Discussion of SQLite Database; General Discussion of SQLite > > > Database > > > >> > Subject: [sqlite] Create database > > > >> > > > > >> > Hi, > > > >> > If I have a database open with sqlite3_open() and then want to > > issue > > > >> > another sqlite3_open(), > > > >> > the old database will be closed and the new one will open? > > > >> > Or I have to explicitly call sqlite3_close()? > > > >> > > > > >> > Thank you. > > > >> > _______________________________________________ > > > >> > sqlite-users mailing list > > > >> > [email protected] > > > >> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- > > users > > > >> > > > >> > > > >> > > > >> _______________________________________________ > > > >> sqlite-users mailing list > > > >> [email protected] > > > >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/ > sqlite-users > > > > > > > > > > > > > > > > _______________________________________________ > > > > sqlite-users mailing list > > > > [email protected] > > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > > > sqlite-users mailing list > > > [email protected] > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > > > > > -- > > Daniel > > *L'action accède à la perfection quand, bien que vivant, vous êtes déjà > > mort* > > *Bunan* > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Daniel *L'action accède à la perfection quand, bien que vivant, vous êtes déjà mort* *Bunan* _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
