chaps

32 ms·

661.
The City of Seattle accidentally gave me 32M emails for $40 (2018)(mchap.io)
322 points by chaps 3y ago|218 comments
662.
by chaps 3y ago
Hah, nice. A long while back I was interested in building a diffuser system that would rotate between different oils throughout the week. The idea at the time was that each new scent would act as a memory anchor of sorts to reflect back upo
663.
by chaps 3y ago
This might quench your thirst in the meantime! https://mchap.io/that-time-the-city-of-seattle-accidentally-...
664.
by chaps 3y ago
I need to write about it ;). We won that case just before the last election and unfortunately other things took priority at the time. But it'll happen. Just first need to write about my IL supreme Court loss...
665.
by chaps 3y ago
It was most notably helpful in litigation against the White House Office of Management and Budget. Was suing for one week of email metadata records (to, from, CC, bcc, time, date) in the last week of Jan 2017. They said that they had no way
666.
by chaps 3y ago
Thanks! That's a relief.
667.
by chaps 3y ago
Being legally right and being morally right are often two very different things though. Like, they even have the full domain name of the original thing. If I were the owner of the original video and the subsequent film, I know I'd be,
668.
by chaps 3y ago
Out of curiosity, did you reach out to them? I think the project is neat, just feels a bit like you're leaning on an established (and extremely creative) piece of work instead of creating your own brand. Hope I'm wrong.
669.
by chaps 3y ago
Yep. It's a very clean, powerful and well thought out API. And I'm saying that coming from a place of love towards unix and its pipes. I'd almost argue it's better than the unix model. Almost . Been able to give poweshe
670.
by chaps 3y ago
Hate to be "that guy", but it's kinda sad that they pretty much stole the name... especially when the (fantastic!) movie with the original character came out recently in 2021. https://youtu.be/k98Afd7Nf3Y
671.
by chaps 3y ago
A lot of recent perception comes from the U-Line owner publishing fake newspapers: https://chicago.suntimes.com/2022/11/3/23438739/right-wing-n...
672.
by chaps 3y ago
"you don't get a bunch of 1s from that query." You've seriously missed the point if this is what you're still saying. Take a step back, breathe, and try to consider that you've missed something. Whether that&#x
673.
by chaps 3y ago
No need to be a dismissive dickhole about it, friend. Maybe I'm not wording it right then? Like I said in other posts, I copy paste SQL statements all the time. If I were to copy/paste that statement then all I'd get is a bun
674.
by chaps 3y ago
Preaching to the choir there! While public records laws stink, a lot of the work by orgs involved in transparency, and others have made it better. By no means is it going to be "good" anytime soon, but progress is certainly being
675.
by chaps 3y ago
Not 100% sure what you mean, but yes we need something similar to GDPR which allows requests for our own information. It's a mostly a matter of legislative interest, which can stem from demands from the public.
676.
by chaps 3y ago
We also have public records laws where we can hold gov agencies accountable to their abuse of, eg information. Doesn't really exist in private orgs, and it's one of the reasons gov agencies love third party vendors.
677.
by chaps 3y ago
Nothing else to add, but I just want to say thank you for reporting it.
678.
by chaps 3y ago
Yep. I think the others commenting here aren't using SQL for analytics and don't recognize the importance of select * in that context.
679.
by chaps 3y ago
1 think my point makes more sense when you consider that I 1. Don't work with production code (more analysis, ad hoc code in an investigatory capacity) and 2. that when 1 mention someone is "new" what 1 mean is someone activ
680.
by chaps 3y ago
Yes, you can put anything there. And yes, you missed the point.
681.
by chaps 3y ago
Yeah. 1 breaks my brain for the same reason probably.
682.
by chaps 3y ago
It's helpful within CTEs as a unique identifier. This whole conversation makes me wonder if not many people minmax this sort of meta programming thing.
683.
by chaps 3y ago
You're missing the point that I don't really care about how they're treated. I want to glance at it and know what it does. For me, the 1 gets in the way. Maybe it doesn't get in the way for you because you don't use
684.
by chaps 3y ago
Any code using select * just breaks in the future with any new columns being added, no thanks. For you, maybe. In my workflows this is really a non-issue for me. Maybe consider that we use SQL differently and your goals and challeng
685.
by chaps 3y ago
I copy paste SQL all the time, especially with CTE after CTE all the time. The row number is a simple thing to copy paste that fills multiple functions with zero modification.
686.
by chaps 3y ago
In the sense that code is data: yes, it absolutely is data.
687.
by chaps 3y ago
Nope, for the same exact reason. Select * makes the most sense because * is in the context of my data, not something I'm working into it. Pretty sure it's the same speed. Also mind you, I use a lot of CTEs, so this would look weir
688.
by chaps 3y ago
Has nothing to do with the language. 1 (in its isolated presentation) exists outside of my set of data and that's not something that gives me comfortable feelings. It forces me to think (less think more good) why some random value need
689.
by chaps 3y ago
Eh, anytime I need to read SQL that includes that I have to sit down and think about it. It's not glance-and-understand and you have to maintain that state in your head. Not the sort of SQL I want to rely on as a practice. Mind you, mo
690.
by chaps 3y ago
Yep, agreed.

More ›