2

I want to use mysql proxy for processing queries trying to execute. I want to make this process available for all databases like mysql, ms sql server, oracle and ... is it possible to use mysql proxy as base engine and connect these database from that? if no, is it possible to do this by making some little changes to mysql proxy source code?

JGC
  • 12,737
  • 9
  • 35
  • 57
  • 1
    Postgres' FDW (Foreign Data Wrapper) might be much better suited for this. Toss in [multicorn](http://multicorn.org/) and life just may be beautiful. If you throw in `unixodbc` into the mix there's really nothing you can't do. – Wayne Werner Mar 05 '15 at 02:20

2 Answers2

1

You could use the standard external stored procedure support in the DBMS, but it would be difficult to map arbitrary queries to something meaningful.

Your are likely to be more successful implementing a lightweight parser as described in MySQL Client/Server Protocol and What communication protocol uses MySQL?.

Your preference that this can be done with 'some little changes' is likely not to be realistic. Expect a major job of the scale of ODBC to implement a generic SQL dialect translator.

Community
  • 1
  • 1
Pekka
  • 3,529
  • 27
  • 45
0

I found that i have to use other exisiting proxies and change them in order to get what I need

JGC
  • 12,737
  • 9
  • 35
  • 57