Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
CodesInChaos
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
6 ms
·
61.
▲
by
CodesInChaos
2mo ago
I assume it's only fast for large databases when running on a filesystem that supports copy-on-write? In particular, I assume it won't benefit from CoW on a tmpfs?
62.
▲
by
CodesInChaos
2mo ago
The pgtestdb readme claims 20ms setup, while OP claims 100ms. Where does that difference come from? A different postgres setup (in memory vs disk)?
63.
▲
by
CodesInChaos
2mo ago
I feel the template approach has a kind of awkward performance level. As the article points out, 100ms of overhead is still a lot if you incur it for each test. But once you re-use the database, it doesn't matter much if creating it ta
64.
▲
by
CodesInChaos
2mo ago
The article even allows you to toggle the notation used.
65.
▲
by
CodesInChaos
2mo ago
There is the ePrivacy directive as well, which mentions cookies (as a representative example), and I think it requires user consent in cases where GDPR doesn't.
66.
▲
by
CodesInChaos
2mo ago
EU should simply outlaw tracking for advertisement purposes. Let's return to context based ads.
67.
▲
by
CodesInChaos
2mo ago
Advertisement.
68.
▲
by
CodesInChaos
2mo ago
One of the more annoying parts of my physics study was getting used to the new matrix multiplication notation they came up with every semester.
69.
▲
by
CodesInChaos
2mo ago
All real numbers are real, but some real numbers are more real than others.
70.
▲
by
CodesInChaos
3mo ago
Two of six screenshots show the app. So the rejection fits the rules and is easy to understand. I often agree with complaints that Apple's rejections are unclear or problematic, but this isn't one of those cases. And I'm kind
71.
▲
by
CodesInChaos
3mo ago
I think introducing unpredictable new prohibitions is a much bigger problem than the specific bans on cryptocurrency or AI written code. Especially when it leads to existing code becoming unavailable and doesn't just ban new contributi
72.
▲
by
CodesInChaos
3mo ago
> The best practice is a policy banning PAN over email, instant messaging, SMS, and chat entirely. Sounds silly to me. A PAN should never even touch an employee's computer.
73.
▲
by
CodesInChaos
3mo ago
> Anyone who cares about security will be using App Attest or the Google store equivalent. Why? I rarely have security objectives where remote attention would help, and it has a huge impact on user freedom. For B2C attestation is just an
74.
▲
by
CodesInChaos
3mo ago
I definitely got more out of paying full attention to lectures in university compared to wasting effort on hand writing notes. And properly typeset lecture notes written by somebody else are much better for studying than the illegible handw
75.
▲
by
CodesInChaos
3mo ago
Abusing IP ranges which were assigned to an organization but aren't actually used on the public Internet as private addresses is pretty common. Sure, it's bad practice, but not a big deal.
76.
▲
by
CodesInChaos
3mo ago
When designing a character on a computer, you play around with many options, until you settle on one of them. Since you did exactly the same thing for all those variants, it's difficult to remember which one you ultimately picked. Writ
77.
▲
by
CodesInChaos
3mo ago
Writing is a distraction from thinking.
78.
▲
by
CodesInChaos
3mo ago
I consider an inline-pointer a form of inline-metadata. When I mentioned that inline metadata isn't necessary I was referring to the kind of external lookup you describe.
79.
▲
by
CodesInChaos
3mo ago
I think German non profit organizations are required by law to have a certain level of governance structure.
80.
▲
by
CodesInChaos
3mo ago
You're right. Fixed.
81.
▲
by
CodesInChaos
3mo ago
Yes, large allocations need to be aligned to `alignof(max_align_t)`. But small allocations could have a smaller alignment. For example a single byte allocation can actually be a single byte with no alignment, since types can't have an
82.
▲
by
CodesInChaos
3mo ago
Your bump allocator suffers from integer overflows turned into buffer overflows when the requested allocation is big enough: if (a->cursor + size > a->limit) return NULL; // out of memory I'd rewrite it like t
83.
▲
by
CodesInChaos
3mo ago
There is no reason an allocation needs to contain any inline metadata. And even if it does, the allocator could choose to make it unalined, and pay the cost of an unalined access on de-allocation.
84.
▲
by
CodesInChaos
3mo ago
I'm a big fan of persisting almost everything in the primary database. With one exception: I'd immediately use object storage (S3) for files which are large in number or size. Files which are few and small (e.g. templates) are fin
85.
▲
by
CodesInChaos
3mo ago
There was some recent uncertainty about pgBackRest getting discontinued due to lack of funding. But the maintainer secured funding, and pgBackRest development will continue. https://pgbackrest.org/news.html
86.
▲
by
CodesInChaos
3mo ago
An atomic volume snapshot should work for any database that's durable on power failure. Ideally preceded by a checkpoint, to minimize recovery time. Atomicity of the snapshot mechanism is essential to prevent data corruption using this
87.
▲
by
CodesInChaos
3mo ago
I'd avoid using overly opinionated code hosters that capriciously change their ToS to ban content that was allowed before without a very good reason. I'd like my code to survive long after I stop maintaining it, and such changes r
88.
▲
by
CodesInChaos
3mo ago
How do they define "vibe coded"? I believe "vibe coded" was originally defined as letting AI write code without human review. But I often see it used for all AI assisted code. edit: Looks like they don't talk about
89.
▲
by
CodesInChaos
3mo ago
> Microsoft could end up being a higher barrier but how much do we really want that? For drivers installed automatically via Windows Update? Absolutely yes. For software the user installs manually? No.
90.
▲
by
CodesInChaos
3mo ago
Occasionally you have faulty hardware. Most commonly RAM.
More ›