Colin Copeland
Colin co-founded Caktus in 2007. As Chief Technical Officer, he helps ensure that Caktus remains at the forefront of the open source community. He regularly implements services and products to better serve clients. He loves coding and still actively works on client projects, often as lead developer.
A proponent of automated testing and continuous integration, Colin is always researching best practices and creating efficiencies to improve deployment processes and provide outstanding support for Caktus clients. He particularly enjoys working on social innovation projects, some of which he’s become involved with through Code For Durham, a civic hacking brigade, which he helped to found around 2013.
One of Colin’s favorite, long-term projects was building the Open Data Policing NC website for the Southern Coalition for Social Justice, which displayed North Carolina police stop data. As a result of the project, Colin was invited to the White House Police Data Initiative in 2016 to share his ideas on how to ensure law enforcement transparency and accountability. In 2020-2021, Colin worked to relaunch the Open Data Policing NC website as NC Cop Watch. It draws on public records to publish up-to-date stop, search, and use-of-force data — broken down by race and ethnicity.
When Colin isn’t working on client projects, he continues to be motivated by volunteering through Code for Durham. He also enjoys baking, playing piano, and spending time with his family.
Hear more about Colin, his background, and his interests in this Modern CTO podcast and the DjangoChat podcast. You can also connect with him on GitHub, LinkedIn, and Twitter.
2023
Migrate to Amazon EKS Add-ons
Amazon Elastic Kubernetes Service (Amazon EKS) released support for operational cluster add-on software, or Amazon EKS add-ons, around Kubernetes version 1.19 in May 2021. These include:
Update an Amazon EKS cluster Kubernetes version to 1.23+
Introduction
Caktus is committed to developing and maintaining high-quality web applications for clients, so we focus on software sustainability. Software sustainability refers to the ability of software to continue to function as expected over time, even as hardware and software environments change. It involves maintaining and updating software to remain reliable, secure, and compatible with new hardware and software technologies. Additionally, from a security perspective, attackers can exploit software vulnerabilities to gain unauthorized access to systems or data. Keeping software up-to-date with the latest security patches helps to reduce the risk of these vulnerabilities being exploited.
Analyze data with SQL window functions
We regularly use tools like PostgreSQL, Pandas, and Jupyter Notebooks to analyze data here at Caktus. Recently, we were reviewing North Carolina traffic stop data for the NC CopWatch project and had the opportunity to use PostgreSQL's window functions, which are helpful when aggregating data.
Reflection on DjangoCon 2022
Ronard’s Recap
“It takes a village” the African proverb goes. Nowhere was this as apparent as in DjangoCon. It was my first technology conference and my experience could not have been better. People from the most senior developer to fellow juniors and even one of the co-creators of Django made the experience feel warm and inviting. Perhaps knowing that you are surrounded by introverts alleviates the social pressure, knowing that everyone has a common interest, or perhaps even love for programming also brought a soothing feeling to the experience.
2021
Python, Django, and React Development on Apple Silicon
Last year, Apple announced that they would transition their entire Mac line from Intel processors to their ARM64 Apple Silicon chip called the M1. Several weeks ago, I started testing development on MacBook Air with the Apple M1 chip (pictured above).
2020
How to Use Kubernetes on Azure for Cloud Computing
For the Review, Appraisal, and Triage of Mail (RATOM) project, funded by the Andrew W. Mellon Foundation, we were tasked with deploying to a Microsoft Azure environment. More details about the project are in our first blog post in this Learn With Us blog series. Caktus has experience with Amazon Web Services (AWS) and Google Cloud, but we hadn't had the opportunity to use Azure yet, so we looked forward to the opportunity to use that environment and document our experience. The entire deployment process is available on GitHub as a reference under the StateArchivesOfNorthCarolina/ratom-deploy repository.
2019
How to Import Multiple Excel Sheets in Pandas
Pandas is a powerful Python data analysis tool. It's used heavily in the data science community since its data structures make real-world data analysis significantly easier. At Caktus, in addition to using it for data exploration, we also incorporate it into Extract, Transform, and Load (ETL) processes.
Our Favorite PyCon 2019 Presentations
Above: A view of the busy exhibit hall. Photo copyright © 2019 by Sean Harrison. All rights reserved.
PyCon 2019 attracted 3,393 attendees, including a group of six Cakti. When we weren’t networking with attendees at our booth, we attended some fascinating presentations. Below are some of our favorites. You can watch these talks and more on the PyCon 2019 YouTube channel.
2018
Love Your Bugs (PyCon 2018 Must-See Talk Series)
Welcome to the 2018 edition of our annual PyCon Must-See Series, highlighting the talks our staff especially loved at PyCon. While there were many great talks, this is our team’s shortlist.
2017
Ship It Day Q1 2017
Last Friday, Caktus set aside client projects for our regular quarterly ShipIt Day. From gerrymandered districts to RPython and meetup planning, the team started off 2017 with another great ShipIt.