On Mon, Nov 14, 2011 at 12:21 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > On 11/14/2011 12:11 PM, Gabor Grothendieck wrote: >> >> The requirement for a large number of columns is actually one thing >> that is often needed when using sqlite from R. Typically the use case >> is that a user wishes to read a portion of an external file into R and >> that file has thousands of columns. For example, each row might be an >> individual and each column is a gene. Or each row is a time point and >> each column is a security (stock, bond, etc.) > > In relational databases, things like that are usually represented as > GeneInfo(person, gene, infoAboutGene) or StockInfo(timestamp, stock, price)
That is a good point; however, in the context of this use case we are dealing with external files and don't have control over their format. -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users