Re: [sqlite] SQLite JDBC column count
I do understand its a bad DB design and i should be actually doing what you have mentioned. But as mentioned in SQLite site it is possible to increase column limit during compile time. So i just need to know out of curiosity how it can be done in SQLite jar (jdbc) 3.7.2? -- View this message in context: http://sqlite.1065341.n5.nabble.com/SQLite-JDBC-column-count-tp76505p76551.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite JDBC column count
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/07/14 22:51, Manoj wrote: > Is there any workaround available for this? https://sqlite.org/limits.html#max_column Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1 iEYEARECAAYFAlO8B14ACgkQmOOfHg372QRr6QCfZfbcFkz/lowVT8uBFy92FY/7 fEAAn1+GgxCIW81Ml848hgbrB+C6bUhw =LzUJ -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite JDBC column count
On 8 Jul 2014, at 6:51am, Manoj wrote: > Am using SQLite jdbc 3.7.2 and in a scenario i have a table with 2300 column > which eventually throwed too many columns exception since the maximum > allowed column count is 2000. > > Is there any workaround available for this? Maybe a query to increase column > limit in SQLite jdbc? I cannot conceive of any way to hold the definitions of 2300 columns in your head at one time. Therefore your database is badly designed. It might be worth remembering that given the design of SQLite, if you need the value of column 1900 of a specific row, SQLite has to read 1900 values in order to find that value. Are these columns numbered ? If so, you have a relational database and should be using a related table. Do the columns come in sets (e.g. 23 sensors each measuring 100 things) ? If so, you still have a relational database and should be using a table (e.g. of sensors) a relation. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite JDBC column count
Am using SQLite jdbc 3.7.2 and in a scenario i have a table with 2300 column which eventually throwed too many columns exception since the maximum allowed column count is 2000. Is there any workaround available for this? Maybe a query to increase column limit in SQLite jdbc? Thanks in advance! -- View this message in context: http://sqlite.1065341.n5.nabble.com/SQLite-JDBC-column-count-tp76505.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users