General discussion

Locked

developing database driven website

By mkreuser ·
Hello --

HTML developer here delving into the database driven website realm and need some help.

Trying to come up with the best combination of technologies to go forward with. SQL Server is probably too expensive now, but getting ColdFusion might be an option if the justification was there.

Here are the options I am exploring, but would welcome other suggestions:

1. ColdFusion/MySQL
2. ColdFusion/Access
3. ASP/MySQL
4. ASP/Access

Any help in coming up with a determinationof which route to go would be appreciated. I have limited ASP programming knowledge, but none using it to access databases. Are the main advantages (response time withstanding) to going with CF that you have more inherent functionality and a quicker learning curve?

Thanks,
Michael

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

developing database driven website

by AlterEgo2 In reply to developing database drive ...

To some degree it's down to personal preference although using Access can be a little 'iffy' if your expecting a large number of users to connect to your DB.

ASP is very, very simple when you get the hang of it and there's a rake of excellent sites out there to help you along.
In addition this will help transition to .net technology in the future if you chose to do so.

The learning curve is largely dependent on the amount of functionality that you wish to leverage from your chosen technology.

As a starter Access would be good to cut your teeth on. Once you get the idea it may be worth taking a look at the benefits of SQL and possibly a COM layer.

Collapse -

developing database driven website

by mkreuser In reply to developing database drive ...

Poster rated this answer

Collapse -

developing database driven website

by Jay Eckles In reply to developing database drive ...

I would go with ASP/mySQL out of the choices you've listed. I don't like Cold Fusion, and I think it's on its way out. If you already know some ASP, then database connectivity is a snap! Go to 4guysfromrolla.com and search for ADO or ODBC or database access to get loads of articles on how to do it - it's really just one line to connect, one line to query, and then possibly a loop to go through the record set generated by the query. Very simple stuff.

There is no more inherent functionality in Cold Fusion than in ASP. I would in fact say there is less, but that's my opinion. If you already know some ASP, then the learning curve for CF is steeper for you. If you didn't know either technology, it would probably be a 50-50 proposition. And, of course, if you already have Windows and are running IIS, PWS, vWebserver, or Apache (with Chilisoft ASP), then you don't have to buy anything addition to run ASP.

I say mySQL because Access isn't a real RDBMS, and if you are willing toinstall mySQL, it's a great little database.

Of course, if you're just looking at database driven websites in general, I would suggest you look at JSP and Java servlets. JSP is nice because it has a syntax VERY much like ASP, and connecting toa database via JDBC is at least as easy. The only downside to JSP and Java servlets is 1. you have to learn to program in Java and 2. setup can be a bit of a challenge if you're using a free application server like Tomcat.

Good luck,

Jay Eckles
www.jayeckles.com

Collapse -

developing database driven website

by mkreuser In reply to developing database drive ...

Poster rated this answer

Collapse -

developing database driven website

by andrew In reply to developing database drive ...

I would go with ASP/Access.

The first poster was right on about ASP, so I needn't say more.

If you're considering a move to SQL Server, then Access can make this seamless for you. You can code your queries in the exact same syntax that SQL Server will use, and continue to use ADO to connect. Access has a massive installed base and many programmer's resources (TechRepublic is a good one). I believe Access even has an 'upsizing' utility to help you migrate the database to SQL Server.

Collapse -

developing database driven website

by mkreuser In reply to developing database drive ...

Poster rated this answer

Collapse -

developing database driven website

by thescout In reply to developing database drive ...

I think that the best option is PHP/MySQL, but PHP isn't so good in managing session as ASP. So, if you want it, choose ASP/MS-SQL

Collapse -

developing database driven website

by mkreuser In reply to developing database drive ...

Poster rated this answer

Collapse -

developing database driven website

by mkreuser In reply to developing database drive ...

This question was closed by the author

Back to Web Development Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums