[Tfug] Linux db

[Liz_Ravenwood at beaerospace.com]

Thanks Don!

Respectfully,
Liz, Data Base Administrator,
Methods Engineering





Bexley Hall <bexley401 at yahoo.com> 
Sent by: tfug-bounces at tfug.org
07/29/2009 06:05 PM
Please respond to
Tucson Free Unix Group <tfug at tfug.org>


To
Tucson Free Unix Group <tfug at tfug.org>
cc

Subject
Re: [Tfug] Linux db







Hi Liz,

--- On Wed, 7/29/09, Liz_Ravenwood at beaerospace.com 
<Liz_Ravenwood at beaerospace.com> wrote:

> I'm going to build a database behind
> a web application and don't know Oracle yet.

I would strongly suggest PostgreSQL, instead.  Even "building it
from scratch" is relatively straightforward (and I suspect you
can just as easily find a prebuilt version).  There is support
for tying it into PHP, Apache, etc.  Aside from one version in
the past few years, I haven't seen any data loss issues and
the code itself is "quite pretty"  :>

Featurewise, there isn't too much in the mainstream that
it doesn't do that Oracle *does*.  (I think you can find a
tabulated list of RDBMS features on the postgresql.org
web site).  I've had some issues over the years with odd
things like using inheritance on arrays of user defined 
datatypes, etc. but most things get added to the featurelist
with amazing speed.

> I've gotten pretty good with MS Access
> so I'm thinking the knowledge will transfer.

There are some GUI tools for data definition and data entry
available (e.g., pgadmin3) but I don't think you will find
the "application end" built-in like Access (e.g., you don't
draw forms or reports in PostgreSQL -- just the data and
its definitions).

> My computer at home is so f---dup that
> I'm going to take everything off and install RedHat,
> but then want to install Oracle and develop to a website.

If your database is going to be large, be sure to have
a sizable place to which to *dump* it; the safest and most
portable way of dumping PostgreSQL databases is in an ASCII 
format (so dumps can get very big, very fast).

Good luck!


 

_______________________________________________
Tucson Free Unix Group - tfug at tfug.org
Subscription Options:
http://www.tfug.org/mailman/listinfo/tfug_tfug.org



--------------------------------------------------------------------------------------------------------- 

This email (and all attachments) is for the sole use of the intended 
recipient(s) and may contain privileged and/or proprietary information. 
Any unauthorized review, use, disclosure or distribution is prohibited. If 
you are not the intended recipient, please contact the sender by reply 
e-mail and destroy all copies of the original message.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://tfug.org/pipermail/tfug_tfug.org/attachments/20090730/e7110e6d/attachment-0002.html>