DrupalConParis2009 - PostgreSQL http://paris2009.drupalcon.org/taxonomy/term/18/0 en Developing with PostgreSQL - Tips, Tools and Tricks http://paris2009.drupalcon.org/session/developing-postgresql-tips-tools-and-tricks <p>Want to work with PostgreSQL but don't know how? Not sure of tool to use or even the tools available? This talk introduces PostgreSQL to developers and gives the 101 on how to work with PostgreSQL from development to testing to production. </p> <p>Topics covered:</p> <ul> <li>The database <ul> <li>Structure</li> <li>Users</li> <li>diff -up mysql pgsql</li> </ul> </li> <li>Tools <ul> <li>pgsql cli</li> <li>pgadmin3</li> </ul> </li> <li>Drupal SimpleTest suite <ul> <li>Bug fixing</li> </ul> </li> <li>Production <ul> <li>backing up data</li> </ul> </li> </ul> <div class="field field-type-text field-field-bio-booklet"> <div class="field-label">Speaker bio:&nbsp;</div> <div class="field-items"> <div class="field-item odd"> Josh Waihi is a Drupal developer for an open source company called Catalyst IT in New Zealand and also the co-maintainer along side Damien Tournoud of the PostgreSQL driver in Drupal 7. He won the 2009 IT Rockstar Competition in New Zealand as a result of the work he has contributed to the Drupal community. </div> </div> </div> <div class="field field-type-userreference field-field-co-presenters"> <div class="field-label">Co presenters:&nbsp;</div> <div class="field-items"> <div class="field-item odd"> <a href="/drupal-users/damien-tournoud" title="View user profile.">Damien Tournoud</a> </div> </div> </div> http://paris2009.drupalcon.org/session/developing-postgresql-tips-tools-and-tricks#comments PostgreSQL Mon, 08 Jun 2009 22:26:52 +0000 fiasco 581 at http://paris2009.drupalcon.org Drupal + PostgreSQL for business http://paris2009.drupalcon.org/session/drupal-postgresql-business <p>Drupal + PostgreSQL for business is a beginner level talk to explain the what PostgreSQL is and how it is different to the other databases supported by Drupal. The talk will cover :</p> <ul> <li>What is PostgreSQL</li> <li>PostgreSQL support in Drupal</li> <li>PostgreSQL vs MySQL</li> <li>PostgreSQL + Drupal as a business solution <ul> <li>when to use PostgreSQL</li> <li>When not to use PostgreSQL</li> </ul> </li> <li>Q &amp; A</li> </ul> <p>This talk will be relevant for both Drupal 6 and the upcoming Drupal 7 and briefly touch on existing use cases of Drupal and PostgreSQL.</p> <div class="field field-type-text field-field-bio-booklet"> <div class="field-label">Speaker bio:&nbsp;</div> <div class="field-items"> <div class="field-item odd"> Josh Waihi is a Drupal developer for an open source company called Catalyst IT in New Zealand and also the co-maintainer along side Damien Tournoud of the PostgreSQL driver in Drupal 7. He won the 2009 IT Rockstar Competition in New Zealand as a result of the work he has contributed to the Drupal community. </div> </div> </div> <div class="field field-type-userreference field-field-co-presenters"> <div class="field-label">Co presenters:&nbsp;</div> <div class="field-items"> <div class="field-item odd"> <a href="/drupal-users/damien-tournoud" title="View user profile.">Damien Tournoud</a> </div> </div> </div> http://paris2009.drupalcon.org/session/drupal-postgresql-business#comments PostgreSQL Mon, 08 Jun 2009 22:03:50 +0000 fiasco 578 at http://paris2009.drupalcon.org