skysight-inc/HackerNews huggingface dataset:
At the scale I operate at, I wouldn't consider this a viable option. What's the backpressure like on NOTIFY/LISTEN? (Docs mention a maximum backlog of 8GB on the message queue, is that configurable? Monitorable?) Tons of constant churn on a table means we have to worry about vacuuming right? Now I have to monitor that too to make sure it's keeping up. Not to mention all the usual operational issues with running relational databases.

No thanks, I'll stick with GCP PubSub or AWS SQS, which are explicitly designed for this use case, and for which I have to setup no infrastructure.
MySQL 8 was extremely new at the time this comment was posted. It's likely that mysql limitations were a big part of the thinking. The mention of pt-online-schema-change at the bottom makes me think so.
You will have to be a resident in Montreal to experience it. Tourist spots don't count.
Nuclear is one third the cost of gas per TWh in Korea: https://www.world-nuclear.org/getmedia/63b1bb09-dbb6-4ed8-90...

Clearly it can be done.

And environmental rabble-rousers are religious zealots at this point - devoid almost completely of rational thought. The most environmentally responsible option at this point (and in the foreseeable future) is nuclear.
also -- if a demographic says they don't want to pay for your product, why would you think cutting off their free access to it would change their mind? There's a lot of competition in the streaming video space.
> A later version of the delay line used metal wires as the storage medium. Transducers were built by applying the magnetostrictive effect; small pieces of a magnetostrictive material, typically nickel, were attached to either side of the end of the wire, inside an electromagnet. When bits from the computer entered the magnets the nickel would contract or expand (based on the polarity) and twist the end of the wire. The resulting torsional wave would then move down the wire just as the sound wave did down the mercury column. In most cases the entire wire was made of the same material.

wow. this is literally a sound wave. i thought it was some kind of euphemism.

as i was until now only familiar with the electric variety.
Are the participants of the epic flame wars of the 90s immune from retroactive CoC violations or is there a statute of limitations?
I'd consider INSERTs and UPDATEs to technically be "assignment", even if they're very different from how other languages do it.

Some SQL dialects do support both traditional variable assignment and iteration for those cases where an iterative/imperative approach makes more sense than trying to shoehorn the problem into something set-based / declarative. Some limit them to stored procedures (e.g. Postgres, and AFAICT Db2), while others allow them pretty much anywhere (e.g. SQL Server / T-SQL).
It would take many human lifetimes to learn how your computer works from the web frontend down to the semiconductor physics.
We used Dropbox' Djinni for a long while and it was good for most cases, but there were performance limitations - we switched to protobuffs over byte[] arrays for complex data later.
Why 50s? I can understand the benefits of not marrying in one's 20s for example, but not marrying until one's 50s?
> It uses standard (or about to be standard) Swift language features, mainly the ability to write DSLs.

that’s not the hard part, and apple knows it ^_^

it will be interesting when/if someone manages to get something close to apples implementation working, though my guess is they will have a “not fun” time trying to reimplement every ui interaction satisfactorily...
“Technology” is such an optimistic statement... You mean slow memory hungry crap?
an exception is the same thing as what Go does, with the difference that the error is just immediately returned by default, while in go you decide what to do.

This can be helpful, in C# there isn't even a good way to find "all functions that might throw Exception foo". In Java this is slightly better since functions must declare what they can throw.

So Go is more typing than C# style exceptions, but more clear as well. There are some middle grounds such as the Java exception approach, or the ? operator in Rust, which Go is thinking of doing something similar to that.
If there is demand that needs to be met, then just use the existing reactor designs. There's no need to reinvent the wheel.
In the same vein, I'd like to remind people that you are probably not a "temporarily low-scale big-data company", in the same vein as a temporarily embarrassed millionaire. In lots of cases going for the very long term scalable solution will be an impediment to your growth, and I'd suggest dealing with those issues when the chance that you need them is on the horizon, rather than across the globe.

