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

USEFULL FUNCTION WITH WEB APPLICATIONS

        Details

        • Type: Task
        • Status: Closed
        • Priority: Trivial
        • Resolution: Duplicate
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None

          Description

          Hi guys again
          reading my old mysql feature requests i read about a interesting and very very used function
          BASE64_ENCODE and BASE64_DECODE
          this is very usefull with files to store than using a text free of sql injection and a very bad compression but usefull
          check here http://bugs.mysql.com/bug.php?id=18861
          the function is used in mysql client code, but not appended to mysql server, it can be done at client side but use a lot of network (when using BASE64_DECODE function, for BASE64_ENCODE is just needed when update/insert)
          there´s a sql implementation and a pluging available at google and dev team, but they aren´t fast, and the plugin is a bit old
          well if it´s still nice to implement....

            Gliffy Diagrams

              Attachments

                Issue Links

                is duplicated by

                Task - A task that needs to be done. MDEV-4387 UDF - Base64 encode/decode

                • Trivial - Cosmetic problem like misspelt words or misaligned text.
                • Closed

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  serg Sergei Golubchik added a comment -

                  Thanks for your suggestion, we'll consider it.

                  Show
                  serg Sergei Golubchik added a comment - Thanks for your suggestion, we'll consider it.
                  Hide
                  Permalink
                  rspadim roberto spadim added a comment -

                  nice sergei, if you look at bugs.mysql there's a patch (or a function) i don't remember now, with source and working (at last for mysql 4.xx) maybe this could help....
                  there's a base64 lib in mysql client too or mysqldump (i don't remember now)

                  maybe this could help developing faster =) bye thanks

                  Show
                  rspadim roberto spadim added a comment - nice sergei, if you look at bugs.mysql there's a patch (or a function) i don't remember now, with source and working (at last for mysql 4.xx) maybe this could help.... there's a base64 lib in mysql client too or mysqldump (i don't remember now) maybe this could help developing faster =) bye thanks
                  Hide
                  Permalink
                  rspadim roberto spadim added a comment -

                  sorry, please close this i have duplicated it (MDEV-4387)

                  Show
                  rspadim roberto spadim added a comment - sorry, please close this i have duplicated it ( MDEV-4387 )

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      rspadim roberto spadim
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Time Tracking

                        Estimated:
                        Original Estimate - 3 hours
                        3h
                        Remaining:
                        Remaining Estimate - 3 hours
                        3h
                        Logged:
                        Time Spent - Not Specified
                        Not Specified