Which DB to Use

by 16 replies
20
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
#programming
  • Well, you can use MYSQL database. It’s free and open source also. Flexibility and storage capacity is depend on your host server.
    • [ 1 ] Thanks
  • 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.
    • [ 1 ] Thanks
    • [1] reply
    • 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 ..."
      • [ 1 ] Thanks
      • [1] reply
  • 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.
    • [ 1 ] Thanks
  • Banned
    [DELETED]
    • [ 1 ] Thanks
  • MySQL would do.

    The newer NoSQL like Mongo and Cassandra are good too.
    • [ 1 ] Thanks
    • [1] reply
    • 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
  • what language are you writing the program in?

    Walkthrough: Adding a SQL Server Compact 3.5 Database to an Application and Deploying it
    • [1] reply

    • It is going to be a C+ language I think
  • definitely mysql +1
  • Great information...thanks for posting guys
  • 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.
  • Ah ha... we have lot of Oracle DBA's supporting MySql, So do I. I am an DBA too!!!
  • I would go for MySql or PostgreSQL.
  • Banned
    [DELETED]
  • +1 for MySQL. I worth to invest in a good hardware instead of investing in expensive Oracle license
Join the discussion

Next Topics on Trending Feed

  • 20

    Which DB to Use

    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.