A few years ago, I released an alternate PostgreSQL interface for Squeak. Recently, Leonardo Cecchi (l.cecchi@mind-informatica.com) greatly improved upon the code by fixing some bugs, adding SmalltalkX compatability, and creating SUnit tests.
http://www.io.com/~jimm/projects/squeak_postgresql/
Jim
Jim,
The link to the last changeset (Jim-PostgreSQL-Test.st) looks like it incorrectly links to the main .st file instead of the test. Is that the way it was meant?
I got quite a laugh out of your sig :).
On 2005 Jun 27 , at 07:59, Jim Menard wrote:
-- Tom Rushworth
On 6/27/05, Jim Menard jimm@io.com wrote:
A few years ago, I released an alternate PostgreSQL interface for Squeak. Recently, Leonardo Cecchi (l.cecchi@mind-informatica.com) greatly improved upon the code by fixing some bugs, adding SmalltalkX compatability, and creating SUnit tests.
What were the motivations behind writing this instead of using the other implementation? How do they differ?
Avi
Avi,
On 6/27/05, Jim Menard jimm@io.com wrote:
A few years ago, I released an alternate PostgreSQL interface for Squeak. Recently, Leonardo Cecchi (l.cecchi@mind-informatica.com) greatly improved upon the code by fixing some bugs, adding SmalltalkX compatability, and creating SUnit tests.
What were the motivations behind writing this instead of using the other implementation? How do they differ?
I wrote mine for fun, to learn the PostgreSQL client interface, and to improve my moderate Smalltalk skills.
Honestly, I'm not sure how it differs from the existing interface because I don't use either one. I only dabble with Smalltalk, and have not yet created any applications that require persistence outside the image itself.
Jim
Tom,
The link to the last changeset (Jim-PostgreSQL-Test.st) looks like it incorrectly links to the main .st file instead of the test. Is that the way it was meant?
Nope; thanks for catching that. It's fixed now.
I got quite a laugh out of your sig :).
Thanks.
Jim
Am 27.06.2005 um 16:59 schrieb Jim Menard: ...
I get:
You don't have permission to access /~jimm/projects/squeak_postgresql/Jim-PostgreSQL-Test.st on this server.
and
You don't have permission to access /~jimm/projects/squeak_postgresql/Jim-PostgreSQL-Config.st on this server.
-karsten
Karsten,
I get:
You don't have permission to access /~jimm/projects/squeak_postgresql/Jim-PostgreSQL-Test.st on this server.
and
You don't have permission to access /~jimm/projects/squeak_postgresql/Jim-PostgreSQL-Config.st on this server.
Fixed. Thanks for reporting this problem. I tend to be a bit paranoid about file permissions on that server, since it's an ISP's machine and I'm just one of many users.
Jim
Great!
The new implementation has support for md5 connections? The older one hasn´t
best regards mdc --- Tom Rushworth tbr@lincsat.com escribió:
Jim,
The link to the last changeset (Jim-PostgreSQL-Test.st) looks like it incorrectly links to the main .st file instead of the test. Is that the way it was meant?
I got quite a laugh out of your sig :).
On 2005 Jun 27 , at 07:59, Jim Menard wrote:
http://www.io.com/~jimm/projects/squeak_postgresql/
Tom Rushworth
___________________________________________________________ 1GB gratis, Antivirus y Antispam Correo Yahoo!, el mejor correo web del mundo http://correo.yahoo.com.ar
marcelo,
The new implementation has support for md5 connections? The older one hasn´t
No, MD5 support has not been added.
Jim
On 6/28/05, marcelo Cortez jmdc_marcelo@yahoo.com.ar wrote:
Great!
The new implementation has support for md5 connections? The older one hasn´t
From a quick look at the code, I think it doesn't, unfortunately.
Incidentally, although I'm all for portable code, the way the port to Smalltalk/X was done makes the code much less pleasant to read - there are what amount to #ifdef blocks for isSqueak and isSmalltalkX littered throughout... if it's too hard to abstract these away, it might not be a bad idea to port those fixes and unit tests back into the earlier clean Squeak-only version, IMHO.
Avi
Avi Bryant wrote:
On 6/28/05, marcelo Cortez jmdc_marcelo@yahoo.com.ar wrote:
Great!
The new implementation has support for md5 connections? The older one hasn´t
From a quick look at the code, I think it doesn't, unfortunately.
Incidentally, although I'm all for portable code, the way the port to Smalltalk/X was done makes the code much less pleasant to read - there are what amount to #ifdef blocks for isSqueak and isSmalltalkX littered throughout... if it's too hard to abstract these away, it might not be a bad idea to port those fixes and unit tests back into the earlier clean Squeak-only version, IMHO.
What about subclasses that implement version-specific behavior? The code could create instances of the proper version at runtime, like some of the filesystem classes do.
Jim
hi all
the class PSQLConfiguration method initialize fail default is wrong The initialize "Initial configuration of PostgreSQL Connector.
Example: (Smalltalk/X) WhichSystem := #smalltalkx.
Example: (Squeak) WhichSystem := #squeak. " uncomment this.
WhichSystem := #smalltalkx. "Here !!!! fault point to smalltalkx.!!! "
best regards MDC
--- Jim Menard jimm@io.com escribió:
Avi Bryant wrote:
On 6/28/05, marcelo Cortez
jmdc_marcelo@yahoo.com.ar wrote:
Great!
The new implementation has support for md5 connections? The older one hasn´t
From a quick look at the code, I think it doesn't,
unfortunately.
Incidentally, although I'm all for portable code,
the way the port to
Smalltalk/X was done makes the code much less
pleasant to read - there
are what amount to #ifdef blocks for isSqueak and
isSmalltalkX
littered throughout... if it's too hard to
abstract these away, it
might not be a bad idea to port those fixes and
unit tests back into
the earlier clean Squeak-only version, IMHO.
What about subclasses that implement version-specific behavior? The code could create instances of the proper version at runtime, like some of the filesystem classes do.
Jim
Jim Menard, jimm@io.com, http://www.io.com/~jimm As a math major, I don't have to be able to add -- I just have to be able to PROVE that I can add.
___________________________________________________________ 1GB gratis, Antivirus y Antispam Correo Yahoo!, el mejor correo web del mundo http://correo.yahoo.com.ar
I tried the PostgreSQL interface, but can't connect to my database - perhaps someone can assist me. I don't have much practical database experience, so it's entirely possible I'm doing something wrong.
I have connected the PostgreSQL 7.4.6 database fine with pgAdmin, so I don't think there's anything wrong on the server end. When trying to establish a simple connection in Squeak 3.8, I get the following error: "unknown message type," followed by a random character. My code looks like so:
client := PSQLClient new host: 'db.cecs.pdx.edu'; database: 'emerson'; user: 'foo'; password: 'bar', port: 5432. client establishConnection.
I also can't get the same code working in Smalltalk/X, but only because ST/X doesn't have a Password class. But this was only a test - I intend to run this software in Squeak.
Thanks in advance,
Emerson
hi all
take a look at your pg_hba-conf file if your conection is tagged with md5 ,kerberos .. o any security protocol the postgresql framework don't support this.
best regards MDC
--- Emerson Murphy-Hill emerson@cs.pdx.edu escribió:
I tried the PostgreSQL interface, but can't connect to my database - perhaps someone can assist me. I don't have much practical database experience, so it's entirely possible I'm doing something wrong.
I have connected the PostgreSQL 7.4.6 database fine with pgAdmin, so I don't think there's anything wrong on the server end. When trying to establish a simple connection in Squeak 3.8, I get the following error: "unknown message type," followed by a random character. My code looks like so:
client := PSQLClient new host:
'db.cecs.pdx.edu'; database: 'emerson'; user: 'foo'; password: 'bar', port: 5432. client establishConnection.
I also can't get the same code working in Smalltalk/X, but only because ST/X doesn't have a Password class. But this was only a test - I intend to run this software in Squeak.
Thanks in advance,
Emerson
________________________________________________ ¡Llamá y ganá! Usá Yahoo! Messenger con Voz y participá del sorteo de un pasaje a cualquier lugar del mundo. Inscribite aquí: http://messenger.yahoo.com/ar/
Yep, they tell me there is some MD5 stuff.
Gracias,
e
marcelo Cortez wrote:
hi all
take a look at your pg_hba-conf file if your conection is tagged with md5 ,kerberos .. o any security protocol the postgresql framework don't support this.
best regards MDC
--- Emerson Murphy-Hill emerson@cs.pdx.edu escribió:
I tried the PostgreSQL interface, but can't connect to my database - perhaps someone can assist me. I don't have much practical database experience, so it's entirely possible I'm doing something wrong.
I have connected the PostgreSQL 7.4.6 database fine with pgAdmin, so I don't think there's anything wrong on the server end. When trying to establish a simple connection in Squeak 3.8, I get the following error: "unknown message type," followed by a random character. My code looks like so:
client := PSQLClient new host: 'db.cecs.pdx.edu'; database: 'emerson'; user: 'foo'; password: 'bar', port: 5432. client establishConnection.
I also can't get the same code working in Smalltalk/X, but only because ST/X doesn't have a Password class. But this was only a test - I intend to run this software in Squeak.
Thanks in advance,
Emerson
squeak-dev@lists.squeakfoundation.org