Over the last year I have been reevaluating how and were I store the data for my projects. Traditionally I have added a new database in MySQL for each but I thought that was a bit overkill for some of the smaller, single user, projects that I was working on.
There are several options for storing your data, but each comes with its own trade-offs in setup time, performance, and scalability. Here I look at the ones I have used in my prejects — flat files, SQLite, and MySQL — and see where each one shines (and where … Read the rest
