Sample Header Ad - 728x90

Redirecting and converting MySQL queries to Postgres on the server side

1 vote
1 answer
193 views
The first thing I would like to say is that I'm not going to build a production on such an architecture. I am interested purely for the sake of experiments in home experiments and performance in the amount of 1-2 users. What I need: - One data storage location from SQL database - The ability to connect using different drivers and different SQL dialects - Isolation of data from the method, libraries and syntax of obtaining them What I don't need: - Replication between different databases, creating duplicate data and tables ---------- For example: I have two apps. The first uses MySQL. The second uses Postgres. It is impossible to rewrite them on one database (for one reason or another). I want them to be able to connect each with their own driver and syntax, to the same data. At the same time, the data itself is not replicated, it is stored in a single instance. Please tell me how you can achieve a similar logic? What tools or settings can be used to achieve this? Which way should I move?
Asked by Pivigor (11 rep)
Aug 13, 2023, 10:50 AM
Last activity: Jul 3, 2025, 09:03 AM