Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
zasdffaa
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
12 ms
·
91.
▲
by
zasdffaa
4y ago
> with competitors that were more focused and agile and had lower cost structures so do economies of scale apply as a principle, or not?
92.
▲
by
zasdffaa
4y ago
One place advertised on StackOverflow jobs a while back. I followed to their job details. Under perks of the job they said free fruit, and that they used version control. That as a fat No then.
93.
▲
by
zasdffaa
4y ago
> creating threads is not possible because the logging system makes heavy use of setjmp(). Naive question from a non-c user, setjmp/longjmp just manipulate the stack and since each thread has its own execution stack, that should be
94.
▲
by
zasdffaa
4y ago
Now this is a useful answer, and perhaps the best in the thread, thanks
95.
▲
by
zasdffaa
4y ago
WHY bad? HOW am I supposed to learn anything from "It's bad"
96.
▲
by
zasdffaa
4y ago
I don't think subqueries are so bad - at least they're clear, and if fast, that's surely problem solved. IME they are clearer and often faster, so overall better. I know purists don't like them but I do.
97.
▲
by
zasdffaa
4y ago
Am curious. How would you write it 'properly'? Other (good) alternative is with toporders as ( select max(order_total) as maxOT, customer_id from orders group by customer_id ) select last_name, maxOT
98.
▲
by
zasdffaa
4y ago
In fairness there's nothing weird about that, it being just a typical correlated subquery. I'd quite possibly do it that way.
99.
▲
by
zasdffaa
4y ago
I do think we should be "protecting all the things we hold dear, family, culture, art, friends, the future", which is why I prioritise eg. climate change, it is a far greater threat.
100.
▲
by
zasdffaa
4y ago
Can't see the top sql because it keeps flipping over, WTF. Where are these examples?
101.
▲
by
zasdffaa
4y ago
The website's awful. There's no user testing on it - why do I have a 20 sec progress bar before it tells me I need to select files - where from? Drag from where? What format? Found the datasets - what is AAPL.csv? What do the colu
102.
▲
by
zasdffaa
4y ago
> With single level store, the program pages are mapped in, not copied. Writing to the page alters the disk image. All processes running the same program share the memory pages. Umm, mmap'ed files on linux allow both https:/&#
103.
▲
by
zasdffaa
4y ago
You can't copyright a style. And this is automation, which put lots of people out of work a while back eg https://en.wikipedia.org/wiki/Luddite amongst other protests (people like Hollie, too). But Disney right no
104.
▲
by
zasdffaa
4y ago
I see. Seems rocket engine efficiency must have seriously improved while I was not looking, thanks.
105.
▲
by
zasdffaa
4y ago
Did I miss something or did this rocket have no stack - it was a single stage (with boosters, but aside those still one undivided rocket)? Can anyone comment on that please.
106.
▲
by
zasdffaa
4y ago
> At what point is the car a truck? when you can use it as a truck (ie. when it can do what the car isn't adequate for).
107.
▲
by
zasdffaa
4y ago
I don't understand that. Quite literally it is (or seems to be). In the 'design' section: "With a single-level storage the entire storage of a computer is thought of as a single two-dimensional plane of addresses, pointi
108.
▲
by
zasdffaa
4y ago
A search for Single-level store gets me https://en.wikipedia.org/wiki/Single-level_store "The term originally referred to what is now usually called virtual memory" And seems to lead on to memory mapped files
109.
▲
by
zasdffaa
4y ago
it's not undefined behaviour, rather it's trying to be helpful by coercing stuff where it can. Unless I'm missing something, it's perfectly defined.
110.
▲
by
zasdffaa
4y ago
This has been known for decades, and is why the original mac (1980s?) was black on white. It keeps being forgotten. UI knowledge keeps being lost.
111.
▲
by
zasdffaa
4y ago
I don't buy this eg. > Black text on white from a computer display is akin to reading a book in direct sunlight and tires the eye. No it doesn't. I don't know where that claim comes from. In sunlight reading is reduced thr
112.
▲
by
zasdffaa
4y ago
Good question, my answer was misleading. It changes virtually nothing in the parse or in the resulting AST. Writing the parser as a process has made me (even) more familiar with SQL syntax and semantics and understand it better, which has
113.
▲
by
zasdffaa
4y ago
And helloooo eternal september. You haven't a clue.
114.
▲
by
zasdffaa
4y ago
That's entirely irrelevant. It was available, got used, and things massively fell over when it was pulled. You've given no case to show things have changed - can you actually give any evidence that 'JavaScriot runtimes are qu
115.
▲
by
zasdffaa
4y ago
And a turing complete language delivered from a third party over said network connection to be executed locally will exponentially increases that risk, no? > JavaScriot runtimes are quite well audited meanwhile. Given (for example) the l
116.
▲
by
zasdffaa
4y ago
Turning mistakes into possibly unwanted run-time behaviour is dodgy. The user may end up with a problem that's harder to debug than just a crash. Perhaps have a switch that can enables stronger type checking.
117.
▲
by
zasdffaa
4y ago
Having written an sql parser, I very very strongly agree.
118.
▲
by
zasdffaa
4y ago
> Lil has a soft, spongy, dynamic type system in which values do their best to convert to a more relevant type as the need arises. Noooooo, this is a terrible idea if you want this to be used at any non-trivial scale
119.
▲
by
zasdffaa
4y ago
from https://www.mediawiki.org/wiki/No-JavaScript_notes 2021: NoScript has between 100,000 and 1,000,000 installs on Chrome[1], and approximately 330,000 installs on Firefox[2]. NoScript is a "recommended extensio
120.
▲
by
zasdffaa
4y ago
> Great machines to develop traditional database apps on Hi, could you explain what it was that made them so good to do this, thanks.
More ›