AppWarp S2 with database services

Question

Hi we developing an app which has real-time multiplayer game play with your AppWarp s2 services. The app is similar to the QuizUp app on Android and iOS.

Features of the game

70,000 questions

Player Profile

• Game History (list of previous matches including detailed results)
• Achievements List
• Friends List
• Chat Inbox (messages history)
• Total Score
• Level Achieved
• Number of Games Played
• Wins
• Losses
• Draws
• Average Score
• Average Answer Time
• Total Questions Correct
• Total Game Time
• Avatar (including load-out)
• List of All Categories Played
• Blocked Player List
• Top 5 Favourite topics Played
• Profile Image
• Country

 

Leaderboard (for each category)

• World Rankings
• Country Rankings
• Friends Rankings
• Leaderboards:

1. Today
2. This Week
3. This Month
4. All Time

 

Categories

• 20 Top Level Categories
• Various Number of Sub-level Categories
• 1500 Questions Per Category
• 6 Languages
• Question Definition:

1. SQL Question Definition

• Question ID (pk) (fk)
• Question Text
• Correct Answer
• Option 1
• Option 2
• Option 3
• Image
• Date Created
• Language ID (fk)
• Additional Info

To store this data we have the option to use your SQL or NoSql add on services. Being new to NoSql we are wondering whether your NoSql is a viable option for the feature we are proposing to offer for our app?

What are the benefits for us using your NoSql over SQL?

What document types does you NoSql services support? Which document type would be suitable to use?

Finally from the extensive collection of services you have on offer which would recommend for this type of functionality?

• App42 Cloud API
• AppWarp - AppWarp.
• AppWarp S2
• App42 PaaS
• BPaaS & GPaaS -  AppWarp S2

Please note this is an early bird enquiry as I'm just trying to flesh out some information at the moment.

Many Thanks

Answer 1

Hi,

There are many benefits in NoSql over SQL. SQL database needs to know what you are storing in advance, however NoSQL databases are built to allow the insertion of data without a predefined schema. That makes it easy to make significant application changes in real-time, which means development is faster, code integration is more reliable. NoSQL Documents can contain many different key-value pairs, or key-array pairs, or even nested documents, every single item in the database is stored as an attribute name (or "key"), together with its value.

App42 Cloud accepts/sends data in jSON format.

For storing data on cloud you should use App42 Cloud API. If your app need real-time data transfer then you can use AppWarp or AppWarpS2.

Let me know if you have any other queries.

Thanks.