So in the spirit of this community and not just to focus on the Reddit... issues... I thought it might be nice to get a topical conversation going in here.
Basically, what open source projects are you currently working on or are you heavily involved with?
I think it would be nice to see what projects people have on the go, get some publicity out there and otherwise talk about stuff that we should be discussing here.
I work on Apache Superset for my day job, it's a BI tool for data exploration and visualization. It's a big project with 100+ committers, so a lot of the challenges are about managing people and communicating effectively.
DJ is a "metrics platform that allows users to define metrics and the data models behind them using SQL, serving as a semantic layer on top of a physical data warehouse." The project is still in its infancy but growing fast.
My favorite project is shillelagh, a Python library that lets you query APIs using SQL, eg:
SELECT *
FROM "https://docs.google.com/spreadsheets/d/1_rN3lm0R_bU3NemO0s9pbFkY5LQPcuy1pscv8ZXPtg8/edit#gid=0"