HNHacker News
TopNewBestAskShowJobs

sschnei8

104 karma · joined September 7, 2021

https://selectfromwhereand.com/about/
submissionscomments
sschnei8··on [dead]
Chinese cigarette website with great UX
sschnei8··on Show HN: Play poker with LLMs, or watch them play against each other
There’s no good way to play pocket jiggities @bradowen
sschnei8··on Prepare for That Stupid World
To be fair they could have done an experiment on a transaction that typically requires a person in the loop. Rather than choosing a vending machine which, already, does not require a person in the loop for the transaction.
sschnei8··on Python Data Science Handbook
Interesting choice of Pandas in this day and age. Maybe he’s after imparting general concepts that you could apply to any tabular data manipulator rather than selecting for the latest shiny tool.
sschnei8··on How to Short the Bubbliest Firms
The market can stay irrational longer than you can stay solvent.
sschnei8··on Text-to-SQL is dead, long live text-to-SQL
Agreed, but maybe the step change there is refactoring the data model, not continuing to author “hairy” sql via LLM that’s all fine until it breaks… and you end having to mend the nastiness back into compliance the ol’ fashion way
sschnei8··on Text-to-SQL is dead, long live text-to-SQL
What is the human need to bash SQL at all costs? At its core, such a simple syntax, yet its so powerful at aggregating/manipulating tabular data and the like. Instead we’d rather declaratively say what we want in a more verbose/disjointed way… fascinating
sschnei8··on America's top companies keep talking about AI – but can't explain the upsides
Do you have any data to backup the claim: “vast majority of companies understand suck cost fallacy.”

I’m assuming you meant “sunk” not “suck”. Not familiar with the suck fallacy.

sschnei8··on The thousands of atomic bombs exploded on Earth (2015)
So sad. Humans are so smart and yet soooo dumb.
sschnei8··on 450× Faster Joins with Index Condition Pushdown
I feel like this is more an example of:

“We filtered first instead of reading an entire table from disk and performing a lookup”

Where both OLAP and OLTP dbms would benefit.

To your point, it’s clear certain workloads lend themselves to OLAP and columnar storage much better, but “an endless sequence of misbehavior” seems a bit harsh .

sschnei8··on Why Semantic Layers Matter (and how to build one with DuckDB)
Exactly. “Everything is urgent” is the great burden of our time lol
sschnei8··on Why Semantic Layers Matter (and how to build one with DuckDB)
I love a semantic layer as much as the next guy...

Pivoting a decent sized BI shop toward using one instead of splashing the same SQL all over the place is *tough*. It's one of those: "the analyst could have been building important report for director and you want them to create re-usable logic??? we'll do that later, get report done now. Just copy/paste that SQL over here"

This is how you end up with the the 1000 model, "the numbers don't match up", hot mess situations that gain momentum and are hard to slow down.

sschnei8··on Making Postgres slower
I always do that when working with a new cloud provider. I spend our Series A as fast as possible after which we can optimize cloud spend!
sschnei8··on How to increase your surface area for luck
Another great way to increase your surface area for luck is being born in a first world country with access to a computer. I hear that has a good success rate!
sschnei8··on We do not break userspace (2012)
You can “stand up for users and the integrity of the product” without telling someone to SHUT THE FUCK UP
sschnei8··on Ask HN: What breakthrough helped you build and maintain better relationships?
Too many factors to possibly diagnose if “it’s you”, or even if there is something “to fix”.

Anecdotally, I desire to hang out with people who share my interests and want to do similar activities that we both enjoy.

I’m a few years removed from college now, and it’s highlighted to me just how special living closely with people of similar age and interest does for one’s social life. Once you spread out, gain dependents, work, etc… it’s much more of an effort to stay in touch.

Just because someone doesn’t reciprocate your effort to connect doesn’t necessarily mean they don’t want to hang out with you.

sschnei8··on In a first, Phoenix hits 100 straight days of 100-degree heat
Eh it's not that bad, lived in Phoenix for 25 years so I'm used to it... vacation weather for 7 months of the year. Great access to nature. There's always trade-offs no matter where you live.
sschnei8··on Mishaps in Redshift Temporary Tables
All excellent points. The best is when most workloads on the cluster use a temp table with an identical name. Then someone comes along and accidentally drops the TEMP from the their temp table ctas and it gets smashed into the public schema.

“Table already exists…”scheduled job run failure galore, fun times.

sschnei8··on Tesla stock drops 29% in first quarter as global dominance wanes
Steering has gone out twice on a family member’s Model Y. N=1 example but plenty of other companies now make EVs and they do a decent job of it… shedding 29% still leaves the company at an astronomical valuation, ~100bn larger market cap than Toyota.
sschnei8··on How does a B-tree make queries fast?
This requires the obligatory https://db.cs.cmu.edu/mmap-cidr2022/
sschnei8··on Redlining
“Responses to questions range from "I don't know, I was just told" to "Let me get back to you"”

I assumed you meant that this created a sense of reflection in the requester as to the value of their ask.

sschnei8··on Redlining
Fair point, I think I’m approaching that view of just doing it, but I’m not quite there yet. You said it yourself that at least it makes them question the value of said task… and I don’t think bringing it up shines back on me negatively. Regardless I appreciate your thoughts.
sschnei8··on In-memory vs. disk-based DB: Why do you need a larger than memory architecture?
https://db.cs.cmu.edu/mmap-cidr2022/