SQL Questions (MySQL or PostgreSQL?)

[Louis LeBlanc]

Then again, you could just ride the fence and install them both . . .

I'd also suggest you start with MySQL though.  As mentioned
previously, it's the more commonly used DB.  I started with
PostgreSQL, and wound up having to install MySQL anyway because I
wanted to try some apps that requred it.  No big deal, they listen on
different ports, and if you aren't running anything "real life" you
won't notice them on a reasonably modern system.

Besides, there are more MySQL books out there.

Lou

On 02/11/05 06:59 PM, Ean Kingston sat at the `puter and typed:
> On February 11, 2005 05:17 pm, Sean wrote:
> > Jan Branbergen wrote:
> > >>I would like to install SQL here for my own use, not for any real life
> > >>
> > >>currently, round now for learning.
> > >>
> > >>Right now plan to install MySQL.
> > >>Looking through the ports there is numerous version and some say for
> > >>
> > >>server, some say for client.
> > >>
> > >>Looking for some tips as to what version of SQL and tools to
> > >>install?
> > >>Also wondering if anyone can point me towards documentation in my
> > >>learning efforts?
> > >
> > > i would like to suggest PostgreSQL if your objective is learning SQL.
> > > MySQL only provides a subset.
> > >
> > > it is by no means more complicated to install or to get started.
> > >
> > > regards,
> > >
> > > Jan
> >
> > What is the difference between PostgreSQL and MySQL?
> >  From what I see MySQL seems to be more common.
> 
> From a basic design standpoint, MySQL was designed to be a fast language 
> compatible RDBMS system. To achieve that goal they cut out a lot of features. 
> Particularly those related to integrity, consistency, and validity checking.
> 
> Postgres is designed to be a fully functional RDBMS that complies with the SQL 
> standard. It includes integrity, consistency, and validity checking that 
> MySQL lacks.
> 
> I also think one of the reasons that MySQL is more common than Postgres is 
> because when they were both starting out, MySQL got a functional RDBMS out 
> much sooner than Postgres did and when Postgres did get theirs out, MySQL was 
> a lot faster (because of the lack of data validation). Postgres has since 
> closed the gap a lot on the speed issues while keeping the data integrity.
> 
> On the other hand, there are a lot more tools that make managing a MySQL 
> server easier.
> 
> -- 
> Ean Kingston
> 
> E-Mail: ean AT hedron DOT org
> URL: http://www.hedron.org/
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"
> 

-- 
Louis LeBlanc                          FreeBSD-at-keyslapper-DOT-net
Fully Funded Hobbyist,                   KeySlapper Extrordinaire :)
Please send off-list email to:         leblanc at keyslapper d.t net
Key fingerprint = C5E7 4762 F071 CE3B ED51  4FB8 AF85 A2FE 80C8 D9A2

Factorials were someone's attempt to make math LOOK exciting.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20050211/73fb0bbb/attachment.bin