Building UDF median with Visual Studio 2008

[Jeff Beard]

Hi folks,

I did a write up on how to build udf median on Windows using Visual
Studio 2008 Professional since the process was a little different from
what was on Roland Bouman's and Dan Moore's blogs. You can find my
article here:

http://www.cyberxape.com/blog/jeff/entry/udf_median_on_windows

Of note is a link in the post to a zip file that contains the
following items:

Visual Studio 2008 solution and project files
udf_median.cc hacked to build with MySQL 5.0.45
*nix Makefile
Install/uninstall SQL scripts that (might) work with the Makefile

It also contains a compiled Windows binary with no warranty, support
or any claim of utility whatsoever. I encourage folks to build their
own since there is an increasing number of articles on how to do so.

Any feedback or commentary is welcome.


Regards,

Jeff

[Arnold Daniels]

Hi Jeff,

Can I ask you for a favor. Could you see if you can also build
lib_mysqludf_xql for windows. There is some demand to it, but I can't
even get my VM up working correctly to compile it. Well basically it's
just a lack of time I guess.

You can find a libxml2 build for for windows here:
http://www.zlatkovic.com/libxml.en.html.
lib_mysqudf_xql is here: http://mysqludf.com/lib_mysqludf_xql/

Thanks a lot,
Arnold

[Jeff Beard]

Hi Arnold,

I certainly understand a lack of time. ;) I'm happy to give it a try.
It might be helpful to know if you know if it's been successfully
built on Windows previously.

Regards,

Jeff

> > IJeff

[Arnold Daniels]

Hi Jeff,

Thanks a lot. I don't think lib_mysqludf_xql has ever been build for Windows. You'll be the first :).

Best regards,

[bb.james]

i have exactly the same problems jeff describe in his blog entry.
But his homepage is no more reachable.

Does any1 have mirror with the tricks what is different in VS 2008 and
maybe a Make for windows?

[Arnold Daniels]

Hi James,

No I'm, but I haven't. I've send Jeff an e-mail last week, but I haven't received a reply jet. Perhaps he's on holiday or just busy. One of my colleagues is a Windows C/C++ developer by origin, I'm going to ask him if he can get this done, at least for lib_mysqludf_xql.

Arnold

[Jeff Beard]

Just busy. Then I got sick. I'm better now but unfortunately I will be
very busy until at least the middle of next month so I won't have
time, Arnold, to try to get lib_mysqludf_xql functioning. (I did get
it to build but MySQL would not load the DLL. I am much better at C on
Unix than Windows but I don't program in that language very often
regardless.)

Sorry about the outage of my web site. It's available again.

I'll monitor this thread to see if anyone else figures out
lib_mysqludf_xql on Windows before I have some time.

Regards,

Jeff

[Arnold Daniels]

Hi Jeff,

Yes busy, if there ware just more hours... Anyway, no problem, but perhaps you could upload your VS project to the google group website.

Thanks,
Arnold

[Jess Balint]

Hi all. I've compiled the lib_mysqludf_xql library under Windows 2003
and MySQL 5.1.22. It seems to work ok with a few tests (just calling
lib_mysqludf_xql_info() and xql_element(), not the test suite). I've
created a very simple CMake build file for this (attached). A few
notes/questions:

What is the STANDARD macro for? I had to disable it to get the right
mysql headers included.

Where is "xor" (line 523) supposed to come from? I've just replaced it
with ^ which most likely isn't the intended operation.

Hope this helps.

Jess