Using DB Api in a portable manner

Question

Hi,

I need to develop some kind of application and use DB in it.

Let's say i want to develop it over Windows currently, however, in a couple months i may have to migrate it to Linux.

I started reading a little bit about it, but couldn't get to point i needed.

Is there or isn't a generic/protable/standart api for using DB ?

I read there is ODBC,JDBC, iOBDC,unixODBC ? why all of these exist ?

Can someone help clearing and setting my head straight regarding the issue ?

Edit - I'm using C++ - so please advise to that direction, even though i'll appreciate inter-language/inter-platform recommendations

Answer 1

Just use the JDBC API in combination with a JDBC driver. Do not use the ODBC (bridge) driver.

Answer 2

I recommend you using SQLite if your DB load is not very heavy. you need only one header file and one source file only(amalgamation version). and It's highly portable. I have been using it on Windows and Linux.