Five things I taught at #VALATechCamp

A couple of weeks ago (only a couple of weeks?!) I was a part of the 2019 VALA Tech Camp, a two-day event in Melbourne for tech-inclined librarians and library-inclined techies. Usually these posts are a variation on ‘Five things I learned at [event]’, but this time I actually did some of the teaching, so here are five things I taught. It was a very different experience to the 2017 Tech Camp—I definitely learned some things as well…

OpenRefine is magic! Been there, done that, wore the t-shirt. I presented a three-hour workshop on OpenRefine, the world’s greatest free and open-source data cleaning and editing program, to upwards of 37 keen participants. Assisted by the unbelievably calm Alexis Tindall, who had generously agreed a few weeks earlier to help a total stranger, I took our intrepid data wranglers through the main features of OpenRefine: importing and exporting data; faceting, filtering, clustering and editing data; transforming data using inbuilt scripting language GREL; and reconciling data against an external source. I demonstrated on both a CSV file and a gently-massaged MARC file, thinking participants could possibly use OpenRefine for both file formats.

I learned a heck of a lot about OpenRefine in the course of writing the workshop slides and teaching materials. (You can view them on this GitHub repository.) It was a privilege to be able to share this knowledge with others, even if I spoke too quickly and seemed a touch nervous. Everyone was keen to learn, asked lots of questions, and looked like they got something out of the session, which is exactly what I had been hoping for.

‘I don’t know. But I will find out, and get back to you.’ The first step towards learning is to know that you don’t know something, right? It’s okay to not know things. I stated at the outset that neither Alexis nor I were experts, and that I was here in the spirit of peer-based learning. If you know the thing, you can teach the thing, etc. Though this was not a formal Library Carpentry workshop, I was inspired by the Library Carpentry ethos of peer-based learning, as introduced to me by Carmi Cronje and Fiona Jones at the LC workshop at NLS8. To think that was my first experience of OpenRefine, less than two years ago, and here I am teaching a workshop of my own… it’s been a wild ride.

As it happened, a couple of people asked questions I didn’t immediately have the answers to. I managed to answer one during the workshop, to the delight of the asker, while the other two are still awaiting my email. (Sorry! I am bad with email! I will get back to you, I promise!)

We can do the thing! (But we probably shouldn’t have.) Hugh and I both presented workshops while also being on the organising committee. I think we separately realised that trying to do both was a very bad idea, and that future committee members should not be allowed to do this. At the time, offering to run the workshop myself seemed easier than asking someone else to do it. I know better now!

Tech Camp was my first experience on an organising committee of this kind. It was also my first experience presenting a formal workshop or talk to a paying audience. I had never done either of these stressful things before, and here I was doing both of them at once. Did I mention I have an anxiety disorder? Fellow committee member Matthias remarked ‘You were playing on hard mode!’ and while I hadn’t thought of it that way, I definitely made it harder for myself than I needed to. I referred in 2017 to ‘the Herculean efforts of the organising committee’—I no longer consider this hyperbole. Running the 2019 camp has been a tremendous learning experience, and it’s opened a few doors for me professionally, but my stress levels were absolutely unreal. I think I could have managed solely being a committee member, or solely presenting a workshop (just). I barely managed to do both.

But I did everything I could. I lunched in the breakout room, I took my meds beforehand, people recognised when I needed company and also when I needed space, and overall it wasn’t a total disaster. To the extent I could control my symptoms I recognised that freaking out would accomplish nothing, so instead I tried to approach the workshop like a wave. It was gonna come anyway, and it would engulf me, and I would feel like drowning for a brief second, and then it would be over, and the sun would still be shining. Just let it crash over me. Just let it happen.

This is for the benefit of those who saw me present and perhaps thought I was handling things just fine. I’m told I looked a lot less stressed than I felt, which is… handy, I guess, but I’m not in the habit of airbrushing.

Our speaker / committee gifts were little cartoon avatars of ourselves. I love mine because thanks to the rosy cheeks it looks really stressed, and therefore quite lifelike.

Just say no to mornings. You may have noticed I was meant to emcee the morning session on day 2 but mysteriously failed to appear. I was late and missed the start, meaning someone else had to fill in, and was so embarrassed I hovered in the foyer until the session was over. This was a fail on my part, but also hopefully it’ll teach event organisers not to expect anything of me until after 9am. (To my relief, my next speaking commitment at NLS9 is scheduled for after 11am. I am so not a morning person.)

I did an SQL thing! This is me cheating and using an ‘I taught myself’ literary device, haha. Having finally dispensed with my teaching responsibilities on day 1, I resolved to learn more things on day 2. The other workshop I attended was on SQL, by Arjen Lentz and Donna Benjamin. I had a feeling I would like SQL if only I had an idea of how to use it, and this workshop was a great introduction. Being a native English speaker, the syntax of SQL just makes sense, as it’s designed to.

I was particularly tickled by Arjen setting the scene with a very quick introduction to set theory. I inexplicably spent a term in year 7 learning set theory, ostensibly because my school had run out of space for all the fun electives and threw two classes’ worth of smart kids in extension maths instead. Until this session it had never once been useful. Now, suddenly, sixteen years later, it was exactly what I needed to know! And it was useful because SQL requires you to envision a particular data structure in order to query it, to hold a table in your head even if it’s not graphically represented. Including or excluding aspects of that dataset entails using terms like LEFT JOIN, which make more sense if you think of data as being inside or outside a set. Or a venn diagram.

