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

Storing lists on SQL

• To: mathgroup at smc.vnet.net
• Subject: [mg106242] Storing lists on SQL
• From: Chris Degnen <degnen at cwgsy.net>
• Date: Wed, 6 Jan 2010 05:58:15 -0500 (EST)

Hi. I'm trying to store lists on an SQL database.  The lists can
contain strings, rules, lists and integers etc. I plan to store them
in a variable character field as a single string, but the first
problem is the quotes on the inner strings have to be elided, e.g./"

At the moment I'm trying a recursive routine with ToCharacterCode[] to
encode the inner strings first.  I'll have to do something else for
the rules.

I'm also going to try serializing the lists with Export[] and then
storing them encoded.  (That might be easiest.)

If anyone has suggestions on how I might store these lists please let
me know.