Re: Need database recommendation

[Rick Roberts <ri...@ait-web.com>]

I recently ported a small Oracle web application to PostgreSQL.
Using Apache, Red Hat 6.2 and JDK1.2.2.
The database only used tables, views, and sequences, so it's a pretty small
test case, and the conversion went without much difficulty.  The only issues
were:

1.
In my Oracle app I was updating the views.
Can't do that in PostgreSQL.
No problem though, I just edited the table directly.

2.
Oracle has some nice text formating and date conversion functions which are not
in PostgreSQL.
I'm just living without them until I write some replacement functions.

3.
PostgreSQL Documentation is still not finished.
Don't stray to far, you will find yourself all on your own.

All in all.  I am happy with PostgreSQL.  Looking forward to seeing it mature a
little bit.  Once that happens, I expect it to shake up the industry a bit.
Much like Linux is doing now.

Rick