Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
Diggsey
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
8 ms
·
61.
▲
by
Diggsey
2y ago
> Putting aside the mis-application of "pattern" (which _should_ be used with respect to a specific design problem, per the Gang of Four) This is not in any way a mis-application of the word "pattern". There is no exh
62.
▲
by
Diggsey
2y ago
Microsoft don't own the kernel in that sense: anyone can write kernel drivers for windows... While there are some things that the kernel can do to protect against a bad driver, it's not a security boundary, so ultimately bad code
63.
▲
by
Diggsey
2y ago
As someone who works in this space, I can tell you: it's because big companies buy Cyber Security Insurance, and the insurance forms have a checkbox along the lines of "do you run Endpoint Security Software on all devices connecte
64.
▲
by
Diggsey
3y ago
You always need app-level retries for SERIALIZABLE isolation level. You don't need any explicit locking - the database should handle that for you (and in the case of PostgreSQL, locking is not the only tool it uses for avoiding seriali
65.
▲
by
Diggsey
3y ago
> No, people cannot escape responsibility by saying "the law made me be belligerent toward my users". Correction: people should not be able to escape responsibility by saying this. The problem is that right now people do esca
66.
▲
by
Diggsey
3y ago
> 30% to 50% of Rust crates use unsafe code This is particularly misleading for two reasons: 1) There are a lot of `-sys` crates which link to C libraries, so the "unsafe" code in these crates comes from the binding to C rath
67.
▲
by
Diggsey
3y ago
I think part of the reason is that there's a very similar code pattern which is user error, and avoiding that pattern tends to avoid this pattern as well. The similar case occurs when you have: - 1+ threads holding a shared lock (Rea
68.
▲
by
Diggsey
3y ago
But when is it going to be able to use indexes to speed up `IS NOT DISTINCT FROM` queries? ;)
69.
▲
by
Diggsey
3y ago
This doesn't make sense even as a joke, since that's not what it means to leak memory. Memory being "reachable" is a property used by garbage collectors to determine what can be safely freed, but reachable memory can sti
70.
▲
by
Diggsey
3y ago
Not really - you have to completely change your data model to avoid pointers which won't save correctly (eg. using a byte array for name in the article) compared to just slapping `#[derive(Serialize, Deserialize)]` on your structs. Not
71.
▲
by
Diggsey
3y ago
> Re-using the existing code where possible is the fundamentally right approach to the problem. Reusing code does not make something "fundamentally right approach". An implementation that actually does what the problem asks is
72.
▲
by
Diggsey
3y ago
Why do you think the MIT license is "revokable"? It's not - the version that was MIT licensed can always be used under that license.
73.
▲
by
Diggsey
3y ago
This is a guardian article, not BBC. Maybe the link was changed?
74.
▲
by
Diggsey
3y ago
Now that Othello is solved, there exist a set of rules a player can follow to guarantee a win or draw every game. It's possible (if unlikely) that a computer could sufficiently compress those rules to be memorizable (and then applicabl
75.
▲
by
Diggsey
3y ago
I would expect writing to be much harder on all file-systems. There's only one way to read the data, but there could be any number of strategies for deciding where to write new data.
76.
▲
by
Diggsey
3y ago
You're overthinking it - the optimization is absolutely possible as you've described. The reason databases haven't done is not some question of design philosophy, it's simply that nobody bothered to implement it. > I
77.
▲
by
Diggsey
3y ago
Nobody actually answered your question helpfully, so here goes: When you write `SELECT DISCTINCT a, b` you are asking for every unique pair (a, b) in the result. Specifically, the same value of `a` could appear multiple times in the result
78.
▲
by
Diggsey
3y ago
Well the ten pounds still exists either way. You'd have to argue that there's more utility in Bentham owning the £10 than the mugger owning the £10, and that the difference in utility between them is greater than the utility of a
79.
▲
by
Diggsey
3y ago
Userspace != Application-managed On Windows, many things exist in user-space that are managed by the OS. This is in contrast to linux where the Linux kernel is its own thing with its own stable API. Fibers are an OS-level concept that exist
80.
▲
by
Diggsey
3y ago
Because for a long time if you wanted to build a website with no money and no experience those were your only options! JavaScript and HTML for obvious reasons. PHP because if you didn't have your own server, you couldn't run anyth
81.
▲
by
Diggsey
3y ago
Software has bugs, that's not really the damning part... The damning part is that in four hours and two levels of support teams, there was noone who actually knew anything about how the system worked who could remove the problematic fl
82.
▲
by
Diggsey
3y ago
> However in Rust, panics cannot be recovered from, there is no way to incept a panic in the current thread. You definitely can: https://doc.rust-lang.org/std/panic/fn.catch_unwind.html
83.
▲
by
Diggsey
3y ago
The research was a side effect of a very well defined goal, which was achievable albeit extremely hard. Investing in achieving a goal (with the research being a side benefit) is different from just investing in research because it changes t
84.
▲
by
Diggsey
3y ago
It's not just CPU - memory usage is also higher. In particular, idle connections still consume signficant memory, and this is why PostgreSQL has so much lower connection limits than eg. MySQL. Pooling can help in some cases, but poolin
85.
▲
by
Diggsey
3y ago
It's missing generality. It can't do basic maths, or even follow instructions. It can't make valid moves in a game. It can only do what it was trained to do: make a good guess at what word should come next. I don't mean
86.
▲
by
Diggsey
3y ago
I asked this specific question before on the PostgreSQL IRC, and was told that it simply wasn't implemented. There's no huge technical blocker to it being done, it's just a bit awkward to make it work the way the code is stru
87.
▲
by
Diggsey
4y ago
You can already do custom allocation in Rust. These efforts are about bringing support for custom allocators to the types in `std` so that you can combine use of a normal `Vec` with a custom allocator, instead of needing to definte your own
88.
▲
by
Diggsey
4y ago
Neither, I was disagreeing with the comparison to Go and generics. Generics in Go don't add anything beyond what generics already do in other languages, so the challenge with bringing generics to Go is "how do we adapt the languag
89.
▲
by
Diggsey
4y ago
I think most of the challenges are around making custom allocators safe without harming the ergonomics, which Zig hasn't solved. If Rust was content to have use of custom allocators be unsafe it would be trivial to add them (since yo
90.
▲
by
Diggsey
4y ago
My comment was only intended to add missing information to the TLDR (since this fact is important in the linked thread) not to say that Firefox is at fault. Now that you raised it however, even if the system call used to be fast, Firefox
More ›