New Open Source Project

[Sergey Kuznetsov]

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?
>  
>
I am extensively using phpPgAdmin, which is works perfect for me. PHP 
have native interface
to PostgreSQL, like the same it has to MySQL.
I am not using PHP because of quite unsecured code. This is quite new 
language, therefore the security
of this language is not proved yet ( you can see how many security holes 
in PHP being discovered quite
often).
I do all my work for Web only on Perl + fast-cgi and my template 
package. It gives me flexibility not lesser than PHP.
BTW, Perl's CPAN site have most impressive set of modules, which is on 
my opinion is supersedes
any Java JDK with all free Java libraries. Using Perl with CPAN modules 
you can do whatever you want
or can imagine.

But this is my choice and my opinion, and I don't want to start another 
holy war =)


All the Best!
Sergey.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://gtalug.org/pipermail/legacy/attachments/20050107/94a592be/attachment.html>