CQRS is one of the biggest examples I've seen personally for this - your flexibility will go down, work to do "basic" things will go up, and you will really lose a lot of speed solving for 10 y/o company problems with technology rather than 1-5 y/o company problems in terms of product market fit.
Also, C# can be read as C++++.

C ++
++
That's a very tall claim in regards to learning a language especially French.
> It's fairly clear to me that these complaints, while real, aren't the core issue which is: people would rather get content for free than pay for it. So a lot of the time they will.

That's not a fair framing. It's not that people want everything for free, it's that they aren't willing to pay an arm and a leg to get everything. I'm happy to pay for 2-3 networks (and do) for 30-50 or so a month but in return I want EVERYTHING meaning live sports and all the shows with no region blocking. I am not willing to pay 150 per month for that and I am not willing to pay 50 for a small subset of content which comes and goes. Sorry, the product was overpriced as a bundle and is still overpriced as an a la carte offering. I don't currently torrent but I understand why other people do as the current setup is highly irritating. You can say I'm being unreasonable and maybe I am, but it is how I feel.
That's fine when one application is using the database. I work in the enterprise space, and we have at least 5 different applications all working with the same database. Each of these applications has their own team. Expecting each team to handle constraint checking uniformly in their applications isn't always feasible, so we use foreign keys.

GitHub's approach might work fine for small, focused teams who have exclusive control over a product. However, that's not often the reality of most organizations.
Apple being anti developer and anti consumer? What's the news?

I make my users use my website, I won't submit to Apple's bullying.
The number of times I’ve seen serious data corruption because “foreign keys are bad and we can just enforce it in code” is amazing. There is zero excuse to not use FK’s

Any database that doesn’t use FK’s is almost guaranteed to have crap in it that didn’t get cleaned up, resulting in data corruption (and yes, dangling stuff in tables count as data corruption).

Developers aren’t perfect. Shit will slip through even with the most rigorous process. The database should always provide tools to keep its self from getting corrupted. This is why good database systems have constraints like FK’s. If your database software makes using those tools painful (cough MySQL), get a better database system.

Not using FK’s is just plain old ignorance.
I tend to lump it in as a "logic programming" language, along with Prolog and Datalog.
Imagine finding a Roman galley out in the Atlantic, or even more than one. I'm always amazed Madeira and the Azores weren't colonized before the Portuguese arrived in the early 1400's, even though there are possible Roman, Viking, and Genovese references or evidence.

https://en.wikipedia.org/wiki/History_of_Madeira

https://en.wikipedia.org/wiki/History_of_the_Azores

Another thing that fascinates me are seamounts: volcanoes that either didn't reach the surface or that did but later eroded and subsided. With sea levels 100-150 ft lower in the last ice age, many eroded to that level, leaving a flat-topped mountain that far beneath the surface. It's too deep for normal scuba, but amateur underwater drones could easily explore them.
A big piece of the WebKit 2020 conference was dedicated to web platform standards catchup in WebKit: https://trac.webkit.org/wiki/WebKitGoalsfor2020

That's pretty much the opposite of "trying to kill web tech".
Got it, thanks for the info!
There are valid arguments for whether it is right nor wrong, but it is most certainly not "theft". Call it copyright infringement or piracy or whatever else.
If they aren't meant to be read/written by humans, JSON is probably a bad choice.
But that also happens quite frequently and people rationalize it. Do you make a conscious decision to put your hand in front of your face when someone throws something at you?
Good. Web UI is terrible.
Is that not good?
That's exactly the point the article is making. In addition to the comprehensive documentation, systemd users need best practices for a good range of common-to-uncommon use cases.
> Whenever I'm editing markdown files, it's usually in a folder of notes, or blog posts, or writing of some kind. And it'd be nice to be able to cycle through several open files like you would in VS Code.

You pretty much describe how I'm using MarkText all the time. On the left, you have a file panel (or search or navigation inside your file) which you can hide/ show with a keystroke. On the top, you have several tabs for your open files. And yes, you can set a default folder.
What do you mean by “code like that”?

If you mean the code that never wraps anything and just does “return
err”, then it could actually be better off using panics. In fact, it's
documented in Effective Go[1]. If all you return in your API is
a simple opaque “shit's broken, yo” error, then it is a perfectly valid
approach to use panics. As long as they are in your package's insides,
and as long as you return an error on the external border of your API
instead of making users handle your panics.

[1] https://golang.org/doc/effective_go.html#recover
Go is so good for web servers. Performs extremely well "out of the box", easy to learn, and easy to deploy due to static linking.

Here's how I usually look at programming languages vs use cases in back end development:

- Go for back end API's with high performance requirements

- Typescript for IO bound API's that can easily be modified and understood by front end developers who use typescript for front end work

- Python for scripting and IO bound API's
How should I see this as anything but whining about producing lazy, resource intensive, non-UI-guideline adhering Electron apps?

Looking at you - Slack, Todoist, Monday.com. Your apps are very bad (and your native apps are Electron lies!)
the official docs worked for me.[0]
Biggest “gotcha” in my experience is version mis-match hell. Each major RN version supports a very precise version of Xcode and Android build tools/targets etc. Read the RN version release notes and you’ll be okay.

[0]https://facebook.github.io/react-native/docs/integration-wit...
I do not believe this generalization is accurate. It wasn't me who said that but the person I quoted. F# is plenty functional but what it does lack are organizational constructs which reduce code duplication. In practice, these are not deal breakers for what you get in return (especially that you can work around them by leveraging more OOP features, which isn't necessarily a bad thing) but that as always, depends on preferences and priorities. Among functional languages, F# is pretty streamlined, believe it or not. F#'s pragmatism means the subset of Haskell that gets used in practice to keep things simple shares a fair amount of overlap with F#. Even more-so for Ocaml.

But, the person might have meant something like, if you already know Ocaml, you might complain about the lack of functors or polymorphic variants. Similarly, if you already know Haskell you might complain about the lack of higher-kinded types or GADTs. On the other hand, F# offers its own features (clean implementations of active patterns, computation expressions, type providers, async, multicore) and advantages, mostly from being able to leverage the .NET ecosystem (which also explains why those specific features are missing).
Or, just not use FKs at all. There are many factors to consider when deciding on a DB, and being able to use FKs is probably not high on the list.
Thanks but your self-hosted solution costs $600 to $900 a month to license it.

I was hoping to find a 1 time purchase solution that meets those requirements. Sorry for not being more clear in my description.
Funny how the same kind of reasoning isn't enough for technology like AMP, where there's endless screeching.

Brand cheerleading at its finest :)
In my experience, it’s the opposite. I’ve had hundreds of packages delivered by AMZL, and only one was late.
Rather Than Saving Public Transportation, We Handed Millions to Lyft and Uber
Yemen is an easy example. [2] "As of October 2018, there have been more than 1.2 million cases reported, and more than 2,500 people—58% children—have died in the Yemen cholera outbreak, which is the worst epidemic in recorded history and was, according to the United Nations (UN), the worst humanitarian crisis in the world."

These numbers are also very conservative estimates, given the state of siege.

[1] https://en.wikipedia.org/wiki/Saudi_Arabian-led_intervention...

[2] https://en.wikipedia.org/wiki/2016%E2%80%9319_Yemen_cholera_...
Medium has decided I can’t read this. But, I think this view stems from a misunderstanding of Apple’s priorities as a company. Accuse them of gross neglect with regard to some aspects of the web if you like, but for outright aiming to kill it, no way.
This works out well in practice -- the ruby parser that ships with the language (the 100 levels one) works for most purposes and will even go back to an all-ruby implementation if it can't load its C extension. It's a reasonable default parser for almost all cases.

