Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13806

SUGGESTION (Disruptive Innovation): Run R Functions directly from MariaDB SQL statements

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      There is a really interesting plugin for Excel called BERT: "Basic Excel Toolkit", which allows to call R Functions as if they were regular Excel Functions:

      BERT Toolkit

      If you have any basic R programming Knowledge, it is interesting to install it and see how it works.

      Now I was wondering, ¿Would not it be cool to be able to do the same from a MariaDB's SELECT statement? Nor PostgreSQL, MySQL, or Oracle Database can call a function from an SQL script (Or a trigger or scheduled event) to a R Function.

      So, we would be able to execute a query like this:

      SELECT
         R_EigenValues_Function(My_Column)
      FROM
         MyTable;
      

      Being R_EigenValues_Function() an R user defined function.

      Thank you.
      Juan

      Attachments

        Activity

          People

            Unassigned Unassigned
            Juan Juan Telleria
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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