So I tried and I got a very basic UDF working.
mysql> SELECT udf_fileexists_go("/etc/hosts"); +---------------------------------+ | udf_fileexists_go("/etc/hosts") | +---------------------------------+ | 1 | +---------------------------------+ 1 row in set (0.00 sec) mysql> SELECT udf_fileexists_go("/nonexistend"); +-----------------------------------+ | udf_fileexists_go("/nonexistend") | +-----------------------------------+ | 0 | +-----------------------------------+ 1 row in set (0.00 sec)
This is nowhere near production quality, so be careful.
The code is here:https://github.com/dveeden/udf_fileexists_go/blob/master/udf_fileexists_go.go.
Super cool. I had to install the development libraries rpm and modify the cgo comment to point to the proper location in my env but it compiled & created without issue. Thanks for sharing and blazing the trail!
ReplyDelete