Jump to content


Photo

mysql


  • Please log in to reply
3 replies to this topic

#1 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 28 April 2006 - 07:45 PM

I know about phpadmin, is msaccess mysql too, if I create a database and use it and connect to it using msaccess, I am unsure of this, I know phpadmin is my sql, and it's written in php, but I am still figuring out, a lot of people tell me not to us msaccess, what are the reasons, it's the only reason is because I already have it on my computer from office 2003, I thought i was convenient. I have had other web developers telling me they have multi hundred thousand databases on there server done in ms access, what is so bad about it, and why does everyone here and other places tell me to stay away from it.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.


#2 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 28 April 2006 - 10:05 PM

One set of opinions - [a href=\"http://www.daniweb.com/techtalkforums/thread5712.html\" target=\"_blank\"]http://www.daniweb.com/techtalkforums/thread5712.html[/a]
Legend has it that reading the manual never killed anyone.
My site

#3 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 29 April 2006 - 08:31 PM

There are a number of reasons:

-any type of client can access a MySQL database, and it is easy to have it accessible over the web, and all are free

-MySQL is designed to handle many simultaneous users/clients.

-MySQL can eaily support large databases

-MySQL has proper login credentials to a DB, whereas Access is just as bad as the rest of the MS Office suite.

-Unlike Access, data storage is centralized for all users, so backups are easy. This also means that disk storage requirements are isolated to the server itself.

-MySQL is free, and will always stay this way, in some form or another.

-MySQL doesn't limit your choice of OS.


Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#4 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 29 April 2006 - 08:53 PM

PERFECT, more than what I was hoping for thanks for the answer.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users