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
>