3 years ago I have announced my disagree on how Sun was crossing the red line and my decision to move out of MySQL, so now is time to announce that develcuy.com is successfully migrated to PostgreSQL 9.1!

If you are wondering how I have achieved it, let me share that is not an easy job in Drupal 6, you should have good experience on MySQL, PostgreSQL and Drupal database schema. Fortunately, In Drupal 7, migration between database engines seems to be so easy thanks to DBTNG.

Nowadays our web development life with FLOSS is getting more complex. Do you remember the nginx vs. lighttpd vs. apache? Now it is about cassandra vs. mongodb vs. couchdb, and memcached vs. redis vs. etc.....

This was a postponed decision, because I did not liked to listen to an experienced counselor.

Sun Microsystems is in the way of closing MySQL, which is a "feeling" years ago, but has never crossed the red line of "minor risk". Unfortunately this is a sad reality today. The good news is that FLOSS is an open space for alternatives in most of cases.

So where am I going now? I'm going back to PostgreSQL, although is rigid but that guarantees will be that way for preserving the FLOSS philosophy.

It is one of my first posts in english(recovered from: http://www.linuxforum.com/forums/index.php/topic,137025.0.html): I don't know if it is new, but today, alfer a large week of intensive research, finally i had discover a way to access visual foxpro databases directly from linux. What do you need? download, compile and install CLIP from http://sourceforge.net/projects/clip-itk/ then put the vfp table into the same directory of the next script:

file: testdbf.prg

use dbftable
list columnname

1. download from http://www.fabforce.net/ I get DBDesigner4-0.5.4-0.i586.rpm

2. apt-get install rpm alien

3. alien --to-deb DBDesigner4-0.5.4-0.i586.rpm you must get a file: dbdesigner4_0.5.4-1_i386.deb

4. dpkg -i dbdesigner4_0.5.4-1_i386.deb

5. fix missing simlinks ln -s /usr/lib/DBDesigner4/libsqlmy.so /usr/lib/

6. from http://cesar.plug.org.ve/?p=41 :

wget http://www.silcom.com.pe/soft/xlibs_6.8.2-77_all.de

sudo dpkg -i xlibs_6.8.2-77_all.deb