Aaron Parecki

whoa that is some serious smoke, I can't believe they still want to fly in that

my problem was I couldn't even figure out how to ask this with words so I wasn't sure what to search for!

Nice!

Apparently EXTRACT(DATE FROM col) doesn't exist in MySQL, but DATE(col) works instead. So:

SELECT DATE(date) AS date, SUM(success) AS success, SUM(IF(success, 0, 1)) AS fail
FROM results GROUP by 1 ORDER BY 1 DESC;

That was fast, we have a winner!

SELECT `date`, SUM(IF(success, 1, 0)) AS `success`, SUM(IF(success, 0, 1)) AS `fail`
FROM `results` GROUP BY `date`

https://twitter.com/jkphl/status/1570804284060475392

Yep it worked perfectly!

you win! That's brilliant, I didn't even think about using an `IF`!

This is better, but I'm still concerned about the sharp right turn a bike will have to make to get on to the 7th bike lane when going west on Tillamook. How can I give them this feedback?

we are very special kinds of people

haha I'm so glad it's not just me 😅

yeah I threatened to cancel last year and they lowered it to to $29 for the year or something but I am tired of playing that game and really have only been using Lightroom lately anyway. I switched to the Lightroom-only plan for $9.99

Twitter was such a different place back then 😅

https://twitter.com/search?q=%40cybersanta&src=typed_query

oops, no https.

http://cybersanta.pin13.net

You can see the replies on Twitter too: https://twitter.com/cybersanta/with_replies

I just cancelled my Adobe subscription, good thing I got the hardware version of it then 🙃

This reminds me of an experiment I did back in the early days of Twitter when you could use the search API to find literally every tweet.

http://cybersanta.pin13.net

I ran this a few years in a row, and by 2010 traffic had picked up enough that I was finally hitting rate limits.

For those of us who have not followed this as closely, what is the bot *supposed* to reply back with? As in what did the company intend the bot to respond with? Also why do all the prompts start with "When it comes to remote work and remote jobs"? Is that part of tricking it?

welp, ordered!

what that's so cool, I need one!

It seems like with a fail-secure electronic door strike, you could put a regular doorknob with a physical key as a backup in case the power goes out or the whole system goes down, and it'll work like a regular door in that case.

https://ui.com/door-access

thanks I hate it

It's a little terrifying that it's been that long tbh! Still living and breathing it though, including how I'm writing this post!