I'm a tech guy but I don't know much about mobile and web technologies. There are so many technologies and more coming out every day - Mongo, Cassandra, SQL, NoSQL. How do I decide on my technology stack? I'd like help to build my architecture. Thanks!
You need to be able to get feedback on your product as quickly as possible, so my advice is to choose the technology stack that will allow you to build a prototype efficiently. There's no right answer here: for some people it's LAMP, for others it's node, for others it's a Windows stack.
Worrying about the technology at the stage you're at is a red herring: worry about the product, the problem it solves and the user experience of your solution, and get feedback you can iterate on as quickly as possible.
I'm a serial startup CTO who's now a startup founder and CEO. Let me know if I can help.
Your choice of technology stack will highly depend on your objectives and projects. There is no one correct answer to this. It would be really great if you can share with us what kind of applications or projects you are working on in order to give you a proper advice. Thanks!
Tech stack always comes down to a combination of two thing: requirements for what you are trying to build and background/preferences for your team. There is no one generic set of answers you will get here because so much of your decision comes down to the specifics of these two factors. I strongly suggest you solicit feedback from friends and advisors that can learn more about your situation.
Like others have said, it truly depends on what your project's goals are.
That said, there's going to likely be many viable options when it comes to the tech and after you've narrowed it down you'll have other factors to consider.
For example; how many developers are out there that use said technology? are they cheaper to hire compared to developers who might use a different technology?
How can one technology (be it a database or hosting provider) lower your overhead? Or how and when does it increase? How does that impact your margins?
Obviously there's a LOT to consider. Just know that the considerations go much farther than just, "what's the best language" or "what's the best database" ... Performance and popularity are not the only things to consider.
I did want to put together a site that would help people decide based on project requirements and explain trade offs. It's going to take a bit of time (so many options), but this is what I help people with all the time on Clarity.
What technologies do you know? or are you outsourcing the development?
If you are worried about software costs for Microsoft there is a Startup Bizspark program where software is free.
Using Opensource is also great, there are so many options. Don't think you could go wrong with LAMP and server hosting end up being cost effective as well.
PHP and MySQL are powerful.