Hi all,

I need your help cause I am drowning fast..

I use vb6 and sql 2000 with win xp in my everyday job, and abit of gcc at home learning linux!

An opportunity arose and I have been asked to write a program in Linux using a db (don't know which one) to read add and update the data and produce reports!!!

I don't know which db server to use (i need to use procedures), which Linux distro and what to use to write the program. The final program needs to work on an intra-extra net with a separate db server!

I have a short deadline of a month and a half.

Any help will be gratelly appreciated.

Thanks!

pretty much arbitrary decisions, but go for mysql, it's quite user friendly and has a vast amount on published and on-line documentation.

As for what to write it *with*... well whatever text editor you want.

thanks for that acid_kewpie!!

But can i use procedures with mysql?

And what to write it with goes to what programming language to use to write the program.... use Kdevelop, use Kylix, Tcl/tk....... I just don't know.


And what about the reports, how to view them and the print them ?

Thanks again

Install Apache with PHP and MySQL.
You can then query the MySQL database with PHP and display the information however and in whatever style suits you
By the way KDevelop isn't a progamming language, neither is Kylix. They're an IDE and a GUI creator respectively.

well there's only so much scope you can really go far... how to print reports... well that's going to be within your application somewhere. but how that application is written depends a) what you already know and b) how it's meant to be used... do you want a UI? web based? automated?

A bit confused but getting the point.

Either a GUI or web based will be ok, depending how easy the language will be to learn!!

Obviously I have to learn something new here, having said that may I rephrase by asjing which language will be better and quicker to pick up?

Go with the PHP/MySQL combo, which will be web-based. The printing can be handled by a web-browser itself, and PHP is a very easy and powerful language to pick up.

really can't answer much more, as it depends so much on what this application is for as to how is best to implement it. the very last thing you want to produce has got to be an application designed not in light of the functional requirements, but what was quickest...

if you want something web based (which i guess would take care of the reporting / printing side quite nicely) then php is your natural avenue... for a local applcaition... well that's one of many many langauges.. c, c++, perl... and as you want a specific result, again i can't recommend a particular language.

but then, from the basic outline, i would hazard a guess that aa web app would probably be what you want... so maybe look at php, and if it stops being approriate, the parts of php you have learnt will most likely transfer quite well to a native perl application, as the to languages are very similar

Thanks a lot for the info guys !!!!


I will have to do a bit of web hunting for info but i think I know a couple of things to start with thanks to U.

Thanks!!