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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
