I would have to agree with Jerry. It would depend on what you are
looking for. I personally like PostgreSQL because its SQL is more
compliant with the ISO standard, it also has the feature like Jerry
mentioned of writing Perl (and you can add other languages) functions
right in the database. PostgreSQL does have a smaller user base right
now, I think it is because MySQL _looks_ so much easier to use. I used
both for extended periods of time and personally felt that PostgreSQL
suited my needs better.
Alex
> -----Original Message-----
> From: plug-discuss-admin@lists.plug.phoenix.az.us
[mailto:plug-discuss-
> admin@lists.plug.phoenix.az.us] On Behalf Of Jerry Davis
> Sent: Thursday, April 15, 2004 6:29 PM
> To: plug-discuss@lists.plug.phoenix.az.us
> Subject: Re: database
>
> On Thursday 15 April 2004 08:10 pm, Michael Havens wrote:
> > A couple of people have recommended I do that. Something I need to
know is
> > why you recommend PostgreSQL over MySQL. I mean how is it better;
does it
> > have more of a future; is it easier to learn or is it just differant
to
> > learn?
>
> Mike,
>
> When I fooled around with MySQL and PostgreSQL, I was equally
impressed with
> both of them.
>
> 1) MySQL seemed faster for selects
> 2) I liked PostgreSQL's ability to write perl functions right in the
database.
>
> So, I guess it depends upon what you want to do with it.
>
> I would go to both sites, and look at the features, to make a real
> determination.
>
> I have a both O'Reilly books. Alas ... I am currently pretty far away
from
> Phoenix now.
>
> Jerry
>
> >
> > I was advised not to go with it previously because I could get help
from
> > more people if I went with MySQL.
> >
> >
> >
> > Then again
> >
> > On Thursday 15 April 2004 17:19, Earl, Alex C wrote:
> > > > > am I correct in assuming that you need Apache to be running to
work
> > >
> > > with
> > >
> > > > > MySQL?
> > > >
> > > > No. MySQL is completely independent.
> > > >
> > > > There is a very large and still fast growing field of
development,
> > >
> > > LAMP:
> > > > Linux, Apache, MySQL, PHP. http://www.onlamp.com/ The tools
work
> > >
> > > very
> > >
> > > > well together, and will for a very long time since development
of all
> > > > these is geared toward working together AND working with as many
other
> > > > protocols as possible. For instance, I worked on a project that
> > >
> > > included
> > >
> > > > a DB2 database, which PHP could interface through an ODBC driver
> > >
> > > provided
> > >
> > > > by IBM. So it was a part LAMP and part LA[db2]P website. Since
this
> > >
> > > is
> > >
> > > > Linux goodness, you can also write cron jobs that run php on the
> > >
> > > command
> > >
> > > > line, e-mail users, automatically submit e-mails into a MySQL
table,
> > > > whatever.
> > > >
> > > > I also highly recommend http://safari.oreilly.com/ .
> > > >
> > > > --Alexander
> > >
> > > I personally recommend PostgreSQL over MySQL as well, I failed to
> > > mention this earlier. I would also recommend using something like
PEAR
> > > to abstract the accesses to the database so that you can plug
different
> > > database servers into the back of your scripts.
> > >
> > > Alex
> > >
> > > ---------------------------------------------------
> > > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> > > To subscribe, unsubscribe, or to change you mail settings:
> > > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
> >
> > This message has been scanned for viruses by the VEI Internet
> > Automatic Email Spam and Virus Scanner, and is believed to be free
of spam
> > or viruses. Please report spam to spamtrap@vei.net. If you would
like 98.9
> > % spam blocked from your E-mail then go to VEI Internet for details.
> > Anti-spam/Anti-virus is FREE with every account.
> >
> >
> > http://www.vei.net/
> > mailtospamtrap@vei.net
> > ---------------------------------------------------
> > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> > To subscribe, unsubscribe, or to change you mail settings:
> > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
> --
> Registered Linux User: 275424
> Today's Fortune: Traveling through hyperspace isn't like
> dusting crops, boy.
> -- Han Solo
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)