I'm a software developer living in a haunted mansion in Chicago. I'm originally from Silicon Valley, a fact that I am both proud and ashamed of.
My pronouns are he/him/his; my website is evanhahn.com; my musical taste is embarrassing.
Just learned #SQLite allows empty table names:
CREATE TABLE '' (foo TEXT);
INSERT INTO '' (foo) VALUES ('test');
SELECT * FROM '';
More broadly, you can name a SQLite table almost anything, even things like "DROP TABLE users;".
My employer, #Signal, just announced our new President.
Official blog post: https://signal.org/blog/announcing-signal-president/
Washington Post coverage: https://www.washingtonpost.com/technology/2022/09/06/signal-meredith-whittaker/
"The Humiliating History of the TSA" https://www.theverge.com/c/23311333/tsa-history-airport-security-theater-homeland
"Tech tool offers police 'mass surveillance on a budget'" https://apnews.com/article/technology-police-california-arkansas-d395409ef5a8c6c3f6cdab5b1d0e27ef
"Use Node built-ins to test small projects" https://evanhahn.com/use-node-builtins-to-test-small-projects/
What would an ideal fediverse organization do?
GitHub removes promise not to track you
"The Internet Is Broken. How Do We Fix It?" https://www.nytimes.com/2022/05/27/opinion/technology/what-would-an-egalitarian-internet-actually-look-like.html
First-ever Gitea comment on an issue from a remote instance!!! 🎉
"...in 2020, firearm-related injuries became the leading cause of death" for people between 1 and 19 in the US. https://www.nejm.org/doi/full/10.1056/nejmc2201761
"In this post I argue that integration-vs-unit is a confused, and harmful, distinction. I provide a more useful two-dimensional mental model instead." https://matklad.github.io/2022/07/04/unit-and-integration-tests.html
(Mostly positive) COVID news
"COVID vaccines saved 20M lives in 1st year, scientists say" https://apnews.com/article/covid-science-health-england-54d29ae3af5c700f15d704c14ee224b5
"Telegram Founder Pavel Durov Owes Me a Million Dollars" https://www.pcmag.com/opinions/telegram-founder-pavel-durov-owes-me-a-million-dollars
"We see very strong results from the urine." https://www.nytimes.com/2022/06/17/climate/peecycling-farming-urine-fertilizer.html
bigshoulders.city is a Mastodon instance for Chicagoans current, former, and future. Its name comes from Carl Sandburg, who once compared ships pulling out to “mastodons, arising from lethargic sleep.” Our goal for bigshoulders.city is to build a community of friends and neighbors across the Windy City. Toot your pho place recommendations, meet-up ideas, pothole gripes, creative dibs, and cross-town baseball taunts—whatever you want, as long it abides by our short and sweet content policy.