skysight-inc/HackerNews huggingface dataset:
> Well, you know about triggers!!!

Yes, and I also know about other nefarious things like monkey patching in some OO languages. Doing such things is antisocial behavior and something that 99% of developers don't expect.

> Those written by the people who wrote that trigger, designed the tables, your whole schema.

As I said, there was no documentation.

> you might create a new contract with that customer later and not want to start from scratch

Or you might get sued for non-compliance with the GDPR.

> because someone who doesn't understand these things might have enough privilege and ignorance to do a real DELETE and break your data.

Or you revoke the privileges and create a straightforward procedure. No magic, no surprises. And you can still grant delete privileges to a role that can delete customer records for GDPR reasons.

> You're choosing to take one aspect of SQL RDBMSes extremely literally while then also choosing to ignore or malign another part. That's not a recipe for success.

The difference is that SELECT, INSERT, UPDATE, and DELETE are straightforward features that do exactly what you say unless you use another malicious feature recommended by leading database experts not to use:

avoid all triggers, all of them, they are evil. — Tom Kyte

My advice is to avoid using TRIGGERs — Joe Celko
Hi HN!

Looking up media biases online could be a boring task - that's why many people never bothered to look them up. BetterWeb helps you do this by providing a fun user interface telling you political biases and reliabilities of different sources with the click of a button. Try it out for any Chromium browser! The project is also open source on GitHub: https://github.com/betterweb-team/BetterWeb
Hopefully they don't send you an inactive enantiomer!

Or an insoluble polymorph.

Realistically, a lot of cancer drugs are injectables, ramping up the risk of something going awry when you inject the powder you will have to handle.
Even though it's the same currency, wouldn't the buying power and cost of living be higher and lower respectively in the poorer countries and somewhat balance it out? Separate currencies are just an abstraction - what really matters in the local economy would be things like the cost of wages or the cost of living expenses.

Edit: _delerium answered my question pretty well in a reply to another commenter.
Most snapchat/whatsapp dealers are 100% fake. Engage with them and see how fast it turns into the same scam language someone on Craigslist trying to buy your item from another state is.
Hamilton also removed unanimous decision from the 6th amendment because common law of jury trial already established that and he didn't want to specify some part of that common law and imply exclusion of other parts related to jury trials. This is now being heard by the Supreme Court in Ramos v Louisiana.
This video https://www.youtube.com/watch?v=Nof3FQj90f8 is a good overview of how things are going so far in that case.
You ever use RH? It's been hard to take them seriously since day 1.
Yes the whole aspect that a democratic result done upon proportional representation could be overturned by split votes and more so a voting system that is regional. Does make you wonder.

Since the referendum we have had a GE a EuroMP election and now...another GE. With only the referendum and the EuroMP being done on the proportional representation system.

Sad thing is, had David Cameron got the EU to agree to reform, things would of been much different. Which is ironic as Mr Macron is keen to see reform, with even Donald Tusk not long after the referendum saying that the EU needed reform. Ironic as that reform is on hold, until the UK leaves. That's sad as in all this time, the EU could of outlined some reforms and the whole reason to have a revote upon the leave/stay would of been more palatable as things had/was changing. Bit like saying your going to quit a game due to some imbalance that has gone on for ages that you don't like, and before you quit, they say they are going to address the issue. So you may well change your mind.

However you look at it though - a lot of people got way more politically educated over the past two years. Be interesting how that pans out over time.
I wonder when the txt file was invented?
While this is technically true for all satellites, what's important is the timescale on which their orbits will decay.
I feel most of these social theories have no basis is reality. Similar logic is used to argue that videogames cause violence, or (in Russia) that men become gay because it's cool.

They just 'make sence' to the people perpetuating them.
They correct the predictions for past data, but I'm sceptical as to whether it's possible to correct for emerging feedback loops when the results of the analysis are public and cause a change in the behavior patterns being analyzed.
..consisting of the majority (over 72%) of eligible voters. That's a high turnout.

