LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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-17-2004, 08:03 AM   #1
yellowtrolley
LQ Newbie
 
Registered: Jun 2004
Location: Kent (UK) / Galicia (Spain)
Distribution: debian. Knoppix hd install
Posts: 4

Rep: Reputation: 0
Question Best language for database making?


Hi

I am a quite newbie debian user and I want to learn database programming.

What is the best option? MySQL?
 
Old 10-17-2004, 08:08 AM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,384

Rep: Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963
yeah, i'd say so. pretty user friendly and close to the SQL standards
 
Old 10-17-2004, 09:09 AM   #3
jordanGSU
Member
 
Registered: Sep 2004
Distribution: Debian, Slackware, Arch
Posts: 65

Rep: Reputation: 15
mysql is also open source...but if you are looking for something that will look better on a resume, check into Oracle...actually I dont even know if an oracle DB can run on linux, worth looking into though
 
Old 10-17-2004, 03:28 PM   #4
Mara
Moderator
 
Registered: Feb 2002
Location: Grenoble
Distribution: Debian
Posts: 9,536

Rep: Reputation: 148Reputation: 148
Oracle runs on Linux, but it's really expensive. If you're not doing something very Oracle-specific, PostgreSQL can be used instead. Or MySQL if there's no need for stored procedures.
 
Old 10-17-2004, 06:16 PM   #5
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,973
Blog Entries: 11

Rep: Reputation: 877Reputation: 877Reputation: 877Reputation: 877Reputation: 877Reputation: 877Reputation: 877
Quote:
Originally posted by jordanGSU
mysql is also open source...but if you are looking for something that will look better on a resume, check into Oracle...actually I dont even know if an oracle DB can run on linux, worth looking into though
Linux is officially Oracle's preferred development platform,
so yes, it DOES work on Linux ;)

[edit]
If the original poster is after OpenSource I'd strongly
suggest PostgreSQL, it may not be quite as fast as
MySQL in everyday life, but it outweighs it in features...
and in GIS databases Postgres outperforms Oracle ;)
[/edit]


Cheers,
Tink

Last edited by Tinkster; 10-17-2004 at 06:37 PM.
 
Old 10-18-2004, 12:19 AM   #6
hack_in_box
LQ Newbie
 
Registered: Sep 2004
Location: India
Distribution: Fedora core1, PCQ Linux2004, SuSE8
Posts: 13

Rep: Reputation: 0
Try out MySQL 5.0 alpha. The documentation is good and there are even procedures and triggers.
Hope it helps u
 
Old 10-19-2004, 06:24 AM   #7
andmalc
LQ Newbie
 
Registered: Nov 2003
Distribution: Debian
Posts: 19

Rep: Reputation: 0
or for minimum administration, sqlite

Sqlite is a tiny but fully functional database that I found perfect for learning SQL on Linux or Windows. Since it's a single user db for local access, there's no administration to need to learn when you just want to get started issuing commands. You'll find everything you need in the Debian repository including language bindings.

It has an interactive interpreter similar to mysql's or postgres's.

Your choice amongst the other two might be governed by the language you use. Python is traditionally associated Postgres, PHP with MySQL.

Last edited by andmalc; 10-20-2004 at 06:26 AM.
 
Old 10-19-2004, 08:17 AM   #8
davholla
Member
 
Registered: Jun 2003
Location: London
Distribution: Mandriva 2008 Spring
Posts: 652

Rep: Reputation: 31
Quote:
Originally posted by Mara
Oracle runs on Linux, but it's really expensive. If you're not doing something very Oracle-specific, PostgreSQL can be used instead. Or MySQL if there's no need for stored procedures.
Actually you can get personal Oracle to install on Linux free of charge although you have to register. It is also a pain to install on Windows and I suspect it is the same on Linux and is a big download.
However you would have to pay to use Oracle forms.
 
Old 10-20-2004, 03:17 PM   #9
Mara
Moderator
 
Registered: Feb 2002
Location: Grenoble
Distribution: Debian
Posts: 9,536

