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

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.

Thanks!

A firend told me that Oracle is the best but if I want to go with a free option I should use MySQL.

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.

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

Another vote for PHP/MySQL in this situation

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.

Heh. I really need to break down and learn python eventually. I just need a good project to get started with.

I would also go with PHP and MySQL.

Or LAPP, to re-iterate the war between PostgreSQL and MySQL ;)

Or, we could make things real fun with LAFFB: Linux, Apache, Flat File, and Bash.
(Original poster: don't take this one seriously)

Or flat file and assembly

HI,
Linux (OS), Apache (Server), MySQL (Database), PHP (front end) is very popular and known as LAMP.
64bit

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 ,:->