skysight-inc/HackerNews huggingface dataset:
He's (possibly) overselling his accomplishment here a little bit. You can achieve what he's describing using a combination of Plex, Sonarr, Jackett, and a private torrent site. You also need a torrent client that can work with Sonarr (Synology's torrent client works great in "watch this directory" mode).

It's a truly self-running system. Other than the upgrades, you're able to select whatever shows you want to follow, and that's it. They automatically get downloaded, sorted into the right directory structure, picked up by Plex, and on-demand streaming around the world is yours, with all kinds of cool features like bandwidth optimization, offline show downloads, etc. More or less feature parity with Netflix, without any of the restrictions.

Of course it's 100% illegal, though honestly I've never heard of a prosecuted case in the US.
https://www.mentalfloss.com/article/31876/12-star-trek-gadge...
I guess you're a big fan of monopolies, huh?
Don't talk like a religious zealot.

What is the cost of gas in Korea, vs the cost of gas in the US? We're the largest producer in the world. They have almost no gas of their own, and must import.

addendum: I find it striking that this thread is full of people telling me that nuclear costs are high in the US because of the treehuggers, and it's so cheap in France, but according to your chart, nuclear power is actually cheaper in the US than it is in France.
I spent the time to learn it and yeah, it's pretty nice when it's working.

The problem is of course when you need to do something that isn't supported by SystemD, in which case you're in for a world of hurt as the system constantly fights you.

For example, I had a requirement to make sure some machines randomized their MAC addresses when connecting to untrusted WiFi in Ubuntu 14. Turns out this functionality was broken in NetworkManager and trying to go around its back was a huge huge headache because the system was relentless in checking the MAC of the interface and setting it back to the physical one.

There are other times where it bites you in the ass too, like writing a raw image to a SD card. In the old days you would just dd the image onto the card, but you can't do that anymore because shortly after you write the filesystem header to the card SystemD will notice the new filesystem attempt to mount it, killing off your dd process.

I always try to work with SystemD now because it's so much harder to fight it.
Case 2 probably involves some (and likely a _significant_) amount of identity theft, and even then I don't think you can do better than pseudonymous - if you want your intended audience to reliably know which sources of information comes from you, then any and all adversaries can know the same.
I think this is a bit hyperbolic of an expression, but I do want to reinforce that all applications need to confirm data integrity, you either confirm it when saving the data, when extracting the data, or have to very carefully balance various consistency concerns and either enforce consistency before saving data or enforce consistency after saving (but before extracting) data.

Things like RDBMS's provide some really nice utilities for data consistency enforcement in the form of FKs, these are not the most performant approaches in all cases but they're optimized to be good for nearly all use cases.

If your business need /Requires/ moving off of FKs onto some other data integrity guarantee, then just understand that you're going to be reinventing the wheel. It might turn out to be a better wheel for your car, but it's going to be expensive. And... unless you specifically hire specialized people who comprehend data guarantees and ACID properties, you'll probably do it wrong. This sort of an undertaking is for mature companies only.
Fuzzy logic 2.0. ECC is just so last century.
Don't forget paramiko, fabulous for automating interserver work.
The example is because SystemD rejects POSIX as a standard. Whenever Pottering decides something is better, POSIX is tossed out the window.
>While wearing a MAGA hat is not illegal in itself, it is a violation of any kind of professional conduct.

To reduce your argument a bit, in the name of inclusion and diversity we must ban anyone who wears a MAGA hat.

Something seems off with that...
Two of Google's big internal databases don't use foreign keys (Spanner[0] and F1 [1]), rather they use hierarchies (parent/child tables). It definitely limits you a lot more than foreign keys, but seems to make sharding easier. It works well for some use cases, but takes some getting used to. Cockroachdb also has this functionality [2].

[0] https://cloud.google.com/spanner/docs/schema-and-data-model

[1] https://ai.google/research/pubs/pub41344

[2] https://www.cockroachlabs.com/docs/stable/interleave-in-pare...
“okay boomer” summons Google Assistant
I am sure a few months is enough.
It's not "you can't add checks because they might fail"; it's "you can't temporarily remove checks in a live system where the database's users are used to leaning on them, because when you try to re-apply them you just might find yourself in a world of fail".
A FK declaration uses named field(s) in your table. You can omit the FK but the associative fields remain. An FK is a constraint on what values can be in those fields.
> > Wearing a MAGA hat is literally political speech protected by the first amendment.

> Sure, but (at least from my understanding of both US and German law) employers can demand that their employees not blast their individual political speech into the faces of their colleagues or customers.

But this isn't "don't talk politics with colleagues or customers". This is "don't talk politics when off work, ever", which is a whole different ball game.

> > But to argue that that was the intent behind the code of conduct policy is stretching reasonability way too far.

> The thing is it's almost exclusively Republicans and outright neo-Nazis who regularly and intentionally cross the lines between speech and harassment. Left-leaning people, from the odd "off to Gulag" meme and beaten up Spencer memes except, don't do this. It's not a fault of the CoC that today's Republican Party is a toxic white male supremacist hellhole.

Um. Every "look at this deplatforming!" post I've seen on HN has been against someone insufficiently far left, being attacked by someone farther left - including this one. How is it that the Right is both so prevalent that their harassment campaigns are the vast majority of incidents, while also being so ineffective that all the major events we see here are the opposite?
I work at Vimeo. We don't have any foreign key constraints in our database either.
Electron doesn’t target iPhone, and Spotify mobile does not use electron.

This article is about the Mac App Store.
The article also inaccurately states that Tuvel's article was retracted.
You couldn't be more wrong. You do not have an entitlement to intellectual property, our entire society is built on top of that concept.

It's more like you're saying you get to use any logos you want because you can download the images for them on their website.

The only reason you can listen to a concert outside of the venue is because there's no way to stop you that's also in any way proportionate to the crime.

Edit: I'm rate limited so here's a clarification.

My point is that just because it's available doesn't mean you ought to have access to it. You do, no arguments there, but should you? No. You are not entitled to that media by virtue of the fact that it is available to you, much like you are not entitled to the contents of someone's home just because their door is unlocked.

You're not satan if you download a TV show, but I hate it when people try to rationalize that behavior with a moral argument.
Um the "alt right" existed well before Trump, and no the notion comes from Trump being absolutely toxic and evil, if you actually followed his policies and positions on a whole multitude of issues you would see why people are criticizing what he is doing on a daily basis, so much to the point that yes, Trump supporters are considered "Nazis" and "White supremacists" or lets just call them "assholes".

Point blank that's what they are since the only benefit they seem to claim from his policies is the "economy" which we all know will begin faltering given enough time as things are slowing down and have been on a global scale, given that I don't see how his bullish policies will do anything other than create more seeded hatred among his own supporters, lie enough times about illegals or immigrants doing something and surprisingly people take the bait.
WeWork says it will divest all ‘non-core’ businesses
It amazes me that Google's managed to maintain this sense of being the underdog with almost 80% share worldwide. Apple is far from a monopoly. Hilariously far, in fact.
You have columns that refer to the PKs of other tables, just without constraints. So your invoice table would have a column `user_id`, which tells you which user the invoice is for. But if you enter an invoice for user ID 999,999 when you have no users, the database eats it happily, since it has no opinion as to what that data should be.
> The moment I needed a bloody table with different companies/packages/subscription in order to figure-out how to watch that show I heard from a friend, I just go to a place where i can get it right now and watch it with my food still warm.

I mean... before the internet, there was the TV-Guide. If you google a show there's plenty of services that will show you where it streams. Content has gotten easier to access (with a few exceptions) compared to cable, especially with the transition from linear to VOD. People just got used to Netflix, where 30% of the content that exists out there looked like "everything" because it was the only streaming game in town. The new services are putting out a ton more content and making them more accessible.

The pirates were definitely right about one thing - $30 for 1 season of a show on DVD or through iTunes is highway robbery. I don't consider the outcome to be in any way worse though. Finding where to get the content isn't the problem.
No, Netflix actually encourages this behavior; this is not stealing.
In my country looka is slang for snot/mucus.
It’s ironic how the excess of political correctness is distancing people more than the original problems PC was aiming to solve.
Someone two degrees of separation from me coined the term "medium data". I don't remember their name, but I absolutely love the term.

You are "big data" when black swan events (like hardware failure taking down a database node) become regular enough that you begin to statistically model it. Before that, you might just have a lot of data, but you aren't having "big data" problems.
If there's one thing that has made me fall in love with Magic all over again, it's my boy trying to get into Yu-Gi-Oh, which is one of the most absurdly complicated games I've ever tried to learn. In Magic, no matter how big the rulebook is now, the core interactions and vast majority of cards are incredibly simple (and still flavourful!), and all the complexity is more or less optional, in terms of playing with more rares or different sets. It's astonishing how much stuff Garfield got right 25+ years ago, whether by accident or not, but I hope to be playing the game for the next 25 years as well.
The association would still exist implicitly in the code that uses the database. The columns could stay the same, and the code could still use the item's hypothetical cart_id column to get the items in a cart.

You lose the explicitness and safety of referential integrity in the database, but it's a trade off that can enable other things, like sharding, as mentioned by the GitHub employee.
Here’s a quick and dirty notebook that uses NASA’s published data to visualize where the ‘Super Emitters’ are located around California:

https://observablehq.com/@jashkenas/californias-methane-supe...
When you get to a point where you need to start sharding your database, congratulate yourselves for the enormous success and toast the night to come.

The next morning you can embark upon the engineering effort to start the sharding re-architecture.
Our will power is like a muscle and can get tired. What if we have free will that is not actually "exercised" all that often. Say 85% or more of our actions are basically pre-ordained by decisions we have previously fully internalized and so are basically automatic, but which still alighn with our general will. Thats like an inexpensive (cached) result from the will banks. Then actual "exercise" of free will comes about when the patterns for these cache lookups fail and we must decide. But not only that, it is not exercised unless our desire and our will diverge. If I desire a second slice of pie, but my will is to not over-eat, it requires effort (will-power) to follow through with my will. That is the exercise of free will and does not actually happen as often as we might think.
I am a bit doubtful of this, especially within PostgreSQL you need to specifically go out of your way to create a NOT VALID constraint. I know that MySQL of old would default to an engine that didn't actually enforce key relationships (which was terrible but at least well documented) but in the modern world DBs will tend toward enforcement unless you specifically work against it.
It's orders of magnitude more expensive for a company to have swift specialists, kotlin specialists, and js specialists for a user experience that is meant to be fluid (or at least consistent) across platforms. Design consistency ends up being manually maintained, which is extremely faulty.

My company uses react-native for iOS and Android, and it works pretty well. We sell a web product, but for certain use cases our users need to be able to use a phone or tablet without internet connection.

I'm really surprised Apple's not cracking down on react-native yet. I wonder if it's because they don't want to get in a fight with Facebook?
> So, the dude in question appears with a MAGA hat to a conference filled with people of diverse origins

No, the conference is scheduled to take place 10 days from now and the dispute seems unrelated to the hat photo.
That is about the worst faith interpretation of parent's comment I would come up with, even if I paid a consultant.
I don't have this problem because I'm not addicted to apps like you. "My Files" that came with the S10 is great for file management and Outlook works fine for my mail.

There isn't a single app on my phone that's junk.
>being able to use FKs is probably not high on the list.

No, that's not at all probable. For many, "database" is synonymous with "ACID database", for which foreign keys are important. https://en.wikipedia.org/wiki/ACID#Consistency
A few years ago I had the pleasure of working with Lee Felsenstein on an electronics design.

One night over burrito bowls we got to talking about the Osborne 1 and the odd size display. Specifically why 52 x 24 instead of 40x24.

As the story goes, there were huge concerns the computer would come in under budget. At the time chip companies would bundle their CPU’s and RAM - loss leading with one but charging more than market for the other. Architectures should have meant these chips were not cross compatible. Adam Osborne set a hard ceiling on the price, Intel compatibility, and 40x24 native resolution for the display (so as to be compatible with with other “Business” applications). Facing these constraints Lee couldn’t make it work unless he got creative. Through some arcane use of the dark arts (read: layout and capacitor placement) he was able to get the timing working between the low cost Z80 processor and the low cost 4116 RAM.

When he presented the news it went something along the lines of: “Adam, I’ve got some good news for you and some bad news. The good news is I made the cheaper ram work with the Z80 and we’re going to come in under budget. The bad news is I can’t get you 40x24, but I can do you one better: 52x24!”

As I understand it, this has something to do with the timing weirdness when integrating into the Z80s built in refresh logic which Motorola devs had to write in software. My understanding is they rolled with it but Adam went on to flush the savings windfall this hack got them down the drain by announcing the Osborne 2 at a lower price with more features before the Osborne 1 shipped.
Yeah, I was trying to be kind. I don't know how anyone could justify that.
If we had the will, there would be ample time. If you look at humanity's achievements, a full-court-press on this problem though multi-faceted technological investment is well within grasp.

However, that framing is de-emphasized in favor of politicizing the issue, imposing guilt on those who consume resources, and trying to alter the way billions of people live through coercion or decree.

We're screwed until the modern-day luddites yield that all of humanity wants, needs, deserves, and can sustain effectively endless economic growth and prosperity as long as the universe's limitless resources remain uncaptured. To think that at this junction we should consider the boundaries of human activity are now fixed is to just continue the endless tradition of doubters and cynics who have lacked imagination over the centuries, and held back all good things.
For me, it's not even things like that. It's boring things like push, pop, erase, index_of, etc. that probably everyone has seen but that can't be written in Go.
I'm guessing it's the possibility for data loss. So someone accidentally deletes a user and it cascade deletes all invoices referenced to that user (deleting invoices is a big no-no in accounting).
I was visiting my parents in New Orleans a few weeks ago when my mom showed me the LA Wallet app and said "we have this cool new ID app now. I'm sure other states must have had it for ages, but we finally got it". Nope, not at all.

It's cool to see my hometown progressing on at least one front.
I would suggest armoring our cars if it were anything but absurdly impractical.

Getting to know yourself better, and understanding how bullying is a projection of others, and not related to who you are as a person is immensely practical.
I've used systemd to great effect managing docker containers. Systemd can order the start up/shutdown of containers with other dependencies, the most common one being network file systems that are used as volumes.
a very simple and clean unit file can ensure that the container is only started after the file system is mounted, and that it is killed before the file system is unmounted.
In addition, eating foods that contain zinc makes this point moot.
Meat, shellfish, nuts, even dairy
Ask HN: Is PoW FDA?
Read the title.
Happy Friday What If You Always Had It Off? Why Don’t You?
They are restricting one very particular tool, not a set of tools or category of tools. I can write an iOS application using a veritable shit-ton of different toolchains. It sounds more like you're locked into a particular toolchain more than Apple has locked all the other toolchains out.
The idea of “centrist apathy” is pretty much unfounded. Most of the time people who describe themselves as center-x are people who would normally be characterised as left or right in the past. Instead we have increasingly polarised parties that represent the minorities and not the whole. Trump succeeded because he somehow managed to appeal to those who have been left out in the cold by the progressive left while also appealing to the right.
Maybe shitty toy database systems like MySQL let you disable constraints on a per session basis. A real database system might let you defer them until the end of a transaction—which is the only correct way to operate. Once you commit that transaction, what you put into the system better fucking make sense and it is the job of the database system (and only the database system) to enforce that.

Like I said before if your database system makes using constraints hard or lets you shoot yourself in the foot (lol at disabling constraints per session), don’t just walk but run away from that system.
> The only reason you can listen to a concert outside of the venue is because there's no way to stop you that's also in any way proportionate to the crime.

As is stopping people from pirating. Where there is will, there is a way. The promise of Netflix was that virtually all content (or at least a very large percentage of it) would be there, under one subscription, at optimal quality. And convenience.

As years have gone by, that promise is nothing but a husk (not necessarily by Netflix' wrong doing).
Consistency, in the context of ACID, just means that the integrity constraints that exist are enforced. It does not mean that constraints that don't exist should be enforced.
>In the end, it's because I value simplicity in usage, rather than the simplicity be in the language constructs.

That's interesting, because to me, Go accomplishes this fairly well. Generics, operator overloading, and custom 'for' loops make it easier to write "clever" code with surprising behavior. Go's design is not elegant like Lisp or Haskell; there are some warts and special cases that exist for pragmatic reasons. But it manages to be simple and effective, which is sadly a rare thing in the modern language landscape, where the mentality seems to be "more features = better language." 90% of Go's value is in what it takes away, rather than what it adds.
Can't say about listeners. But connection poolers introduced more problems than I cared to fix. So now I routinely use 3000 connections, and have 9000 set up for peaks. It eats a little more ram but it is more stable.
I'm not sure you want to create a subscription plan where you're punished for using it in a situation that's not a monopoly.
I really could see this taking off. Unfortunately, I could see a lot of copycats.
>Legal buffer: I will not say what the content was. It may have all been non-copyrighted cat videos ;)

Cat videos are far more enjoyable to watch than the dreck that Hollywood is putting out these days.
YAGNI - learn to embrace it.
John Walker's tale of the rise of Autodesk ought to be required reading for every entrepreneur starting a company. Period. While it is true that most start-ups do not have the intellectual depth of the founders of Autodesk, they have to contend with the same problems. While it may be apocryphal, I remember another Autodesk friend saying that John regretted the day that Autodesk had to hire its first employee with an IQ under 200.

And while you are reading it, take a look at the other stuff at http://www.fourmilab.com.
As I read it, they are using their dominance to force sellers to use their logistics service while increasing the price sellers pay for that logistics service with threat of being de-ranked if they don't use it.

All they will say is that buyers prefer amazon logistics and will pull out some user surveys and delivery rate statistics to prove it.
Reorganization of the Fed. Most importantly: Board of Governors created in Washington. Combined with the exigencies of WW2, this basically finished Reserve Bank power. And this structure did worsen the Great Depression (Reserve Banks acted independently and wouldn't participate in market operations).
> but it makes it so that your project can only run on amazon cloud servers

Why? Can't you use it as a standalone product that integrates into whatever service you want? The last time I used it was a few years ago for batch processing. I had Heroku instances that dispatched jobs directly to SQS. I'm doubtful but it's been a while since I've used the service so it might have changed.
I text myself.
Same reason all unnecessary things exist, it benefits rich people in the rich remaining rich and the poor remaining poor.