Re: [sqlite] Developer questions about the Online Backup API

Simon Slavin wrote: > If the source database is changed while the Online Backup API is > running, it returns to the beginning of the database and starts again. The backup API must create a consistent snapshot of the source database, i.e., the result must be the exact state at some point in time

Re: [sqlite] Developer questions about the Online Backup API

> Le 14 mars 2019 à 09:27, Dan Kennedy a écrit : > > On 13/3/62 22:51, Simon Slavin wrote: >> If the source database is changed while the Online Backup API is running, it >> returns to the beginning of the database and starts again. I have a couple >> of questions which might be useful,

[sqlite] Are the 'sqlite3_snprintf()' family protected against SQL injection?

For example, if I write function like: void CreateSQL_SetName( char* buffer, int size, const char* szName, const char* szCondition) { sqlite3_snprintf( size, buffer, "UPDATE my_table SET name='%s' WHERE %s", szName, szCondition); } Does SQLite 'sqlite3_snprintf()' processes

Re: [sqlite] Are the 'sqlite3_snprintf()' family protected against SQL injection?

On 3/14/19, John Smith wrote: > For example, if I write function like: > > void CreateSQL_SetName( char* buffer, int size, const char* szName, > const char* szCondition) > { > sqlite3_snprintf( size, buffer, "UPDATE my_table SET name='%s' WHERE > %s", szName, szCondition); > }

Re: [sqlite] missing SQLITE_DEFAULT_TEMP_CACHE_SIZE

On Mar 10, 2019, at 1:33 PM, Joshua Thomas Wise wrote: Hello, The documentation here (https://www.sqlite.org/tempfiles.html#other_temporary_file_optimizations

[sqlite] Missing docs

Nowhere in the current documentation does it mention the existence of the SQLITE_ENABLE_NORMALIZE compile-time option, and nowhere does it mention that sqldark_source_normalized() requires that option to be present. The docs should probably mention this. - Josh

Re: [sqlite] Feature suggestion / requesst

May I ask whether this suggestion has been considered being added to SQlite? - Original Message - From: Clemens Ladisch To: sqlite-users@mailinglists.sqlite.org Sent: Friday, June 8, 2018, 08:25:25 Subject: [sqlite] Feature suggestion / requesst Hick Gunter wrote: >> I've encountered