• Ruby Rails and Sqlite

    When trying to create my first rails app, well it’s not my first rails app, I am just trying out the examples in the Ruby on Rails Tutorial Book. this is what I got: Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/sqlite3-1.3.5 for inspection. Results logged to /usr/lib/ruby/gems/1.8/gems/sqlite3-1.3.5/ext/sqlite3/gem_make.out An error occured while installing sqlite3 (1.3.5), and [...]

    Apr 18th, 2012 | Filed under Database
    Tags: , ,
  • Mysql Incremental Backup

    Still using mysql? about time you gave up on it and switched to Percona. It is a drop in replacement for mysql. That means your existing data, and stored procedures, or data retrieval methods don’t need to undergo any changes. Even if you don’t switch to Percona, you can still use their xtrabackup and innobackupex [...]

    Apr 17th, 2012 | Filed under Database
  • Percona xtrabackup

    Having recently recently replaced MySQL installations with Percona it was time to try out xtrabackup but things didn’t get off to an auspicious start.   111123 22:11:14 innobackupex: Starting mysql with options: –user=’root’ –unbuffered — 111123 22:11:14 innobackupex: Connected to database with mysql child process (pid=25271) 111123 22:11:20 innobackupex: Connection to database server closed IMPORTANT: [...]

    Nov 24th, 2011 | Filed under Database
  • Percona Installation Woes

    It turns out that all the EC2 Amazon Machine Instances that have Percona installed by default have older versions of either Percona or PHP or both. My intention was to use Percona on a web app so it’s required that the version of PHP is reasonably new.  So the logical thing to do is to [...]

    Nov 12th, 2011 | Filed under Database, PHP
  • Percona a Drop in Replacement for MySQL

    I have a love hate relationship with MySQL. I first discovered and fell in love with it around twelve years ago. I didn’t mind that it didn’t have stored procedures and sub queries. My first disappointment was when MySQL announced changes to their client license terms around eight years back.   Disillusionment occurred when MySQL [...]

    Oct 14th, 2011 | Filed under Database
  • CouchDB or Java which one should I hate?

    Never been a fan of RDBMS no sirree. But that has never stopped me from using them (but with many repitions of the phrase ‘databases suck’). Then along came non relation databases and then no-sql. For a while I had to modify my phrase to ‘SQL Databases suck’. But it wasn’t long before I started [...]

    Nov 13th, 2010 | Filed under Database, Java
  • ImportError: No module named MySQLdb

    When you see that title, you are gonna say; ‘you need to install the MySQLdb module’. Well, let me assure you that it’s already it’s already there. Provided by MySQL-python-1.2.3-0.4.c1.fc12.x86_64.rpm . On the other hand if you are here because you ran into the same problem and want a solution, but don’t want to listen [...]

    Apr 28th, 2010 | Filed under Database, Java, PHP
  • Twitter over capacity and SimpleDB Errors

    As I write this, ‘Twitter is over capacity’. The fail whale as it’s popularly known is flying with the help of a few tweety birds. In between reloads the broken robot (or is that an  alien) with the ‘Something is technically wrong’ message also pops up. By quite a coincidence, simpleDB, Amazon’s cloud hosted nosql [...]

    Apr 5th, 2010 | Filed under Database, PHP
    Tags: ,
Archive for the ‘Database’ Category