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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
