Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4057
  • Last Modified:

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
1 Solution
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
For database programming VB (or .NET) is better than C.
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

mattdyeAuthor Commented:
ok thanks, and is this good to use to execute sql queries? to edit the mysql db and then display in php?
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.
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.
MFC would be best language to use with DB.  

C++ is one of the best languages but also ne of the hardest but i would recomend either MFC or C++.
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)
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
hello there

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

where can i install this programs?thanks.

Install j2sdk1.4.2_02

JCreator LE 2.5 or higher

Rational Rose 98 Enterprise Edition
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.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now