Re: [sqlite] Find stmt that's stopping a DB from closing

On 5 Nov 2019, at 8:39pm, Keith Medcalf wrote: > If pStmt is NULL then this interface returns a pointer to the first prepared > statement associated with the database connection pDb. Ah, that's brilliant. I missed that. ___ sqlite-users mailing list

Re: [sqlite] Find stmt that's stopping a DB from closing

>The first statement associated with an open connection is pointed to by >the pStmt of that connection. Once you've found the first statement call >sqlite3_next_stmt() >on it to find the next one. > > >Unfortunately the database connection is

Re: [sqlite] Find stmt that's stopping a DB from closing

Thanks Simon. Used this string str; sqlite3_stmt *stmt=NULL; do { stmt=sqlite3_next_stmt(FSQLiteDB,stmt); if (stmt) str+=string(sqlite3_sql(stmt))+"\r\n"; } while (stmt); From:

Re: [sqlite] Find stmt that's stopping a DB from closing

On 5 Nov 2019, at 7:27pm, x wrote: > I’m sure the team added a fct that listed the offenders but I can’t find it > in the documentation. The first statement associated with an open connection is pointed to by the pStmt of that connection. Once you've found the first statement call

Re: [sqlite] Find stmt that's stopping a DB from closing

>I think you're referring to "The SQLITE_STMT Virtual Table": https://www.sqlite.org/stmt.html That’s it David. Thanks. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Find stmt that's stopping a DB from closing

I think you're referring to "The SQLITE_STMT Virtual Table": https://www.sqlite.org/stmt.html -Original Message- From: sqlite-users On Behalf Of x Sent: Tuesday, November 5, 2019 2:27 PM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Find stmt that's stopping a DB from

[sqlite] Find stmt that's stopping a DB from closing

I’m sure the team added a fct that listed the offenders but I can’t find it in the documentation. I would’ve thought it would have been mentioned on the sqlite3_close page but no sign of it. Am I imagining things? ___ sqlite-users mailing list

Re: [sqlite] SQLite with branching

> On Nov 5, 2019, at 1:27 AM, Dominique Devienne wrote: > > AFAIK, that was one of the goals of SQLite4 [1], to change the backend to LSM. LMDB (LiteTree's back-end) doesn't use LSM; it's a B-tree manager. The speedup appears to come from a combination of techniques like eliminating caching

Re: [sqlite] Rounding Error

Adrian Sherwin, on Monday, November 4, 2019 03:41 AM, wrote... > > Hi, > > I would like to report the following as a bug in SQLITE: > > The SQLITE "round" function fails to round between 4.1 and 4.6% of numbers > correctly to x decimal places when held as x+1 decimal places. > > The simplest

Re: [sqlite] SQLite with branching

On Tue, Nov 5, 2019 at 10:01 AM Wout Mertens wrote: > On Mon, Nov 4, 2019 at 10:26 PM Jens Alfke wrote: > > > I don't have a practical use for the branching features, though they're > cool, but I'm salivating at the thought of a 2x speedup. > > With all the work that's put into eking out small

Re: [sqlite] SQLite with branching

On Mon, Nov 4, 2019 at 10:26 PM Jens Alfke wrote: > I don't have a practical use for the branching features, though they're cool, > but I'm salivating at the thought of a 2x speedup. > With all the work that's put into eking out small performance increases in > SQLite, I'd imagine the devs