How to convert drupal 6 site from postgres to mysql
I have a project that was set up on drupal 6 on postgres database as i always prefered it over Mysql.
I am currently in progress of moving some stuff to dreamhost.com (which RULES!) and i finally have shell access and i can actually do stuff. The only problem is they dont support pgsql at all! LOL! So i have decided that it takes too much effort and time to maintain it.
Here are 3 simple steps to migrate your drupal installation (possibly other apps) from postgres to mysql.
Top Drupal modules
So for start i would setup Acquia from acquia.com and see their set of modules and their setup. Its a project based on Drupal (led by Drupal initial creator). It uses many of the modules and tries to make the system a bit more user friendly and feature rich.
Then after you get familiar with some of the concepts get the newest drupal release and install modules listed below.
- Administration Menu - nice fast menu at the top of the page
- Google Analytics - flexible way to track activity of your visitors
- Pathauto - generates SEO friendly urls for your pages
- Printer-friendly pages - makes printer friendly versions of your pages as well as easy pdf generation
Drupal 6 with postgres
I really love Postgres and i was always happy with its flexibility, performance and features. So starting work on a new Drupal setup i thought ok, lets take advantage of that great 'database abstraction layer'. I really tried, i fixed bugs in some modules and had high hopes. I hope it will get better in the future but for now i would not recommend it. See more details in the full post.
How to get started with Drupal
A few hints how to get started with Drupal and not get stressed out too much.
Open Source CMS systems
I was looking for a good cms system for a long time. And i really could not find one. I was playing with ez publish and joomla and basically i was depressed. I have never seen more confusing and user-unfriendly systems in my life! Especially joomla is a huge surprise. How in the world did it become so popular?
Any way if you are considering a new cms you might find some tips here.
digg