Hey all, I was hoping to get some advice on how to structure an app I’d like to make. Without giving away too much info, it is similar to a “Daily Quotes” type app. Essentially it will need to access a server to download Today’s quote.
Here is the plan:
-
On launch, the app will get the current date from the device
-
App will connect to server, find today’s data, and download Today’s quote
-
App will display Today’s Quote to user
-
App will also have the option to download & show the previous X amount of day’s quotes.
I don’t have too much experience dealing with server-side data, so any advice would be appreciated. I am assuming that using a MySQL database is probably the best bet here. What is a good way to go about creating this database? Do I need to create 3 columns for Day, Month, Year? How does the app access the database? Directly? Through a script?