On 3/9/2005 at 20:39 Jan Ekström wrote:
>Clay! >Thank you for your answer. >Still. I have been programming IBM system 3- AS 400 thirty years ago or >so. >I didn't like the IBM prison. I'am struggeling for fresh air. >I like SQLite very much. >I want to put data - preferably validated data - in my sqlite database. >Then work with the data and finaly get the result out on paper. >Later perhaps I want to try the same with MYSQL and php. >All in open source inviroment. >But for now. Where can I find C and C compiler - if C is right - or >another >suitable tole for my efforts. There are far too many correct answers to this question for me to start listing them. You need to evaluate the options and decide. Nearly all open source OSes come with gcc installed, which is a plenty good C/C++ compiler. If yours doesn't have it, or make it really easy to install then you are likely looking at the wrong distribution. (I haven't used any that don't have it) See the documentation to your package manager. C is great for low level, performance at any price work. It is a pain for quick and dirty code, and leaves a lot of room to shoot yourself in the foot if you are not careful. This is the price you pay for power, it might or not be worth it. The way you ask the question I'm going to guess that you are not a C expert, so I would recomend you avoid C when you can. However remember that when the going gets tough you might need to drop into C where everything is hard, but at least if it can be done C can do it. I recomend you use python (www.python.org) as your programing language. However sqlite comes with good tcl binding, and tcl is nice enough. I can't stand perl, but this is a personal thing, you need to make your own decisions. Ruby is sometimes mentioned as a good general purpose scripting language, but I know nothing about it. Those 4 are the main open source scripting languages, take your pick. I would strongly recomend postgressql over mysql where you have a choice. Where you need a simple database sqlite is better than mysql, where you need a powerful database postgresssql is better. In the little middle ground left you will find that mysql still isn't enough better to bother with. There is one major exception though: mysql is used all over and is worth knowing because you might encounter it again.
