Re: [sqlite] [EXTERNAL] Limit on number of columns in SQLite table

2019-10-17 Thread Hick Gunter
Decker Gesendet: Donnerstag, 17. Oktober 2019 08:24 An: SQLite mailing list Betreff: Re: [sqlite] [EXTERNAL] Limit on number of columns in SQLite table On Wed, Oct 16, 2019 at 11:03 AM Mitar wrote: > Hi! > > On Wed, Oct 16, 2019 at 3:16 PM Hick Gunter wrote: > > 100k distin

Re: [sqlite] [EXTERNAL] Limit on number of columns in SQLite table

2019-10-17 Thread Hick Gunter
mailing list Betreff: Re: [sqlite] [EXTERNAL] Limit on number of columns in SQLite table Hi! On Wed, Oct 16, 2019 at 3:16 PM Hick Gunter wrote: > 100k distinct column names? Or is that 1 repeats of 10 attributes? 100k distinct names. Like each column a different gene expression. Mi

Re: [sqlite] [EXTERNAL] Limit on number of columns in SQLite table

2019-10-17 Thread J Decker
On Wed, Oct 16, 2019 at 11:03 AM Mitar wrote: > Hi! > > On Wed, Oct 16, 2019 at 3:16 PM Hick Gunter wrote: > > 100k distinct column names? Or is that 1 repeats of 10 attributes? > > 100k distinct names. Like each column a different gene expression. > To me that sounds more like a table

Re: [sqlite] [EXTERNAL] Limit on number of columns in SQLite table

2019-10-16 Thread Simon Slavin
On 16 Oct 2019, at 7:03pm, Mitar wrote: > On Wed, Oct 16, 2019 at 3:16 PM Hick Gunter wrote: >> 100k distinct column names? Or is that 1 repeats of 10 attributes? > > 100k distinct names. Like each column a different gene expression. Don't do that. It's an abuse of how relational

Re: [sqlite] [EXTERNAL] Limit on number of columns in SQLite table

2019-10-16 Thread Mitar
Hi! On Wed, Oct 16, 2019 at 3:16 PM Hick Gunter wrote: > 100k distinct column names? Or is that 1 repeats of 10 attributes? 100k distinct names. Like each column a different gene expression. Mitar -- http://mitar.tnode.com/ https://twitter.com/mitar_m

Re: [sqlite] [EXTERNAL] Limit on number of columns in SQLite table

2019-10-16 Thread Hick Gunter
100k distinct column names? Or is that 1 repeats of 10 attributes? -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Mitar Gesendet: Mittwoch, 16. Oktober 2019 14:57 An: sqlite-users@mailinglists.sqlite.org Betreff: