New Open Source Project

[Devin Whalen]

On Fri, 2005-01-07 at 00:51 -0500, Logan Rathbone wrote:
> 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
> 

pgAdmin III is another good way to view your database visually.  It also
runs on windows just in case you need that as well.  However, as Lennart
said, the command line for PostgreSQL is far superior than any database
I have worked with, especially Oracle.
http://www.pgadmin.org/


Later

-- 
Devin Whalen
Programmer
Synaptic Vision Inc
Phone-(416) 539-0801
Fax- (416) 539-8280
1179A King St. West
Toronto, Ontario
Suite 309 M6K 3C5
Home-(416) 653-3982


Take back the Web with FireFox....a browser you can trust
www.getfirefox.com

   .-.
   /v\    L   I   N   U   X
  // \\  
 /(   )\
  ^^-^^   

--
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