skysight-inc/HackerNews huggingface dataset:
>>> The relationship between Orders and Products is one-to-many, not many-to-many.

Let's deal with this one first. Suppose customer 12 orders 10 pounds of gravel and a potted cactus while customer 15 orders 30 pounds of gravel and a cherry sapling.

I claim that this illustrates that it's possible for one order to be associated with multiple products (customer 12 placed an order for two different things), at the same time that it's also possible for one product to be associated with multiple orders (customers 12 and 15 each ordered gravel).

But you appear to know better than me. Please explain to me why it wasn't possible for the same product to appear in several orders.

> I always find it hilarious how passionate people can get about SQL just because it's hard to discuss without a full working example.

I actually don't have much in the way of opinions on SQL. But I do have strong opinions about self-righteous stupidity. You have repeatedly made it plain that you don't understand what the words you're using mean. Take this claim of yours:

> why aren't these tables normalized better anyway? None of them should have columns for the PK of another table.

The tables are already fully normalized. It would be possible to render them differently, so that (for example) the Orders table didn't have a column for CustomerID and instead a separate table existed with records of the form (OrderID, CustomerID) -- but this would not affect the normalization of the tables. All this would do is cause you to perform extra queries whenever you had one piece of information and you wanted the related piece of information.

Or this one:

> Also, OrderDetails is not a bridge table because it has the quantity of Products.

