Re: [sqlite] Proposal: limit the number of columns in a table to 2000.

[Edward Macnaghten]

I am an application programmer by trade, programming accountancy and 
inventory type packages using various SQLs.

2000 columns/tableis plenty for my use.  I do not see needing to go 
above that in any scneario.  If the need requires that you do need to go 
above that either the database design is wrong and needs redoing, or you 
should not really be using an engine like SQLite anyway!

Eddy
D. Richard Hipp wrote:
As currently implemented, there is no fixed limit to the number
of columns you can put in a table in SQLite.  If the CREATE TABLE
statement will fit in memory, then SQLite will accept it.  Call
the number of columns in a table K.  I am proposing to limit the
value of K to something like 2000.
Would this cause anyone any grief?

<snip content="justification"/>