Hi all,
I am in the process of installing roundceube on my FreeBSD 7 server. While I wait for a FreeBSD packaging issue to be sorted out, I have a rather general question:
Which database backend to use?
My initial inclination is to go with sqlite. My installation will basically be for use on my SoHo gateway/server; I am not sure I need all the firepower of a Postgres or mySQL. The server on which I will be running roundcube is an older Pentium IV with only 512 MB, and I hoping sqlite has a smaller memory footprint than the others. That being said, the message database could become fairly big (by way of example: after using gmail for about two years, my account has around 100k messages, using about 3GB, thanks to so busy mailling lists I subscribe to). If for some reason, I later want to migrate to Postgres, will be be possible to import the sqlite db?
Thanks.