View Full Version : Which database method would be best? All opinions welcome!

02-07-2006, 11:08 PM
Hey all, I hope it's ok to post this question here...if not, please move to the appropriate forum.

I'm beginning a new site for a client and they are not very computer savvy, none the less web savvy. As a quick summary: The site is informational and needs to tie into a database so that what is in the database is posted on the web. There are a dozen or so fields for each record and the idea is that the information gets requested by the web pages. So, it's dynamic, but the user is not selecting what information is displayed, that part is programmed into the page. They want to be able to update their site on their own once it has been created. It has to be very basic thus, no FTP, no web creation software, etc.

I am learning PHP so that I can hopefully build the html pages and then place in the php where needed for the dynamic part.
My question is this: In the long run, which of these two would be easier to use for the database: MS Access or MySQL? I know a bit of Access, and not very much about MySQL. Whichever it is, I was hoping that I could create "admin" html pages where the owners can update the data in the database to update the website. I think this would be the easiest way since they are very non-technical people.

I first thought it would be easier to create the DB in Access and then just use Access Data Pages for them to update the DB, but after playing around with it, I'm no longer sure that's easiest. However, I haven't really used Access Data Pages very much, so I shouldn't judge quite yet.

Any recommendations as well as examples of or links to this type of scenario would be greatly appreciated! I'm sure I'm in for a bigger project than I imagined, but hopefully it won't be too difficult.


02-07-2006, 11:13 PM
I'd recommend MySQL as it's definetly faster than access. THe SQL syntax should be the same for both. The functions might be different though. MySQL has an online manual so it shouldn't be a problem.

02-08-2006, 01:46 AM
MSAccess is useless after a few concurrent connections, it is not suitable for a multi-user environment such as the internet (though fine for small intranets etc)

+ As it happens , if you use PHP there are sqillions of PHP/MySQL examples/tutorials/forums out there to help you along.

02-08-2006, 03:50 PM
PHP & mySQL go together like Curry & Lager :D

There are far more functions availble to you in PHP and mySQL is more of a standard database than Access. Access has it's own little idiosyncracies, probably because it is propriety.

Also, there are far more scripts avialble to use with mySQL and to manage mySQL, such as phpMyAdmin etc.

02-08-2006, 04:14 PM
Mmm...I had a feeling that was going to be the consensus. I didn't find tons of documentation on Access and PHP, but clearly I found a lot to sort through with regard to MySQL and PHP. Thank you marek_mar, firepages, and degsy for your replies! Others are still welcome.

02-08-2006, 05:22 PM
i just love that firepages said the word "sqillions"

02-09-2006, 02:45 AM
i just love that firepages said the word "sqillions"
DOH, I misspelt it as well ... I meant of course squillions ;)

02-09-2006, 10:47 AM
I wonder how much a squillion is... can't be too big though...