About Me
I’ve worked several jobs since graduating University, the most notable being my last job as a Technical Writer for MySQL AB. I’ve spoken at every MySQL User Conference since the first conference in 2003, on subjects from VB6 development with MySQL to Managing Data Hierarchies.
Until recently I was a resident MySQL Expert for Techtarget’s SearchOpenSource.com site, I position I retired from when I left MySQL AB and became busy with other things.
I am one of the top ranked MySQL experts at Experts-Exchange, a site for providing advice to fellow developers.
I currently work as a Sales Engineer for Message Systems, a division of OmniTI Computer Consulting.
November 4th, 2006 at 3:48 pm
Hi,
I am looking for code samples of how to implement an embedded MySQL Server with a VB6 Application. Sure we could do the whole thing in any C Flavour, but there has already been much time invested in the non DB Part of the App. ( Questionaire Analysis with OMR OCR and ICR ).
Many Thanks
Thomas Hoebelt
Imaginative
January 27th, 2007 at 4:07 pm
Thanks alot for this great article:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
Helped me understand a whole bunch more of the nested set model. Keep it up!
/J
September 11th, 2007 at 10:15 pm
Hi,
Wanted to thank you for the great article mentioned by previous poster, John B, too. I find it really easy to understand for the people that had never heard of ways to store hierarchical data in a relational database. The examples and how is the information offered to the reader is just perfect. Thanks a lot!
Got one question. I tried hard to find available solution, an MySQL function or a working set of operations, to move trees around from one parent under another with no luck. I understood it’s the most complicated part of management but isn’t there any available working solution? The only thing I could find was a couple of implementations in PL/PgSQL ( http://svr5.postgresql.org/pgsql-sql/2002-10/msg00392.php , http://archives.postgresql.org/pgsql-sql/2002-11/msg00358.php ). So is the only option to fix these (as far as I understood the first one is more reliable) to become MySQL compatible? It’s a pity that would require me to learn some PL/PgSQL.
Thanks in advance,
VL
October 17th, 2007 at 4:57 am
Hi Mike:
I believe you authored a book, “MySQL Windows Development and Administration by Mike Hillyer.”
I can’t seem to find it for sale anywhere!
Can you tell me where I might be able to purchase a copy?
Thanks!
John Goette