In this tutorial I've used SQLite. I use PostgreSQL for production services. I don't remember now why I used such type.