"Sarah Tanembaum" <sarah.tanembaum_at_yahoo.com> wrote in message news:<c78jfi$vomj$1_at_ID-205437.news.uni-berlin.de>...
> Is PostgreSQL reliable enough to be used for high-end commercial
> application? Thanks
Some rules of thumb, A guide to the perplexed:
- If you don't have the source code for a product, and the right to
modify and redistribute it in perpetuity, nothing you develop on top
of it can be relied upon, so therefore the open source applications,
or applications for wich you've been granted such rights via an
non-expiring licence, are much *MORE* suitable for high-end commercial
applications, since you are not locked into any external dependencies.
- Ideally, your Application's data access will be built around a data
abstraction layer that can use alternative database backends, i.e.
PEAR::DB.
- If your data is really important to you, you will use network, not
application or database level security to protect access to it.
- If your data is really important to you, you will only keep a
secondary copy of it in *ANY* SQL server for indexing and querying
purposes, not as the primary datastore.
- Your primary datastore should be self contained, self describing and
human readable, something like a heirarchy of XML files. This is the
best way to ensure the perminancy and portabilty of your important
data.
- Anyone who calls Free Software 'Freeware', implies that believing in
it is a 'religion' or thinks that it is low quality as a rule should
be considered unskilled labour, not a source of real advice.
I'm also in Berlin BTW :) I hope you had a fun May 1st.
Cheers.
Received on Thu May 06 2004 - 10:11:39 CDT