|Question for my super geeky HN Friends:|
I'm building an app. At a very high level, it will be an Android app that pulls and sends some JSON for a picture-rating system. I expect this to scale quite a bit and may become very popular. Given that option I am thinking I want the best technology for the job, even if it's something I don't know and will have to learn. Here are the options I'm considering:
Most likely MySQL or MS-SQL.
My question is, what do you guys suggest? I know that NO-SQL stuff is all the craze right now, but I don't feel really comfortable with keeping a lot of data in one of these stores without knowing a lot about them. I have extensive experience with MySQL and MS-SQL and trust both of them can do the job great.
The interface on the other hand is much more open. It's just going to be pushing text (images will be hosted on S3) so anything that serves text quickly will work. Heavily leaning towards Node.JS for this, but I'm not set yet.
Any advice or input would be great. I expect at least a couple thousand users right from the start, so it will need to be pretty fast. If it takes off it will need to scale up, which is why I may do a Node/MySQL arrangement on Linode so I can just scale up the servers as needed.
Another note: this isn't going to make much money, if any. So a pure .NET/MS-SQL solution may not be the best choice if I have to keep buying expensive servers for a project not likely to ever gain revenue.
Anyway any thoughts you guys might have would be great!