12-16-2015, 05:21 PM
I have been reading up on the MyISAM vs InnoDB engines. In general for what coreBOS does and, specially in an environment as you indicate of very low usage and data you will be safe using either. That said, InnoDB is better, not only because it is safer against crashes and supports transactions (faster) but because it permits establishing relations (foreign keys) which are interesting for a relational application like coreBOS.
Your real problem will not be as much in the application, which you can fork and adapt as you need, but with other external modules where each one can define the tables as they please, so you would have to end up forking and patching those too if you have access to the code.
Just a quick example that comes to mind would be the coreBOS Employee module:
https://github.com/tsolucio/coreBOSEmployee/blob/master/manifest.xml#L89
Your real problem will not be as much in the application, which you can fork and adapt as you need, but with other external modules where each one can define the tables as they please, so you would have to end up forking and patching those too if you have access to the code.
Just a quick example that comes to mind would be the coreBOS Employee module:
https://github.com/tsolucio/coreBOSEmployee/blob/master/manifest.xml#L89
Joe
TSolucio
TSolucio