This is for version 1 & 2 of Mobile Web OSP.
By default Mobile Web OSP uses SQLite for its database. Why SQLite? When I first set up the Mobile Web OSP I didn't have access to MySQL but I didn't want to change the database calls that much. PDO SQLite gave me the opportunity to keep most everything the same. Also, because of the low traffic expected as well as the needs for easily distributing the project SQLite seemed like a good choice.
SQLite Support
To set-up the SQLite version of the database:
- Navigate to the root of your Mobile Web install
- Copy 'development.copy.sqlite3' to 'development.sqlite3' (Why '.copy' files?)
Note: In version 1 of Mobile Web OSP you also need to edit 'lib/db.php' with the appropriate path to the project.
Having Problems with SQLite?
I have some helpful troubleshooting info regarding SQLite.
MySQL Support
To set-up the MySQL version of the database:
- Sorry, you're on your own. If you happen to set it up on your campus I'd love to know how you did it so I could share it with others.
Special Note
I would like to get to the point where Mobile Web OSP uses ORM so it can support many different databases with little configuration. Hopefully that will be here with version 3 of the product.
Comments (0)
You don't have permission to comment on this page.