Sunday, September 11, 2005

Now this blog runs on 'sql:'. I use MySQL as my backend. Before that I tested it locally with SQLite (so easy to install!) and MySQL.

I learned today that MySQL, which is provided by my host (DreamHost), uses MyISAM for all tables. MyISAM doesn't support transactions. AT home I use InnoDB, which supports transactions. However the hope is not lost — DreamHost mulls over InnoDB support. But as far as I know, they don't have an implementation schedule yet.

I hope somebody will help me to test it using MySQL with InnoDB, and PostgreSQL. As for me I would settle for 'file:' or even 'locmem:'. The latter looks like a reasonable choice given into account small size of my site.

This site was running using 'locmem:' caching option, which is fine for small web site. Now it runs using 'file:'. Please let me know, if you spot any issues.

I am planning to implement 'sql:' next.