Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Database suggestions

  1. Apr 3, 2005 #1
    I need to make a database of a bunch of samples and log several bits of info about each sample. Any software suggestions on how to do this? A spreadsheet really doesn't work and I want to keep this within Windows.
  2. jcsd
  3. Apr 4, 2005 #2
    PostgreSQL or MySQL
  4. Apr 4, 2005 #3
    You mean making your own database using a programming language, or using something like mdb or Microsoft Database?
  5. Apr 4, 2005 #4
    Last edited by a moderator: May 2, 2017
  6. Apr 4, 2005 #5


    User Avatar
    Gold Member

    PostgreSQL and MySQL are both tailored towards UNIX, which the poster desires something more tailored towards Windows. Last time I checked, PostgreSQL did not have a Windows port, and MySQL charged for a Win32 version (client was free). I could be out of date here, but I think Foxpro or Access would be the better route to go. Also, experience with SQL is very useful to have with PostgreSQL or MySQL. If the poster doesn't have this experience then, again, Access is the best in this situation.
  7. Apr 4, 2005 #6
    No, MySQL only charges for corporate licenses(I think the lowest level is $200 at least that's what it used to be). MySQL is open source and free to use on all platforms for non-corporate uses. In fact MySQL has better support of MS and Apple than it does for Linux. Actually, MySQL may be used by corporations as long as the use does not violate the GPL. If a corporation wants to develope a piece of software based on MySQL and keep the code secret then a MySQL license is required. http://www.mysql.com/company/legal/licensing/

    [edit]PostGRE can be built under Windows as well: http://www.weberdev.com/Manuals/Postgre7.4.2/install-win32.html [Broken]
    Last edited by a moderator: May 2, 2017
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook