That would be falling off the other side of the horse. Neither column nor table names are supposed to be derived from data items, but rather from abstract categories.
-----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von J Decker Gesendet: Donnerstag, 17. Oktober 2019 08:24 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] [EXTERNAL] Limit on number of columns in SQLite table On Wed, Oct 16, 2019 at 11:03 AM Mitar <mmi...@gmail.com> wrote: > Hi! > > On Wed, Oct 16, 2019 at 3:16 PM Hick Gunter <h...@scigames.at> wrote: > > 100k distinct column names? Or is that 10000 repeats of 10 attributes? > > 100k distinct names. Like each column a different gene expression. > To me that sounds more like a table distinction; such that you;'d have 100k tables with 2 columns each (their row, and their value of that gene)... it's too bad table names cant be bound parameters. > > > Mitar > > -- > http://mitar.tnode.com/ > https://twitter.com/mitar_m > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
