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@samadhiweb.com To: Pharo Development List pharo-dev@lists.pharo.org, Any question about pharo is welcome pharo-users@lists.pharo.org Subject: Re: [Pharo-users] Reading an SQL db on OS X Reply-To: Any question about pharo is welcome pharo-users@lists.pharo.org

On Wed, Mar 04, 2015 at 05:18:57PM -0500, Alexandre Bergel wrote:

...

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