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
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.
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?
heidik's Avatar, Join Date: Oct 2010
Contributor
What is s Simple Data Access Layer using Hibernate? Do you have any idea?
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/
heidik's Avatar, Join Date: Oct 2010
Contributor
Here is another website

http://www.sqlapi.com/
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
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
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Books are your best friends buddy.