*

Recent Posts

Welcome, Guest. Please login or register.
November 22, 2024, 08:07:01 AM

Login with username, password and session length

Members
  • Total Members: 61
  • Latest: AciDeX
Stats
  • Total Posts: 28505
  • Total Topics: 1915
  • Online Today: 128
  • Online Ever: 569
  • (August 02, 2024, 06:20:39 AM)
Users Online
Users: 0
Guests: 76
Total: 76

Permissions

Author Topic: Oracle vs MySQL  (Read 3965 times)

0 Members and 1 Guest are viewing this topic.

Offline JollyRoger

  • That's Captain
  • Hero Member
  • *****
  • Posts: 3965
  • Karma: 5
  • I be plundering the interweb for booty.
    • View Profile
Oracle vs MySQL
« on: November 10, 2004, 09:00:49 AM »
My first question is does anybody know how much it costs to get a license for Oracle? I know it is free to use while developing but you need to buy a license to actualy deploy it for commercial use.
I need to find out how much it cost for the commerical license. Anybody?

[Edited on 11-10-2004 by [303]JollyRoger]
No matter how hard you try to push the envelope, remember it's only stationary.

Offline opiesilver

  • Administrator
  • Hero Member
  • *****
  • Posts: 3614
  • Karma: 5
  • Well, Santa is 2000 years old....
    • View Profile
Oracle vs MySQL
« Reply #1 on: November 10, 2004, 12:07:58 PM »
Just call an Oracle reseller to get a quote for a small single processor box.  It'll be expensive though.

I just use mysql for everything.
Mediocre people are always at their best.

Offline ZWarrior

  • Administrator
  • Hero Member
  • *****
  • Posts: 7798
  • Karma: 8
  • Shhh! Be wery wery qwiet...
    • View Profile
    • Ambush!
Oracle vs MySQL
« Reply #2 on: November 10, 2004, 10:23:03 PM »
Not cheap.

However, there happens to be an Oracle vendor on the forums, sometimes.

Just send a U2U to Vector and see if he will answer.  He is out of town a lot though.  If you don't get an answer let me know and I will contact him.
--------------------------------
Zoë: Shepard, isn't the Bible kind of specific about killing?
Book: Very specific. It is, however, somewhat fuzzy around the area of kneecaps.

Offline JollyRoger

  • That's Captain
  • Hero Member
  • *****
  • Posts: 3965
  • Karma: 5
  • I be plundering the interweb for booty.
    • View Profile
Oracle vs MySQL
« Reply #3 on: November 11, 2004, 11:13:25 AM »
I might just do that.  but which is more secure?
most say Orical I am not sure myself.
No matter how hard you try to push the envelope, remember it's only stationary.

Offline Morpheus

  • Hero Member
  • *****
  • Posts: 1186
  • Karma: 0
  • I shoulda taken the green pill!
    • View Profile
Oracle vs MySQL
« Reply #4 on: November 11, 2004, 12:06:19 PM »
To a good hacker nothing is secure.  It all depends on your deployment too.
Luck is better than skill anyday! The more skill I get, the luckier I get!

Offline JollyRoger

  • That's Captain
  • Hero Member
  • *****
  • Posts: 3965
  • Karma: 5
  • I be plundering the interweb for booty.
    • View Profile
Oracle vs MySQL
« Reply #5 on: November 11, 2004, 12:11:14 PM »
Well I know that. it will be a shared data base between a Inventory Tracking/Account Mangaging Aplication and a website,  doesn't need to be ulta secure.
No matter how hard you try to push the envelope, remember it's only stationary.

Offline Morpheus

  • Hero Member
  • *****
  • Posts: 1186
  • Karma: 0
  • I shoulda taken the green pill!
    • View Profile
Oracle vs MySQL
« Reply #6 on: November 11, 2004, 03:32:47 PM »
Then MySQL will do just fine, and will be much easier to develop, and manage.
Luck is better than skill anyday! The more skill I get, the luckier I get!

Offline JollyRoger

  • That's Captain
  • Hero Member
  • *****
  • Posts: 3965
  • Karma: 5
  • I be plundering the interweb for booty.
    • View Profile
Oracle vs MySQL
« Reply #7 on: November 11, 2004, 06:01:34 PM »
Thats our thought too, Ijust was leaving all options open to thought.  My partner and I both know MySQL, but we were just thinking that Orical might be a better option for security reasons though I know that MySQL can be made pretty darn secure. Like I said All options Open. Right?
No matter how hard you try to push the envelope, remember it's only stationary.

Offline opiesilver

  • Administrator
  • Hero Member
  • *****
  • Posts: 3614
  • Karma: 5
  • Well, Santa is 2000 years old....
    • View Profile
