Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
cafxx
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
8 ms
·
31.
▲
by
cafxx
4y ago
For complex SELECT queries, I do: WITH cte1 AS ( /* whatever / ), cte2 AS ( / you can refer to cte1 here / ), cte3 AS ( / you can refer to cte1 and cte2 here */ ), ... If I need access into multiple stateme
32.
▲
by
cafxx
4y ago
Yup, common occurrence also here in Tokyo. If you are not Japanese you can expect quite a few rejections, as well as having to pay extra "guarantor" fees, and in general higher than average rent. And, mind you, I'm probably a
33.
▲
by
cafxx
4y ago
Not sure I buy the argument. By that logic, Apple should only allow phone calls from callers they consider trusted, because any call originating from a non-trusted phone number may be a scam phone call, and someone may fall for it. Do s
34.
▲
by
cafxx
4y ago
> no one would tell a senior engineer just a single sentence "please implement mult command" It definitely happens (at least it did to me) to be given programming tasks without context. Maybe my comment wasn't crystal clea
35.
▲
by
cafxx
4y ago
> Via its incr and decr commands, memcached provides a built-in way to atomically add k to a number. But it doesn’t provide other arithmetic operations; in particular, there is no “atomic multiply by” operation. Your programming challe
36.
▲
by
cafxx
5y ago
Sounds somewhat similar to the closed-world assumption that graalvm makes ( https://www.graalvm.org/22.0/reference-manual/native-image/ ), and the optimizations that assumption enables.
37.
▲
by
cafxx
5y ago
You may want to look at project loom's virtual threads, that are designed to address almost exactly your problem: https://openjdk.java.net/jeps/8277131 https://cr.openjdk.java.net/~rpressler/l
38.
▲
by
cafxx
5y ago
> The most novel feature of my return to education calculations was that I tried to count everything that matters . I took the countless papers that start with the standard return estimates and tweak them with one novel complication.
39.
▲
by
cafxx
5y ago
Yeah considering that the test is on btrfs, I would really be interested in knowing what OP is referring to. Also, even if we were on ext4, it's worth pointing out that the ext4 documentation refers to apps that rely on that behavior a
40.
▲
by
cafxx
5y ago
I am not aware of implicit fsyncs. Can you please link to what you are referring to?
41.
▲
by
cafxx
5y ago
I don't see anything preventing the OS, or the hypervisor on which the OS is running, from moving/copying the memory contents around to different physical pages, or potentially to swap or even over the network (e.g. for live migra
42.
▲
HVM: a massively parallel, optimal functional runtime in Rust
(github.com)
5 points
by
cafxx
5y ago
|
0 comments
43.
▲
by
cafxx
5y ago
This is a strawman argument. It presents the two options as mutually incompatible, whereas they are not (as demonstrated by other languages that allow to do both).
44.
▲
by
cafxx
5y ago
Can't bother to register. Waiting for the inevitable leak to satisfy my curiosity
45.
▲
by
cafxx
5y ago
That is indeed a very good example of why the article is unclear in it's aim: zopfli is not a codec, it's an encoder. And furthermore the 80% figure is probably for the default configuration, as zopfli has an -i argument that can
46.
▲
by
cafxx
5y ago
Codecs are normally defined/specified in terms of the decoding process, not of the encoding one. So if the encoding is one million times slower, it has very little to do with the codec itself and only to do with the encoder and the way
47.
▲
by
cafxx
5y ago
Worth pointing out for bystanders that in superscalar, pipelined processors the number of instructions has very little bearing over whether something is faster or slower (unless we are talking about differences of many orders of magnitude i
48.
▲
by
cafxx
5y ago
It sounds like the author of the article is really confused, or is just trying to kick up dust. The included screenshots from the ITER website don't claim what he says they are claiming. And note that he carefully avoids pointing out t
49.
▲
by
cafxx
5y ago
Yeah but loading slowly... archive.org to the rescue: https://web.archive.org/web/*/http://101.132.96.154/\ * (hn mangles the URL, shortened: https://bit.ly/3aXqwVK )
50.
▲
by
cafxx
5y ago
I just closed chrome, reopened hit and immediately hit the home button at the top left. That was enough to get me to safety.
51.
▲
by
cafxx
5y ago
You could potentially also speed it up a bit by, after the first pass, trying to read first blocks that are unlikely to be written again soon (normally the longer a block has been written last, the less likely it is to be written again soon
52.
▲
by
cafxx
5y ago
> > Blurring (safely!) the line between database and the app using it > What do you mean by this? Consider this app pseudocode: resultset = db.query("SELECT ... WHERE ...") for row in resultset if some_com
53.
▲
by
cafxx
5y ago
- Blurring (safely!) the line between database and the app using it: transparently switch between bringing data to compute, or compute to data. - Comprehensive auto tuning: automatic index creation, automatic schema tuning, dynamically swit
54.
▲
by
cafxx
5y ago
Run a port scan on your public IP address. Plenty of websites allow you to do it, although it's probably safer to grab a shell on any other host connected to the internet (could be even just your phone connected to its mobile network)
55.
▲
by
cafxx
5y ago
> these routers are secure. Owner of a C7 v4 here. There has not been a firmware update from TP-Link since December 2019 (note that v4 is the second-most recent HW revision). No way these are not affected by at least some CVE somewhere i
56.
▲
by
cafxx
5y ago
> Would BitTorrent be faster over HTTP/3 (UDP) or is that already a thing for web seeding? The BT protocol itself runs on both TCP and UDP, but it has preferred the UDP variant for many years already.
57.
▲
by
cafxx
5y ago
Not sure what point we're trying to make here. Any other firewall/CDN/WAF enable you to do the same thing, to the point of many also providing ready-made protection profiles... what makes this specific member of that group sp
58.
▲
by
cafxx
5y ago
[nit] you should really run analyze before vacuum, not the other way around ( https://github.com/segfall/static-wiki/blob/6d455de149c24e2a... )
59.
▲
by
cafxx
5y ago
That's one lovely trick. If I may suggest one thing... instead of range requests on a single huge file how about splitting the file in 1-page fragments in separate files and fetching them individually? This buys you caching (e.g. on CD
60.
▲
Ask HN: Could Copilot be an additional vector for supply chain attacks?
(twitter.com)
2 points
by
cafxx
5y ago
|
0 comments
More ›