Annotating the relationship it embodies won't make OrderDetails not a bridge table. It's a bridge table because it records the many-to-many relationship between Orders and Products. Here ( https://www.youtube.com/watch?v=uKd01Ouw_b8 ) is a university lecture in which one of these tables is explicitly identified as a "bridge table" at the same time that it records such supplemental information. (In that case, what's happening is that the "AssignmentGrades" table bridges between "Assignments" and "Enrollments" while recording the grade each student earned on each assignment. This is fundamentally identical to OrderDetails bridging between Orders and Products while recording the quantity of each product purchased in each order.)
This is not just an ignorant idea but a stupid idea. Just because you can't figure out the right way to do it in vanilla SQL doesn't mean it can't be done [1]. This strawman is just a different form of the NoSQL strawman [2].

Edit: Ah, looks like I've struck a nerve with the event sourcing Datomic fanboys. Enjoy using your golden hammer and turning every problem into a nail!

By the way, if you ever make my way into my organization and waste my time with this nonsense, I WILL fire you. Nobody should tolerate your desire to solve already-solved problems with poorer quality solutions you have selected for their novelty. At that point, I'll kindly ask you to please explain to me what a write ahead log is and what it does, because if you don't, I'll happily explain it for you.

[1] https://brandur.org/idempotency-keys

[2] https://www.youtube.com/watch?v=b2F-DItXtZs
Don't look before you jump, instead look after you jump, because then you can rollback and undo the hurt :)

You can do this with deferred triggers, for example. Here's where a COMMIT trigger would be handy -- something that runs when the client's COMMIT begins executing (though other triggers could still run in the COMMIT trigger were to execute any DMLs).
The big place where it happens in modern environments are for pointers to members, where 0 is a bad nullptr value because the member at index 0 is legitimately a thing you want to name. MSVC uses -1 for nullptr in such cases.
This is the answer. Young people especially need to realise that this country doesn't want them.
Your comment seems unnecessarily antagonistic.

Given whatever size of garage I have, being somewhere I can live without a car gives me more garage space, regardless of whether it's a suburb. If I want to maximize garage space given my choice of a car-free lifestyle, I would probably move to a suburb with a good train station, not one where "only 20 minutes' drive to downtown" is seen as the selling point. Those are subtly different kinds of places, in my experience, where most people are going to fill their garage space with cars.
I too question why people make flame-baiting comments about topics they don't understand.
It's failing to start, tons of errors in the console. The language looks good, and I'd like to give it a try but I can't find any repo of the compiler/LSP extension so I can try it locally, it seems only this hosted IDE exists and then some kind of remote shell script execution. Both are non-starters.

Just make it public/open source.
It's tough to see the arguments, I can't sympathize with her because doesn't seem to be offering arguments in good faith.

To her credit, gender discrimination is hard to prove and perhaps she felt she really had a strong case (based on the risk she took - this action may close some doors for her), but allowing these arguments to go through really erodes what facade of meritocracy we have left in the industry.

The claims seem to be have gone as far as saying she should have been hired as VP. Her background was senior tech management at a bank, which no doubt is a significant appointment, but I don't think it's easy for anyone to argue that bank tech management easily transfers to big tech.

Giving L8 and presumably a sizeable raise from her bank role means Google already valued her experience very highly. Much more highly than I would have tbh; if someone was top level management in an bank, effectively at least partially responsible for the poor culture of bank tech, and then hired as senior tech management at my company, us grunts would be running for our lives. As she didn't get consistently stellar performance reviews as L8 (which Google uses as argument), the only thing one can argue for is that the performance reviews were biased - which again to her credit tends to be hard to prove - but there's no reason to believe that say a third party looking at those reviews would have given her a promotion.

I also can't fathom someone is arguing in good faith that at this level MS in CS should be a barrier. It should be clear to any Google L8 that MS in CS means absolute jack shit for anyone who manages to get to L6, if not L5. It should only be a factor in junior-ish hiring. For one, Google's technical work even at L6 level can literally shape curriculums at universities. It may just be a legal tactic but I don't want US courts to lend any credibility to this argument, and anyone who wants the court to sanctify this point is basically someone that damages my profession and I don't want near my jurisdiction.
Next gen http
why can the browser work with copy/paste and intercept keys in the first place?

I would like to turn all that completely off.
> In general, globally, pre mine arrival local communities

That was poorly phrased, I wanted to distinguish between communities local to mines from before the mine was established as opposed to communities established after a mine arrives.

Long term locals can often get fully sidelined, especially indigenuous and or otherwise minority communities.

> These lands are owned by the federal government and not the local community.

Globally?

I suspect things vary in detail as you travel about the world. Still, in the case of a Federal government that represents the entire population of a country it might be asked why that body is essentially giving away a resource within the territory of the people it represents for very little in return.
> have a treaty with the government to that effect which is being violated by "giving you"

The treaty was violated, but it isn't currently still being violated, is it?

My understanding of international law is that treaties are considered terminated once either party violates them. Does that apply to internal treaties like this too? These usually work within the framework of sovereign nations.

I might be getting way too pedantic with this, but I don't know if that's how it works.
I'd rather they open the spectrum up for unlicensed use than do this.
Nice that more of these are popping up; cf.

https://news.ycombinator.com/item?id=37954707

But I would hope that these wouldn't all be online apps. Unfortunately, the open source community never managed to build a decent diagram application (although you can of course play with TikZ etc.).
No, it really is completely unproblematic; "But", you might ask, "what if a current leader does so as partisan retaliation, is not constrained by other forces, and starts of a chain of retaliation against past leaders?"

Sure, but using criminal process or any other power of office to punish partisan enemies is a problem whether or not the target is a past leader; there's no special danger around past leaders. if anything, there is less danger around past or current high government officials in general, and past Presidents in particular, because of the extraordinary degree to which those persons tend to be visible and well-connected politically.
macOS is Unix, though.
Gergely Orsoz, The pragmatic engineer, duped into chatting with a bot account
I love this site for quick prototyping. Anyone knows of something similar (with quick rendering like this) that can be self hosted? I usually can't send any "architectural" information outside the company and fall back to less dynamic generation.
Asking this earnestly and not as a rhetorical question: what do I get from Prolog that I can't get from using SQL? Is it speed, is it ergonomics, is it the ability to do computations that are otherwise intractable? And if there are any such advantages, at what level of complexity of abstraction do they come up, and at which level would I not see the value of using prolog?
I've never really been a bond fan, but of course the craig era eschews much of the almost 100% of the camp of previous generations. Except (and you'll need to pardon me, i've seen each of these movies at most once and they don't really stick in my brain at all) maybe the villan who's face had been eaten by acid or something, it's not jawz or oddjob levels of camp but it's getting there.

