Prev: Piecewise once more
Next: interesting mathematica questions on StackOverflow
From: Nate Dudenhoeffer on 18 Apr 2010 05:57
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


From: Nate Dudenhoeffer on 18 Apr 2010 05:57
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(a)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
>
 | 
Pages: 1
Prev: Piecewise once more
Next: interesting mathematica questions on StackOverflow