Services & Resources / Wolfram Forums / MathGroup Archive

MathGroup Archive 2010

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Storing lists on SQL

  • To: mathgroup at
  • Subject: [mg106340] Re: Storing lists on SQL
  • From: Chris Degnen <degnen at>
  • Date: Fri, 8 Jan 2010 06:29:08 -0500 (EST)
  • References: <hi1qbt$eka$> <hi6sv7$9u5$>

Thanks to all who replied.  SQLExpr was exactly what I was looking
for.  I found if I define a text field with data length greater than
65535 a 16 million character-length field is created, which should
certainly suffice if 65535 isn't enough.

E.g. with DatabaseLink connection established:

SQLCreateTable[conn, SQLTable["Testing"],
   {SQLColumn["Record", "DataTypeName" -> "INTEGER"],
   SQLColumn["Data", "DataTypeName" -> "TEXT",
    "DataLength" -> 65536]}];
(* check table definition *)
Print[SQLColumns[conn, "Testing"]];
data1 = {"Lots of data",
   aRule -> {91, 90, 93, 92}, {"A list", "Etc."}};
SQLInsert[conn, "Testing", {"Record", "Data"}, {1, SQLExpr[data1]}];
retreivedData = SQLSelect[conn, "Testing",
     {"Data"}, SQLColumn["Record"] == 1][[1, 1, 1]];
SQLDropTable[conn, "Testing"];



{Lots of data,aRule->{91,90,93,92},{A list,Etc.}}

  • Prev by Date: Re: Lists of Equations
  • Next by Date: Re: Lists of Equations
  • Previous by thread: Re: Storing lists on SQL
  • Next by thread: difficult/unconventional series expansion