Thread: Newbie question :-)

Newbie question :-)

From
Bela Lantos
Date:
Hi,

I just started learning Database Design, our programs have to work on
Oracle, but at home I run Linux.

Can any of you tell me how portable are the programs written for Progresql?
Would they run on Oracle without problem?

Is there an easy install and configuration guide anywhere on the net? I am
a bit lost in the documentation that comes with the packages.

Regards,  Bela


Re: Newbie question :-)

From
"Brett W. McCoy"
Date:
On Sat, 24 Feb 2001, Bela Lantos wrote:

> I just started learning Database Design, our programs have to work on
> Oracle, but at home I run Linux.
>
> Can any of you tell me how portable are the programs written for Progresql?
> Would they run on Oracle without problem?

That all depends on the programming interface you are writing your
programs with.  If you are using Oracle's or PostgreSQL's native
libraries, they are not going to be portable at all.  However, if you are
building your code with a data abstraction layer (i.e., Java's JDBC,
Perl's DBI, ODBC), you will have a lot more portability between database
systems.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Please come home with me ... I have Tylenol!!


Re: Newbie question :-)

From
"Mitch Vincent"
Date:
If you're talking about some kind of C application then it's going to be
portable only you'll have to rip out the PG API and replace it with the
Oracle API, I'm sure that's not such an easy task..

If you're speaking of an application written in say, PHP, then that's a
horse of a different color. I wrote a database class for PHP that gives me a
layer between my applications and the database, it allows me to change the
code in my database class for another database as opposed to going through
all the code that uses PG and changing it all to use another DB.. I would
strongly suggest you do something like that if you're needing to swap out
backends to applications fairly quickly... Note you could do the same thing
in C -- build a generic database library that is..

If you're talking about query/table layout portability then that's again
something different.. I'm not sure what all the differences are but I know
that everything in PG isn't the same as it is in Oracle. There are things
that PG does that Oracle doesn't and vice versa. For example I don't think
Oracle has sequences like PG's, and I'd guess that a lot of the aggregate
functions are named different and take different arguments..

-Mitch

----- Original Message -----
From: "Bela Lantos" <belantos@optusnet.com.au>
To: <pgsql-general@postgresql.org>
Sent: Saturday, February 24, 2001 5:22 AM
Subject: Newbie question :-)


> Hi,
>
> I just started learning Database Design, our programs have to work on
> Oracle, but at home I run Linux.
>
> Can any of you tell me how portable are the programs written for
Progresql?
> Would they run on Oracle without problem?
>
> Is there an easy install and configuration guide anywhere on the net? I am
> a bit lost in the documentation that comes with the packages.
>
> Regards,  Bela
>
>


Re: Newbie question :-)

From
"Mitch Vincent"
Date:
Oh and the instructions in the INSTALL file (under the directory where the
source was un-tar'd)  is very easy to follow and walks you through the
installation as much as possible IMHO..

The user/admin/programmer manuals and the tutorial @ www.postgresql.org are
all good too, they detail just about anything you'd want to do with PG..

-Mitch

----- Original Message -----
From: "Bela Lantos" <belantos@optusnet.com.au>
To: <pgsql-general@postgresql.org>
Sent: Saturday, February 24, 2001 5:22 AM
Subject: Newbie question :-)


> Hi,
>
> I just started learning Database Design, our programs have to work on
> Oracle, but at home I run Linux.
>
> Can any of you tell me how portable are the programs written for
Progresql?
> Would they run on Oracle without problem?
>
> Is there an easy install and configuration guide anywhere on the net? I am
> a bit lost in the documentation that comes with the packages.
>
> Regards,  Bela
>
>


Re: Newbie question :-)

From
Tim Freund
Date:
I like Postgres and all, but if you REALLY want to be sure that your
programs are compatible with Oracle, you can always download copy for
free under a development license.

http://otn.oracle.com/software/

...and then you can go back to using Postgresql for all of your own
projects.

Tim

On Sat, Feb 24, 2001 at 08:22:18PM +1000, Bela Lantos wrote:
> Hi,
>
> I just started learning Database Design, our programs have to work on
> Oracle, but at home I run Linux.
>
> Can any of you tell me how portable are the programs written for Progresql?
> Would they run on Oracle without problem?
>
> Is there an easy install and configuration guide anywhere on the net? I am
> a bit lost in the documentation that comes with the packages.
>
> Regards,  Bela
>
>
> ------------=_983233203-49421-1
> Content-Type: message/rfc822
> Content-Disposition: inline
> Content-Transfer-Encoding: binary
> Content-Description: 200102/1285
> MIME-Version: 1.0
> X-Mailer: MIME-tools 5.409 (Entity 5.404)

--
/* Tim Freund -- tim@technofreund.com */