srcreigh

49 ms·

571.
by srcreigh 4y ago
They still are sometimes. Whenever you have a CTE which is referenced more than once, to be specific.
572.
by srcreigh 4y ago
Only when the CTE is referenced once. If it's referenced more than once, it is automatically materialized.
573.
by srcreigh 4y ago
This is a great idea if you disable materialization (which the author of this post does not mention). Yes, materialization is fine for small hardcoded values in the post, but for most other lookup tables, it's definitely not fine. For
574.
by srcreigh 4y ago
It’s also a thing in Rust and other functional languages such as Haskell, Scala
575.
by srcreigh 4y ago
Lisp shines with macros. I like to use macros to add new static checks to the code For ex I wrote about one such check here https://tech.perpetua.io/2022/01/generating-sqlite-bindings-... This macro checks SQLite
576.
by srcreigh 4y ago
Thanks, it is important for people to know this. In this article 5 tables are pulled into CTEs which aren’t marked as not materialized. It wasn’t the point of the example, but the default is scary, leading to disabling all indexes for the q
577.
by srcreigh 4y ago
CTEs considered harmful. This query will run nornally as long as those CTEs stay unmaterialized. But all you need is a single intermediate CTE and due to the “two+ references cause CTE materializations” rule in Postgres, the query will star
578.
by srcreigh 4y ago
Not always. I for one am just not upgrading at all due to costs. It would be a lot better to make $500 profit for each of the 100k people buying your product than $1000 profit for each of the 20k buying.
579.
by srcreigh 4y ago
What partition configuration do you have? Do you have a fdisk printout handy (aka `fdisk /dev/FOOBAR` and run the p command)
580.
by srcreigh 4y ago
> that can reliably be updated without the boot partition getting full Funny you say that. I can't boot into my dual Windows-arch desktop atm. systemd-boot is broken after I tried to set up XBOOTLDR partition, which I only had to d
581.
by srcreigh 4y ago
How'd you pick 11 threads? How do the algorithms scale as you change # of threads? T=2, 10, 100, 1000, 10k
582.
by srcreigh 4y ago
The AI can also read our proofs
583.
by srcreigh 4y ago
Where does Q = { (S1 . T1) . (S2 . T2) : S1,S2,T1,T2 in Q } not work?
584.
by srcreigh 4y ago
This is incorrect. The article had significant results for 2 groups (everybody and a subset of the participants) on the 29 day result, and also had significant result when looking at 28 days. They claimed the opposite - since multiple end p
585.
by srcreigh 4y ago
The article describes an initial test where people ate 2000 calories of potatoes every day and lost weight. The potassium experiment was a follow-up.
586.
by srcreigh 4y ago
We’ll see if twitter gets gatekeeper status. They have significantly less MAU in the UK than the example qualifications here. https://www.dpocentre.com/the-digital-markets-act-and-gdpr-c... .
587.
by srcreigh 4y ago
1) still true. And I for one think Elon’s utter transparency if all his flaws and explicit policy about sharing competitors is categorically better than the vague policy games and hidden algo promotions that nearly every other site runs. Yo
588.
by srcreigh 4y ago
PG left instructions for how to follow him on Mastodon, which is against the new policy. You may not like it, but you can’t say it’s not transparent.
589.
by srcreigh 4y ago
Sorry for all those downvotes. I get people dislike Elon right now, and dislike the ban, but you are correct. I wish we would seek understanding instead of trying to… promote misunderstanding and silence people who point it out?
590.
by srcreigh 4y ago
Again, you are benefiting from transparency of his opinions to form your own opinion. I think you being able to disagree is valuable, and I’m not really trying to change your mind either.
591.
by srcreigh 4y ago
At least it’s explicit policy. FB messenger likes to fail to send signal URLs, mark PushBullet URLs as unsafe. Deprioritize YT links in the FB feed too. It’s not an official policy, just plausible denial secret policy. I respect Elon for ma
592.
by srcreigh 4y ago
My science fiction philosophy is that much of human thought is more like interacting with an objective, shared thought universe with other humans (living and dead) as well as gods and angels and stuff. As opposed to brains firing based on p
593.
by srcreigh 4y ago
Hey foldr, re higher level language parser, I’d just like to say at uwaterloo it was common to use racket to write the compiler for the above^5 mentioned class (you could use racket or C). Is this what you had in mind? Which language is bes
594.
by srcreigh 4y ago
Does VSCode link you to the file a built in command is written in? In emacs not only can I read built in command source code. I can even change it and reload the functions on the fly. Sometimes I find config options by reading source code e
595.
by srcreigh 4y ago
Every UWaterloo CS student has to take CS241 (2nd year class, 4 months after learning C). Each student must write tokenizer and parser by hand. The full assignments include about 8 programs in binary and MIPS assembly, a MIPS assembler incl
596.
by srcreigh 4y ago
Yeah. Whether this is faster than normal sort is a big "depends" based on how the sorted data is accessed. SIMD sort with indirection would be nice if you only need to access top 25 or 1/255 items in the array or something. F
597.
A Comprehensive Guide to Stool and Microbiome Testing (2021)(lucymailing.com)
2 points by srcreigh 4y ago|0 comments
598.
by srcreigh 4y ago
There is an app for this. Reduce motion is still slow fade animation. The app was a little buggy but mostly worked like Linux tiling window managers. The apps price was a few bucks. I can’t remember the name of it, but I’m looking an will e
599.
by srcreigh 4y ago
This is an issue with anyone who has your email, not really SSO. Those emails would be illegal in Canada, the business has 10 days to stop sending them after you contact them requesting to unsubscribe.
600.
by srcreigh 4y ago
I just saw that estimate for atoms in an average human body is on the order of 10^27. I didn’t expect that the whole body is 100,000x atoms compared to the eye. By weight (68kg/28g) the body is only about 2500x the size of an eye.

More ›