Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

Which RDBMS to use for Database Storage

 
Ranch Hand
Posts: 674
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi there

I want a little information.

I am developing a application for commercial purpose for an organisation.

I want to know which version of MySQL is free and which is Premium.
and same for Oracle Database also.?


My Question is
MySQL has mainly 4 edition
MySQL Community Edition(Free)
MySQL Standard Edition(Premium)
MySQL Enterprise Edition(Premium)
MySQL Cluster Edition(Premium)

so if I am using MySQL community edition can I use it for commercial purpose?

and same I want to know for Oracle database Products which is free and Which is not?


Thanks
 
Marshal
Posts: 70305
283
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you looked at the conditions on those suppliers' websites?

Moving to our databases forum.
 
Rancher
Posts: 43016
76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I doubt that there are any Oracle versions that are free for deployment (as opposed to free for development).
 
Kishor Joshi
Ranch Hand
Posts: 674
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ok
@ulf:
What about Oracle Database 11g we can download it and dvelop and work on it?


Can you clear your answar more which version I should use?

(I am a Student)
 
Ulf Dittmer
Rancher
Posts: 43016
76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Go with Campbell's advice and read up on that on Oracle's web site. That will also have download links, documentation and everything else you need to get started.
 
Bartender
Posts: 2407
36
Scala Python Oracle Postgres Database Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oracle Express Edition (XE) is "an entry-level, small-footprint database based on the Oracle Database 11g Release 2 code base. It's free to develop, deploy, and distribute; fast to download; and simple to administer".

This is a great option if you want to explore Oracle technology or build a prototype for an application that will be deployed on one of Oracle's enterprise databases. You can also use it to deploy your own small applications. However, XE is quite limited in how much data it can store (11GB), how many databases you can create (one) and how many CPUs it can use (one).

So you could use XE initially, then scale up to one of Oracle's commercial licences later on e.g. if your company already has access to Oracle DBA skills to support this. Alternatively you might prefer to go for an open source database like MySQL or (my preference) PostgreSQL, but you'll still need to think about how you are going to support and manage your database for a commercial application.

 
Bartender
Posts: 10777
71
Hibernate Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Kishor Joshi wrote:and same I want to know for Oracle database Products which is free and Which is not?


TBH, most of the databases mentioned will probably do you just fine - and there's also JavaDB, which was written specifically to integrate easily with Java programs and jars - so I would spend your effort in making sure that your app can work with any of them, with minimal effort.

Unfortunately, that's not necessarily a given, as SQL itself differs from db to db; but there are middleware tools around, like Hibernate, which simplifies the process of "database to POJO conversion" and offers its own query language which is the same across the board.

However, if you don't want to go that route, I think I might try an Oracle-based db, simply because Oracle now owns Java, so it's products are likely to be highly integrated. And, as chris said, it offers a path for deployment with a free version which you can then upgrade as and when your product does become "commercial".

Winston
 
Hot dog! An advertiser loves us THIS much:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic