EasyCFM.COM ColdFusion Forums / Other / Before I go too far...

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Before I go too far...

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

Eiolon
01-21-2006 @ 3:28 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 13
Joined: Jan 2006

This isn't an issue, I am just looking more for advice.

All the practice applications I have created so far have used MS Access for its database.  Is it wise for me to start learning MSSQL or MySQL and use that instead?  I know Access can be powerful but I am curious if it will be too limiting to what other databases could possibly offer?  Is there a large security concern with using Access?

Thanks for your advice!

JJfutbol
01-21-2006 @ 3:36 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 1250
Joined: Nov 2004

Very good questions. Lets just say this. In a important and large environment you do not want to be using Access. Good database for very small apps that won't ever get large and also for local testing or for yourself. But if you got a big app in the works, especially stuff for clients that can get very very complex, no questions asked, you got to ditch Access. Next week I will start working with MySQL so I'm excited about that. It runs very very fast. For the past few months I've been working in SQL Server and have really enjoyed it. Moving to SQL Server will offer you so much more and yet be very similar in feel to Access so you will most likely be better off with that. I picked up SQL Server just fine on my own as doing easy stuff in it like Access is very easy. I'm sure it will be the same for you.

----------------------------------------------------
Need FREE CF applications?? Then my site has it all, http://www.javier-julio.com/development/coldfusion/downloads/ In time I will be including many more free CF apps and ASP ones as well. Currently working on a fully accessible Forum, which validates as full CSS and XHTML 1.0 Strict. It will be open source and available to all.

Eiolon
01-21-2006 @ 4:34 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 13
Joined: Jan 2006

Thanks for the info.  I just installed MySQL 5.0 with the Query Browser.  There are so many more options at first glance but a bit more confusing to use than Access.

I will try SQL Server and see how that looks.

mquack
01-22-2006 @ 12:10 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 1544
Joined: Jan 2005

Props to JJ Smile

DEFINITELY ditch Access if you plan on being a serious developer.  The sooner, the better!

Personally, I'm a SQL Server guy.  The ONLY thing that I like better about MySQL is its limit() and offset() functions.  (There are ways to do the same thing in SQL Server, they're just more involved.)

But, so long as you decide on SQL Server or MySQL, you'll be MUCH better off than if you stick with Access.  Smile

http://www.rachelqueensg.com

This message was edited by mquack on 1-22-06 @ 12:10 AM

JJfutbol
01-22-2006 @ 12:20 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 1250
Joined: Nov 2004

Apprecaite it the backup! Wink  You should notice that MySQL runs very quickly at least when you are doing queries in cfm pages. If you dabble in SQL Server I think you will like it a lot more Eiolon. I picked it up right away. If you install it, make sure you install Books Online. SQL Server by default doesn't put that there but you should!! Its the equivalent of the CF Docs that is installed with Dreamweaver except its for SQL Server. I have found it very useful. Let us know how you do.

----------------------------------------------------
Need FREE CF applications?? Then my site has it all, http://www.javier-julio.com/development/coldfusion/downloads/ In time I will be including many more free CF apps and ASP ones as well. Currently working on a fully accessible Forum, which validates as full CSS and XHTML 1.0 Strict. It will be open source and available to all.


Website Designed and Developed by Pablo Varando.