TL DR: I am making a web app called OshePraPra. It is a way for anyone to learn any dance steps e.g Shaku Shaku. The content will be community driven. Surprisingly, I have nothing doing today so I have to complete the first version of the web app in less than 5 hours.

Long Read:

Inspiration
--------------------
Yesterday my girl agreed to go on a Movie date with me, I was quite happy and decided to do the shaku-shaku dance on my bed. I kinda sucked at it and wondered if there was a place where I can see what a typical shaku-shaku dance looks like. I couldn't find any.

So I thought, why don't we have a crowdsourced system where people could upload their version of popular dance routines. I just wrote the idea down cuz I knew I wouldn't have any time for that.

Anyway, today, the girl cancelled our plans for some family ish. I had cleared my schedule for today so I suddenly had time.

Stack
--------------------

1. I'll stick to what I am most familiar with here, I'm not planning to learn anything new. So PHP/MySQL + React.
2. I am expecting more traffic from mobile so I am only focusing on that. Thus the need for a mobile web framework. Onsen UI is the best for now. Downside is, it doesn't play well with older browsers i.e Android 4.x and below
3. Hosting the backend on one of my servers. I'll host the frontend on Heroku

Data Model
-------------------

I'm optimising for speed of devlopment now. So this is the data structure

1. Video
--------- id
--------- link
--------- thumbnail
--------- owner_id

2. User
--------- id
--------- username
--------- platform [fb/ig/twitter]

3. Tag
--------- id
--------- name

4. Video_Tags
--------- id
--------- video_id
--------- tag_id

5. Upvotes
--------- id
--------- ip_address
--------- video_id

Nice, I don't know jack about programming, but I like the idea.

Nice how much did you use to buy your server and where?