Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2010

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

Search the Archive

Re: sqlite database connection

  • To: mathgroup at smc.vnet.net
  • Subject: [mg109228] Re: sqlite database connection
  • From: Nate Dudenhoeffer <dudenhoeffer at wisc.edu>
  • Date: Sun, 18 Apr 2010 05:57:36 -0400 (EDT)
  • References: <z2n631e2e6e1004171006jb3f59581p72ebebdfe1f8121@mail.gmail.com>

So I just answered my own question.  Here is the solution for future
googlers.  The DatabaseLink package is not needed.

In[7]:= testlite =
 Database`OpenDatabase[StringJoin[mydir, "/testlite.db"]]

Out[7]= Database`Database["/Volumes/DudesFiles/DATA LLC/Experimental \
Software/sqlite testing//testlite.db"]

In[8]:= Database`QueryDatabase[testlite, "SELECT * FROM ptdata"]

Out[8]= {{"2010-04-17 15:45:49", 1, 43.265, 89.4348, Null, Null, Null,
   Null}, {"2010-04-17 17:17:19", 1, 43.265, 89.4348, Null, Null,
  Null, Null}}

The functions "Database`QueryDatabase" and  "Database`OpenDatabase" appear
in blue as though unrecognized and do not appear in the documentation.

Nate


On Sat, Apr 17, 2010 at 12:06 PM, Nate Dudenhoeffer
<dudenhoeffer at wisc.edu>wrote:

> Can anyone hep me connect to a sqlite database?  I have used DatabaseLink
> extensively with MySQL, but sqlite is not in the list of available
> databases.
>
>  The only example I have found online is at <
> http://dev.ragfield.com/2009/05/wolframalpha-tweet-analysis.html> a blog
> of "Rob",  a wolfram employee. His syntax (db =
> Database`OpenDatabase["dbname.sqlite"]) is not supported by any of the
> packages I have loaded.  Is there another package I need to load, or is
> there a third-party JDBC driver that I need to install?
>
> Thanks.
> Nate
>


  • Prev by Date: Re: Where is the code for DistanceMatrix?
  • Next by Date: Re: integrate log*sinc
  • Previous by thread: sqlite database connection
  • Next by thread: Tracking dynamic trigger