mySql to Postgres

heidik's Avatar, Join Date: Oct 2010
Contributor
Hello everyone

I am a recent graduate and have recently joined my job. I have been assigned a task of introducing a layer between the c++ program and its connectivity with database which would translate a query to any given database which in this case is postgres. We are using mysql++ and I have to write the code such that it works with any database tool.

Could anyone please guide me?

Thanks
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
First you have to detect the engine and then have the needed interface that works same on top but works differently for different database connectivity.
0
heidik's Avatar, Join Date: Oct 2010
Contributor
Thanks Shabbir. I am totally new to databases, a novice. I am basically a C++ programmer and am interacting with databases for the first time. Could you please guide from the beginning?
0
heidik's Avatar, Join Date: Oct 2010
Contributor
What is s Simple Data Access Layer using Hibernate? Do you have any idea?
0
heidik's Avatar, Join Date: Oct 2010
Contributor
I have just found this website but is above my head ;'(

http://www.theregister.co.uk/2006/11...ase_framework/
0
heidik's Avatar, Join Date: Oct 2010
Contributor
Here is another website

http://www.sqlapi.com/
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Yes that is what I was suggesting you in simple terms. Actually you are trying to create ODBC like miniature thing
0
heidik's Avatar, Join Date: Oct 2010
Contributor
Is there any tutorial that starts from beginning? Or could you help me do this from scratch. I am not at all familiar with Databases. I have been coding in C++ or J2SE but never in sql etc
0
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Books are your best friends buddy.