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)
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