However, if you need the all-singing, all-dancing, handles the most complex use cases super fast parser, which is Oj at the bottom (which handles infinite levels), then you have the option to install it and use it.
Who is honestly suprised? This is the inevitable outcome of all these modern CoCs.
> Apple doesn't give a toss if your app is cross platform

They seem to have some incentive to make it harder for you to switch platform. By restricting developers from using some of the common tools to build cross platform they are able to build an ecosystem that's harder to leave.
Firing a gun is something that you should not do lightly, especially not in public places. These vigilante morons who are whipped up by their media savvy puppetmasters are dangerous. Firing a gun should be enough evidence for that, regardless of what it was fired at. What John Wayne does in the movies could have ended up very badly IRL. So yes, that was with reckless disregards for life, you have no way of knowing where that bullet you fired will end up. Signed, Yours Truly, Deadeye Dick.

Oh, and that's besides the fact that mentally ill people - and most of the general public - should not have access to guns in the first place.
You can gain karma fairly casually by just using the site, you get 1 karma per comment, so it's easy to make it a passive activity.

The site has also been around for over a decade, lots of opportunity to accumulate.
Because of politics and DRM, Apple doesn't offer Disney movies in 4K, for example. I really don't give a rats behind about Hollywood politics. I would have purchased if I could get DRM free movies. Alas, this is not an option. So I go the "remux" way, where everything is free, quality is better than all streaming services and there is no DRM. It's up to Hollywood to make change.
You are saying the same thing.
Jesus, Mary, and Mary
Just learn Swift and Apple frameworks if you are building an App or use a template if your actual product is content and your app is just a delivery medium.

Just because it's JS, it doesn't mean that it is web technology. It's simply a way to build apps using technologies that are traditionally used for the web, making it approachable for people who know JS so that they can build bloated apps.

