Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Which software to use?

Which software to use?

Which software to use?

Hi All
Bit of a straight, to the point question...

I am commecning build of a new website, that needs a backend DB to hold user/transaction info etc. Users i hope to be >1000.

I have lost track of current trends in development world, what is my best/preferred software to pick up knowledge on again? i.e. What database backend to use? What language for front end coding etc?

Many thanks for your time and replies.

RE: Which software to use?

what did you use before? are you going to do all the coding yourself, or hire it out?

where are you going to host the site? what software is available on that host?

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

RE: Which software to use?

what i used before was circa 15 years ago and the landscape then was much different to what it is today.

I will attempt as much of the design and coding as possible.

The hosting as not been selected, i wish to understand what is the de facto standard out there before making any financial committments?

RE: Which software to use?

you can't go wrong with php and mysql

well, that's not exactly true -- you can go wrong with every single combination of technologies out there

but these two products are extremely popular, to the point where they are usually available, free of charge, on most web hosts

and there's a much better chance that if you run into a snag you can't solve yourself, there will be competent support people easily available, online or right in your neighbourhood

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

RE: Which software to use?

Ok thanks- thats sort of what i had picked up thus far. mySQL i have downloaded and will familiarise myself with it. Thanks for your input, helps alot.

RE: Which software to use?

Classic ASP and Access is pretty much entry level (and what I function at) and were always the thing to have in a Microsoft world, but Access won't do 1000 users.

ASP.NET MVC and SQL Server would handle it but your learning curve will be pretty steep.

PHP and mySQL is a fine choice in my opinion.  If I had time and gumption, I would learn them and switch over.  Tons of cheap hosts for it.

I think running my own LAMP box would be fun, but it's more skill than I have at the moment.

RE: Which software to use?

One thing to consider is, what is to be stored in the database.  If there is personal information you may need to encrypt the database.

Since I have not worked with very many databases I cannot give a good suggestion.

The Lord is my shepherd (Psalm 23) - I need someone to lead me!

RE: Which software to use?

Don't forget there also is the Java world, and it's strong on Android smartphones, too. For the web that means Tomcat & Java Servlets for example.

For a judgment of the landscape, take a look at tiobe: http://www.tiobe.com/index.php/content/paperinfo/tpci/index.html

It's kind of weird to mix full programming languages with rather limited sql or even more specific academic languages like lisp, ada, logo. But the index is made with several indicators in mind and a good indicator.

Java is in the lead, it's even more cross plattform than PHP, was there before PHP and thus is very mature, also still in development and active. You can see PHP has made a drop, mainly because C# is getting the better Java on Windows plattforms at least. and ObjectiveC is string through the Apple app market.

So PHP+Mysql is a choice nevertheless, all that I said about Java is true for PHP+MySQL, too. The learning curve is not that steep as with Java and the hosting plans include these technologies. I also do PHP rather than Java, but I'd also take a look at other databases besides mysql.

PDO is a strong class to use in PHP for access of many databases, of which I'd mention PostgreSQL. I think alone of index options and query optimisation with them.

Much more details: http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL

It will be harder to find hosting for PostgreSQL, but not impossible. Depends on your location, Google is your friend of course.

Bye, Olaf.

RE: Which software to use?

Thinking out of the box a little, not knowing the purpose of the site, might could you use a prebuilt CMS like Joomla for your main infrastructure?  You mentioned transactions and Joomla has add-ons for about everything including e-commerce storefronts.

It's never too early to begin preparing for International Talk Like a Pirate Day
"The software I buy sucks,  The software I write sucks.  It's time to give up and have a beer..." - Me

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close