GeekPoint Forum Subscribe to Forum RSS WhoIsHostingThis.com
Please register or login on GeekPoint Forum.
It takes only a minute to register, & moreover,
majority of the ads shown will be removed!
Login OR Register
Register a Free Account
Reply
 
LinkBack Thread Tools
Old 02-11-2008   #1
watward07 watward07 is offline
Junior Geek
Join Date: Feb 2008 Posts: 139
Default What exactly are MySQL and those Databases for?

Just like yesterday, well, pretty much a few hours ago, I guessed that they were used for stuff like forums and registration-like stuff. Am I right? How do you use them???
  Reply With Quote
Old 02-11-2008   #2
Shadab Shadab is offline
Web Developer
Shadab's Avatar
Join Date: Feb 2007 Location: Bhopal Posts: 2,752 iTrader: 100% (1)
Default

Yep. Databases... as the name suggests, are used to save 'data' (organised information) in them.

Forums are an excellent working example of how you can utilize a database.

Basically we use 3 things :

1. HTML
2. PHP
3. MySQL

You see *this* HTML page. You type and create a post. Now when you "Submit" the post, the post's content goes to the web server. There PHP processes the data, and asks MySQL to store it in appropriate tables. (Read this post to know the basic terminology).

Simple. Now when another user browses the same page, PHP asks the MySQL to 'fetch' your post, and then display it using HTML.

My periodic table contains only 1 element : the element of Surprise.
  Reply With Quote
Old 02-11-2008   #3
watward07 watward07 is offline
Junior Geek
Join Date: Feb 2008 Posts: 139
Default

Oh, I get it. So people use these MySQL databases instead of making their own, in say, C or even something simple like VB.NET? It's a good thing I'm in web design and not programming, hahaha
  Reply With Quote
Old 02-11-2008   #4
Shadab Shadab is offline
Web Developer
Shadab's Avatar
Join Date: Feb 2007 Location: Bhopal Posts: 2,752 iTrader: 100% (1)
Default

Even with VB.NET you have to use a database to store your data. (if any).
With VisualBasic.NET, I use either Oracle, or MS Access to store / access data.

And if you have a good capable machine, 'MS SQL Server' can be deployed too,
for use in conjunction with VB.NET to store our data.

Note: I haven't tried using MS SQL server with VB.NET till now!

My periodic table contains only 1 element : the element of Surprise.
  Reply With Quote
Old 02-12-2008   #5
watward07 watward07 is offline
Junior Geek
Join Date: Feb 2008 Posts: 139
Default

Yeah, I knew about the VB and Access/Oracle thing. So people just use MySQL because it works with PHP, hmm? Interesting... well, here's another two things I'm going to have to teach myself.
  Reply With Quote
Old 02-22-2008   #6
online.education online.education is offline
Newbie
Join Date: Feb 2008 Posts: 44
Default

MySQL used to be just one of affordable database servers. But, now, Sun, one of IT giants acquired it, so in the coming months, it'll be promoted as an enterprise database. Good database to learn. Knowing how to manage this will become a very marketable skill.

online.education
  Reply With Quote
Old 10-10-2008   #7
alsa alsa is offline
Newbie
Join Date: Oct 2008 Posts: 4
Default

I'm confused, I thought that MySQL was open source and free? So if Sun bought MySQL it won't be free anymore, is that right?
  Reply With Quote
Old 10-11-2008   #8
Shadab Shadab is offline
Web Developer
Shadab's Avatar
Join Date: Feb 2007 Location: Bhopal Posts: 2,752 iTrader: 100% (1)
Default

Originally Posted by alsa View Post
I'm confused, I thought that MySQL was open source and free? So if Sun bought MySQL it won't be free anymore, is that right?
They already have a paid version : 'MySQL Enterprise'.
And the free version, which we use, 'MySQL Community Server' will remain free.

It won't change.

My periodic table contains only 1 element : the element of Surprise.
  Reply With Quote
Old 10-14-2008   #9
frih frih is offline
Junior Geek
frih's Avatar
Join Date: Oct 2008 Location: http://www.techbusy.org/ Posts: 148
Default

it is made to hold information regarding customers, site visitors,etc....at one place...

information present in database is in same format and can be easily retrieve....

it is meant to prevent scattering of data..
  Reply With Quote
Old 01-24-2009   #10
Victim Victim is offline
Newbie
Join Date: Jan 2009 Posts: 7
Default

Basically keeps track of information related to your site, like members, purchases, and that sort of thing.
  Reply With Quote
Reply
Thread Tools