Re: Storing lists on SQL
- To: mathgroup at smc.vnet.net
- Subject: [mg106305] Re: Storing lists on SQL
- From: David Reiss <dbreiss at gmail.com>
- Date: Fri, 8 Jan 2010 04:13:15 -0500 (EST)
- References: <firstname.lastname@example.org>
Are you using DatabaseLink for this? If so, perhaps simply wrap your Mathematica expression in DatabaseLink's SQLExp function. If there are evaluable expressions in your list then you may want to wrap it in Hold as well in the form SQLExp[Hold[your stuff....]] ?? SQLExpr SQLExpr[ expr] allows a Mathematica expression to be stored in a database. >> --David http://scientificarts.com/worklife On Jan 6, 5:58 am, Chris Degnen <deg... at cwgsy.net> wrote: > 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.