S
S
Smilley2021-06-01 22:17:20
Database
Smilley, 2021-06-01 22:17:20

Is there an analogue of a proxy for a DBMS?

Good evening, tell me, please, are there any proxies for the DBMS? There is specific software that can only work with MSSQL, I would like to configure it so that it connects to some service, and the service can translate requests to another DBMS (oracle, postgresql, etc.)

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
DevMan, 2021-06-01
@Smilley

In one way or another, there are solutions.
but they are partial, and will not make you happy/full transcription.
this is one of the reasons why dbal and orm are built on top of them.

R
rPman, 2021-06-01
@rPman

If we are talking about access drivers, then there are plenty of them, starting with separate ones, as was done with Microsoft ODBC, to those built into the programming language (more precisely, the proposed 'default' framework). For example, in php when using PDO or in the same java in JDBC, it is enough to specify the type of database and connection settings in the database connection string and all code will work with the new database.
But unfortunately different databases can work in an incompatible way. Even if you close your eyes to DDL (sql queries for creating and modifying database objects) and close your eyes to the presence and standards of the built-in language for describing functions, triggers, views and other things, and even close your eyes to the fundamental ability of the database to execute complex queries (for example recursive select), there are such features as, for example, new values ​​of identifiers, there are databases where there are sequences, and where they are not, and instead of calling the corresponding functions, new identifiers are generated automatically (i.e. sql query takes a new one as the default value) and their value can be obtained not before calling insert but after, i.e. the code is radically different... and it's not nice to change it, (but you can simulate the behavior of the sequence based on tables,

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question