Naive Question
Assume we have an Application which was originally written for ORACLE as DBMS. If I want write an intermediary layer that gives this application independence to be able to work with PostgreSQL DBMS - I presume that I would be required to perform the following :
SQL : Application--> ODBC API (Oracle Wire Protocol) --> My Layer ---> ODBC API (PostgreSQL Wire Protocol)
Response : Application-->ODBC API (Oracle Wire Protocol)<--- My Layer <--- (PostgreSQL Wire Protocol)PostgreSQL DBMS
Is such a layer sensible?
Who else has done this?
What are the challenges we need to tackle?
For ANSI compliant SQL queries will it be sufficient if one simply replaces the ODBC Driver for PostgreSQL. So that scenario changes to :
SQL : Application--> ODBC API (PostgreSQL Wire Protocol) ----> PostgreSQL DBMS Response : Application-->ODBC API (PostgreSQL Wire Protocol) <---- PostgreSQL DBMS
