• Using KML to define Geofences

    I’ve written about geospatial alerting in previous posts.  Here’s a fun example where we drive Philips Hue lighting changes based on geofence definitions driven by a mobile device’s GPS. Demo Overview: MarkLogic will be configured to accept KML with colored polygons as a description of geofences Each supplied geofence will...

  • Hacking my Sonos

    The previous project of controlling the lights in my living room with REST calls has given me an idea for a home automation project which will probably get written up here over a few more posts.  Next step … controlling my sound system!  As reverse-engineering practice, I decided to do...

  • Controlling Philips Hue with XQuery

    Playing around with a set of Philips Hue light bulbs.  Turns out you can control them with simple REST calls. l-mlhue.xqy library on github Simple Controller: xquery version "1.0-ml"; import module namespace lh = "http://derickson/lib/l-mlhue" at "/lib/l-mlhue.xqy"; for $i in (1 to 10) for $state in ( $lh:RED, $lh:MAGENTA, $lh:PURPLE,...

  • Kettles, Spoons, Kitchens, and Jobs

    Using Kettle – Spoon ETL tool to move data from an RDBMS to MarkLogic Don’t get me wrong.  My ETL-fu is strong.  Give me some SQL, XQuery, Java, Perl, and Python and I am a dangerous man when it comes to rapidly taking data out of your beloved RDBMS silo...

  • ‘Best’ advice from boss I’ve ever received

    Me: After reading up on , I had the feeling that I was slightly ambushed . My Boss: Just remember standard tactics for an ambush—charge directly into the weakest group among the attackers, without waiting for orders from your leadership, who are probably already dead.