Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-1

MaxScale filter to real Microsoft SQL Server syntax

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • None
    • N/A
    • N/A

    Description

      Develop a MaxScale filter that will translate SQL Server syntax to MariaDB syntax. Develop a SQL Server client protocol plugin.

      Attachments

        Activity

          bwepngong Wepngong Ngeh Benaiah added a comment - - edited

          Hello @Sergei Golubchik

          I am a 4^th^ year BEng Student in Computer Engineering at the University of Buea. I am specialized in Software development and have been using MariaDb and Java since 2 years ago. I have proficient skills in C, Java and PHP and will like to work on this issue as a way of contributing to MariaDb by means of GSoc2016.
          I will appreciate any pointers on this issue and how I can proceed to draft a proposal for it.
          Kind regards!
          Wepngong Ngeh Benaiah

          bwepngong Wepngong Ngeh Benaiah added a comment - - edited Hello @Sergei Golubchik I am a 4^th^ year BEng Student in Computer Engineering at the University of Buea . I am specialized in Software development and have been using MariaDb and Java since 2 years ago. I have proficient skills in C, Java and PHP and will like to work on this issue as a way of contributing to MariaDb by means of GSoc2016. I will appreciate any pointers on this issue and how I can proceed to draft a proposal for it. Kind regards! Wepngong Ngeh Benaiah
          markus makela markus makela added a comment -

          This filter should only do SQL level translation, not network level. That should be handled by a separate protocol module.

          With this filter, one would connect using MySQL wire protocol but would still talk in MS SQL. The expected results would be returned according to the MySQL protocol.

          markus makela markus makela added a comment - This filter should only do SQL level translation, not network level. That should be handled by a separate protocol module. With this filter, one would connect using MySQL wire protocol but would still talk in MS SQL. The expected results would be returned according to the MySQL protocol.
          bwepngong Wepngong Ngeh Benaiah added a comment - - edited

          @markus makela
          From what you explain, this means that an existing MS SQL application for example will not change its code but will however just change its connection string to suite that of MySQL and the filter will handle everything else. Am I correct?

          bwepngong Wepngong Ngeh Benaiah added a comment - - edited @markus makela From what you explain, this means that an existing MS SQL application for example will not change its code but will however just change its connection string to suite that of MySQL and the filter will handle everything else. Am I correct?
          markus makela markus makela added a comment -

          Using a MariaDB connector and the filter this task describes would allow MS SQL applications to talk to MariaDB databases. So the filter only translates on the language level.

          markus makela markus makela added a comment - Using a MariaDB connector and the filter this task describes would allow MS SQL applications to talk to MariaDB databases. So the filter only translates on the language level.
          Zhu Bo added a comment - - edited

          I am a student from Clemson univerisity. What does that mean "using filter to conver Mysql SQL to MS SQL " ?
          Could I write a C++ program as MaxScale filter and translate the MySql -> MS Sql ? If so, I think it is just as same as a compiler front-end problem.

          Zhu Bo added a comment - - edited I am a student from Clemson univerisity. What does that mean "using filter to conver Mysql SQL to MS SQL " ? Could I write a C++ program as MaxScale filter and translate the MySql -> MS Sql ? If so, I think it is just as same as a compiler front-end problem.

          People

            Unassigned Unassigned
            serg Sergei Golubchik
            Votes:
            4 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.