Possible move away from PG

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

Possible move away from PG

Jason Tesser
I work for a college and we use PG currently as our main backend.  We
are currently developing with Java.  We are considering moving away from
postgres for the reasons I am going to list below.  I would appreciate
some thoughts from the Postgres community on way we should or shouldn't
leave postgres.  

1. Our dev plan involves alot of stored procedures to be used and we
have found the way this is done in PG to be painful. (ie.  To return
multiple record from different tables you have to define a type.  This
is a pain to maintain because if you ever have to change what it returns
it cannot be dropped because of dependencies etc.. In some other
databases you can simpley write a stored proc to return whatever the
query inside returns and this is handled dynamically)

2. Also with stored procs it is painful to return mulitple records. The
syntax is more complicated than some other databases.  (We are currently
using PL/SQL)

3. The tools.  PgAdmin does some things well but it is lacking the
features of some of the other gui tools.  This is not a big deal as we
do also have PgManage which is acceptable except I personally don't like
it cause it doesn't run in Linux and the Linux version is pretty bad.

Thank you for any input and help,
Jason Tesser

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Reply | Threaded
Open this post in threaded view
|

Re: Possible move away from PG

Kris Jurka


On Thu, 30 Jun 2005, Jason Tesser wrote:

> 1. Our dev plan involves alot of stored procedures to be used and we
> have found the way this is done in PG to be painful. (ie.  To return
> multiple record from different tables you have to define a type.  This
> is a pain to maintain because if you ever have to change what it returns
> it cannot be dropped because of dependencies etc.. In some other
> databases you can simpley write a stored proc to return whatever the
> query inside returns and this is handled dynamically)

Have you considered returing refcursors instead of setof some type.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org
Reply | Threaded
Open this post in threaded view
|

Re: Possible move away from PG

Jason Tesser
I am not familar with how to do this.  Could you give me an example of how
this could help?

<snip>
>
> Have you considered returing refcursors instead of setof some type.
>
> Kris Jurka

--
Jason Tesser
Developer for NMI
[hidden email]
Eph 2:8-10

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: Possible move away from PG

Bugzilla from pbaena@gmail.com
If found this article of help: http://www.onjava.com/pub/a/onjava/2003/08/13/stored_procedures.html?page=2

On 6/30/05, Jason Tesser <[hidden email]> wrote:
I am not familar with how to do this.  Could you give me an example of how
this could help?

<snip>
>
> Have you considered returing refcursors instead of setof some type.
>
> Kris Jurka

--
Jason Tesser
Developer for NMI
[hidden email]
Eph 2:8-10

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [hidden email]



--
    > There are a lot of us out there who both do and do not work for Sun

    Wow! Quantum programmers!
Reply | Threaded
Open this post in threaded view
|

Re: Possible move away from PG

Bob-4
In reply to this post by Jason Tesser
PL/SQL is awesome just awesome no doubt about it.
 
But if you like to pay at a minium for 5 users 800 bucks then stick with PL/SQL.  I personally can live with pl/psql and at a higher level postgresql to be honest.  Not to mention the rate that things are being added and improved is mind numbing.  Depends on your setup though. Do you really need all the bells and whistles that PL/SQL gives you given the cost and maintence of Oracle databases.

 
On 6/30/05, Jason Tesser <[hidden email]> wrote:
I am not familar with how to do this.  Could you give me an example of how
this could help?

<snip>
>
> Have you considered returing refcursors instead of setof some type.
>
> Kris Jurka

--
Jason Tesser
Developer for NMI
[hidden email]
Eph 2:8-10

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Possible move away from PG

Jason Tesser
In reply to this post by Jason Tesser

Ok.  This sounds good to me but I have one question>  In the manual for 8.0 with comments someone commented at the end of the section on frecursors that they need to be closed which the manual didn’t seem to mention will this be a problem with doing this in java? 

 


From: Pablo Baena [mailto:[hidden email]]
Sent: Thursday, June 30, 2005 12:30 PM
To: Jason Tesser
Cc: Pgsql
Subject: Re: [GENERAL] Possible move away from PG

 

If found this article of help: http://www.onjava.com/pub/a/onjava/2003/08/13/stored_procedures.html?page=2

On 6/30/05, Jason Tesser <[hidden email]> wrote:

I am not familar with how to do this.  Could you give me an example of how
this could help?

<snip>
>
> Have you considered returing refcursors instead of setof some type.
>
> Kris Jurka

--
Jason Tesser
Developer for NMI
[hidden email]
Eph 2:8-10

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [hidden email]




--
    > There are a lot of us out there who both do and do not work for Sun

    Wow! Quantum programmers!