I’m using Peewee and obtain my connection from an URL like this:
from playhouse.db_url import connect db = connect('sqlite:///C:/some/file.db') connection = db.connection() connection.execute('PRAGMA foreign_keys=ON') # How can I set the SQLITE_MAX_VARIABLE_NUMBER here? connection.execute('?????????????????')
How can I correctly increase the SQLITE_MAX_VARIABLE_NUMBER
? I am stuck in an older 2.x SQLite version and can’t upgrade unfortunately … corporate policies. I am aware that the latest versions of SQLite have increased the default limit beyond 999.
Advertisement
Answer
See the documentation here: https://www.sqlite.org/limits.html#max_variable_number
You will need to recompile Sqlite to raise the limits.