Extending Support for PostgreSQL Outside Drupal Core

As all well and done providing PostgreSQL support for Drupal Core - it an important job that provides future proofing for thousands of projects around the world. But it doesn't, well that is to say it shouldn't, stop at just core.

Drupal contrib modules are in all kinds of states when it comes to PostgreSQL, quite often, no one has tested contrib modules on PostgreSQL and quite often I'm the first (lucky me!). Its moments like these I really wish MySQL was a standard compliant database - it would sure as heck my life easier. Developers who use MySQL love doing crazy things with there SQL that work in MySQL and no where else. SQLite support will be introduced in Drupal 7 and I suspect it will find many common problems that PostgreSQL has with contrib modules.

Since I've become a PostgreSQL maintainer for Drupal, its been great to see more and more issues been raised with PostgreSQL issues. Bringing these issues to the contrib maintainer's attention helps create awareness of PostgreSQL and how to do things right.

However, now there are so many issues regarding PostgreSQL in the Drupal issue cue, now the task is to make them all go away again. But this time, fixed rather than ignored.

 

I'm off-topic but how did you

I'm off-topic but how did you made those nice glossary / question marks ?

Drupal glossary module

Josh, I'm thinking about

Josh,

I'm thinking about using drupal for my project (educational) and interesting i
if drupal has support of full-text search feature of PostgreSQL ?

Oleg

PS.btw, what configuration of drupal you use for your blog ?

Unfortunaltely, Drupal

Unfortunaltely, Drupal doesn't use the full-text search support of PostgreSQL, it does however have support of Apache Solr which I've had great success with. As Drupal supports several databases, we can't use particular features of a single database.

I use the Acquia distribution of Drupal to run my blog. with a few additional modules like 'glossary'

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <h2><h3><h4><a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <p> <div> <span>
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
  • Glossary terms will be automatically marked with links to their descriptions. If there are certain phrases or sections of text that should be excluded from glossary marking and linking, use the special markup, [no-glossary] ... [/no-glossary]. Additionally, these HTML elements will not be scanned: a, abbr, acronym, code, pre.
  • You may insert videos with [video:URL]

More information about formatting options