andrenotgiant

9 ms·

61.
by andrenotgiant 3y ago
Yeah I think the list is only highlighting the worst offenders. It would be more useful to also include the cheap VPS providers mentioned later, that would be: - Scaleway: $0 - Hetzner: ~$490 _(article says bandwidth is free but I think abo
62.
by andrenotgiant 3y ago
I don't have an opinion, but this article gives a fairly unbiased comparison of DuckDB vs Clickhouse-local, which I imagine exhibits similar performance characteristics as ChDB, just without the embedded part: https://www.v
63.
by andrenotgiant 3y ago
I think the original question came up after the recent Rails keynote where they mention that, with NVMe speeds, disk is cheaper and almost as fast as memory, so Redis is not as vital. https://youtu.be/iqXjGiQ_D-A?t=2836 So
64.
by andrenotgiant 3y ago
Ahh thanks for clarifying - now I better understand the significance of the OP's point about the rarity of younger COMMITTER's.
65.
by andrenotgiant 3y ago
I have the honor of working with a Postgres ~committer~ contributor who was just over 25 when they first contributed! The story about their first commit is great: They were testing SQL behavior for Materialize and thought to check that bo
66.
by andrenotgiant 3y ago
I commute through Penn Station three days a week, I can't understate how terrible it is for commuters. Every morning when I exit the train to a blast of heat on cramped platforms, wait in line for my turn to weave up a tiny staircase,
67.
Deleted Instacart Data Eng Article: Optimizing ETL from Snowflake to Spark(webcache.googleusercontent.com)
1 points by andrenotgiant 3y ago|0 comments
68.
by andrenotgiant 3y ago
Is there something (besides the convenience of being already in the proper vector formats) unique about the combination of semantic search and LLM's that makes it a better fit? I guess I'm surprised that the approach is to use sem
69.
by andrenotgiant 3y ago
Great explanation. I understand the process a lot better after reading. I have questions now: It seems like everything hinges on the search step, where domain-specific content is gathered to serve as prompt input for the LLM. 1. In an area
70.
by andrenotgiant 3y ago
The article is separating "operational" and "analytical" use-cases. IIUC analytical = "what question are you trying to answer" and in analytics, RT/NRT is absolutely novelty/vanity. Operational = &quo
71.
by andrenotgiant 3y ago
It seems like Snowflake is going all-in on building features and doing marketing that encourage their customers to build applications, serving operational workloads, etc... on them. Things like in-product analytics, usage-based billing, p
72.
by andrenotgiant 3y ago
incremental view maintenance is the database equivalent of: "recompute only the changed data by checking the relationship between fields," Oracle has decent support for incrementally updated materialized views, redshift has some t
73.
by andrenotgiant 3y ago
Write for an audience, read the other work that audience reads, that will help you get a sense of whether something is going to be surprising to them. Here is a longer lecture on a similar idea from U Chicago Writing Program https:/&#
74.
by andrenotgiant 3y ago
This is a dumb article that's trying and failing to tie Attestation to ad blocking. > However, how this plays out with browsers that allow extensions or are modified remains a grey area. As the proposal vaguely mentions, "Web E
75.
by andrenotgiant 3y ago
They actually did have it as an experimental feature for a little while, maybe 10 years ago. [0] If I recall correctly, it was made available in response to another big wave of criticism directed towards Google about "Content Farms&quo
76.
by andrenotgiant 3y ago
How would you explain them to someone who knows the syntax but still finds them counterintuitive?
77.
Incremental Computation at the Data Layer(materialize.com)
2 points by andrenotgiant 3y ago|0 comments
78.
The part of Postgres we hate the most: Multi-version concurrency control(ottertune.com)
257 points by andrenotgiant 3y ago|143 comments
79.
by andrenotgiant 3y ago
Yeah being pedantic here, but reading the details of the $750k reference, it's (hopefully) nowhere near $750k that they saved: > That, combined with the fact that these streams usually have large viewership, means we incur a not ins
80.
by andrenotgiant 4y ago
It doesn't really start at $250k. It's just a dumb quirk of the AWS marketplace participation process. As a vendor, if you want to participate, you have to have a public listing page with a price. But many vendors don't actua
81.
by andrenotgiant 4y ago
I think you're paraphrasing from Maciej Ceglowski amazing "Haunted by Data" talk from seven years ago. Everyone should watch it https://www.youtube.com/watch?v=GAXLHM-1Psk
82.
by andrenotgiant 4y ago
I used this one through this winter and it worked fine: https://www.amazon.com/gp/product/B09C5LQ86D/ I'd just look for what people say in the bad reviews. I generally use mine on the lowest temps, 80 or
83.
by andrenotgiant 4y ago
not OP. But in my experience there's a big gray area between "Brilliant/Nice" and "Brilliant/Asshole" quadrant where people who are very direct, have less patience for incompetence, or hold their coworkers
84.
by andrenotgiant 4y ago
I think maybe I'm just small-potatoes, but the only limitations or constraints I've ever run into with Redis are: 1. memory utilization 2. deployment/orchestration 3. bugs I created for myself related to using caches What are
85.
by andrenotgiant 4y ago
I know nothing about FanDuel and DraftKings, or sports betting in general. Do FanDuel and DraftKings only make money on fees, or are there also situations where , like in a Casino, you're playing against the house? Also, I bet there ar
86.
by andrenotgiant 4y ago
not trying to be snarky, genuinely curious: What benefit does that have over ordering delivery from a restaurant?
87.
by andrenotgiant 4y ago
This is really interesting, but a basic part I don't understand: What would it actually look like to run this on a live dataset? If I understand correctly: you'd run the recursive query, it produces results for every step, effecti
88.
by andrenotgiant 4y ago
There's a variation of that in the data space, where early-stage data companies show the logos of _other_ data companies. It's so obviously just that the other company was like checking to see how your product and there's int
89.
by andrenotgiant 4y ago
just from reading the site, looks like vantage takes a 5% fee vs Usage 20% - but that's a big difference, not sure if it's an apples-to-apples comparison.
90.
by andrenotgiant 4y ago
How would you describe the mechanics of this in regular finance terms... Almost like you are providing mortgages for reserved instances? I think I understand the model here, but I guess I'm curious how you model in risk of suddenly get

More ›