| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Free ware databases: which are worth the money?
hi,
we're using postgres extensively. it's cheaper than oracle, and requires little management. but that's what i don't like about it. the data dictionary tables are scarce and cryptic, and with little documentation available (the interactive docs online are useless for most of my inquiries... have to slog through tons of pages to find what i'm looking for.)
for instance, *where* do i find a list of all foreign key constraints? and if you create databases to mimic tablespaces in oracle, it doesn't work bc you can select from objects across databases.
good luck!
kris
kaustin=# select version();
version
---------------------------------------------------------------------
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
(1 row)
On Fri, 2 Aug 2002, Daniel Wisser wrote:
> hi!
>
> i can strongly recommend PostgreSQL. i have worked with it modelling
> data for a java application and perl cgis using it.
>
> it supports transactions, functions in pure sql, a procedural
> language similar to PL/SQL etc. etc. and is very robust.
>
> the only thing i miss is handling tablespaces as on oracle.
>
> i have sofar only used it on debian, but it should also be fine
> on other linuxes and some elitist bigots work with it on sun.
>
> there is also good literature and a very good o'reilly book on
> it. on the web htpp://www.postgresql.org
>
> regards
>
>
> Mark Teehan wrote:
> >
> > Hi,
> > we are investigating some freeware databases for deployment on systems that
> > dont justify the cost of an oracle license, on linux. What databases out
> > these can cope with a OLTP load, all transaction based, with some
> > reporting? Uncomplicated databases, with mid size volumes of transactions
> > (say low millions) and some reporting queries? I guess reliability is the
> > primary concern, if something can be built as solidly as an oracle
> > instance, with whatever OS protection this would need, then its a starting
> > point for making a non oracle freeware enterprise database.
> > Anyone have any suggestions on what I should download first?
> >
> > Thanks!
> > Mark Teehan
> > Singapore
> > ---------------------------- ERG Group --------------------------
> > The contents of this email and any attachments are confidential
> > and may only be read by the intended recipient.
> > -----------------------------------------------------------------
> >
> > ---------------------------- ERG Group --------------------------
> > The contents of this email and any attachments are confidential
> > and may only be read by the intended recipient.
> > -----------------------------------------------------------------
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Mark Teehan
> > INET: mteehan_at_erggroup.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>
+-----+------+-----+------+-----+-----+-----+------+------+------+-----+ kris austin-murray ... senior database manager, ocp ... advance internet
www.advance.net ... kaustin_at_advance.net ... 201-459-2805 +-----+------+-----+------+-----+-----+-----+------+------+------+-----+ "Darkness cannot drive out darkness; only light can do that. Hate cannot drive out hate; only love can do that." - Martin Luther King, Jr.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kris Austin-Murray INET: kaustin_at_advance.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Aug 02 2002 - 10:03:28 CDT
 |
 |