Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
asah
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
30 ms
·
451.
▲
Pumped hydro is the only real gravity storage solution
(cleantechnica.com)
3 points
by
asah
3y ago
|
6 comments
452.
▲
by
asah
3y ago
Pretty sweet for Android users...
453.
▲
by
asah
3y ago
I assume the future is an LLM where you specify everything in plain english...
454.
▲
by
asah
3y ago
Agreed, i.e. * IF * we want companies to follow the rules... but so far, society (certainly American society...) does not seem to actually want companies to always follow the rules... sigh...
455.
▲
by
asah
3y ago
Regulators typically start with a small fine and then if the behavior continues, fines and penalties increase exponentially. Having worked inside a number of companies who've received fines, the ones that intend to continue operating c
456.
▲
by
asah
3y ago
Everyone's asking "but why" ? My 2c: you see transparent displays in movies (e.g. Minority Report) because they're cool but also for the Hollywood-practical reason that it allows the audience to see the body language and
457.
▲
by
asah
3y ago
well I dunno, we've only tested this architecture for 60 years and a few million companies... in all seriousness, putting the data in one place also makes it a lot easier to optimize and to amortize the optimization efforts.
458.
▲
by
asah
3y ago
This is great. One thing I'd add is a sense of scale - are these architectures for 100 queries per second or 100,000 or 100,000,000 ?
459.
▲
by
asah
3y ago
thx! Indeed, upon reading the source and sleeping on it, I agree, and in fact it looks like a single-user postgres backend with COPY FROM <filename> BINARY is approximately the same architecture as writing the database files in-place,
460.
▲
by
asah
3y ago
The margins are set by willingness to pay (value), direct and indirect competition. The value was fine but competition forced margins negative. Direct competition because there's no barrier to entry and little locking/loyalty. Ind
461.
▲
by
asah
3y ago
wow! awesome tips. I knew COPY rocks but didn't realize it would win vs INSERT INTO SELECT FROM ! https://pganalyze.com/blog/5mins-postgres-optimizing-bulk-lo... 1/10th scale tests: psql -c 'create
462.
▲
by
asah
3y ago
Exactly. The issue is that postgresql takes 37 bytes per row normally, which then causes it to spill out of RAM on the limited VM specified for this challenge, causing the query to be I/O bound, hence the array representation and unnes
463.
▲
by
asah
3y ago
for my SQL implementation, I normalized the city names and temps to 2 bytes apiece, so it's even less! https://news.ycombinator.com/item?id=38866073
464.
▲
by
asah
3y ago
1:05 in PostgreSQL 16 but it was harder than I thought to saturate the CPUs and not be disk-bound. Also, I ran on GCP not Hetzner, so maybe different hardware. SQL in theory makes this trivial, handles many of the big optimizations and look
465.
▲
by
asah
3y ago
apparently! ... or have a computer "type in" a book i.e. file copy i.e. OCR scan (or microphone for audio) (or video-record for video) ...
466.
▲
by
asah
3y ago
sorry if I wasn't clear: under JP copyright, you can encode and then redistribute, presumably for a profit or other gain, and not renumerate content creators at all. True wholesale piracy which destroys the economics for all forms of c
467.
▲
by
asah
3y ago
So wait. If I encode something near-losslessly into a neural net then it's ok? Books and music are now free ?
468.
▲
by
asah
3y ago
FYI the article was from 2008 - these trends are largely post-2008.
469.
▲
by
asah
3y ago
not promising: "For the 2022-2023 and 2023-2024 academic years, I'm on leave to work at OpenAI on the theoretical foundations of AI safety."
470.
▲
by
asah
3y ago
Kagi gives me websites that require more clicking; Google just gives me reasonable answers and I don't see spam in your examples. "why do wider tires have better grip?" Wider tires provide more grip due to a larger contact pa
471.
▲
by
asah
3y ago
Loved personics!!! It was a bit expensive but they made great gifts, and were a good way to get singles. Much easier than waiting for the radio then quickly pressing record+play.
472.
▲
by
asah
3y ago
https://en.m.wikipedia.org/wiki/Enshittification (No mention of promotion)
473.
▲
by
asah
3y ago
These jokes contribute to single motherhood.
474.
▲
by
asah
3y ago
sweet! but alas, I'm looking through the examples and one line of simple+clear JQuery is a often a dozen tricky lines of pure CSS.
475.
▲
by
asah
3y ago
"enshittification" happens because wall street demands revenue growth, and eventually companies run out of innovations and optimizations, and have to resort to raising prices.
476.
▲
by
asah
3y ago
I just tried installing this on a fresh GCP instance with NVidia T4 GPU, and let's just say it was non-trivial. The CPU version running on my mac was mostly an OK install and worked pretty well.
477.
▲
by
asah
3y ago
lol, more like a (quantum) of (computer music) !
478.
▲
by
asah
3y ago
He buried the lede: "Drawing comic strips for five years without pay drove home the point that the fun of cartooning wasn't in the money; it was in the work." My advice is similar: don't do what you love, do what you can
479.
▲
by
asah
3y ago
Watering down is standard for politicians responding to social change. This is the first step.
480.
▲
by
asah
3y ago
nah. But it will mean 100M even-more-vulnerable consumer PCs and a Big Business providing aftermarket support for 140M business PCs.
More ›