GeoNotes Blog

Notes for myself and others

  • Benchmarking MySQL

     By John C. Zastrow

    Posted on April 22, 2011

    So I’m trying to figure which old machine to turn into a little mySQL number cruncher. So, I’m going to do some clean installs of Ubuntu server on each and run this little script (with the same my.cnf) and see how they fair. Perhaps you will this useful, run it... [Read More]

  • Run queries in sequence in Access

     By John C. Zastrow

    Posted on April 22, 2011

    I’ve gotten so used to using “real” databases, that I find myself frustrated when I have to switch back to Microsoft Access. But, hey, it’s good for a lot of things. [Read More]

  • Screen capture programs

     By John C. Zastrow

    Posted on April 22, 2011

    I always need to capture computer screens into graphic files. Even for my Mom who needs the occasional over-email tutorial. So here is a list of screen capture utitlities that I’ve used over the years. Snag-it is by far my tool of choice. But really, all will work. Do you... [Read More]

  • Tables of Tables from MySQL

     By John C. Zastrow

    Posted on April 21, 2011

    From Matthew Crowley on the MySQl forums (http://forums.mysql.com/read.php?101,8004), this php script will output a DESC of all databases and tables in MySQL. It needs some formatting for the output, but it works and might be handy later. I really just need to get around to figuring out how to do... [Read More]

  • MySQL Functions

     By John C. Zastrow

    Posted on March 31, 2011

    I just want to record these for future reference. I’m actually using the first now. [Read More]

  • ITIS Organism Flat table from MySQL

     By John C. Zastrow

    Posted on March 17, 2011

    I need to make a table to look up common (vernacular) names for some organisms. So I imported the USGS ITIS database from text files into MySQL and created this little view. Hopefully this helps someone else. [Read More]