SQLite could, in theory, be enhanced (with just a few minor tweaks) to support up to 2 billion columns. But having a relation with a large number of columns seems like a very bad idea stylistically. That's not how relational databases are intended to be used. Normally when a table acquires more than a couple dozen columns, that is a good indication that you need normalize and/or refactor your schema. Schema designers almost unanimously follow that design principle. And so SQLite is optimized for the overwhelmingly common case of a small number of columns per table.
Hence, adding the ability to have a table with a huge number of columns is not something that I am interested in supporting in SQLite at this time. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
