tmoertel

30 ms·

301.
by tmoertel 2y ago
No, the wanted stats are a function of the top 100 items. As a concrete example, consider computing the average sales volume by category for the top 100 items. Here's the vanilla SQL for it: WITH TopItems AS ( SELEC
302.
by tmoertel 2y ago
That's fascinating! I bought something recently, I think it was an Anker USB-C cable, and saw that little T logo on the packaging and wondered whether Transparency was still a thing. I tried the app on the logo/code, and the code
303.
by tmoertel 2y ago
> The new pipe syntax appears to bolt on an imperative construct to an otherwise purely functional language. It's not imperative. The pipe symbol is a relational operator that takes one table as input and produces one as output. It&
304.
by tmoertel 2y ago
Did that Transparency thing with the code stickers and the verification app ever make an appreciable difference?
305.
by tmoertel 2y ago
CTEs are not inherently busywork. I rather like them. What is busywork is having to chop a linear flow of operations into chunks and then wrap those chunks in CTEs that you must wire together. All this, simply because the SQL syntax doesn&#
306.
by tmoertel 2y ago
> Some developers have problems, because they don't understand its abstraction. I think the point of this new syntax is to lower the cost of understanding the abstraction. You keep the familiar clause syntax but let clauses be chain
307.
by tmoertel 2y ago
The post I was referring to said that this new pipe syntax was a big reordering compared to the vanilla syntax, which it is. But my point is that if you're going to understand the vanilla syntax, you already have to do this reordering
308.
by tmoertel 2y ago
Thanks for sharing this perspective! HTML is a lot more accessible in general than PDF documents. QQ: Do the math formulas render properly in reader mode for you? (On my test with Chrome, the answer seems to be no.)
309.
by tmoertel 2y ago
Just my personal take, but when I have to read something carefully, I find it easier to do on paper. For example, I recently wrote an article about taking random samples using SQL. Even though I was writing it for my blog, which is HTML, I
310.
by tmoertel 2y ago
The point of SQL pipe syntax is that there is no reordering. You read the query as a sequence of operations, and that's exactly how it's executed. (Semantically. Of course, the query engine is free to optimize the execution plan a
311.
by tmoertel 2y ago
I'm glad to see pipe syntax moving forward! In my time at Google, I wrote a lot of SQL queries that required a long sequence of intermixed filtering, grouping, aggregation, and analytic window operations. But the ordering of those oper
312.
by tmoertel 2y ago
The classic way that businesses openly coordinate their pricing is via price matching. Businesses advertise their preferred prices but also promise that they'll match lower prices from competitors. Competitors see these advertisements
313.
by tmoertel 2y ago
It seems like there might be some lessons in this whole pre- and post-launch timeline for how (not) to launch a new version of an existing product without damaging your company's reputation and user trust. The speculation is that Sonos
314.
Update on the Sonos App from [Sonos CEO] Patrick Spence(sonos.com)
2 points by tmoertel 2y ago|3 comments
315.
by tmoertel 2y ago
> Google is actually using the Google Fonts service to track traffic. According to https://developers.google.com/fonts/faq/privacy#when_i_embed... , "For clarity, Google does not use any information collect
316.
Google One 'Dark web reports' coming to all Google Account holders in late July(9to5google.com)
25 points by tmoertel 2y ago|3 comments
317.
by tmoertel 2y ago
> 2. Vehicles with bumpers/hoods higher than Xcm should never be allowed in the left lane; How does this edict apply to roads on which each direction has only one lane (accounting for about half of US traffic volume)?
318.
by tmoertel 2y ago
That model comes from Hirschman's treatise on Exit, Voice, and Loyalty . https://en.wikipedia.org/wiki/Exit,_Voice,_and_Loyalty
319.
Citing Papers in Software (2021)(fredrikj.net)
2 points by tmoertel 2y ago|0 comments
320.
by tmoertel 2y ago
I interpreted this to mean that the walking group suffered a greater number of leg and foot problems than did the non-walking group.
321.
by tmoertel 2y ago
Randomized controlled trial, 701 subjects, not blinded. Bottom line: > The intervention was effective in preventing an episode of activity-limiting low back pain (hazard ratio 0·72 [95% CI 0·60–0·85], p=0·0002). The median days to a recu
322.
by tmoertel 2y ago
Thanks for the recommendation. Just ordered a copy!
323.
by tmoertel 2y ago
+1. I have Tempest devices at a couple of sites. They were easy to set up, and they've worked well. The API is straightforward, too, so it was easy to write a Python script to sync my data to a local SQLite database and keep it up to d
324.
DAK Industries Catalog, Early Fall 1985(archive.org)
43 points by tmoertel 2y ago|20 comments
325.
Technical Analysis of Anatsa Campaigns: Banking Malware in the Google Play Store(zscaler.com)
2 points by tmoertel 2y ago|0 comments
326.
by tmoertel 2y ago
Out of curiosity, which networking appliance form-factor computer did you purchase?
327.
by tmoertel 2y ago
> And a final note, predicting one token at a time is what we are doing as humans when we speak... I wouldn't be surprised if we could predict token groups. When speaking off the cuff, people often rely on well-worn phrases and clic
328.
by tmoertel 2y ago
The oldest thing I've written that I can still find on the Internet — the original disks are long gone — is a microbe simulator I wrote about 35 years ago. Apparently, at least two people archived a copy: https://www.macinto
329.
by tmoertel 2y ago
While some interview problems rely on knowing a trick (and I would argue that these are poorly chosen problems that reveal little about candidates except whether they know the trick), most problems can be solved with a good understanding of
330.
How did a GMO purple tomato get mixed up for an organic variety?(npr.org)
1 points by tmoertel 2y ago|0 comments

More ›