Rep: Reputation: 148Reputation: 148
Quote:
Originally posted by davholla
Actually you can get personal Oracle to install on Linux free of charge although you have to register. It is also a pain to install on Windows and I suspect it is the same on Linux and is a big download.
However you would have to pay to use Oracle forms.
Yes, but the license says you can use it only for a prototype and so on (I've read it once). I think it's not good to use a product with such licence as first database. Others will be better. And the installation is ...hmmm... interesting experience.
 
Old 10-20-2004, 05:34 PM   #10
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,973
Blog Entries: 11

Rep: Reputation: 877Reputation: 877Reputation: 877Reputation: 877Reputation: 877Reputation: 877Reputation: 877
I agree with Mara ... and trying to install Oracle on
something other than DeadRat or SuSE is a pain in
the neck (not that I find it easy on the certified ones).

Postgres all the way - yeah baby! :)



Cheers,
Tink
 
Old 10-20-2004, 06:10 PM   #11
mrcheeks
Senior Member
 
Registered: Mar 2004
Location: far enough
Distribution: OS X 10.6.7
Posts: 1,690

Rep: Reputation: 50
*the only thing you need to know to get started is your "SQL" not proprietary or sql specific to oracle or another database sql extensions, but GENERIC SQL.
*when you know SQL then you choose a database be it mysql, postgresql , hsqldb, instantdb, etc...
*when you know the differences between databases, in terms of performance, features, tools , then you choose the one which is most suited.

you might also want to learn a programming language to interact with the database if you don't want to edit manually or with a gui tables values.
 
Old 10-20-2004, 08:59 PM   #12
andmalc
LQ Newbie
 
Registered: Nov 2003
Distribution: Debian
Posts: 19

Rep: Reputation: 0
Quote:
Originally posted by mrcheeks
*the only thing you need to know to get started is your "SQL" not proprietary or sql specific to oracle or another database sql extensions, but GENERIC SQL.
*when you know SQL then you choose a database be it mysql, postgresql , hsqldb, instantdb, etc...
Exactly.

And another reason why big, complicated databases like Oracle are not such a good choice for learning is that you'll spend too much time learning Oracle administration when all you wanted to do is learn some SQL.

Like mrcheeks and others in this thread have said, start with the generic. That way you'll know what you can do with the standard.

For a language I suggest Python. It had the best combination of intuitiveness, maturity, range of uses, and excellent documentation.

Last edited by andmalc; 10-21-2004 at 06:15 AM.
 
Old 10-21-2004, 12:48 AM   #13
yellowtrolley
LQ Newbie
 
Registered: Jun 2004
Location: Kent (UK) / Galicia (Spain)
Distribution: debian. Knoppix hd install
Posts: 4

Original Poster
Rep: Reputation: 0
Thank you my brothers!
 
Old 11-01-2004, 06:47 PM   #14
jdtiede
Member
 
Registered: Apr 2003
Location: Baton Rouge, LA
Distribution: Kubuntu 12.04, 12.10, 13.04a
Posts: 244

Rep: Reputation: 30
I agree with Malc about SQLite. It's fast, takes little disc space, and is self-contained (no server with attendant administration problems). It's a subset of PostgreSQL, meaning all the SQL command are pretty standard. If you start with sqlite and decide you need more features, it's very easy to move up to PostgreSQL--just export your tables as text files and use pgsql's COPY function.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
What database and what language for this task: zaoka Programming 16 07-01-2005 08:29 AM
Which is the best language to develop a database using application tuxfood Linux - Newbie 2 12-18-2004 02:05 PM
which language is the best to manage database? poeta_boy General 1 12-09-2003 10:00 PM
Language for a simple gui and database connectivity JHuizingh Programming 2 07-26-2002 12:50 PM
A simple language abstract, please, re: making my Linux network public lhoff Linux - Networking 3 02-07-2002 09:52 AM


All times are GMT -5. The time now is 05:17 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration