After doing some research, I have decided that we will stick with MyISAM as a default. We can add a feature to allow webmasters to change it to InnoDB. My reasoning is that MyISAM is faster for most average stuff, which is fine since we have nothing complicated in our script. It is also more reliable.

We really don't need row-level locking or transaction based queries due to simplicity. If we had numbers of very complex queries, transaction based queries would be a must. Row level locking would only be necessary if we were getting many requests a second.

__________________