• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!


Setting Up the Database

Page history last edited by PBworks 13 years, 9 months ago

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:


  1. Navigate to the root of your Mobile Web install
  2. 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:


  1. 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.