<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Logan Rathbone wrote:
<blockquote cite="mid20050107005106.14e40fa9-bi+AKbBUZKY6gyzm1THtWbp2dZbC/Bob@public.gmane.org"
type="cite">
<pre wrap="">On Fri, 07 Jan 2005 00:35:40 -0500
Sergey Kuznetsov <a class="moz-txt-link-rfc2396E" href="mailto:tlug-9a/WvBvX2Qpg9hUCZPvPmw@public.gmane.org"><tlug-9a/WvBvX2Qpg9hUCZPvPmw@public.gmane.org></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi Paul,
I would recommend you to choose LAPP instead of LAMP (PostgreSQL
</pre>
</blockquote>
<pre wrap=""><!---->instead
</pre>
<blockquote type="cite">
<pre wrap="">of MySQL).
First of all you will have more stable environment, as well as you
</pre>
</blockquote>
<pre wrap=""><!---->will
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap=""><!---->with
</pre>
<blockquote type="cite">
<pre wrap="">Oracle and PostgreSQL.
MySQL fast on simple queries, and in case if you have only few users
</pre>
</blockquote>
<pre wrap=""><!---->who
</pre>
<blockquote type="cite">
<pre wrap="">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>
</pre>
</blockquote>
<pre wrap=""><!---->
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?
</pre>
</blockquote>
I am extensively using phpPgAdmin, which is works perfect for me. PHP
have native interface<br>
to PostgreSQL, like the same it has to MySQL.<br>
I am not using PHP because of quite unsecured code. This is quite new
language, therefore the security<br>
of this language is not proved yet ( you can see how many security
holes in PHP being discovered quite<br>
often).<br>
I do all my work for Web only on Perl + fast-cgi and my template
package. It gives me flexibility not lesser than PHP.<br>
BTW, Perl's CPAN site have most impressive set of modules, which is on
my opinion is supersedes<br>
any Java JDK with all free Java libraries. Using Perl with CPAN modules
you can do whatever you want<br>
or can imagine.<br>
<br>
But this is my choice and my opinion, and I don't want to start another
holy war =)<br>
<br>
<br>
All the Best!<br>
Sergey.<br>
</body>
</html>