New Open Source Project

[Logan Rathbone]

On Fri, 07 Jan 2005 00:35:40 -0500
Sergey Kuznetsov <tlug-9a/WvBvX2Qpg9hUCZPvPmw at public.gmane.org> wrote:

> Hi Paul,
> 
> I would recommend you to choose LAPP instead of LAMP (PostgreSQL
instead 
> of MySQL).
> First of all you will have more stable environment, as well as you
will 
> forget the licensing headache from
> future MySQL AB license perturbations, as well as more solid DB ( I 
> would say the PostgreSQL is an
> OpenSource Oracle ). I have quite a lot of experience with different 
> flavors of DB ( Oracle, Sybase,
> MS-SQL, MySQL, PostgreSQL ) and I had only positive experience only
with 
> Oracle and PostgreSQL.
> MySQL fast on simple queries, and in case if you have only few users
who 
> is querying DB,
> if more users starts to querying or more complex queries at the same 
> time - MySQL quite often corrupting
> indexes. PG behaves very well in the most of the cases, and shows 
> incredible performance on very complex
> queries. PG's feature set is just outstanding! Many of features was 
> implemented only in PG.
> <snip>

I just thought I'd bud into your conversation for a sec ...  I too have
been working on getting a similar system going, not for any "real" work
but just to figure out how it all works should I need to do it for real
in the future.

One of the things that led me to choose MySQL was that I heard it works
really well with PHP, and above all, I could use the PHPMyAdmin
web-based tool to view my database.  But I've been hearing people rave
on about both Firebird and PostgreSQL.

Are there any good tools out there that can allow you to view your
PostgreSQL database visually like PHPMyAdmin can?
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml