Running on 'sql:' cache now
Post Info
Author
Date
Posted: Sunday, September 11, 2005
Updated: Thursday, February 16, 2006
Categories
Development::DB::MySQL (4)
Development::DB::SQLite (1)
Development::Python::Django (45)
Hosting::DreamHost (8)
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.
Save/recommend this post:
Subscribe to this blog:
Most recent related documents:
Documents published at about the same time:
- Added RSS — September 13, 2005
- DreamHost: no transactions — September 12, 2005
- Running on 'file:' cache now — September 11, 2005
- TinyMCE 2.0RC1 is out — September 10, 2005
- Something wrong with simple cache — September 9, 2005
- Say no more! Say no more! — September 8, 2005
- Django on Dreamhost: happy end — September 7, 2005
