LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
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 06-28-2005, 12:15 AM   #1
zaoka
Member
 
Registered: Jan 2005
Distribution: I learn Ubuntu :)
Posts: 61

Rep: Reputation: 15
What database and what language for this task:


Please help me to start learning in right direction!

This is what I want to do:

I want to make an online database (stored on server) that will work same way as client based Windows software for repair shops. So user should be able to enter customer and item informations, issue and create invoices and work orders, inventory, track and create tasks etc.

Also all other employes should be able to access this database, read and write, from diferent locations, over the internet.

Can you recommend me what type of database to use and what language to use to comunicate with database??
Is it possible to do it the way I explaned?
Also what books are available for that plan?

(this plan I want to realise during next 3 years but I need somebody to point me to the right direction)

Thank you a lot!

zaoka
 
Old 06-28-2005, 04:55 PM   #2
Matir
Moderator
 
Registered: Nov 2004
Location: San Jose, CA
Distribution: Ubuntu
Posts: 8,507

Rep: Reputation: 118Reputation: 118
I would strongly reccomend using MySQL and PHP for this task. Both PHP and MySQL will run on Windows and Linux servers, and making the interface web-based allow users of any platform to access your system.
 
Old 06-28-2005, 05:11 PM   #3
zaoka
Member
 
Registered: Jan 2005
Distribution: I learn Ubuntu :)
Posts: 61

Original Poster
Rep: Reputation: 15
hi

Thanks!

A firend told me that Oracle is the best but if I want to go with a free option I should use MySQL.
 
Old 06-29-2005, 03:20 PM   #4
Mara
Moderator
 
Registered: Feb 2002
Location: Grenoble
Distribution: Debian
Posts: 9,537

Rep: Reputation: 149Reputation: 149
Oracle can be used in a free (as beer) way if it's a prototype (plus some mroe cases). It's a very big piece of software, however, and dealing with it (esp. installation) is big pain. Go for MySQL. You may realize it doesn't have the functionality you want, then switch to PostgreSQL. If you decide to go for PHP, write database-independent code (and use ODBC) so you can switch them without too much extra work. Such libraries for different languages also exist.
 
Old 06-29-2005, 03:44 PM   #5
zaoka
Member
 
Registered: Jan 2005
Distribution: I learn Ubuntu :)
Posts: 61

Original Poster
Rep: Reputation: 15
hi

Thank you all a lot!

I really appreciate that!

I am not experienced programmer and I do not see now what features I would be able to do with Oracle and not with MySql... but time will show
 
Old 06-29-2005, 04:13 PM   #6
lowpro2k3
Member
 
Registered: Oct 2003
Location: Canada
Distribution: Slackware
Posts: 340

Rep: Reputation: 30
Thumbs up

Another vote for PHP/MySQL in this situation
 
Old 06-29-2005, 07:01 PM   #7
Matir
Moderator
 
Registered: Nov 2004
Location: San Jose, CA
Distribution: Ubuntu
Posts: 8,507

Rep: Reputation: 118Reputation: 118
On a more general note, this looks like a good candidate for LAMP: Linux, Apache, MySQL, and PHP (or PERL, but PHP here)
 
Old 06-29-2005, 07:09 PM   #8
Crashed_Again
Senior Member
 
Registered: Dec 2002
Location: Atlantic City, NJ
Distribution: Ubuntu & Arch
Posts: 3,503

Rep: Reputation: 57
Quote:
Originally posted by Matir
On a more general note, this looks like a good candidate for LAMP: Linux, Apache, MySQL, and PHP (or PERL, but PHP here)
Don't forget the other P->Python.

I'm using psp(python server pages) with mod_python on a project at work. Admitedly, php is more widely excepted then psp but I like python's syntax better.
 
Old 06-29-2005, 10:53 PM   #9
Matir
Moderator
 
Registered: Nov 2004
Location: San Jose, CA
Distribution: Ubuntu
Posts: 8,507

Rep: Reputation: 118Reputation: 118
Heh. I really need to break down and learn python eventually. I just need a good project to get started with.
 
Old 06-30-2005, 02:42 PM   #10
chatmasta
LQ Newbie
 
Registered: Jun 2005
Location: Southern Maine
Distribution: Debian (Server), Ubuntu/Windows (Desktop)
Posts: 5

Rep: Reputation: 0
I would also go with PHP and MySQL.
 
Old 06-30-2005, 02:47 PM   #11
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,988
Blog Entries: 11

Rep: Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880
Or LAPP, to re-iterate the war between PostgreSQL and MySQL ;)
 
Old 06-30-2005, 02:52 PM   #12
Matir
Moderator
 
Registered: Nov 2004
Location: San Jose, CA
Distribution: Ubuntu
Posts: 8,507

Rep: Reputation: 118Reputation: 118
Or, we could make things real fun with LAFFB: Linux, Apache, Flat File, and Bash.
(Original poster: don't take this one seriously)
 
Old 07-01-2005, 01:42 AM   #13
lowpro2k3
Member
 
Registered: Oct 2003
Location: Canada
Distribution: Slackware
Posts: 340

Rep: Reputation: 30
Quote:
Originally posted by Matir
Flat File, and Bash.
(Original poster: don't take this one seriously)
Or flat file and assembly
 
Old 07-01-2005, 02:29 AM   #14
64bitprocessor
LQ Newbie
 
Registered: Jul 2005
Location: Bangalore
Distribution: Debian
Posts: 15

Rep: Reputation: 0
HI,
Linux (OS), Apache (Server), MySQL (Database), PHP (front end) is very popular and known as LAMP.
64bit
 
Old 07-01-2005, 02:31 AM   #15
bigapple
LQ Newbie
 
Registered: Oct 2004
Location: Hangzhou.China
Distribution: Suse 9.3 | redhat 9.0 | Solaris 10
Posts: 29

Rep: Reputation: 15
hi ,Crashed_Again
i really want to set up a web server than can running python. but I don't konw how can i get the tools and coulud you help me ?
anything about it will be helpful ,:->

Last edited by bigapple; 07-01-2005 at 02:33 AM.
 
  


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
Snort database: Closing connection to database "" Homer Glemkin Linux - Security 2 07-14-2005 06:58 PM
Which is the best language to develop a database using application tuxfood Linux - Newbie 2 12-18-2004 02:05 PM
Best language for database making? yellowtrolley Programming 13 11-01-2004 06:47 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


All times are GMT -5. The time now is 04:17 AM.

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