CODEWITHSUNDEEP
python-2.7sqlitemax
user2928681
user2928681

Reputation:

How to actually change the maximum number of columns in SQLITE

So I have a sqlite3 db, which I access from Python (2.7), where I would like to store more than the by default allowed 2.000 columns. I understand that there is a setting or command, SQLITE_MAX_COLUMN, which I can alter, so that my database can store up to ~32.000 columns. My question is how do I in practice set the maximum number of columns to for example 30.000 - what is the specific code, that I should run? Hope my question is clearly stated. Thanks

Upvotes: 1

Views: 1255

Answers (1)

John Zwinck
John Zwinck

Reputation: 249153

That's a compile-time parameter for SQLite itself. As in, you'll need to recompile the SQLite library in order to change it. Nothing you can do in Python will be able to overcome this.

Upvotes: 2

Related Questions