Earlier bonds i've seen a few here and there but missed many. Like I've seen moonraker, but never thunderball, view to a kill but not goldeneye, octopussy but not never say never again. I couldn't tell you what any of the plots were (other than i'm pretty sure they go to a moon base in moonraker) or which villan goes with which film. Bond, to me, has always been kind of a mystery to me, how do these terrible films keep getting made?

I will also say that 'yes' to thor rangnarok, no to 'love and thunder' which i thought got mired in too many plots and had too many inappropriately timed jokes. Like do the Jane arc or do the Gor arc, but if you do either right they don't both fit in the film. So instead they opted to do a half assed version of each.
The Road User Fee Task Force was almost right. They didn't take into account curb weight.

The right way forward is a weight-mile tax, like those levied on fleets and cargo transport. Good news! That will create incentives for lighter passenger vehicles, ending the reign of deadly oversize SUVs.https://jalopnik.com/watch-video-on-us-deadly-obsession-with...
> In the first case they are paid the same as someone with a higher title, and when promoted inevitably they will be paid more than someone with the same title.

You act like promotions are automatic, but you're ignoring case where they never get promoted, and can't leverage their resume nearly as effectively because of the lower title.

In which case, all they got was a temporary pay bump in exchange for doing extra work, but didn't get any credit for that work.
Have you not followed nvidia? He literally makes himself the center of attention at all times.

Any new announcement features a video of him making the announcement. They’re more CEO focused than Jobs lead Apple was.
It would be interesting to contrast this with a possible theory that Prometheus represents an oral tradition of the first controlled use of fire around 1M years ago.
I bought it outright. Salvage, so it's possible that the previous owners died in bringing it to market.
Let's look at one US University, UC Berkeley. 26 faculty Nobel Prize winners and 35 alumni winners. The current faculty includes 262 American Academy of Arts and Sciences Fellows, three Fields Medalists, 77 Fulbright Scholars, 139 Guggenheim Fellows, 90 members of the National Academy of Engineering, 144 members of the National Academy of Sciences,[81] ten Nobel Prize winners, four Pulitzer Prize winners, 125 Sloan Fellows, 8 Wolf Prize winners and 1 Pritzker Prize winner.

Or, lets take CalTech with a similar size enrollment (in the thousands): As of October 2022, Caltech has 46 Nobel laureates to its name awarded to 30 alumni (26 graduates and 4 postdocs), including 5 Caltech professors who are also alumni.

> IITs are prestigious institutions. They’re not OKish institutions in the slightest.

They aren't. They are a filter for a few thousand out of 1.4 billion people. Yet, all the IITs put together produce nothing compared to the output of one US University. > 99% end up writing Java code for Wall Street or work for ad-tech. I doubt they are pushing the boundaries of science.
Teens Want Parents to Track Their Phones and Monitor Their Every Move
Certainly the Sphere will be quite difficult to use without fractional scaling as well.
I realize that this is a hot take, but I think that

> money ... allows collaboration between groups with opposing values, because at least we have one motive in common

...only really holds if our common motive is that we both don't want to be killed by some Leviathan type thing (originally this a Roman soldier who would kill you if you didn't trade Caesar-face coinage above its buillion value). Money today is just a proxy for the same old violence as before.

This places a cap on how legitimate money can be. The have-nots, should they ever manage to coordinate, would be better off turning their backs on it. When a rich nation shows up and starts throwing money around, you can be sure that the poorer nation is getting screwed. Probably there's some kind of violence hanging around ensuring that they don't act up. See the history of US policy in South America in the 70's for more on this sort of thing.

