Re: Dynamic web sites with PostgreSQL

On Nov 10, 2005, at 2:50 AM, Nicolay A Vasiliev wrote:

> I'd like to ask the PostgreSQL community for the conseptual thing.
> We develop our web sites using MySQL. We like this for its high
> speed and fulltext search feature. But nowadays our projects are
> growing fast and we afraid our MySQL won't be able to perform large
> amount of complex complicated queries. So we get a question about
> altenative SQL server. In fact there are not too much from open
> source SQL servers, I think only 2 serious: PostgreSQL and MaxDB.
> May I sak you about words for advocacy or accusation for each of
> these database servers?
>
> Our tasks: static content generation but using of complicated
> search feature on the web site.
>
> Any suggestions are very appreciated.

My suggestion would be to try a content management system like Drupal
(http://drupal.org). It supports both MySQL and PostgreSQL, so you
could design a system that works with both databases and choose the
one that best fits your requirements. It has lots of powerful
features and a nice modular architecture which makes it easy to
extend and customize.

See the link below for some information about installing Drupal with
PostgreSQL and some early discussion about integrating tsearch2 into
Drupal.

http://pgedit.com/install_drupal

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL