Incorporating database
Hello all,
I need to incorporate a database into my site. Is MySQL the easiest / best to use?. I know SQL, but have never used a MySQL DB. I am very farmiliar with Access, but from what I hear, it is not the way to go. Is MySQL easy? - like a point and ckick to set it up?.
I hope I don't have to go through hell to incorporate it. I work as a VB delveloper.... so I know the basics of client side programming -do you think I'll be able to set one up with ease?.
Also, do you know of any good sites for tutorials?.
Thanks a million!!!!!
- Beekay -
www.links411.com
Busy posted this at 02:30 — 25th April 2003.
He has: 6,151 posts
Joined: May 2001
you should be ok with MySQL, pretty easy if you know programming basics
MySQL comes with phpmyadmin which is like an editor to set up all your tables etc, then just add the code to pull out the info.
sorry no complete tutorials to give you, do a search on here for mysql, phpmyadmin or even php and you should come up with some links
SqlGuru posted this at 20:14 — 1st May 2003.
They have: 11 posts
Joined: May 2003
You will probably go through hell with Mysql. Here's why
a) You or someone on your team need to be adept at mysql setup, configuration, maintenance, security
b) Mysql does not come with a GUI front end to manage databases, tables, users, etc, although there is myPhpadmin which does the job, but requires a linux(?) server running php
c) If you are doing development on windows, there is mysql for windows.
Best bet: find a hosting provider that already has this for you and pay the extra $$$ for the database access.
Mark Hensler posted this at 11:06 — 2nd May 2003.
He has: 4,048 posts
Joined: Aug 2000
By SQL, I'm assuming you mean Microsoft SQL Server? Rather than transact-SQL. There is a learning curve. I'd imagine that it's not quite so hard with your basic queries, but may take some time to learn the user management.
I use a windows GUI for my linux box (on a lan). It's called MySQL Front. The software is no longer being developed, but you can still find it on google. (download | official site) This app has the best GUI I've found for mysql, but it's nothing like Enterprise Manager.
Mark Hensler
If there is no answer on Google, then there is no question.
shanda posted this at 01:39 — 14th May 2003.
They have: 105 posts
Joined: Jan 2002
I can't help with the setup, but a tutorial by Kevin Yank (actually the first four chapters out of his book) has pulled a whole bunch of folks out of the dark on MySQL in my office. It can be found at :
http://www.sitepoint.com/article/228
CPRhosting.com - CPR Hosting...Giving life to the web
Custom-made Hosting Plans starting at $2
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.