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 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: <hi1qbt$eka$1@smc.vnet.net>

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.



  • Prev by Date: Symbolic Formula
  • Next by Date: Re: Re: Re: Re: Re: algebraic numbers
  • Previous by thread: Re: Storing lists on SQL
  • Next by thread: Re: Storing lists on SQL