Introducing SQL to Evergreen administrators, round two

Posted on Sat 16 February 2013 in Libraries • Tagged with Evergreen, PostgreSQL, evergreen, postgresql

Three years ago I was asked to create and deliver a two-day course introducing SQL to Evergreen users. Things went well and I was able to share the resulting materials with the Evergreen and PostgreSQL community. Perhaps one of my happiest moments at the Evergreen conference last year was when …


Continue reading

Introducing version control & git in 1.5 hours to undergraduates

Posted on Sun 20 January 2013 in misc • Tagged with Coding, coding

Our university offers a Computer Science degree, but the formal curriculum does not cover version control (or a number of other common tools and practices in software development). Students that have worked for me in part-time jobs or summer positions have said things like:

if it wasn't for that one …

Continue reading

Triumph of the tiny brain: Dan vs. Drupal / Panels

Posted on Thu 18 October 2012 in misc • Tagged with Coding, Perl, PostgreSQL, coding, perl, postgresql

A while ago I inherited responsibility for a Drupal 6 instance and a rather out-of-date server. (You know it's not good when your production operating system is so old that it is no longer getting security updates).

I'm not a Drupal person. I dabbled with Drupal years and years ago …


Continue reading

Seek and ye shall find: full-text search in PostgreSQL

Posted on Tue 18 September 2012 in Databases • Tagged with PostgreSQL, postgresql

I'm at PostgresOpen in Chicago, and just gave my talk on Implementing full-text search in PostgreSQL. The goal was to give novice users the understanding and examples they needed to build a workable search solution using PostgreSQL's full-text search. And it went (in my opinion) well - an almost full room …


Continue reading

Leaving SELinux in enforcing mode with Evergreen on Fedora 17

Posted on Sun 02 September 2012 in Libraries • Tagged with Evergreen, evergreen

Ever since I switched over to Fedora a few years back (hi Fedora 13!), I've been guilty of a dirty secret: to run Evergreen, I've had to run setenforce 0 to disable the most excellent SELinux security policies before I could start up the Apache web server to serve up …


Continue reading

Finding DRM-free books on the Google Play store

Posted on Wed 01 August 2012 in misc • Tagged with Coding, coding

John Mark Ockerbloom recently said, while trying to buy a DRM-free copy of John Scalzi's Redshirts on the Google Play Store: “The catalog page doesn’t tell me what format it’s in, or whether it has DRM; it instead just asks me to sign in to buy it.” I …


Continue reading

Enabling mod_wsgi with LDAP access under Fedora 17

Posted on Wed 11 July 2012 in misc • Tagged with Evergreen, evergreen

Continuing my path of new problem to solve = opportunity to try something new, I opted to give web.py a shot as a Web front-end for an existing script I had put together to provision users in our Evergreen library system based on their LDAP entry. The goal was to …


Continue reading

First Go program: converting Google Scholar XML holdings to EBSCO Discovery Service holdings

Posted on Mon 11 June 2012 in Libraries • Tagged with Coding, coding

Update 2012-06-19: And here's how to implement stream-oriented XML parsing

Many academic libraries are already generating electronic resource holdings summaries in the Google Scholar XML holdingsformat, and it seems to provide most of the metadata you would need to provide a discovery layer summary in a nice, granular format …


Continue reading

Running libraries on PostgreSQL: PGCon 2012 talk

Posted on Sun 20 May 2012 in Libraries • Tagged with Evergreen, PostgreSQL, evergreen, postgresql

On Friday, May 18th I gave a talk at the PGCon 2012 conference on the use of PostgreSQL by the Evergreen project. My talk fell in the case study track, which meant that I had been asked to describe to PostgreSQL developers what Evergreen was, why it was a project …


Continue reading

The State / Stats of Evergreen development: 2011-2012

Posted on Mon 30 April 2012 in Libraries • Tagged with Evergreen

On Thursday, April 26, I was part of The State of Evergreen talk, organized by Grace Dunbar, that also included sections by the dynamic combo of Kathy Lussier, Ben Hyman, and Tara Robertson. We opened the Evergreen 2012 conference and lead into the day's featured keynote speaker Mr. Jono Bacon …


Continue reading