If we want to move past all of this yucky stuff I'm talking about, we need to your acceptance of my money synonymous with me proving to you that I've done something that benefitted you specifically. As it is now, it's just proof that my activities somehow benefit a bank somewhere.
> There's virtually nothing I'm interested in that's in walking distance

That's the problem to solve, then.
> This assumes that the same barriers are being put up in front of all candidates, no?

No, my example very much does not. It's about the exact the opposite, where extra barriers are put in front of one group, but not the other.
To get to the bottom left: [RRR][[[[[[F]F]F]F]F]F]F[RRR][[[[[[F]F]F]F]F]F]FF

https://susam.net/cfr.html#BR3EB6FEFEFEFEFEFEFBR3EB6FEFEFEFE...

Prepend a C to get there without drawing lines on the way. Suffix with [RRRRRR]C to rotate upwards and get a visible color again.

Whenever I'm lost I paste [[[[CFCF]]]] at the end to find my cursor.
Job Search advice and resume feedback
Hi!

I recently graduated with a Masters degree in Computer Science. I conducted research and did my thesis in the field of Machine Learning and Computer Vision.

I'm interested in pursuing a career in the field of Software Engineering (instead of ML or CV) as I find it more fulfilling and enjoyable personally than working in CV or doing research, especially in startups.

I enrolled into graduate school right after graduation from university so I could only get professional experience while being a student.
By the time I graduated grad school, all my professional experience was in the field of SWE (Full-stack Web Dev) through:

- Four internships: 2 x 3 months + 2 x 6 months
- Freelance work: 1 year 6 months
- Contract work: 3 months

However, during my job search for entry level dev jobs (in startups) in the last 2 months, I received many rejections (100 applications, 50 rejections, 40 no-response, and 10 interviews that didn't result in job offers).

Is that response rate normal considering my resume and my experience?

Here is a link to my resume https://imgur.com/Mssxs1K and I'd appreciate any feedback or thoughts about it (what to improve, add, delete...). I only included my four most recent professional experiences to keep my resume fit in one page.

Thank you
Revitalizing physical collections is certainly a great idea, but it doesn't go far enough as publishing moves into the digital realm. (I'm also not sure "no censorship" is practical but we seem to be moving toward small and very bland collections where anything remotely controversial has been removed.)

As Brewster Kahle notes in the article, current copyright law is unfavorable to libraries and makes it difficult (if not impossible) to build digital library collections legally. To preserve existing publishing models, we have also destroyed many of the intrinsic benefits of ebooks, such as unlimited readers and nearly free global distribution.

Copyright reform, such as a statutory first-sale doctrine and resale and lending rights for ebooks (and other digital media) might possibly help, though it could also provide a perverse incentive for publishers to adopt even more restrictive approaches, such as a service/subscription-only model.

Compulsory licensing (e.g. to public libraries) could perhaps be made a prerequisite for copyright protection. The Library of Congress could also be granted digital lending rights.
Huh, from web searching for "fossil clone" and similar it is more common than I thought. There is even a GitHub-esq hosting site for it.
> Exploiting is a weasel word. They're making the useful minerals useable, which benefits the public more than leaving them in the ground.

Well put. However, with the additional stipulation that it is sometimes useful to leave minerals in the ground if the company that extracts them does not make an unpaid/ unremediated toxic enviromental mess when extracting them.

> The reservations get what they're entitled to, which is nothing.

Depends on who "owns" the land. If the land is owned by the federal government then the reseservations aren't technically owed anything. However, was the land taken from the reservations by force in the past ? If so, then 0% share is highly objectionable. Would you like it I came to you, forcibly took away your assets, made profit from them and then claimed that I didn't owe you anything because it wasn't yours anymore ?

Now, it is fully possible that these federal lands were virgin in the past so then the the federal government does not owe anything extra to any special group of citizens.

TL;DR We must go into the history of the land. Depending on the history of the land, local communities/reservations _may_ deserve a small formal share in the profits of the mining company.

