Thread: application compatibility with Oracle

application compatibility with Oracle

From
"adivi"
Date:
hi,

 i am looking to write applications in .net
        ( using odbc or some faster but similar compatible tech.)
 that could run with
        PostGreSql OR Oracle
 with minimal changes.( any other database server compatibility would be a bonus !)
 
 for this i need to know
        what database constructs and
        programming techniques
            i can use so that the application would run with either PostGreSql or Oracle.
 
 any advice in this regards is greatly appreciated
 
TIA
 
regards
-adivi

Re: application compatibility with Oracle

From
Tino Wildenhain
Date:
Hi adivi,

first of all, every technical mailinglist I know doesnt
like HTML mails. You got an interesting indentation style
anyway ;)

I'd recommend an abstraction layer for your Application
which resolves the database specific part.

Although you can stick to the subset of constructs which
will be supported by both databases, you cannot optimize
your queries for maximal performance during the different
implementations.

So most Applications which support more then one database
have different backend-handler with their special queries.

If you built and intelligent solution, you could write
most of the simpler statements in a way working well
on both systems and derive the layer and only replace
the complex queries with specialized ones for the given DB.

HTH
Tino Wildenhain

adivi wrote:
> hi,
>
>  i am looking to write applications in .net
>         ( using odbc or some faster but similar compatible tech.)
>  that could run with
>         PostGreSql OR Oracle
>  with minimal changes.( any other database server compatibility would be
> a bonus !)
>
>  for this i need to know
>         what database constructs and
>         programming techniques
>             i can use so that the application would run with either
> PostGreSql or Oracle.
>
>  any advice in this regards is greatly appreciated
>
> TIA
>
> regards
> -adivi