Apple's toolchain is so much superior to anything JS-Frankenstein and the Swift itself is a pleasure to work with, probably easier to learn and manage than to try to adopt your JS skills to a mutant JS. Almost always results in better UX and I think it's O.K. to care for the users, something that apparently never crossed the minds of the WebTech people(through the years, all the frameworks were about making developers life’s easier, rarely anything was about the user ).
No, classic has only dropbox as an option and uses some kind of Dropbox api to manage it :/
I'm only waiting for the first SWATting incidents triggered by an algo "recognizing" a turtle of mass distraction.
I've yet to see a single studio offer to sell me a DRM-free copy of a movie or TV show, at any price. Until they do, their offering is strictly worse than what 'piracy' is offering.
Yes, we’re ahead of places we think of as first world countries (Australia, South Korea, Ireland, and Switzerland. And we’re pretty close to Japan, the U.K., Israel, etc. We are closer to Germany than Germany is to France. The clustering in the OECD is pretty close.
I am curious to know about the infra / tech stack, if you're comfortable with sharing any information.
Bah, you're right. I put in a KG instead of G in my calculation, so 3000 months instead of 3 months. In any case I am not worried about running out even if we go whole hog on these batteries.
Isn’t this also why the terms SX and DX are used (from the Latin Sinister and Dexter, for Left and Right) respectively - because they always unambiguously refer to the subject/patient’s left and right?
The Archlinux package repositories[1][2]. At least, they seem to be using svn first and then mirror to git. I wonder if there's a benefit in doing so, or if it's just because of inertia.

[1] https://git.archlinux.org/svntogit/

[2] https://wiki.archlinux.org/index.php/Arch_Build_System#Retri...
For the streaming companies, fragmentation has become a feature. They have absolutely no interest in resolving it.
Am I the only one who thought retreats are just a method for the company to force employees to work unpaid OT, cause well, where are they gonna go? Everyone's in some far away destination disconnected from friends/family so you may as well work for a week straight.
I honestly think that any language that enables too much cleverness will inevitably produce a mess given enough developers involved.
Would be fine with payware, but sadly that is not how ynab sync is done :/ I have nextcloud and tried syncing the YNAB files directly, but that just breaks tons of things.
Based on my reading there are two laws in question:

* Tax Reform Act: This seems to only penalize supporting an existing boycott by another country of a third country [1]. As there is no government boycott of Russia and China (at least not in countries these clients are from I'm guessing) this shouldn't apply.

* Export Administration Act: This also specifically says it related to boycotts conducted by a country against another country the US is friendly with [2].

I'm open to someone pointing out my misreading of these laws but it seems that they only apply to government mandated boycotts. So, to me, clients are free to require restrictions if there are no government boycotts in place.

[1]: https://www.irs.gov/pub/irs-soi/03-04boycott.pdf

[2]: https://www.govinfo.gov/content/pkg/CFR-2019-title15-vol2/xm...
Thanks @rickette for pointing it !
Always proud to see people suggesting my work !
You should try it for a few hours it's pretty fun.

You can even do play by post, since you only make decisions on your turn. You have to trust the other person to shuffle, but it works
Communication takes up more time when technology makes it more efficient
Sadly I don't think this is actually true. From that page:

DDL statements, atomic or otherwise, implicitly end any transaction that is active in the current session, as if you had done a COMMIT before executing the statement. This means that DDL statements cannot be performed within another transaction, within transaction control statements such as START TRANSACTION ... COMMIT, or combined with other statements within the same transaction.

Whereas with real transactional DDL, the DDL can be done within large transactions, multiple ALTER's could be rolled back, no changes are visible outside the transaction...
But that doesn’t get the clicks Owen and medium need
Harvard business school dean to step down
One of the biggest reasons Apple fans like myself remain Apple fans is precisely the ecosystem. I've no desire to leave it, and so your app allowing me to isn't a selling point.
> It may even rely on FK to cascade deletes (shudder)

Is this just the author's personal taste, or is there something about mysql that makes ON DELETE CASCADE a bad idea? In postgresql it's a useful tool for maintaining database consistency.
The really troubling thing is how people like this “Sarah Mei” are allowed to call shots. Why does anyone even give credence to what she says? She’s clearly a power-hungry megalomaniac who spends all of her time “calling out” people who violate her religious beliefs (Intersectionalism / Foucaltian Power Dynamism).

Sorry, not everyone is a member of that religion, so we should not be policing based upon your own personal religious beliefs.
> How outrage mobs silence academics...

How seriously should one take an article when the author can't be bothered to find any examples of it to include in the article?

> Rebecca Tuvel, a philosopher and assistant professor at Rhodes college, in 2017 published an article...

Still at Rhodes, still teaching, still publishing...

> Sarah Bond, an assistant professor of classics at the University of Iowa, published an article...

Still at Iowa, still teaching, still publishing...

¯\_(ツ)_/¯
It was never a rule, only a quirk a few other tools had. The kernel has always permitted these usernames; it is plainly systemd's responsibility to not shit the bed when it encounters such a username.
> Indeed. This is about residence not about nationality.

The two are so correlated that they might as well be the same, and it strikes me as dishonest to make the distinction.
Wow. No discussion at all regarding the correctness of their databases. Is all the data correct, or are there FKs referencing missing PKs? Actually, even discovering this would be difficult, since any FK violation could be just viewing the middle of what would be a consistent update in flight.

I get that cross-shard FKs are especially difficult. But any discussion of this topic without addressing correctness concerns is woefully incomplete.
They would be great in case you ever run out of firewood.
Who cares if an app has a lousy UX? Doesn't the market filter these out?

How is it any of Apples concern if I want to make the ugliest most useless app ever? If people love it, and everyone wants it, isn't that enough reason to sell it?
From the abstract, the main point of the article is:

> ...higher-order functions and lazy evaluation, can contribute significantly to modularity.

You can not have lazy evaluation without referential transparency, and you can not get referential transparency with mutable variables.

Rust does good use of high-order functions, but gets nothing near the modularity of Haskell code.
I created a startup to fund OSS like my nearly abandoned 2.6k star repo