LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices


Reply
  Search this Thread
Old 10-08-2004, 11:26 AM   #1
Burgin
Member
 
Registered: Apr 2004
Posts: 54

Rep: Reputation: 15
best database for a class project


I'm working on a web-based class project for which I need a database. I'd like to stick to something that is easily available and a somewhat-low learning curve.

The one caveat is that this will not be a throw-away application. It will live on after the class.

Given, is there any reason that I should not go with Access which is available on all the PCs accross my campus. Or Should I use a REAL database, like MYSQL? It's also possible that Oracle might be available as well.
 
Old 10-08-2004, 11:49 AM   #2
Hko
Senior Member
 
Registered: Aug 2002
Location: Groningen, The Netherlands
Distribution: Debian
Posts: 2,536

Rep: Reputation: 111Reputation: 111
If university/school has it's standard database, it may be best to stick with that...

It also depends partly on the web-server and script language you're going to use. If it's apache + PHP or Python, and you a choice to install it, I'd go for MySQL.
 
Old 10-08-2004, 11:51 AM   #3
clinton
Member
 
Registered: Oct 2003
Location: Vancouver
Distribution: RH Enterprise AS 3
Posts: 47

Rep: Reputation: 15
I would tend to recommend MySQL.

1) It's free
2) I find Access lacking in some really good features (MySQL may lack others)
3) I think MySQL is more likely to be used in industry.

I find that Microsoft tends to turn its nose up at industry standards and so learning on an MS product can result in some very sloppy programming that may not work in other applications. Take, for example, ASP. Statements there are "newline separated" rather than ";" separated. Try that in just about every other programming language and you're in for a massive headache.

Furthermore, learning everything via a GUI means you don't understand what's actually going on. Calculators are banned in grade school for the same reason.

Oracle is a nice database, but can be quite costly.

To re-iterate then, I would go with MySQL. They have fairly good documentation on their website, and there are plenty of forums available to assist you.
 
Old 10-08-2004, 11:53 AM   #4
secesh
Senior Member
 
Registered: Sep 2004
Location: Savannah, GA
Distribution: Ubuntu, Gentoo, Mythbuntu, ClarkConnect
Posts: 1,154

Rep: Reputation: 47
First: what server will you use?

Is this microsoft server? Both would work fine.
Is this Linux server? -- don't waste your time with access, get MySQL.

Now, I might be biased, but I prefer MySQL. I have worked with both, and if nothing else, I didn't like the ODBC functionality for making DBs live on a server.

Moreover, it's been a couple years since I ran a MS server with access DB via ODBC, and it was not stable at the time! -- I would have to commonly reload the ODBC link; for some reason, the DB would go offline periodically. I trust this has since been fixed, but...
 
Old 10-08-2004, 12:36 PM   #5
gizmo_thunder
Member
 
Registered: Apr 2004
Posts: 101

Rep: Reputation: 15
mySql is the best for class projects.. easily available..
and learning curve.. hmm actually its' just same as
any other db coz.. its' just sql any where
 
Old 10-08-2004, 02:56 PM   #6
Mara
Moderator
 
Registered: Feb 2002
Location: Grenoble
Distribution: Debian
Posts: 9,696

Rep: Reputation: 232Reputation: 232Reputation: 232
It depends how complicated things you'll do with the database. If you need strong support of stored procedures and such things, use PostgreSQL. But it doesn't looks this way (you thing about Access), so MySQL should be enough.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Class project Idea AquamaN Programming 5 09-22-2005 12:04 AM
Write the Database RecordSet class nelnel Programming 2 09-14-2005 08:53 PM
Open Source contact details database project hamish Linux - Software 2 02-09-2005 06:18 AM
Class project, setting up network using Fedora for small startup company. Bronco1 Linux - Networking 2 09-28-2004 03:48 AM
Help Picking two servers (class project)+ Q Quatttro General 1 04-25-2004 11:16 AM

LinuxQuestions.org > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 11:32 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration