On Fri, Jan 22, 2010 at 8:19 AM, Jay A. Kreibich <[email protected]> wrote: > On Thu, Jan 21, 2010 at 07:55:14AM -0800, newlog scratched on the wall: > > >> Keyword-01 Foo 12.007 Bar 24.9682 >> Keyword-02 64738 65535 12.12 3.1415 2.71 0.007 >> Keyword-03 SingleString >> ... >> >> So my question is : how to create a table in which rows (keywords) >> could contain variable type > > SQLite supports different types out of the box. > >> and number of data ? > > You don't. That's not what databases are about. > If you have > variable attributes that match to single keyword, you want to setup > a one-to-many relation between two tables. Find a good intro to > database normalization; that should point you to a good example of > this fairly quickly. >
Yes, most of the above is true, but sometimes multiple data points in a single column are very useful. Hence, the array datatype. See PostGres http://www.postgresql.org/docs/8.2/interactive/arrays.html > -j > > -- > Jay A. Kreibich < J A Y @ K R E I B I.C H > > > "Our opponent is an alien starship packed with atomic bombs. We have > a protractor." "I'll go home and see if I can scrounge up a ruler > and a piece of string." --from Anathem by Neal Stephenson > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= Sent from Madison, Wisconsin, United States _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
