Reading PCAP Files (Directly) With DuckDB

Reading PCAP Files (Directly) With DuckDB

| | duckdb, pcap
We generate a ton of PCAP files at $DAYJOB. Since I do not always have to work directly with them, I regularly mix up or forget the various tshark, tcpdump, etc., filters and CLI parameters. While this is less of an issue in the age of LLM/GPTs (just ask local ... Read More

Resolve Bluesky/ATproto Handles To did:plc

| | bash, bluesky
Short post just to get the internets to index that I posted a repo with a small Bash script I’ve been using to resolve Bluesky/ATproto handles (like hrbrmstr.dev) to did:plc identifiers. Not sure why I did do this ages ago tbh. Code is here but it’s small enough to include ... Read More

Where Do We Go From Here?

| | Commentary
Christian nationalists, the GOP, clueless Dems, & SCOTUS have done quite a bit of real, serious damage to the fragile state of democracy & discourse in the U.S. They’ve also set back over 70+ years of hard fought advancements at record speed. It’s a big, complex problem to solve, and, ... Read More
The image displays three newspaper front pages featuring headlines about the conviction of former President Donald Trump. 1. **The Wall Street Journal**: The headline reads "Trump Convicted" with a subheadline stating, "Verdict Shakes Up Presidential Campaign." The date is Friday, May 31. A large photo of Trump looking down with a serious expression accompanies the article. 2. **USA Today Weekend**: The headline reads "Trump Guilty" with a subheadline stating, "Historic verdict: Trump is first former president convicted in a criminal case." The date is Sunday, June 2. The main photo shows Trump in a courtroom, seated and flanked by security personnel. 3. **The New York Times**: The headline reads "Guilty" with a subheadline stating, "Jury Convicts Trump on All 34 Counts." The date is Friday, May 31. A large photo of Trump looking directly at the camera with a stern expression is featured. Each newspaper front page emphasizes the historic nature of the conviction and its potential political ramifications.

Disgraced, Twice Impeached, Former President Joins His Long List Of Campaign And Administration Officials And Advisors As A Convicted Felon

| | Commentary
Wake the heck up, 🇺🇸. This is the company the dude +40% of you want to give the keys to the country again kept. Crooks hang with crooks. I don’t know about y’all, but I like candidates for U.S. President who haven’t been convicted of a felony. Here’s the list ... Read More

CVE-2024-27322 Should Never Have Been Assigned And R Data Files Are Still Super Risky Even In R 4.4.0

| | R
I had not planned to blog this (this is an incredibly time-crunched week for me) but CERT/CC and CISA made a big deal out of a non-vulnerability in R, and it’s making the round on socmed, so here we are. A security vendor decided to try to get some hype ... Read More

Get A Day’s Schedule From Fantastical On The Command Line With Shortcuts

| | macos, programming
I use Fantastical as it’s a much cleaner and native interface than Google Calendar, which I’m stuck using. I do like to use the command line more than GUIs and, while I have other things set up to work with Google Calendar from the CLI, I’ve always wanted to figure ... Read More

VulnCheck’s Free Community KEV & CVE APIs (Code & Golang CLI Utility)

VulnCheck has some new, free API endpoints for the cybersecurity community. Two extremely useful ones are for their extended version of CISA’s KEV, and an in-situ replacement for NVD’s sad excuse for an API and soon-to-be-removed JSON feeds. There are two ways to work with these APIs. One is retrieve ... Read More

Three Years After January 6th: The Insurrection’s Impact on U.S. Democracy

| | Commentary, Democracy-2024
Three years ago, on January 6, 2021, the U.S. Capitol was stormed by a mob intent on overturning the results of the 2020 Presidential Election. This event — the January 6th insurrection — was a direct attack on the democratic process and the peaceful transition of power, a cornerstone of ... Read More

Democracy 2024: Stakes vs. Horses

| | Commentary, Democracy-2024
The 2024 U.S. Presidential election isn’t just another tick on the political timeline. It’s a crucial juncture for — quite literally — the future of American democracy. We’re not just deciding who gets to sit in the Oval Office for the next four years. We’re determining the trajectory of our ... Read More
Welcome To 2024

Welcome To 2024

| | Commentary, Democracy-2024
Hey folks, This is likely our last shot at preserving liberal democracy in the U.S., or at least avoiding 20–40 years of abject horribleness by wannabe bigoted and sociopathic demigods. The year 2024 is also set to be a significant year for global politics, with a large number of critical ... Read More