VAST and pgsqlodbc on Linux

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

VAST and pgsqlodbc on Linux

jtuchel
I know I've asked before, but I wonder if anyone has previous experience with using PostrgeSQL on Linux with VAST using ODBC.

Is this adventurous construct production ready?

Of course I would prefer to use a native V3 driver in VAST but since it doesn't exist (yet?), I also wonder if there is anothervstable alternative.

The requirements are not too demanding, we avoid B/CLOB data types or xml/json or object-relational sql extensions in our application anyways. We currently use DB2 and have strange outages from time to time....

Joachim

--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/group/va-smalltalk.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: VAST and pgsqlodbc on Linux

Norbert Schlemmer
I suggest to use Oracle Database Server (Oracle Database 11g Express Edition or Oracle Database 12c)
Norbert

Am Mittwoch, 11. April 2018 07:29:11 UTC+2 schrieb Joachim Tuchel:
I know I've asked before, but I wonder if anyone has previous experience with using PostrgeSQL on Linux with VAST using ODBC.

Is this adventurous construct production ready?

Of course I would prefer to use a native V3 driver in VAST but since it doesn't exist (yet?), I also wonder if there is anothervstable alternative.

The requirements are not too demanding, we avoid B/CLOB data types or xml/json or object-relational sql extensions in our application anyways. We currently use DB2 and have strange outages from time to time....

Joachim

--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/group/va-smalltalk.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: VAST and pgsqlodbc on Linux

Jan van de Sandt
In reply to this post by jtuchel
Hi Joachim,

In Pharo Smalltalk they have a nice "lean-and-mean" PostgreSQL client [1]. It communicates directly with the server through TCP Sockets so no client driver is required. It is actually very little Smalltalk code. It should be pretty easy to port to VA Smalltalk. Except perhaps for the TLS/SSL support, that's probably more tricky.

Regards,
Jan.


On Wed, Apr 11, 2018 at 7:29 AM, Joachim Tuchel <[hidden email]> wrote:
I know I've asked before, but I wonder if anyone has previous experience with using PostrgeSQL on Linux with VAST using ODBC.

Is this adventurous construct production ready?

Of course I would prefer to use a native V3 driver in VAST but since it doesn't exist (yet?), I also wonder if there is anothervstable alternative.

The requirements are not too demanding, we avoid B/CLOB data types or xml/json or object-relational sql extensions in our application anyways. We currently use DB2 and have strange outages from time to time....

Joachim

--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/group/va-smalltalk.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/group/va-smalltalk.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: VAST and pgsqlodbc on Linux

dmacq
In reply to this post by jtuchel
Joachim,

I have used ODBC to talk to MySQL and it works pretty well. YMMV.

Donald

--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/group/va-smalltalk.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: VAST and pgsqlodbc on Linux

Leonardo Oillataguerre
We use unixodbc and postgresql on an intensive workload server farm and it works pretty well

--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/group/va-smalltalk.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: VAST and pgsqlodbc on Linux

jtuchel
In reply to this post by Jan van de Sandt
Jan,

that is the V3 driver I was referring to (is P3 the correct name? Then sorry for the confusion). I'd love to use it. Much less moving parts and no infrastructure issues for cross-platform stuff.

I remember Marten talked about attempting to integrate either MySQL or PostgreSQL (don't remember) and he gave up because of the "Upper Layers" of DB drivers in VAST, meaning ABT Parts and Glorp... So I guess it will not be tooo easy... Seems like I should take this option into account .. or wait for Instantiations to do it, as it is on the product roadmap.

So my rationale was: maybe start with ODBC for "a few months" and switch to a native driver as soon as VAST ships with one.
But ODBC on Linux sounds a bit like a bunch of layers stacked on anothe bunch of Layers, Layers all the way down, so it scares me... ;-)

Joachim




Am Mittwoch, 11. April 2018 16:14:09 UTC+2 schrieb Jan van de Sandt:
Hi Joachim,

In Pharo Smalltalk they have a nice "lean-and-mean" PostgreSQL client [1]. It communicates directly with the server through TCP Sockets so no client driver is required. It is actually very little Smalltalk code. It should be pretty easy to port to VA Smalltalk. Except perhaps for the TLS/SSL support, that's probably more tricky.

Regards,
Jan.

[1] <a href="https://pharo.org/news/ann-p3" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fpharo.org%2Fnews%2Fann-p3\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNEkDSmgf_BKUd944x5WuqwOCCQU-A&#39;;return true;" onclick="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fpharo.org%2Fnews%2Fann-p3\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNEkDSmgf_BKUd944x5WuqwOCCQU-A&#39;;return true;">https://pharo.org/news/ann-p3

On Wed, Apr 11, 2018 at 7:29 AM, Joachim Tuchel <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="CJUs9B4fCQAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">jtu...@...> wrote:
I know I've asked before, but I wonder if anyone has previous experience with using PostrgeSQL on Linux with VAST using ODBC.

Is this adventurous construct production ready?

Of course I would prefer to use a native V3 driver in VAST but since it doesn't exist (yet?), I also wonder if there is anothervstable alternative.

The requirements are not too demanding, we avoid B/CLOB data types or xml/json or object-relational sql extensions in our application anyways. We currently use DB2 and have strange outages from time to time....

Joachim

--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="javascript:" target="_blank" gdf-obfuscated-mailto="CJUs9B4fCQAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">va-smalltalk...@googlegroups.com.
To post to this group, send email to <a href="javascript:" target="_blank" gdf-obfuscated-mailto="CJUs9B4fCQAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">va-sma...@....
Visit this group at <a href="https://groups.google.com/group/va-smalltalk" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://groups.google.com/group/va-smalltalk&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/group/va-smalltalk&#39;;return true;">https://groups.google.com/group/va-smalltalk.
For more options, visit <a href="https://groups.google.com/d/optout" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;">https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/group/va-smalltalk.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: VAST and pgsqlodbc on Linux

jtuchel
In reply to this post by dmacq
Donald,

I absolutely trust in VASTs ODBC support on Windows. I've been using it with Access, Oracle, Sybase and maybe a few more.
My scepticism is more about ODBC and Linux and VAST on top of that...


Joachim


Am Mittwoch, 11. April 2018 22:38:11 UTC+2 schrieb Donald MacQueen:
Joachim,

I have used ODBC to talk to MySQL and it works pretty well. YMMV.

Donald

--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/group/va-smalltalk.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: VAST and pgsqlodbc on Linux

jtuchel
In reply to this post by Leonardo Oillataguerre
Leonardo,

Thanks for this signal. So at least somebody got it to work. Is there anything about the project available publicly?

Going from DB2 to PostgreSQL promises to be enough work to make this a little project of its own, so I was looking for evidence it is at least worth trying.

Anyways, thank you very much for sharing.

Joachim



Am Donnerstag, 12. April 2018 02:22:46 UTC+2 schrieb Leonardo Oillataguerre:
We use unixodbc and postgresql on an intensive workload server farm and it works pretty well

--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/group/va-smalltalk.
For more options, visit https://groups.google.com/d/optout.