why implement this functions?

well some guys use plain text mysql clients and must have a a 'secure blob transfer', but they can't send blobs or predefined queries
one solution for this is base64, but it is 33% bigger than raw data , but it's binary safe because it don't use special chars

how guys could use it?
1) INSERT INTO some_table (primary) values (1);
2) at client side, $base64_file_value=base64_encode($real_file_value); // CPU use is high here, but it's not a problem, use wait the file to be 'uploaded'
3) UPDATE some_table SET file=COMPRESS("$base64_file_value") WHERE primary=1; // ok COMPRESS is normally used to use less space but consume more CPU
4) SELECT UNCOMPRESS(file) FROM some_table WHERE primary=1; // without COMPRESS we have less CPU use, it's a use option..
5) at client side, $file=base64_decode($value_from_field_file); // since mariadb can't decode base64 before COMPRESS(), we need to decode in client side

and? what this help? well check what we could optimize:
1) INSERT INTO some_table (primary) values (1)
2) at client side, $base64_file_value=base64_encode($real_file_value);
3) UPDATE some_table SET file=COMPRESS(BASE64_DECODE("base64value")) WHERE primary=1
4) SELECT UNCOMPRESS(file) FROM some_table WHERE primary=1
5) at client side, $file=$value_from_field_file; // no decode needed =) less cpu use, and less ram use at client side

with this, we have
1)smaller network traffic at (4) -> 33% less traffic
2)less CPU utilization at (5)
3)more CPU use at (3)
4)more CPU use in (3) isn't a problem, it's a solution, we have more CPU use at UPDATE and less in SELECT, since read is more intensive than write for BLOBS, it's a very good solution!

well that's all, thanks guys and google summer code good works

like MDEV-251 (closed)

like http://bugs.mysql.com/bug.php?id=18861 (mysql bug database)
http://bugs.mysql.com/file.php?id=3294

hi sergey, the UDF plugin function link, works in mariadb, maybe just a 'default mariadb function' could be considered

PLEASE CLOSE THIS MDEV
http://bazaar.launchpad.net/~maria-captains/maria/10.0/revision/3822

revision 3822 -> FUNCTIONS TO_BASE64 / FROM_BASE64