<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Kevin,<br>
<br>
PostegreSQL is a great SQL backend, and has a bunch of advantages over
MySQL for larger sites. However, in Drupal usage, it has two main
strikes against it:<br>
<br>
1. The majority of Drupal developers use MySQL. A somewhat lesser
number use Postgres. As a result, Postgres-specific bugs in core aren't
quashed quite as quickly as MySQL-specific bugs.<br>
<br>
2. While Drupal has a commitment to be compatible with Postegres,
contrib can vary quite a bit. That is, as often as not, your contrib
modules will have SQL queries in them that just plain don't work with
Postgres.<br>
<br>
Of these two problems, I think the lack of compatibility in contrib is
the one you would deal with more. At least, you would likely find
yourself in a position to be writing Postgres compatibility patches for
modules you use.<br>
<br>
Brian<br>
<br>
On 10-07-20 07:20 PM, Kevin Davison wrote:
<blockquote cite="mid:E2DFC38E-B592-4FFC-9357-037B48218C0D@quevin.com"
type="cite">I'm not very familiar with the use of PostgreSQL with
Drupal, as I tend to use Pressflow with MySQL on most projects. I read
about the advantages and disadvantages, but not sure how to compare a
clustered DB with PostgreSQL and Pressfow running on Pantheon with
MySQL optimized, perhaps on multiple DB servers. It looks like there
are various issues with contributed modules & PostgreSQL, and that
doesn't sound like much fun to deal with.
<div><br>
</div>
<div>So now I have a potential client who needs help with PostgreSQL
in the mix, and I'm not sure if I should get involved.</div>
<div><br>
</div>
<div>Here's the client's development/production environment:</div>
<div><br>
</div>
<div>
<ul class="MailOutline">
<li>Debian Lenny (5.0) host environment</li>
<li>Debian packaging for deployment</li>
<li>Drupal 6 framework</li>
<li>PostgreSQL 8.3 database</li>
<li>Git source control</li>
<li>Apache Solr 1.4 for search and related artist matching</li>
<li>Amazon S3 + CloudFront for storage and streaming of videos</li>
<li>FFMpeg for encoding of uploaded videos</li>
<li>JWPlayer for playback (looking to replace this in a future
phase))</li>
<li>Apache and Nginx web servers (although development can be done
with just Apache)</li>
<li>PHP 5.2</li>
</ul>
</div>
<div><br>
</div>
<div>They know what they're doing!</div>
<div><br>
</div>
<div>Here's what I read about PostgreSQL on <a moz-do-not-send="true"
href="http://Drupal.org">Drupal.org</a>:</div>
<div><br>
</div>
<div>(From <a moz-do-not-send="true"
href="http://drupal.org/node/33171">http://drupal.org/node/33171</a>)</div>
<div><br>
</div>
<blockquote type="cite">
<div>First off you have to ask yourself is it really worth it? In
most cases no absolutely not, MySQL is just fine for sites that are
small and want to remain that way, this includes personal sites and
blogs etc.<br>
<br>
PostgreSQL's real strength at least in my opinion comes from its
ability to seamlessly cluster, thereby distributing the load among many
DB servers rather than bogging down a single server. If you have a big
website with lots of traffic and have the resources for multiple
servers, then PostgreSQL is definitely the way to go.</div>
</blockquote>
<div><br>
</div>
<div>This potential client has a lot of data, with the potential for
a lot of traffic. Their current configuration may be ideal, as far as I
know right now.</div>
<div><br>
</div>
<div>And I've been really happy with staging development on
WebEnabled, but they don't support PostgreSQL yet. I don't even have
PostgreSQL installed on my local development environment!</div>
<div><br>
</div>
<div>So I'm asking the Drupal community about this one. Perhaps I
need to learn more about PostgreSQL, or I just need to stick with what
I know best (as an intermediate at MySQL). And I may need some help
from Developers who do know more.</div>
<div><br>
</div>
<div>What do you think?</div>
<div><br>
</div>
<div>
<div>Thank you,</div>
<div><br>
</div>
<div>Kevin</div>
</div>
<div><br>
</div>
<div><font class="f1" face="Courier New" size="3">--- </font><br>
<br>
<font class="f1" face="Courier New" size="3">Quevin, LLC</font><br>
<font class="f1" face="Courier New" size="3"> <a
moz-do-not-send="true" href="http://Quevin.com">Quevin.com</a></font><br>
<font class="f1" face="Courier New" size="3"> <a
moz-do-not-send="true" href="http://twitter.com/Quevin">twitter.com/Quevin</a></font><br>
<font class="f1" face="Courier New" size="3"> <a
moz-do-not-send="true" href="http://linkedin.com/in/quevin">linkedin.com/in/quevin</a></font></div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
consulting mailing list
<a class="moz-txt-link-abbreviated" href="mailto:consulting@drupal.org">consulting@drupal.org</a>
<a class="moz-txt-link-freetext" href="http://lists.drupal.org/mailman/listinfo/consulting">http://lists.drupal.org/mailman/listinfo/consulting</a>
</pre>
</blockquote>
<br>
</body>
</html>