20 {{ upvoteCount | shortNum }}
20 {{ upvoteCount | shortNum }}

Which DB to Use

by Whateva
16 replies
Hi,
I am getting a very large local DB built to do with Horse racing, but I am not sure which DB to use. I would like one that is open source or free, but a small price one is ok that i can sell with the program. The size of the DB could be up to 10-20 gigs, it needs to be very robust, but also very flexible.

Any suggestions welcome

thanks
Phil
  • Profile picture of the author Ensten
    Well, you can use MYSQL database. It’s free and open source also. Flexibility and storage capacity is depend on your host server.
    {{ DiscussionBoard.errors[4437888].message }}
  • Profile picture of the author odehfehr
    I think oracle is the best option to maintain database, because oracle is more secure than any other database, Oracle Server has multi-version consistency model. Oracle is capable to store large number of data.
    {{ DiscussionBoard.errors[4438737].message }}
    • Profile picture of the author LikeDaddy
      Phil,

      You may wish to carefully investigate the license agreement associated with MYSQL. Sun Microsystems may; if they choose to do so, begin to extract MYSQL usage fees at some time in the future. It seems that this is a little-known aspect of the terms, even though it is written in the license agreement. Presently, there is no precedent indicating that Sun Microsystems would invoke the license terms as written. However, developers of commercial applications would do well to consider the matter.

      Alternatively, there are other databases like PostgreSQL; for example, that specify license conditions like:

      "... Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement ..."
      {{ DiscussionBoard.errors[4438946].message }}
      • Profile picture of the author mojojuju
        Originally Posted by LikeDaddy View Post


        You may wish to carefully investigate the license agreement associated with MYSQL. Sun Microsystems may; if they choose to do so, begin to extract MYSQL usage fees at some time in the future.
        I know the likelihood of this happening is probably next to nothing, but it still makes me feel uneasy. I'm thinking about trying out MariaDB which is a community developed drop in GPL'd replacement for MySQL..
        Signature

        :)

        {{ DiscussionBoard.errors[4441659].message }}
        • Profile picture of the author mojojuju
          Originally Posted by LikeDaddy View Post

          As a new Warrior Forum member, LikeDaddy is seeking to earn thanks by helping with questions when practicable. If the database license reply was helpful to you, please extend a Warrior Forum thanks - LikeDaddy is new here.
          mojojuju thinks that warrior forum members are aware of the "thanks" button and they will use it as they see appropriate. mojojuju also believes that solicitation of thanks is unnecessary and maybe annoying.
          Signature

          :)

          {{ DiscussionBoard.errors[4442790].message }}
  • Profile picture of the author KirkMcD
    MySQL should be fine, but the problem is you can't distribute the code for it without a license. To get around that, your end-user would need to install it and the you would provide a way to import the data into their system.
    The next issue you will encounter is where to host the db. Is this a web-based system or is it for a desktop?
    A web host will balk at it's size unless you are on your own server or vps.
    {{ DiscussionBoard.errors[4438928].message }}
  • Profile picture of the author productsmith
    MySQL would do.

    The newer NoSQL like Mongo and Cassandra are good too.
    Signature
    cloudegg.com
    fbreveal.com
    {{ DiscussionBoard.errors[4451102].message }}
    • Profile picture of the author Whateva
      Thanks for your suggestion. The DB will be local on each individual pc and people will be importing data that they own into it. My worry is the initial setup on the DB on many PC's and the problems that could encounter. Also I do not want to breach any legaility in respect to selling a program that contains a DB

      All the info above is good and I appreciate your thoughts, keep it going

      Thanks
      Phil
      Signature
      Only $15 - 20 x PR3 - $1 Trail for 1 month - Click to Grab your Spot
      {{ DiscussionBoard.errors[4451726].message }}
  • Profile picture of the author Ken Durham
    what language are you writing the program in?

    Walkthrough: Adding a SQL Server Compact 3.5 Database to an Application and Deploying it
    Signature

    yes, I am....

    {{ DiscussionBoard.errors[4456410].message }}
  • Profile picture of the author avatar9812
    definitely mysql +1
    {{ DiscussionBoard.errors[4474119].message }}
  • Profile picture of the author scsheldon33
    Great information...thanks for posting guys
    {{ DiscussionBoard.errors[4483796].message }}
  • Profile picture of the author cordyceps75
    You can use MySql. Youtube is also use MySql when another big media use Oracle.

    I'm a Oracle DBA too, but I prefer use MySql because it's open source and I just now how to optimize it for larger transactions.

    Thanks.
    Signature
    Build Your Own WP Plugin For SEO
    {{ DiscussionBoard.errors[4490256].message }}
  • Profile picture of the author leppozdrav
    Ah ha... we have lot of Oracle DBA's supporting MySql, So do I. I am an DBA too!!!
    Signature
    www.seorockstars.net
    {{ DiscussionBoard.errors[4505358].message }}
  • Profile picture of the author SebastianJ
    I would go for MySql or PostgreSQL.
    {{ DiscussionBoard.errors[4505498].message }}
  • Profile picture of the author r4inna
    +1 for MySQL. I worth to invest in a good hardware instead of investing in expensive Oracle license
    {{ DiscussionBoard.errors[4535848].message }}

Trending Topics