[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

[sqlite] Is it possible to use sqlite online-backup system in an ongoing manner?

I am working with IN-MEMORY database. When my program starts I load data from file-system DB into my IN-MEMORY DB. All other SQL operations are performed directly on my IN-MEMORY database. This is in order to keep performance high. However, I have a requirement that my original file-system

[sqlite] Can I assign negative value to the INTEGER PRIMARY KEY column?

Hi, I read in SQLite documentation that if I define column of type INTEGER PRIMARY KEY then this column will become an alias to SQLite internal 64-bit integer index that uniquely identifies the row (hence ‘rowid’). I also read that the initial default value that will be used for such column

[sqlite] Building SQLite DLL with Visual Studio 2015

Hi, I need to build a data-layer DLL for a large project. My project is 64-bit built with Visual-Studio 2015. I want to ask about what would be the preferred way to build SQLite: 1. Build SQLite code as a separate DLL and use it from my data-layer DLL, 2. Use the ready-built binary of

[sqlite] codepages

dear users I use sqlite for vb6, utf-8 database, when insert arabic data to database and search it with 'like' operator (within % syntax), return all records!!! Please help me... thanks John Smith ___ sqlite-users mailing list sqlite-users@sqlite.org