Best language for the job?

Hey guys/gals

For a project i have decided to do a content management system, which i think will be best doing in PHP/MYSQL. Now i thoght itll b cool to have a program which changes settings in the site by connecting to the db, such as a C program or VB???  Dunno if this is a good idea or not.. but anyways.. what would be the best program to do this and to learn, baring in mind i have basic knowledge of java.....but yeah..

Cheers Matt
mattdyeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mattdyeAuthor Commented:
Just like to add that i wanted a program to edit the db, so itll b a exe they run to edit the db
0
AlexFMCommented:
For database programming VB (or .NET) is better than C.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

mattdyeAuthor Commented:
ok thanks, and is this good to use to execute sql queries? to edit the mysql db and then display in php?
0
AlexFMCommented:
I don't know about php. I know that VB is better choice for database programming than C in Windows environment. Both VB and C programmers have the same technologies for database programming - default choice is ADO. However, C programmers need to write a lot of COM client code to implement simple things which may be written in a fiew lines in VB. For DB operations, there is no difference in performance between VB and C programs.
However, running VB program requires installation of VB runtime library (msvbvm60.dll) on the client computer. Usually this is not a problem.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AlexFMCommented:
I don't have DB Java experience, but I guess Java has relatively high level database access libraries, like VB. C and Java may be a good choice if you need to write platform-independent programs.
0
Alien3Commented:
MFC would be best language to use with DB.  


0
secretservgyCommented:
C++ is one of the best languages but also ne of the hardest but i would recomend either MFC or C++.
0
drjustinCommented:
My suggestion: 100% Java (since you already know some of it)

If you don't know about Spring (www.springframework.org) now is the time to look at it. It covers all things that you are looking for - easy db integration, UI, configuration, documentation, forums, ... It has steep lurning curve, but all this stuff mentioned really helps and once you master it, there's no limit to what you can do :-).

All things below are already integrated with Spring:

- db integration (db independent - only jdbc driver limitations):
  - simple sql mapping: iBatis (www.ibatis.com)
  - more advanced ORM tool: Hibernate (www.hibernate.org)

- user interface:
  - most widely spread: Struts (struts.apache.org/)
  - easy usage: WebWork (www.opensymphony.com/webwork)
  - component oriented: Tapestry (jakarta.apache.org/tapestry)
  - integrated: Spring MVC (www.springframework.org/docs/reference/mvc.html)
0
bdcCommented:
I work mostly in C++, but I have done a lot of work with Java, C, .NET (both VB and C#). I have spent many years working with COM, ATL and MFC. You should be careful when asking a question like this. People tend to answer by shouting out there favorite language. In truth different languages have advantages and disadvantages. When working with a DB all of the mentioned languages will do the job and so I think you should look at the other needs of your application.

These are some of the things I would consider.

-Is this a client side or server side app?
If running in a server environment it is typically preferable to use a managed language like Java or one of the .NET languages. This provides you with nice exception handling, garbage collection, etc. On a server this is invaluable.

If you are building a client side app, then you should think about download size. Languages like Java and .NET require users to download and install large runtimes. In the case of .NET I think the runtime is larger then 15MB. Also, in a client app the managed environment is not so important.


-What type of data is in the DB and what will you be doing with it?
If the data is text and numbers then any of the languages should do. On the other hand if the DB contains some kind of graphical data that requires lots of processing, then I would suggest using a language like C or C++.

-Does your app need to run on multiple platforms?
If it does, I would stay away from .NET, COM, ATL and MFC.

-Do you need to work with any other components?
.NET and C++ do a very good job of communicating with older components, while it is a real pain with Java.

How do you plan on deploying this app?
If you have no idea what is on the user system, then hands down a simple C or C++ is the simplest. Once you start introducing COM things become complicated. If you know your users have the .NET runtime, then .NET is very very very easy to deploy.


Hope this helps
0
hariavinashCommented:
hello there

can anyone help me to find a copy of CA-XCOM User Guide or Manual for MVS.

cheers
:)
Avi
0
xxeCommented:
where can i install this programs?thanks.

Install j2sdk1.4.2_02

JCreator LE 2.5 or higher

Rational Rose 98 Enterprise Edition
0
InternetArmyCommented:
There have been some suggestions on using Java. UNless you are a fotune 500 company, I would stay away from it. The problem with Java is the cost of ownership is higher. Java requires more powerful hardware as well as a higher payroll to build upon it and maintain it. Java is an Enterprise application and that is why alot of banks and etc use it. However if you dont have a deep pocket for development costs, you will find it hard to meet your tight budgets. Java programers charge much more than PHP developers because there are far less Java programmers and they are more in demand.

PHP/mySQL is my suggestion. But if you require win32 API access, I would suggest C++ so you can work within one primary language to accomplish all of your tasks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java EE

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.