Solved

Database Driven Site Development

Posted on 2012-04-06
6
311 Views
Last Modified: 2012-04-09
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.
0
Comment
Question by:tsprks
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 37817064
---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
 

Author Comment

by:tsprks
ID: 37817184
Is it difficult/more expensive to find a host for APS.net and SQL Server?  That was my main worry there.
0
 
LVL 8

Accepted Solution

by:
ee_reach earned 500 total points
ID: 37818100
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Closing Comment

by:tsprks
ID: 37822998
Would you mind telling me if you use a specific IDE for php/mysql development?
0
 

Author Comment

by:tsprks
ID: 37823004
Also, can you recommend a good host?
0
 
LVL 8

Expert Comment

by:ee_reach
ID: 37824011
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question