oracle mysql

[Kyle D. Harris]

What is the latest version of oracle? Does oracle have to be installed to run mysql or are they totally irrelavent. If anybody can link me to a site that i can install oracle at that'd be great. I'm getting broken links. Thanks

Kyle

[Gerrit Kistemaker]

Kyle,

Latest version seems to be 10g.
As far as I know mysql is completely seperate from Oracle (but I never used mysql).

You could try starting from here:

http://otn.oracle.com/software/products/database/oracle10g/index.html

and follow the links, but maybe that also gives broken links,

Gerrit

[Mark Grant]

Kyle

Oracle is an enterprise level very expensive database application.

MySql is a not quite so enterprise level, dead cheap (i.e. free) database application.

They both basically do the same thing so you don't need to have them both.

I don't think you are going to be able to download a free Oracle but mysql youprobably already have.

[Steven E. Protter]

Latest Version of Oracle is 10g or 9.0.4

High end Enterprise class db with lots of good tools.

The unlimited user license costs $40,000.

Per CPU.

Support is expensive and of spotty quality.

Mysql is the up and coming competitor which may evolve as a competitor. The license fee is zippo, nada. Support for legacy/production applications will have to be purchased third party.

SEP

[Claudio Cilloni]

I'm an Oracle DBA and I'm starting to use MySQL. They are two different products, you can install MySQL without having Oracle. Some linux distributions, like RedHat, comes with MySQL in their CDs. For the latest version see http://www.mysql.com .

I don't know if you can download Oracle CDs for free... give a look at http://www.oracle.com . Latest version of Oracle, published in these days, is 10. I suggest to look for Oracle 9.2.

Ciao
Claudio

[Kyle D. Harris]

I probly already have? Does it come with RH 9.0?

[Mark Grant]

I'll eat my chair if it doesn't

[Kyle D. Harris]

lol well i won't be purchasing that then for 40 G's! Especially for work. What is the purpose of my_sql ? And is it easy to get going?

[Mark Grant · Accepted solution]

MySql basically just stores data efficiently and makes it easy to get that data out again. It needs some sort of front end appliaction to write stuff into it and get stuff out of it again. You can do it yourself but it's kind of ugly. You design "tables" to store your data that describe it. For example, it might descibe "name,age,next birthday, address", for a simple address book database. You then populate this with some kind of front end or using SQL commands. You can make quieries of that data such as "give me all people that will have a birthday today" or "select everybody who fell for my 'pretend my friends owe me money' scam"

It's quite a big subject but is quite fun and not too difficult to get into. I'm sure you'll be a senior database administrator within a day or two.

[Kyle D. Harris]

I see... I like the comedy there at the end of your post Mark.

[Kyle D. Harris]

http://otn.oracle.com/software/products/database/oracle10g/index.html

This link you can download oracle 10g .. Doesnt' look like it costs anything, none the less 40 g's.. ????

[Jean-Luc Oudart]

Hi

mySQL licensing : follow the link

http://www.mysql.com/products/licensing.html

Regards,
Jean-Luc

[Mark Grant]

Kyle,

You can download it like you can a lot of software but you are still supposed to pay for it. Oracle are a very very very large company and you don't want to be running unlicensed software from them. Particularly in the environment you work in.

[Claudio Cilloni]

RH9 gives you mysql-server-3.23.54a.
I'm using mysql 4.0.12, and I'm sure this isn't the latest stable version. But I don't remember where I downloaded it...

Ciao
Claudio

[Kyle D. Harris]

Why is that Mark? Why is that bad?

[Mark Grant]

Kyle, it's very illegal and, I understand you kind of work for the government.

[Kyle D. Harris]

I'm a gambling man. :)

[Paul Cross_1]

Let's clarify a bit here. Oracle is a fully implemented, commercial (you have to pay for it, and it aint cheap) RDBMS that is fully supported by Oracle and intended for large amounts of data storage and retrieval. It is heavily used by banks and other large corporations for (among other things) financial applications (SAP, oracle financials, etc). Mysql is a mini-me sql database (not trying to start a flame war here). Mysql doesn't have a tenth of the features that Oracle does and is accordingly lightweight (doesn't require a superdome to run it). Despite what mysql's homepage says about NASA and Yahoo using mysql I can almost guarantee that they aren't using it for mission critical applications. Mysql has it's place in the industry, but one should definitely not confuse mysql and oracle, two very different beasts.

[Bruce Copeland]

FWIW, there is a raging controversy over mysql in the IT world because of changes in licensing introduced with version 4.0. Basically they've switched the license from LGPL to GPL. I'm not sure whether Kyle's outfit would be considered 'commercial' , but if the goal is to have a free DBMS, it might be worthwhile to check out postgresql.

Bruce

[Jeffrey Pogodzinski]

Postgresql is a great open source database and is getting better all the time. Postgresql is closer to Oracle in capabilities than MySql. You can download it from wwww.postgresql.org

[Martin P.J. Zinser]

Hello,

without raining into the parade of the Oracle guys here (out big production database is Oracle Rdb), yes it does has tons of features that MySQL does not have, but do you really need them? To decide which of the two is the right solution for you you need to detemine your requirements and then check what each database has to offfer. As mentioned before our big production databases run on Oracle Rdb while the little CMS I build in my sparetime runs happily on MySQL.
As for Oracle, I would currently stick with 9.x, 10g is just to new yet.

Greetings, Martin

[Mr. Burns]

look at http://otn.oracle.com/software/index.html you can download evry oracle pruduct for developing and prototyping your applications