mySql to Postgres

Contributor
8Dec2010,20:27   #1
heidik's Avatar
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
Go4Expert Founder
8Dec2010,20:33   #2
shabbir's Avatar
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.
Contributor
9Dec2010,18:01   #3
heidik's Avatar
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?
Contributor
9Dec2010,18:21   #4
heidik's Avatar
What is s Simple Data Access Layer using Hibernate? Do you have any idea?
Contributor
9Dec2010,20:11   #5
heidik's Avatar
I have just found this website but is above my head ;'(

http://www.theregister.co.uk/2006/11...ase_framework/
Contributor
9Dec2010,20:17   #6
heidik's Avatar
Here is another website

http://www.sqlapi.com/
Go4Expert Founder
9Dec2010,20:22   #7
shabbir's Avatar
Yes that is what I was suggesting you in simple terms. Actually you are trying to create ODBC like miniature thing
Contributor
9Dec2010,20:27   #8
heidik's Avatar
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
Go4Expert Founder
9Dec2010,21:17   #10
shabbir's Avatar
Books are your best friends buddy.