The past week I’ve been working with the iDeal API from Mollie. Mollie is a company that give’s us developers an easy way to make iDeal payments through there API, for a small fee.

After a long search I wasn’t able to find a stable, well tested gem, I could use in our Rails project, so I developed the ideal-mollie gem. After I finishing this gem, there was only one problem.

When you want to test a iDeal transaction with the Mollie test bank, you MUST do some routing, so that Mollie can send you a request if the payment was paid or not, to your local machine from the internet. So I made a alternative Mollie test bank you can use for what ever programming language you use for making Mollie iDeal payments without the routing problems.

After writing my last article how to Convert PostgreSQL to SQLite, I was asked why this couldn’t be automated?

So I started coding and managed to create a Rake task that will do all of the steps I described in the article in just a few seconds!

Today I’d like to share the steps I take when I need to convert a PostgreSQL database into a SQLite database.

Commonly I have to do this when a Ruby on Rails application is in production and I have to check some issues with the production data. In the production environment we usually use a PostgreSQL database and for developing I use a SQLite database, so we need some conversion.