nknealk

10 ms·

31.
by nknealk 5y ago
Can someone from EdgeDB explain why the SQL isn't as simple as what I have below? What am I missing? Why is that cross join lateral necessary: SELECT title, ARRAY_SLICE(ARRAY_AGG(movie_actors.name WITHIN GROUP (order by
32.
by nknealk 5y ago
An M6a on AWS has 128 GB of RAM and 32 cores and goes for around $0.60 on the spot market. If you need local SSD and you’re willing to go ARM, an m6gd has a similar spot price and nearly 2 TB of NVME local storage. I’m sure other cloud prov
33.
by nknealk 5y ago
Not me but my wife started an Etsy store during COVID to sell the art she was making. She now does custom watercolor house portraits and has a variety of prints for sale as well. https://www.etsy.com/shop/UrbEmSketches
34.
by nknealk 5y ago
The New York Times recently published this which I feel explains why a lot of my peers don’t want to have children. https://www.nytimes.com/2021/11/20/style/breed-children-clim...
35.
by nknealk 5y ago
Does this work well for SQL?
36.
by nknealk 5y ago
There’s another consideration here. The entire buying operation was debt financed which created incentives for risky behavior and left very little margin for error. Not only does your sales price need to cover the cost of the house and any
37.
by nknealk 5y ago
Dr. Hardinger at UCLA teaches the intro organic chemistry courses for essentially anyone graduating in science. His lectures regularly exceeded enrollment of 1000 people per quarter when I was there in 2009. Dr. Hardinger also wrote his own
38.
by nknealk 5y ago
To be fair, some might call that good marketing. Largely speaking, it’s the affluent who will pay for a subscription workout product.
39.
by nknealk 5y ago
From the cash flow statement for the last 9 months: 10.8B spent on dividends 66.2B spent on repurchase of shares For context, Apple spent 16.1B on R&D. It’s amazing they can self-fund this kind of growth while still returning so much ca
40.
by nknealk 5y ago
Charles Schwab. I’ve been a customer for decades. The good: Similar to vanguard and fidelity on most dimensions which are also mentioned in this thread, but they’re also a bank so you can have a checking + savings account with them and all
41.
by nknealk 5y ago
I recommend Bayesian Methods for hackers [1]. It doesn’t go too deep on theory but I feel like it’s well written and has really good coded up examples of theory being applied to problems. It has a relatively narrow scope, but I find myself
42.
by nknealk 5y ago
Some considerations on manufacturing — there’s a variety of product quality steps necessary to release batches of medicine. The FDA mandates this as part of GMP regulations. These steps help ensure things like: * How do I know that every vi
43.
by nknealk 5y ago
The endpoints for vaccines are “does the person end up in the hospital and does the person die of COVID” not “does the person get infected”. To that end, the vaccines are still effective. From the original WSJ source [1]: “Analysis by Engla
44.
by nknealk 5y ago
As others have said, PostGIS is a great option if supports everything in your use case. The GIN indexes in particular give you very fast bounding box lookups. You can also do shape intersection and other sophisticated things. I recommend th
45.
by nknealk 5y ago
Tome of identify only holds 20 charges
46.
by nknealk 5y ago
The alternative hypothesis is that the phylogenetic tree is wrong. Maybe those two fish actually share a recent common ancestor.
47.
by nknealk 5y ago
Turns out, AMD did the opposite: https://www.tomshardware.com/news/amd-shows-new-3d-v-cache-r...
48.
by nknealk 5y ago
MySQL can handle many more connections per instance than postgres. Often when you have a high-transaction database in prod with postgres, you need something like pgbouncer to handle connection pooling or you'll have a bad time. I agree
49.
by nknealk 5y ago
> I have continuously been near or around folks that have come down with Covid and have yet to encounter a second infection or positive test since my initial infection. I look forward to when greater fact-based realities start to take ho
50.
by nknealk 5y ago
If it weren’t for shareholders, the company wouldn’t even exist. Who do you think kicked in the initial capital for the company to get started?
51.
by nknealk 5y ago
Some would argue the standardized tests select for those who can afford test preparation services, regardless of what section of the test is in question.
52.
by nknealk 5y ago
Most money market funds are required to publish their holdings. For example, here's a Schwab money market fund's holdings: http://hosted.rightprospectus.com/SF/MMD/Fund.aspx?cu=808515... You can see ever
53.
by nknealk 5y ago
Several considerations to what other commenters have already said: * Rental properties, vending machines, etc have poor liquidity. What if you need to get your cash back out in an emergency? This poor liquidity is particularly correlated to
54.
by nknealk 5y ago
There's a great Acquired podcast episode about Warren Buffet and his obsession with compounding returns. After listening to that episode, it totally makes sense why he'd be opposed to a stock split. I highly recommend it for those
55.
by nknealk 5y ago
I just finished filing my taxes in the USA. Let me tell you, the US government is my biggest annual subscription by cost. Joking aside: Jetbrains all product pack - $149/yr Half decent home internet - $65/mo Cell phone bill (with
56.
by nknealk 5y ago
Consider a hybrid approach as a fallback? I'll come in all week every other week. Or I'll come in 2 days per week. Your manager might be more open to that kind of an arrangement than fully remote.
57.
by nknealk 5y ago
I believe LevelDB automatically passes blocks through snappy compression, hence the smaller size. SQLite has an extension[1] that will do something similar. I’ve never used it so I can’t comment on how it might work for your use case. [1]
58.
by nknealk 5y ago
How firm are your "less than 1000ms" requirements. Could you identify a subset of your images/videos that are very unlikely to ever be accessed and move those to s3 glacier and price in that some fractional percentage will re
59.
by nknealk 6y ago
Here’s an interesting question — if you receive BTC from one of these addresses as payment for something, do you refuse it? You know it’s stolen and you might worry someone else who you might pay in the future would be able to track down th
60.
by nknealk 6y ago
> the gold standard, for example, contributed in some ways to The Great Depression Most people don’t realize this. A great book on the topic is Lords of Finance which outlines how the gold standard made the Great Depression truly great.

More ›