Database Driven Site Development

I'm just starting to plan a database driven website and I'm looking for some advise on language and database selections.  First let me say that I have experience with ASP.net and SQL Server, but I'm open to anything.  My 'requirements' are 'cheap', easy to find a good host, and somewhat robust.  If the answer is to stick with ASP.net then I have that product so the cost doens't matter, but if there is a better solution it would be helpful if it didn't cost a lot.  

Thanks.
tsprksAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Wasim Akram ShaikCommented:
---My 'requirements' are 'cheap', easy to find a good host, and somewhat robust.

as you are already aware of the pros and cons of the SQL Server, stick to it..!!


else go with oracle and java, it will cost you the same with a little bit of difference but will satisfy your requirements
0
tsprksAuthor Commented:
Is it difficult/more expensive to find a host for APS.net and SQL Server?  That was my main worry there.
0
ee_reachCommented:
In my experience, you always end up paying more for SQL server.  Personally, i always use mysql. you can't beat 'free'.

Also, i personally find asp.net restrictive compared to the flexibility of php.  Mind you, i have plenty of clients who use one or the other, so i end up using both.  But imho, php is much more flexible.  And again, you can't beat 'free'.

Also i heard a rumor that ms will be discontinuing support for the forms-based asp.net and will support only the mvc format in the future.  Not sure how accurate that was or when it would happen, but it made me think about how i don't like being subjected to the whims of ms. Especially considering there are legions out there who are and will always support and enhance php and will provide fixes to the language for free.  (Not to mention, if you find a bug, you can fix it yourself, rather than waiting on ms to decide to fix it or not.)

All the above are reasons I have switched my preference coding in php.  All my new sites are being done in php whenever the choice is up to me.  And there is so much support for mysql in php that the combination is really superb for getting stuff done fast.

Hope this helps.

ee_reach
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

tsprksAuthor Commented:
Would you mind telling me if you use a specific IDE for php/mysql development?
0
tsprksAuthor Commented:
Also, can you recommend a good host?
0
ee_reachCommented:
Re hosting, all my clients either have their own machines on which their sites are hosted already, or they have their site on one of my servers.  Also, I have become a reseller for a well-known ISP, which allows me to provide competitive prices to my clients for the few things I don't provide directly on one of my own servers.  (For more info, see my profile.)  

The upshot being that I haven't surveyed hosting for a couple of years now, so I am probably not the best one to make hosting recommendations.  :-)

Re IDE's, I use a combination of tools rather than a single IDE.
However, here are several IDE surveys:

IBM - an older php survey, but the points he makes about what to look for are important and they haven't changed.
http://www.ibm.com/developerworks/opensource/library/os-php-ide/

SmashingMagazine- The comments on the article are quite useful and suggest many more products than those that are reviewed in the article.
http://coding.smashingmagazine.com/2009/02/11/the-big-php-ides-test-why-use-oneand-which-to-choose/

Wikipedia - http://en.wikipedia.org/wiki/List_of_PHP_editors - this is a useful list that includes editors and IDEs.

Hope this helps!

ee_reach
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.