Discussion Locked

Is C++ a good frontend for DB Systems?

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have always find it easy using C++ in developing games, embedded systems, etc. But when it comes to developing Database systems I find it a little bit difficult because of the following difficulties.
1. I have not found a standard method to establishe a connection to the Daatabase. (i.e.dbconnection as new ADODB.Connection)
2. Its rather a little bit difficult to Use SQL with C++. For example to implement the following:-
(sqlString="INSERT INTO tblStudents(StudID,Names) VALUES ('"+Me.StudentId +"','"+me.Names +"'))

1 reply

by jay eckles

It sounds to me like you answered your own question. C++ is an OK language to use to front-end a database system. It's a powerful low-level language, but the lack of abstraction results in the two problems you identified.

If you're looking for alternatives, there are a couple of obvious choices:
1. Visual Basic - Super easy to build a GUI, has access to ADO for very easy database connectivity, has classes for dealing with SQL and databases. It's little brother VBScript can be used withinASP to provide a web-based front-end to a database with the same advantages.
2. Java - JDBC makes database connectivity about as easy as ADO, with drivers for darn near every database you can think of. Toss in the syntactic similarity to C++ (withwhich you indicated you are quite comfortable) and very good portability, and I think you have a very attractive alternative to C++. Modularize your code well and you can use it in a servlet or JSP to provide a web-based interface with little additional coding.

Good luck.

Jay
www.jayeckles.com

This discussion is closed to new replies.