Working in public
8th April 2023
I participated in a panel discussion this week for path to Citus Con, a series of Discord audio events that are happening in the run up to the Citus Con 2023 later this month.
The topic was “Working in public on open source”, and Citus developer (and pg-cron creator) Marco Slot and myself were interviewed by Claire Giordano and Pino de Candia.
The full hour-long audio conversation is now available on YouTube.
I ran it through Whisper to create my own transcript. Here’s my answer to a question about the benefits of working in public:
The biggest thing for me is that I never want to have to solve the same problem twice, ever.
That’s the most frustrating thing: when you sit down to solve a problem and you think wow, I solved this before and now I’m gonna have to waste my time figuring it out all over again.
A lot of the problems that I solve when I’m engineering are problems that can be captured in some kind of form. Maybe it’s a commit message with a commit that updates something. Maybe it’s a few notes. Maybe it’s just a sketch in an issue description of the approach that I was going to take.
I found that having those out there, just having those in a system massively increases my productivity. Defaulting to putting them in public, partly it’s sort of an insurance scheme.
I’ve worked for companies where I did everything in private. And then I left those companies and I’ve lost all of that work!
Everything that I do in public that has an open source license attached to it is just out there: I will never have to think about those things ever again.
That’s a problem that I’ve solved once and will never have to go back and revisit.
And I love that.
I feel like the work that I’m doing is constantly adding up to me having more capabilities and more tools in my tool belt.
It’s actually very selfish.
I have this website, my TIL website—and I just published my 400th note there.
And on the one hand, it is for other people, so that if somebody else needs to figure out how to copy a table from one SQLite database to another, and they do a Google search, they’ll land on my site, and it’ll solve the problem for them.
But mainly it’s for me.
The fact that I’m publishing causes me to increase the quality of the notes a little bit, so they make more sense to other people.
But it also means they make more sense to me when I come back in a year’s time and I’ve forgotten everything.
So yeah, I feel like you can actually be very selfish in your motivations and still do all of this stuff in public in a way that benefits other people.
Here are links to my posts that I referenced during the discussion:
More recent articles
- Weeknotes: Llama 3, AI for Data Journalism, llm-evals and datasette-secrets - 23rd April 2024
- Options for accessing Llama 3 from the terminal using LLM - 22nd April 2024
- AI for Data Journalism: demonstrating what we can do with this stuff right now - 17th April 2024
- Three major LLM releases in 24 hours (plus weeknotes) - 10th April 2024
- Building files-to-prompt entirely using Claude 3 Opus - 8th April 2024
- Running OCR against PDFs and images directly in your browser - 30th March 2024
- llm cmd undo last git commit - a new plugin for LLM - 26th March 2024
- Building and testing C extensions for SQLite with ChatGPT Code Interpreter - 23rd March 2024
- Claude and ChatGPT for ad-hoc sidequests - 22nd March 2024
- Weeknotes: the aftermath of NICAR - 16th March 2024