I'm starting a web project that likely should be fine with SQLite. I have SQLObject on top of it, but thinking long term here -- if this project should require a more robust (e.g. able to handle high traffic), I will need to have a transition plan ready. My questions:
- How easy is it to transition from one DB (SQLite) to another (MySQL or Firebird or PostGre) under SQLObject?
- Does SQLObject provide any tools to make such a transition easier? Is it simply take the objects I've defined and call createTable?
- What about having multiple SQLite databases instead? E.g. one per visitor group? Does SQLObject provide a mechanism for handling this scenario and if so, what is the mechanism to use?