Day: August 28, 2003

  • Problems with Gadfly (Python 2.3/Win32)

    Hmm, I seem to be banging my head against the wall here.  I’ve been looking at Gadfly, a python database that supports a subset of SQL.  I haven’t tested it against other versions of Python on other platforms, but I’m having some issues with it under Python 2.3 on Win32.  Here’s a code snippet copied and pasted from the Gadfly documentation:

    import gadfly
    connection = gadfly.gadfly()
    connection.startup("mydatabase", "./")
    cursor = connection.cursor()
    cursor.execute("create table ph (nm varchar, ph varchar)")
    cursor.execute("insert into ph(nm, ph) values ('arw', '3367')")
    cursor.execute("select * from ph")
    for x in cursor.fetchall():
      print x
    # prints ('arw', '3367')

    The only problem is, here’s what I get as output:

     ('3367', 'arw') 

    A simple reversing wouldn’t be too hard to deal with, but in a more complex situation, I had an ID field first that was ending up somewhere in the middle during output.  It definately wasn’t the order that I was expecting.

    Any thoughts?  At first I thought that I was doing something horribly stupid, but I’m supposed to get one answer and I’m getting another! 🙂

  • Geolocation in Radio Userland and Movable Type

    Mikel Maron has released a tool for embedding geolocation data in an RSS feed.

    For the record, there is already an RSS module that does the same thing: the ICBM RSS Module.  It can be applied to entire feeds and/or single entries.

    Update: Thanks to Jim [old blog new blog] for pointing out MTLocation, which allows you to geolocate your Movable Type blog.

    Another Update: I got an email from Mikel.  He’s going to look into using the ICBM module.  Cool!

  • RSS Geek

    You know you’re a geek when a friend asks you to drop him a line, and you get it via RSS.

  • Low Power, Low Connectivity

    Ack! Thunder storms suck!