Yep, I have tried Tantalus. It is good, but I see it as a more "conventional" approach to object relational mapping. I like the approach Avi and company took with ROE, namely modeling the relational algebra itself rather than attempting to abstract it away.
Having said that, we are up to our eyeballs around here in Oracle databases but Postgress is pretty rare, hence my question. It is not a big deal though. I was just wondering if anyone had played around with Oracle and ROE.
----------=-=-=-=-=-=-=-=-========oOo========-=-=-=-=-=-=-=-=---------- mailto:Ronald.P.Welch@baesystems.com Phone:(607)770-3701 BAE SYSTEMS Controls 600 Main St Johnson City, NY 13790-1888 ----------=-=-=-=-=-=-=-=-===================-=-=-=-=-=-=-=-=----------
-----Original Message----- From: Pablo Iaria [mailto:iariap@hotpop.com] Sent: Monday, November 29, 2004 1:38 PM To: 'The general-purpose Squeak developers list' Subject: RE: ODBC connection
Hi Ronald,
mmmmmm...ROE only works with pgsql
I have tried tantalus (another small mapping tool) and it worked fine with ODBC.
Cheers! Pablo.-
-----Original Message----- From: squeak-dev-bounces@lists.squeakfoundation.org
[mailto:squeak-dev-
bounces@lists.squeakfoundation.org] On Behalf Of Welch, Ronald P (US
SSA)
Sent: Lunes, 29 de Noviembre de 2004 03:29 p.m. To: The general-purpose Squeak developers list Subject: RE: ODBC connection
Ooops sorry I meant ODBC not JDBC.
----------=-=-=-=-=-=-=-=-========oOo========-=-=-=-=-=-=-=-=----------
mailto:Ronald.P.Welch@baesystems.com
Phone:(607)770-3701
BAE SYSTEMS Controls 600 Main St Johnson City, NY
13790-1888
----------=-=-=-=-=-=-=-=-===================-=-=-=-=-=-=-=-=----------
-----Original Message----- From: Welch, Ronald P (US SSA) Sent: Monday, November 29, 2004 1:28 PM To: The general-purpose Squeak developers list Subject: RE: ODBC connection
Taking this one step futher, is there a way to get ROE to talk to Oracle via JDBC?
----------=-=-=-=-=-=-=-=-========oOo========-=-=-=-=-=-=-=-=----------
mailto:Ronald.P.Welch@baesystems.com
Phone:(607)770-3701
BAE SYSTEMS Controls 600 Main St Johnson City, NY
13790-1888
----------=-=-=-=-=-=-=-=-===================-=-=-=-=-=-=-=-=----------
-----Original Message----- From: Pablo Iaria [mailto:iariap@hotpop.com] Sent: Monday, November 29, 2004 1:19 PM To: 'The general-purpose Squeak developers list' Subject: RE: ODBC connection
Hi Alejandro,
Take a look at http://minnow.cc.gatech.edu/squeak/2480
Cheers, Pablo.-
-----Original Message----- From: squeak-dev-bounces@lists.squeakfoundation.org [mailto:squeak-dev-bounces@lists.squeakfoundation.org] On Behalf Of Alejandro Torres Sent: Lunes, 29 de Noviembre de 2004 03:16 p.m. To: squeak-dev@lists.squeakfoundation.org Subject: ODBC connection
There is any way to connect to a database like Oracle using Squeak ?
Thanks -AlxTorres
On Mon, 29 Nov 2004 14:04:48 -0500, Welch, Ronald P (US SSA)
I was just wondering if anyone had played around with Oracle and ROE.
Yes, the VW port has Oracle support, which could be pulled over very easily. The problem is finding a reasonable way to connect to an Oracle database from Squeak. Because the ODBC lib uses FFI, it's synchronous - your whole VM will hang while you wait for the results of a query. What I've done in the past is build a simple Java app that accepts queries on a socket, uses the JDBC driver to get results, and then sends them back, but this isn't terribly performant either. A proper Oracle plugin would be great, if anyone has time or money for one...
Avi
Avi Bryant avi.bryant@gmail.com wrote:
Yes, the VW port has Oracle support, which could be pulled over very easily. The problem is finding a reasonable way to connect to an Oracle database from Squeak. Because the ODBC lib uses FFI, it's synchronous - your whole VM will hang while you wait for the results of a query. What I've done in the past is build a simple Java app that accepts queries on a socket, uses the JDBC driver to get results, and then sends them back, but this isn't terribly performant either. A proper Oracle plugin would be great, if anyone has time or money for one...
Also, of course, one could fork() multiple Squeak's and have each of them talk to the database server via ODBC. Each individual Squeak is still synchronous, but you can run a few of them in parallel to balance things back out.
OSProcess has both fork() and system(), so you can use it to create the extra Squeak processes however you like.
Lex
I notice a significant speedup (relative of the significant speedowns caused by ~3.9 misc additions/changes) in /general/ graphics operations when disabling Easy Selection. I've not looked deep through the system to find the cause of this behaviour, but it is curious, isn't it?
-Lyndon
squeak-dev@lists.squeakfoundation.org
-
Avi Bryant -
lex＠cc.gatech.edu -
Lyndon Tremblay -
Welch, Ronald P (US SSA)