Thread: 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
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!!
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 > >
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 > >
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 */