Design masjid database - Githubissues

meltuhamy / masjid-times

Finally a prayer times app that works with your Mosque!

http://meltuhamy.com/masjid-times/

12 stars 4 forks source link

Design masjid database #2

Closed meltuhamy closed 11 years ago

meltuhamy commented 11 years ago

Design a database which will hold all Masjid data such as

masjid locations
masjid info (contact details, etc)

as well as masjid prayer times.

Decide whether to use NO-SQL or an SQL database, and decide which database to use.

Requirements:

High performance
Downloadable formats
Easy to represent a timetable (it seems obvious but still need to think about it)

Don't forget about the possibility of NOT using a database but just using downloadable "time tables"... However, we need a way of doing RESTful requests.

meltuhamy commented 11 years ago

Advantages MySQL:

Easy to implement: just have a table per month.
Easily available on many hosting platforms
Relatively fast

Disadvantages of MySQL:

need to convert between tables and JSON (which is straight forward but still needs processing)
Not very scalable (which is not that bad because most load is expected to be from mobile phones)

Advantages of NoSQL:

scalable
fast and hacky to implement
Already JSON

Disadvantages of NoSQL:

need more expensive hosting package (heroku/azure/aws)
our data is very table-like. But noSQL is very unstructured (doesn't suit the job).

Winner: MySQL.

meltuhamy commented 11 years ago

MySQL table structure: MasjidTimesDB