Oracle vs MySQL
« Reply #8 on: November 11, 2004, 06:58:17 PM »
If you have you website set up right no one will ever be able to touch your database.
Mediocre people are always at their best.

Offline JollyRoger

  • That's Captain
  • Hero Member
  • *****
  • Posts: 3965
  • Karma: 5
  • I be plundering the interweb for booty.
    • View Profile
Oracle vs MySQL
« Reply #9 on: November 11, 2004, 08:02:29 PM »
Yeah I know. I just could see me make a dumb mistake then  over looking it and then later getting caught with my pants down somewhere around my ankles.:*

Not say that I couldn't set it up right the first time. I just know how I can be, sometimes.

[Edited on 11-12-2004 by [303]JollyRoger]
No matter how hard you try to push the envelope, remember it's only stationary.

Offline ZWarrior

  • Administrator
  • Hero Member
  • *****
  • Posts: 7798
  • Karma: 8
  • Shhh! Be wery wery qwiet...
    • View Profile
    • Ambush!
Oracle vs MySQL
« Reply #10 on: November 12, 2004, 12:08:29 AM »
I would suggest seperating the 2 databases however.  eggs in a basket and all that.

Make it more work for them to get to your inventory when they are working against the website backend.
--------------------------------
Zoë: Shepard, isn't the Bible kind of specific about killing?
Book: Very specific. It is, however, somewhat fuzzy around the area of kneecaps.

Offline JollyRoger

  • That's Captain
  • Hero Member
  • *****
  • Posts: 3965
  • Karma: 5
  • I be plundering the interweb for booty.
    • View Profile
Oracle vs MySQL
« Reply #11 on: November 12, 2004, 12:26:46 AM »
But the database for the catalog on the website database needs to reflect the store database perfectly so that inventory matches.
We want to make it so that when an order is made online it is removed from inventory at that time.
No matter how hard you try to push the envelope, remember it's only stationary.

Offline ZWarrior

  • Administrator
  • Hero Member
  • *****
  • Posts: 7798
  • Karma: 8
  • Shhh! Be wery wery qwiet...
    • View Profile
    • Ambush!
Oracle vs MySQL
« Reply #12 on: November 12, 2004, 10:22:39 AM »
Looks like you are stuck with a BIIIGG database then.
--------------------------------
Zoë: Shepard, isn't the Bible kind of specific about killing?
Book: Very specific. It is, however, somewhat fuzzy around the area of kneecaps.

Offline JollyRoger

  • That's Captain
  • Hero Member
  • *****
  • Posts: 3965
  • Karma: 5
  • I be plundering the interweb for booty.
    • View Profile
Oracle vs MySQL
« Reply #13 on: November 12, 2004, 11:07:18 AM »
Yeah You could say something like that.:)
No matter how hard you try to push the envelope, remember it's only stationary.

Offline opiesilver

  • Administrator
  • Hero Member
  • *****
  • Posts: 3614
  • Karma: 5
  • Well, Santa is 2000 years old....
    • View Profile
Oracle vs MySQL
« Reply #14 on: November 12, 2004, 12:47:33 PM »
You are making this waaaaaay to difficult on yourself.  There are a lot of solutions that will do both from one piece of software.  You just have to set up and follow, ZW, a good backup schedule.  Also make a good disaster recovery plan and practice it a few times to make sure all the unexpecteds don't happen.
Mediocre people are always at their best.

Offline ZWarrior

  • Administrator
  • Hero Member
  • *****
  • Posts: 7798
  • Karma: 8
  • Shhh! Be wery wery qwiet...
    • View Profile
    • Ambush!
Oracle vs MySQL
« Reply #15 on: November 12, 2004, 02:40:01 PM »
I HAD a good backup plan.  But the dang drive died and that put a nail in it HARD!!

:cry:
--------------------------------
Zoë: Shepard, isn't the Bible kind of specific about killing?
Book: Very specific. It is, however, somewhat fuzzy around the area of kneecaps.

Offline JollyRoger

  • That's Captain
  • Hero Member
  • *****
  • Posts: 3965
  • Karma: 5
  • I be plundering the interweb for booty.
    • View Profile
Oracle vs MySQL
« Reply #16 on: November 12, 2004, 03:41:57 PM »
I know there is alot of software out there that will do all of this for us, and I know that we might be looking at this from some wrong angles, but the point is that we are doing this for the credit. My partner whom you all know, is a programmer and he is doing his part for experience and credit. I am focusing on the network end and Website.

We want to get the developement experience.
No matter how hard you try to push the envelope, remember it's only stationary.