Examples of Garage for DB2

On Tue, Jan 02, 2018 at 02:10:03PM -0500, Andrei Stebakov wrote:
> I downloaded Garage to my Pharo 6.1 on windows. But in Garage I only see
> drivers for MySql, Postgres and Sqlite3.
> Does it mean that for DB2 I should look somewhere else or there is a way to
> create a connection for DB2 using existing Garage functionality?

Garage uses the OpenDBX C language database access library underneath.  Looking
at https://linuxnetworks.de/doc/index.php?title=OpenDBX/Support, it doesn't
look OpenDBX supports DB2.

Does the Windows DB2 ODBC driver work? Does Pharo successfully use the ODBC
driver to talk to DB2?

Pierce

On Wed, Jan 03, 2018 at 10:12:32AM -0500, Andrei Stebakov wrote:
> Pierce, I couldn't find any smalltalk framework to work with DB2 at this
> point. I couldn't also find any Pharo odbc library. That's why at this
> point I am looking for any ideas how to connect to DB2 from Pharo.

I suppose Instantiations VA Smalltalk will be able to talk to DB2. I'm quite
sure Dolphin Smalltalk does ODBC too.

Staying with Pharo, assuming you have known-working DB2 ODBC driver for Windows
installed and ODBC to DB2 configured, try this:

  http://smalltalkhub.com/#!/~PharoExtras/ODBC/

Most recent commit was in Apr 2015 by Torsten 'switching to newer FFI'. So
hopefully this works with Pharo 6.1.

If the above doesn't work, but you know that the Windows DB2 ODBC driver works,
then - I'm not being facetious - install PostgreSQL, set up PostgreSQL foreign
data wrapper to ODBC, and talk to PostgreSQL using Pharo.

   http://www.postgresonline.com/journal/archives/372-ODBC-FDW-now-supports-9.5-and-9.6.html

Or, set up Python's SQL Alchemy for DB2, install PostgreSQL, set up PostgreSQL
foreign data wrapper to SQL Alchemy, and talk to PostgreSQL using Pharo.

  https://wiki.postgresql.org/wiki/Foreign_data_wrappers
  https://github.com/Kozea/Multicorn

HTH.

On Wed, Jan 03, 2018 at 11:42:22AM -0500, Andrei Stebakov wrote:
> I tried before to install odbc.
> Gofer new
>   squeaksource: 'ODBC';

Not Squeaksource. Load the version from Smalltalkhub:

  Gofer new
    smalltalkhubUser: 'PharoExtras' project: 'ODBC';
    ...

Hopefully this version works with or without Esteban's suggestion.

> I still don't see how postgres can help but I'll give it another try.

I suggested PostgreSQL FDW because I know PostgreSQL. If you are not familiar
with PostgreSQL, then setting it up, setting up its FDW, and finally setting up
programmatic access to PostgreSQL to get at the FDW data is probably more work
than it is worth.

Pierce

this: 

SmalltalkImage compilerClass: Compiler.

Metacello new 

smalltalkhubUser: 'PharoExtras' project: 'ODBC';

configuration: 'ODBC';

version: #bleedingEdge;

load.

SmalltalkImage compilerClass: OpalCompiler.

loads for me (after proceeding a warning) in Pharo7. 

no idea if it will work, but it *loads* :)

Esteban

On 4 Jan 2018, at 18:18, Andrei Stebakov <[hidden email]> wrote:

Thank you, Pierce

I got similar ffi exceptions when I call

Gofer new

  smalltalkhubUser: 'PharoExtras' project: 'ODBC';

  package: 'ConfigurationOfODBC'; load.

  (Smalltalk at: #ConfigurationOfODBC) load.

On Jan 4, 2018 11:41 AM, "Pierce Ng" <[hidden email]> wrote:

On Wed, Jan 03, 2018 at 11:42:22AM -0500, Andrei Stebakov wrote:

> I tried before to install odbc.n

> Gofer new
>   squeaksource: 'ODBC';

Not Squeaksource. Load the version from Smalltalkhub:

  Gofer new
    smalltalkhubUser: 'PharoExtras' project: 'ODBC';
    ...

Hopefully this version works with or without Esteban's suggestion.

> I still don't see how postgres can help but I'll give it another try.

I suggested PostgreSQL FDW because I know PostgreSQL. If you are not familiar
with PostgreSQL, then setting it up, setting up its FDW, and finally setting up
programmatic access to PostgreSQL to get at the FDW data is probably more work
than it is worth.

Pierce