Wednesday, February 6, 2013

My answer to "Integration Lampcms with postgesql"

This is my answer to a Question on Support site for LampCMS project


MySQL is used only for the search feature, not as a main datastore. The site will work without MySQL just will not have the search and auto-suggest for when you ask new question.

If you know how to use Postgresql as a full-text search provider then yes, it can be used instead of MySQL. My goal was to eventually move to some type of real search engine like Lucene Solr.

I designed the search classes to be pluggable module using interfaces instead of hard-coded classes, so it should be possible to just write a Solr based search provider and use it instead of MySQL/PDO based provider.

Same can be do with Postgresql, but will not made as much sense as replacing MySQL with a real search engine.

No comments:

Post a Comment