(FWIW I don't think a referendum should have been held in the first place, and an un-referended decision either way would have been better.)
Well the 10th amendment specifically says this: The powers not delegated to the United States by the Constitution, nor prohibited by it to the States, are reserved to the States respectively, or to the people.

So we only delegate to the federal what is specifically enumerated in the Constitution. And the enumeration of certain rights does not preclude the existence of other rights not specifically listed.
During the past six months I have been challenged intellectually and aesthetically by these works:

Paideia: The Ideals of Greek Culture, vol 1-3, by Werner Jaeger

Diary by Witold Gombrowicz

Computer Science: An Interdisciplinary Approach by Sedgewick

2666 by Roberto Bolaño

The Linux Programming Interface by Michael Kerrisk

Tomie: No Use Escaping by Junji Ito

L’homme aux cercles by Fred Vargas

Cryptonomicon by Neal Stephenson

Lab Girl by Hope Jahren

Operating Systems: Three Easy Pieces by Arpaci-Dusseau

I Contain Multitudes by Ed Yong.

The Weird by Ann and Jeff VanderMeer

The Federalist Papers, ed. by Kesler

The Anti-Federalist Papers, ed. by Ketcham

Doctor Faustus by Thomas Mann, new translation by John Woods

Searching for Stars on an Island in Maine by Alan Lightman

Loren Eiseley in the Library of America Edition

Tu rostro mañana by Javier Marías

The Complete Essays by Michel De Montaigne, translation by Screech

Earning The Rockies by Kaplan

Desperate Remedies by Thomas Hardy

The Notebooks of Joseph Joubert

Nature Stories by Jules Renard

Mac y su contratiempo by Enrique Vila-Matas

Olinger Stories by John Updike

Greek Science in Antiquity by Marshall Clagett

At The Existentialist Cafe by Sarah Bakewell

100 Diagrams That Changed The World by Scott Christianson

Heart of Europe: A History of the Holy Roman Empire by Peter Wilson

Alec "The Years Have Pants" by Eddie Campbell

Landmarks by Robert Macfarlane
Not true at all. I am from Czech republic and we benefited massively from these contributions. If I compare for example general state of infrastructure it is much better than in UK where I currently reside. All the train stations were rebuilt using EU funds. Also not sure what you are talking about "This halfway step only serves the wealthy.", not not really. Look at quality of life and GDP rise in post soviet EU countries.
> halfway step only serves the wealthy

How?
There's an analogous difference between pro-censorship and anti-censorship factions.
Tools for Conviviality - Ivan Illich; The Dark Forest - Liu Cixin
Do they have to go bankrupt? Can’t the state just pass laws to force them to quit operating? Sort of like eminent domain (or maybe exactly?)

I’m sure they’d have to make reasonable payments to the shareholders, but it’s not like PG&E is in a very good bargaining position here
I don't know, they shouldn't sue them simply for taking advantage of the exploit, these users did knowingly take on leverage by borrowing money to do so. The standard practice when taking on leverage is that you owe the money one way or another. Saying that Robinhood wouldn't have want to give them that leverage, but did give it to them, doesn't really change the legal obligation to make good on a debt willingly and knowingly incurred.
Amazingly you can get cheaper cell plans including more data than these unlimited plans in the socialist bastion of Europe. I don't think the bandwidth is the problem it's the company and the regulatory capture. It's only this bad in the US and Canada.
Agreed. It can take that long living in town, to drive a mile to the grocery store. I drive 12 miles to the edge of town, rarely seeing another car until I'm almost there, to a grocery on the edge of town. Takes 15 minutes
Shaderfrog is more geared towards shaders you can actually use in realtime effects for webgl. Shadertoy otoh is really high end proof of concept and high art focussed. That said. I have managed to use some shaders from shadertoy in different tests of mine..

http://vectorslave.com/iqclouds/
That's why we should adopt the customer-owned utility model used for SMUD in Sacramento county.
Not sure I agree. Some propaganda probably just wants to rile up the base.

It's also possible to change which issues seem most salient/urgent/etc. without actually changing anyone's mind. E.g. Democrats typically care about police brutality, and the environment, but they probably thought more about the former a few years ago and the latter more in 2019, even though AFAIK the actual issues haven't changed much.
I don't think they were complaining. Now they have boots too!
Don't believe all of the cultural memes that you see on TV. I think the reason that the smaller population areas were dissatisfy was the outcome of globalism and off-shoring of jobs.
Ehhh, everyone (relevant) already knows the general process for making highly enriched uranium or Pu-239, and how to make a bomb with it once they get it. The issue is that actually implementing those things takes a ton of infrastructure, and until relatively recently that infrastructure was extremely visible. As gas centrifuges have replaced gaseous diffusion as the primary method of enrichment, though, the amount of - and visibility of - required infrastructure to refine uranium has decreased dramatically. 20 years ago enriching uranium in a cave would have been incredibly impractical, as the machines were just too large and required too much power. But today... :(
Depending on when you last looked at Dart, there's a good chance we've either fixed or are fixing the things you hate about it. What didn't you like?
> That being said though, I'd expect that a tuple would satisfy a `any[]` type.

You have it backwards, the error in question is complaining that `any[]` does not satisfy the tuple type.

Minimal repro:

function f(x: any[]): [number, string] {
return x;
}

The error matches yours:

Type 'any[]' is missing the following properties from type '[number, string]': 0, 1

From poking the playground, `any[]` hasn't been assignable to tuples since at least v3.3.3

My guess is that the compiler got smarter around reasoning about your `SinonSub` generic and is now forcing you to deal with lingering unsoundness.
1. Older paradigms have been reinforced by many predecessors, creating lindy effect.

2. Being a relatively new paradigm, less people understand where, when, how, and why FP fits. There is a lack of effective education over FP.

3. Having some radical jargons (e.g. HOF, recursion > looping) , FP brings fear of change. Especially, recursion > looping can only be applied to languages with gc, preferably those with tail call optimization.

4. FP's more universal virtues (immutability, pure functions, type system, no side effect) are not advertised enough compared to other virtues (recursion, hof).
I agree completely, except for the "fun" part --- what developer enjoys waiting for gargantuan projects to compile, slow tools to respond, or debugging through a byzantine maze of dependencies and indirection bloat?

...unless it's this sort of fun, perhaps? https://xkcd.com/303/
Can we just end this capitalist cancer already?
I agree, when I use d3 and react together I tend to use all of the non-DOM-manipulating d3 utilities for transforming data then react for rendering the DOM. D3 is a swiss army knife of utilities for data visualization, and as you point out only a small part of it deals with DOM manipulation.
> if I could figure out what kind of one would do that kind of work

Open up the phone book. I'm sure you can find one within a day.

Chemists like money. Especially when it's not even a controlled drug.
Different isn’t always better.
>preventing friends from oversharing "your" data.

I don't think this is really what privacy advocates are typically after. At least I'm not, and I'd consider myself one of them. It's more about what data the provider has access to, not your friends.

If you don't trust your friends, uh... get better friends?
>Microsoft might need to add something like a legacy control panel which only appears if you install an old app that adds something there.

That's literally what they've done, the problem is most of their own systems are legacy!
There is no fiscal union, but there certainly are transfer payments done on a regional (not national) level; i.e. a region of a country (or the whole country, if it is particularly poor) can access EU funds for infrastructure and the like.

https://en.m.wikipedia.org/wiki/European_Regional_Developmen...
For those interested, the demo instance is at https://sandbox.ebay.com/ The message at the top says "eBay and PayPal will be separate companies soon", even though they became seperate companies 4 years ago.
Lena source image resulting in some other random woman "reconstruction" = model over fitted AF. Put a dead fist and it will continue generating "reconstructions".
> There's nothing wrong with having a trigger that turns deletes into updates, if that's what you want.

While I wouldn't use it on base tables, a view that provides a “current” picture where deletes are updates (or even inserts of a deletion event) into a base tabl with (potentially along with others) provides a complete historical picture of the status of the data of which the view presents a current snapshot is a useful approach.
> Can anybody who is not into climbing even tell this is all fake?

Hm, I'm pretty sure it's hard to climb five 8000 meter peaks in 24 hours :)
I don't know if this is a good analogy, but as an Electrical Engineer, the process of simplifying the analysis by going from Newtonian to Lagrangian gave me flashbacks from the first time we used Laplace transforms to solve (previously very, very tedious) circuit analysis problems. Almost felt like cheating.
The crisis was caused by lying about the kind of risk hidden in collateralized bundles of debt. That doesn't seem to be an issue this time. It's just about the inherent dangers of lots of people moving in to homes they can't afford to pay for.
I'm a big fan of the new operators.

One of my remaining gripes with Javascript/Typescript is the try/catch mess around await. It makes assignment of const a pain for async calls that may reject.

e.g.

let result: SomeType;
try {
result = await funcThatReturnSomeType();
} catch (err) {
doSomethingWithErr(err);
}

// at this point result is `SomeType | undefined`

if (result) {
doSomething(result);
}

I really want some kind of structures that allow me to make `result` constant. In some cases I've rolled my own Maybe/Either wrapper and then move the try/await/catch into a function but that is still a pain.

This is such a common pattern in my code ... I wish there was a more elegant way to deal with it.
I don’t see a reason in your response other than “the political system is bad”

I’d be more curious if you had a reason why you think state-owned would be worse than state-regulated.

To me it seems better for sure. A panacea? No, but better than where we’re at today
Still no license for flying a shopping bag, despite one blocking whole airport and starting this circus.
How does the conditional type inference work? E.g. from the article:

let stack = VStack {
if myState {
Text("Hello")
} else {
Rectangle()
.fill(myState ? Color.red : Color.green)
.frame(width: 100, height: 100)
}
}

Type:

VStack<
_ConditionalContent<
Text,
ModifiedContent<_ShapeView<Rectangle, Color>, _FrameLayout>>>

How does an `if` expression get inferred as a type `_ConditionalContent<...>`? Is there some magic support for SwiftUI in Swift? Does it desugar into something like:

let stack = VStack {
ConditionalContent(myState,
Text("Hello"),
Rectangle()
.fill(myState ? Color.red : Color.green)
.frame(width: 100, height: 100))
}

?
no, just the client!
Cppreference (learn by doing and look stuff up as you go)

https://cppreference.com

The ISO C++ Standard draft (unironically—it's actually quite readable and is actually up-to-date unlike a lot of books)

https://wg21.link/std

Tour of C++ (book) by Bjarne Stroustrup (start here, you can read it in one weekend)
> They can't all win - and that's assuming any of them win.

While I agree with your general point, do we completely understand the opportunity that space launch/travel/exploration provides yet?

The opportunity may be exponentially bigger than we currently understand.
This was the exact legal rationale accepted between Schenck v. United States and Brandenburg v. Ohio that allowed the imprisonment of people for advocating draft resistance and organizing communist parties.
You're not the only one, but I'm of the other thought.

I like the insane level of backwards compatibility.

When you can run a windows game from 1996 with only a few tweaks, it's beautiful. It's a worthless gimmick, but it makes me pop.
I suspect most people outside of the most privileged circles know at least a couple opiate addicts who have ruined their own lives and harmed others around them.

the important question to ask is how much of this is inherent to the drug itself and how much is a consequence of prohibition. my take is that most of the horrible things that heroin addicts do is a result of the financial/legal situation that prohibition puts them in, not the inherent effects of the drug. in my experience, opiate addicts with a secure supply tend to be docile, if unproductive, members of society. I wouldn't say the same for alcoholics...
Robin Hood customers absolutely should consider switching. These are the basics, and they can't even get it right. Would you trust a GP who didn't know how to use a thermometer? What happens if it's the other way around, and the customer's account shows a net profit but their books don't reflect that?
Yeah, that's my assumption as well. It would explain why there's no mention of it in breaking changes, and why being specific about the generics in `SinonStub` fixes the error.

Makes me wonder what other unsoundness the compiler isn't catching.
Collection agency. They'll get something, and probably most of what the customer has.
I did notice a difference but the bacteria comes back if something is affecting mobility.

After the second time. I did three things that really helped.

- Ate chicken/carrot for lunch. Fish/seafood/bacon/pork/beef roast with one or all of squash, zucchini, spinage. In between I made a loaf of banana bread with honey and most importantly carob and ate one a day. That digested earlier and didn't feed the overgrowth lower allowing me to put weight back on. The carob forced mototity

- I did pure cbd in very small amounts for 2 weeks. That seemed to help close intestinal valves.

- I stopped all starches. Potatoes, sweet potatoes, peas..

I'm 4 months off of the second round and feeling and looking much better.
> copyright enforcement.

Ahh, but copyright won the last war, by moving to centralised platforms. The privacy mavens are going to lose, but they are going to lose to Big Brother, not to decentralisation.
It's a two way street, the sovereignty argument. A bigger entity has different sovereignty to multiple smaller entities. The British pound is worth about half what it was when I first moved to the UK - that's not the kind of sovereignty that's kind to my pocket. A bigger currency is a more stable store of value for citizens. That's not worthless, independent of the lack of friction in international transactions - not a major friction online, but really nifty when you cross a land border every day.
This is true. We drive 30 minutes to a butcher in Roanoke, AL and it is seriously packed on a Saturday. Reasonable good meat and local flash frozen southern vegetables.
Well, it gives two different heights and locations for a single mountain
Google is at fault for this constant outrage from employees over contracts, government work, and selective biases. It percolates down all the way from the top there. It's not good business, the inmates are running the asylum at Google.
Forgetting the politics of George Soros (which isn't suitable for HN anyway), I don't believe he is to blame for the UK government's questionable choices.

To put the estimated £3.3 billion loss into perspective:

* The failed NHS software update/upgrade project cost >£12 billion [0].

* The UK spends ~£9 billion a year (after calculating rebates) to be a minority voting block in the EU [1]. It's currently costing ~£0.75 billion a month to stay in the EU [2].

* The "divorce" settlement to the EU is currently set between £30 billion and £40 billion [2]. To put that itself into perspective, that is each person (including people on death's door and babies) in the UK (~70M) paying the best part of £600 out of their own pocket to the EU - something they never voted to be a part of anyway.

I could go on all day about the UK government's awful handling of money.

[0] https://en.wikipedia.org/wiki/List_of_failed_and_overbudget_...

[1] https://fullfact.org/europe/our-eu-membership-fee-55-million...

[2] https://www.bbc.com/news/uk-politics-49563957
This is the same as most Australian states where failing a breathaliser results in leaving your car, handing over your keys and doing a blood test for a more accurate reading. You're fine to go if you're under; also the penalties vary on the reading so they need it to be fairly accurate.

I was under the impression that it was common knowledge that the breath test is unreliable and never relied on in court as evidence. You also can't rely on the self-test kits if you think you might be over.
Might be different in other markets, but in my home city picking the best (price, time) ride is not so easy. The time it takes for the car to arrive varies a lot. In all the services available I need to first place the order, then they find the car and after that I get estimate how long it takes to arrive. I can cancel and try another one, but that’s quite inconvenient. Also the time estimates seem to be fairly optimistic.

At least on my case this means that I’m not always trying to pick the cheapest option, but instead go with the option that has had good price/performance ratio in the past.
People perpetuating it would have us believe the human race has been degrading for a few thousand years:

The children now love luxury; they have bad manners, contempt for authority; they show disrespect for elders and love chatter in place of exercise. Children are now tyrants, not the servants of their households. They no longer rise when elders enter the room. They contradict their parents, chatter before company, gobble up dainties at the table, cross their legs, and tyrannize their teachers.

Socrates
https://www.touchstoneenergy.com

"Touchstone Energy Cooperatives represents a nationwide alliance of member-owned electric co-ops, including yours. Collectively, it delivers power and energy solutions to more than 750 unified local electric cooperatives across 46 states, forming the largest electric utility in the country."