Re: Pl/Java - next step?

For me it would be fine at 7pm GMT Tuesday. Here's an attempted agenda:

1. Try to identify the common public interface (SQL and Java).
This is the most important item in my view since it enables a user to
seamlessly switch between our two solutions. You describe your design from
this angle, and I describe mine. Let's also look at what the proposed
standard say.

2. Find things that we can collaborate on.
For instance, I have some of stuff written in Java that enables java classes
to be stored and loaded from the database. You might have similar things or
Java code that covers other areas that I can reuse.

3. Probe deeper and see if there's more that we can share (C-code
essentially).
I have my doubts about sharing C-code since we do things fundamentally
different. I know you have a generic call mechanism that we could use to
establish a common ground, but I think it would bad for both designs. We
have different objectives. You strive to minimize the number of RPC calls. I
strive to minimize call overhead and resource consumption.

You probably have more ideas so please add to this.

Please confirm the time and tell me where we meet (what IRC).

Regards,

Thomas Hallgren

----- Original Message ----- 
From: "Dave Cramer" <pg@fastcrypt.com>
To: "HORNYAK Laszlo" <hornyakl@inf.elte.hu>
Cc: "Thomas Hallgren" <thhal@mailblocks.com>; <pgsql-hackers@postgresql.org>
Sent: Monday, February 23, 2004 13:41
Subject: Re: [HACKERS] Pl/Java - next step?


> tues evening euro time is fine with me. I am at GMT-5 so it will be
> afternoon for me. What time ?
>
> We should attempt an agenda?
>
> Dave
> On Sun, 2004-02-22 at 15:33, HORNYAK Laszlo wrote:
> > Hi all!
> >
> > Sorry for my latencies.
> > An IRC chat is ok for me, anytime.
> >
> > On Sun, Feb 22, 2004 at 08:08:00PM +0100, Thomas Hallgren wrote:
> > > I'm in Sweden. Some time tuesday evening (european time) perhaps?
> > >
> > > Why is your work not made public somewhere? The project on sourceforge
is
> > > inactive it seems. Do you have a CVS setup privately?
> >
> > Yes, actualy, the sf.net cvs was used very rarely, so I simply droped it
> > after a while. Now we use the CVS on Dave`s server, but it will move to
> > a new server.
> >
> > >
> > > > Not to minimize your work, as I think it is great, but this
particular
> > > > use-case I consider to be overkill for pl/java. It is probably
easier to
> > > > use pl/pgsql if all you want to do is calculations.
> > > >
> > > Not to minimize your work, but if the only thing you want to do is to
send a
> > > request to a servlet, that is very easy to do with Pl/Perl ;-)
> > >
> > > Seriously, when I say calculations, I mean any computed value that
doesn't
> > > involve database accesses. It could for instance be an implementation
of a
> > > soundex algorithm comparing two values or something similar like
graphic
> > > image matching. Regardless if such things can be implemented in pgsql
or
> > > not, the fact that there's a bunch of downloadable Java code out there
that
> > > can be used, with little or no effort, is enough to motivate my
statement.
> > >
> >
> > Java in the database has quite a lot of advantages, and most people
> > would prefer using java instead of learning one more language for stored
> > procedures. If we can show that it can be stable and portable, people
> > will love it. It is their problem what they use it for :))
> > I think one could use it for sending data into message queues, call
> > validation with EJB methods, do complex analisis on it, check if a key
> > exists in another database(db platform independent distributed RDBMS),
> > or whatever, it would make a DB realy inteligent, and would help a lot
> > keeping 2 tier systems out of trouble.
> > /s/would/will
> >
> > Laszlo Hornyak
> >
> > > Regards,
> > >
> > > Thomas Hallgren
> >
> -- 
> Dave Cramer
> 519 939 0336
> ICQ # 14675561
>
>