ProgrammingThis forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
I have some programming experience. I do BASH scripts, and I used to code Javascript, HTML, and CSS by Hand. I have also used Autoit to convert VB Login scripts to something more user friendly. I took 2 formal college courses on c++ years ago, but forgot most of it.
What is the easiest language for me to start application development and to learn to use SQL?
What types of projects do you want to work on? The language choice is usually determined by what the goal is. If you're looking for a general language that works well with SQL, you might want to look into PHP. But if you have more specific goals we might be able to help you select a more appropriate language.
I was thinking I would like to start with something that is good for stand alone client to DB relationship but is not web based. Otherwise I would just invest the time into PHP for web development.
By Day I am a Systems Administrator and not a developer, so it would be good to learn something that would help me in day to day task as well.
PHP is actually a decent (not great mind you) scripting language for systems administration tasks. I've found on more than one occasion that doing something for a batch job in my administration was most easily accomplished with PHP (yes even easier than python or ruby). Like I said it depends on the task at hand for the language choice, and if you're looking for a scripting language that is good for DB accesses PHP is one of the easiest around.
You said "application development". To me, that means a compiled language like C or C++. PHP is normally used for web applications running on the server side.
In studying Python, I see lots of talk about writing the initial app in Python and then putting specific segments into C where speed is important.
For simple stuff, Python is hands-down one of the easiest languages around. Beyond simple, it gets pretty convoluted.
Personally, if I were going into development, I would learn C first, then build out from there.
Offline and Online languages doesn't specify anything other than there is a web server that interprets that language. All languages are as offline as the next. I guess I don't see what that criteria has to do with why PHP would not be a good choice as a language.
Python is a dead simple language, but the handling for DB calls is not nearly as simple (or built-in) as PHP's. That's the only reason I suggest PHP over another modern scripting language. The DB support in most compiled languages is about the same as Pythons.
I'd be willing to throw out more languages if you'd like, but my recommendation won't change unless the specifications change.
I guess I am looking for a good catch all language that does not require a web server. However I do know I need to learn SQL so something that will allow me to incorporate learning SQL would be nice. I like DB driven Apps, but it is not always needed.
C# is a more purely object oriented language that MS came out with. It's very very similar to Java (although it has quite a few differences). It can be used on the web as a language that plugs into the .net framework in IIS. (This gets back to my point of offline and online being the same thing. e.g. C is a web programming language with the right apache module.)
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.