Re: Newbie question :-)
От | Mitch Vincent |
---|---|
Тема | Re: Newbie question :-) |
Дата | |
Msg-id | 011201c0a002$c036a7c0$0200000a@windows обсуждение исходный текст |
Ответ на | Newbie question :-) (Bela Lantos <belantos@optusnet.com.au>) |
Список | pgsql-general |
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 > >
В списке pgsql-general по дате отправления: