|
from #postgressql-friendly
Hi everybody. I looked into PG a few months back. Reading the messages above, I agree with the notion that if there were to be PG compatibility in MariaDB it should be limited to the subset seen as essential to PG users. The scope of my research was very limited and I quickly realized that most of the questions and issues to solve are on the MariaDB side, or maybe even more so on the business and marketing side. We can re-prioritize PG in MaxScale if there is a need for that, but I think this forum is good as the "What" needs to be researched before the "How".
You are right about the wire protocol, it is not the hard part. A straight protocol converter in MaxScale could be implemented in relatively short order. Simple PG extensions could be translated in that module.
In case more of the PG dialect and extensions had to be supported in MaxScale, we might have to use their parser (rather than enhance our own), which obviously would take a bit longer.
Overall I am somewhat against implementing PG features in MariaDB and MaxScale, and more for migration tools, be it that we add a module for migration in MaxScale as long as it can be defined so that it does not cause the rest of the code base to be touched to any greater extent.
|