★ Favorited https://kylewm.com/2017/06/in-case-you-were-wondering-why-woodwind-xyz-and-silo
post from
In case you were wondering why woodwind.xyz and silo.pub were down for ages, the database had finally filled up the disk. I eventually willed myself out of entropy and wrote a cron job to delete entries older than a year (or more than 2000th in their feed, from e.g. twitter-atom) DELETE FROM entry USING ( SELECT id, ROW_NUMBER() OVER (PARTITION BY feed_id ORDER BY retrieved DESC) AS row FROM entry ) AS numbered WHERE entry.id = numbered.id AND (row > 2000 OR retrieved < CURRENT...
In case you were wondering why woodwind.xyz and silo.pub were down for ages, the database had finally filled up the disk. I eventually willed myself out of entropy and wrote a cron job to delete entries older than a year (or more than 2000th in their feed, from e.g. twitter-atom) DELETE FROM entry USING ( SELECT id, ROW_NUMBER() OVER (PARTITION...
Replied to https://werd.io/2017/if-only-there-was-a-way-to-share-portions-of
post from
If only there was a way to share portions of the #indieweb audio newsletter ... cc @jimpick

It’s possible, although there is no UI for it. My site supports media fragments on the URL like #t=[start],[end] in seconds to limit playback!

About to kick things off at #IndieWebSummit

📍 Checked in at Mozilla Portland, Portland, OR.
#IndieWeb Summit day 1! Excited to have some good discussions with some fun people!
★ Favorited https://gregorlove.com/2017/06/marty-this-is-that-security/
post from
@Marty: This is that security at Standing Rock session I was talking about: https://www.linuxfestnorthwest.org/2017/sessions/security-resistance-camps-lessons-standing-rock
📍 Checked in at Pine Street Market, Portland, OR.
IndieWeb Summit Pre-Party, woo!
📍 Checked in at Mozilla Portland, Portland, OR.

This Week in the IndieWeb Audio Edition • June 17th - 23rd, 2017

Audio edition for This Week in the IndieWeb forJune 17th - 23rd, 2017.

You can find all of my audio editions here.

You can subscribe with your favorite podcast app on huffduffer.

Music from Aaron Parecki’s 100DaysOfMusic project: Day 48 - Glitch, Day 49 - Floating, Day 9, and Day 11

Thanks to everyone in the IndieWeb chat for their feedback and suggestions. Please drop me a note if there are any changes you’d like to see for this audio edition!

📍 Checked in at Prasad Cuisine, Portland, OR.
IndieWeb Leaders meeting over. Time for lunch!