In any case, the government must work for the betterment of all its residents and citizens whether in cities, farms or mining areas. Mining areas deserve special care because they house some of the historically most poor and opressed citizens.
These days the language has become so debased that any new business or small business is called a “startup” (and of course they have to be “tech” startups even if they just sell organic oats online — real example).

I’d set the ground rules up front so people who don’t want a high-growth business (and I see complains about that on this site which is fine) can stop reading. Likewise if your business doesn’t need the CTO function (even if they are still a four-person startup) then you can stop reading.

If your dream for your book is to be about tech startups (in the actual meaning of the two words) I’d partner up with someone else from a different domain relatively soon, then expand the scope again after you’ve got edition 1 done. And call it the “Tech Startup CTO’s Handbook”. What about the folks making semiconductors?
They are pretty easy compared to the others mentioned
'Techno-Optimism' Is Not Something You Should Believe In
As mentioned in the comments for the post, and as I can remember in recent flights, if you drop your phone you’re supposed to alert the cabin crew immediately. Now I understand why.
The white furnace test
> Plenty of affordable homes in Canada at the $500,000 mortgage + down payment range.

Canadian humor is weird.

Using the most typical US salary as a guide, it would require the combined salaries of 6.3 people to afford a $500k home. After adding insurance, maintenance, fees, property taxes, etc - I'm thinking more like 8 people (10 in FL).

ref: https://www.marketwatch.com/story/how-much-do-you-need-to-ea...

ref: https://www.indeed.com/career-advice/finding-a-job/common-jo...
> the economic cycle that has led to the usage of a common computing platform, underpinned by rapidly improving universal processors, is giving way to a fragmentary cycle, where economics push users toward divergent computing platforms driven by special purpose processors

Where does RISC-V and all its extensions land on the GPT <-> fragmentation spectrum?
On first sight, I read "How planets communicate with each other when in danger" and immediately thought of Earth sending messages out for "help".
Silicon Valley is great for running and biking. Just look at Rancho San Antonio for example.
> considering the fact that astronomical extrapolation calculates the movement of the stars to indeed have once been visible as seven, it might actually be evidence of a shared story.

That can't be evidence of a shared story, because people are capable of viewing the sky independently.

The fact that both traditions call them "sisters" might be such evidence, but (1) that has nothing to do with how many of them there are; and (2) it is evidence so weak that it's not worth considering at all.
Add a few other seasonings (paprika, cumin, garlic powder) and you've basically got the Taco Bell quesadilla sauce
The articles up you're both linking to describe people hiking a small portion or part of the length of the overall gap, after which they'll presumably take a boat to continue their journey.

So it's not comparable to driving the whole way, which would be a much larger distance.
> Let's look at one US University, UC Berkeley. [...]

> Or, lets take CalTech with a similar size enrollment (in the thousands) [...]

Caltech student population is a little over 2,200, mostly graduate students.

UC Berkeley is over 45,000, about 3/4 undergraduates.

They don't have "similar enrollments".
Probably just means you need to sharpen it more often.

As I understand it, a steel doesn't sharpen the knife, but aligns the edge - in normal use, the edge folds over; steeling makes it straight again, and should be done before using the knife. It takes a _lot_ of effort with a steel to put an edge on a knife where it's worn away.
Boring technology is so crucial. As a private sector startup company you are already living a fraught existence - why risk it even more with unproven tech?

As an example, mongodb inexplicably became a de facto DB for a bit between 2013 and 2016. It seemed like 1/3 of startup companies switched from MySQL or Postgres to Mongodb. What an absolute unmitigated shitshow clusterfuck moronic disaster
The fake contractor scheme is exactly the same in Sweden, the dividends too and saving assets inside the business entity.
What's inefficient about floats? ML seems to get a big benefit out of having access to multiple/many orders of magnitude.
Generally speaking most content on the internet is spam so I am downvoting yours.