I thought it worth looking back at my experiences of the 2017 Tech Camp and comparing them with this year’s. Obviously I was a lot greener around the edges two years ago, and a close reading suggests I gained just as much in worldview expansions as I did in practical tech skills. Some of our short talks this year, such as Katrina Grant on digital mapping and Adam Bell on digital preservation, were aimed at showing attendees what is or might be possible. I did learn less this year, simply because I taught more (and stressed more), but even though I’ve had a library degree for less than six months I already feel less like a ‘n00b’ (as I described myself) and more like a newly-established technical librarian. After all, new professionals tend to be the ones attending workshops, not teaching them.

I love how past me wrote, in closing:

On a much smaller scale, I found myself much more able to get out there and do things I find really difficult. Yes, I can go and make small talk to people! Yes, I can summon the courage to thank people for writing things that have meant a lot to me! Yes, I can do the thing! Yes I can.

I’m still no good at small talk, but I did succeed at far bigger things, and I am proud of myself. This was really difficult and a steep learning curve, and yet I still managed to do the thing. I could not have done it without the help and support of the Tech Camp committee, the VALA Secretariat, my helper Alexis, my poor colleagues who sat through an in-progress version of the workshop and didn’t say it was dreadful, and the workshop attendees who took the materials and ran with them. Yes, I can do the thing. Yes I can.

Yes I can.

On exhaustion

A stack of post-its saying Do Less
via @hugh@ausglam.space

I am tired.

Most days I get enough sleep, eat a reasonable breakfast, get to work on time, look and feel on the surface like I’m awake, but it’s only a shell. It’s been a tough year. I’ve started a new job, I’ve been sick a lot, and I still can’t stop saying ‘yes’ to things.

When I’m in the right headspace, everything is doable, and I proudly tell people that I’d love to get things done for them. But when I’m in the wrong headspace, everything feels insurmountable, and I don’t want to tell people that because it makes me look like a fraud. I have little to no control over what headspace I wake up in on any given day. I can’t tell you how frustrating this is.

I have a lot on my plate at the moment. Most of it is library-related. I love what I do, and I wouldn’t have it any other way. I can’t talk about everything I’ve volunteered my time for, but I’m on a few LIS committees, I have three (!) conference / PD event presentations scheduled in the first half of next year, I do a lot of cataloguing reading and research, and I participate in a couple of miscellaneous LIS projects. I say this not to boast, nor to complain, but rather as an illustration of what happens when I say ‘yes’ to everything, because I’m still a little stunned that people ask me to do anything at all.

The problem is that whenever I look at my never-ending to-do list, my short-circuiting brain misinterprets ‘these are things you need to do’ as ‘these are things you need to do RIGHT NOW’. Consequently I panic a lot about how much I haven’t done. The problem is, as usual, a lack of temporal perspective. Some of the things aren’t due for another six months. They can wait. Other things are due last week, so they need more urgent attention.

Did I mention how much I love what I do? I mean this sincerely. I can’t think of anything else I’d rather be doing with my life. But I’m beginning to reach some hard limits on how much I can achieve as an individual. I resent these limits (because who doesn’t want to do all the things?!) while recognising that they are necessary (because we can’t do any of the things if we’re completely exhausted).

Shira Peltzman shared this wonderful flowchart with me, outlining how she decides whether to say yes or no to a professional opportunity. I’ve found it really helpful in evaluating all the things I’ve recently said ‘yes’ to, and whether I should perhaps have made other decisions. The flowchart is also Creative Commons-licensed so you can print it out and stick it next to your desk. Note that most of the arrows point to saying ‘no’. I think I’ll be referring to this flowchart a lot.

There’s a great Mastodon bot called Wollstonecraft BOM, a weather bot for a Sydney suburb I have never been to. Every few hours it spits out some weather data and a forecast, but it also includes a lovely little platitude at the end as a mood-booster, and I follow the account purely for this reason. While I was drafting this post a week ago it said to me, ‘You’re doing the best you can, and good people know it.’ I try to remind myself of this a lot, that I am doing the best I can, even if some days that best is not very good.

Part of me wanted to spike this blog post, that being tired isn’t a good look, professionally. But I want to talk about this stuff. It’s important that we aren’t all hiding behind veneers of perfection, telling the world we have it together while over-caffeinating ourselves into oblivion1, because not talking about being tired is part of how we all became tired in the first place. By admitting our exhaustion, we recognise that things aren’t quite right, and we begin the difficult process of balancing ourselves.

Recently I was made an offer. Quite a good offer. And my response, after considerable thought, was ‘Yes… but’. I never used to ask for concessions or amendments, and I’m not a natural negotiator, but reaching hard limits necessarily entails making sure I don’t exceed them. I’m a little impressed with myself, and very grateful that the offerer was prepared to accommodate me.

I’m still tired, but now I’m looking forward to next year because of all the things I’ve said ‘yes’ to, not in spite of them. I hope this means I’ll find myself in better headspaces, where more good things can happen. 🙂


  1. I was recently forced to give up caffeine cold-turkey for medical reasons. I miss Lady Grey tea really quite a lot, but I think not being able to push myself beyond my natural limits has actually helped me recalibrate. This is a personal view. Your mileage may vary.