Apps I'm Taking into 2019

I should probably start off with a bit of a caveat.

image of Steve Jobs calling all categories of computer program an app.

Okay. Now that we have that out of the way, here are a few of the apps that I’ve discovered over the last 365 days that I’ll be taking with me into 2019.

PyCharm is a Python IDE with an extensive collection of plugins. I’m using the community edition to develop Python scripts in support the Consortium of Ohio Libraries, mainly to interact with the Evergreen ILS. PyCharm includes a useful testing suite and refactoring tools, while also providing straightforward integration with GitHub and seamless implementation of pipenv virtual environments. Simple on-boarding for new python developers, but feature rich and extensible as your needs grow.

Essentially, a terminal replacement for the native terminal application that shipped with my MacBook Pro. I find the ability to split terminal panes both vertically and horizontally an advantage for different tasks. I’ve also made use of the integrated search feature quite a bit. With colorized output, it’s beautiful to use. There are also a slew of other powerful features that I rarely make use of (in 2018, at least).

Sequel Pro
A MacOS native application for interacting with MySQL and MariaDB and a replacement phpMyAdmin. Enough said.

DB browser for SQLite
Open source application to create and edit SQLite database files. My main use case is to import Excel worksheets and be able to execute SQL commands on the data. Maybe more importantly is the ability to import multiple Excel worksheets, join them together, and query across them. This tool said me quite a bit of time when working with the Academic Library Association of Ohio (ALAO) this past year.

A web browser built on Chromium and the Blink rendering engine, a fork of WebKit. It’s my drop-in replacement for Google Chrome at the moment.

Oh My Zsh
I’ve abandoned Bash and began using the Z shell on my MacBook Pro. I’m a very big fan of the available themes, which have assisted with git workflow and generally made working in the terminal a much more pleasant and enjoyable experience. Highly recommended.

A Python-based SIP 2 client that has been invaluable this year. I’ve used this tool for testing SIP connectivity during the statewide implementation of, while establishing authentication for the Ohio Digital Library, for new subscriptions to Hoopla, and also while implementing a PC management system at one on the COOL libraries. Outstanding little application.

Library Systems Analyst

Focusing on cultural heritage institutions: discovery applications, data (and metadata) wrangling, web development, process automation, and system integration.