7 Mar
2015
7 Mar
'15
10:59 p.m.
Hi!
I am forwarding Pierce’s answer to the mailing list. I think it may interest some people.
I was able to open and query a SQL database (.db file). It works nicely.
Just to let you know.
Cheers,
Alexandre
Begin forwarded message:
Date: March 7, 2015 at 3:09:37 AM EST
From: Pierce Ng <pierce(a)samadhiweb.com>
To: Pharo Development List <pharo-dev(a)lists.pharo.org>rg>, Any question about pharo is
welcome <pharo-users(a)lists.pharo.org>
Subject: Re: [Pharo-users] Reading an SQL db on OS X
Reply-To: Any question about pharo is welcome <pharo-users(a)lists.pharo.org>
On Wed, Mar 04, 2015 at 05:18:57PM -0500, Alexandre Bergel wrote:
--
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.
I would like to read a SQL .db file. The page
http://smalltalkhub.com/#!/~PharoExtras/NBSQLite3 mention how to do this on
Windows and Linux, but not on OSX. What should I do to read a SQL file on OS
X? I tried google, but it did not work.
Do it the same way on OSX as on Windows and Linux. On OSX you need to supply a
full path name to the DB file. This is due to weirdness in Pharo.app; search
this list's archives for a recent discussion.
I wrote NBSQLite3 on OSX and tested on Linux. I don't use Windows. Subsequently
Torsten moved NBSQLite3 to STH. Seems Torsten uses Linux and Windows, so now we
have the 3 main platforms covered. :-)
You may also want to check out http://www.samadhiweb.com/NBSQLite3.html.
Pierce