skysight-inc/HackerNews huggingface dataset:
> I use Postgres […] SQL is pretty darn effective.

FWIW postgres used to have its own query language derived from QUEL[0] rather than SQL.

And findings that SQL is kinda shit are not exactly recent, e.g. C.J. Date's "A Critique of the SQL Language" (1983) lists the following sections

* lack of orthogonality: expressions

* lack of orthogonality: builtin functions

* lack of orthogonality: miscellaneous items formal definition

* mismatch with host languages

* missing function

* mistakes

* aspects of the relational model not supported

The conclusion was, obviously, prescient:

> if SQL is adopted on a wide scale in its present fortm~ then we will to some degree have missed the relational boat~ or at least failed to capitalize to the fullest possible extent on the potential of the relational model. That would be a pity, because we had an opportunity to do it right, and with a little effort we could have done so. The question is whether it is now too late. I sincerely hope not.

SQL succeeded not because it's "pretty darn effective" but because IBM decided on it (at a time where it drove technology) and Oracle are great at sales and marketing (whereas Ingres definitely wasn't).

[0] https://en.wikipedia.org/wiki/QUEL_query_languages
> Remember too that many billionaires are control freaks. Them policing their children's screen time may just be part of larger control regime. Lots of rich people, going back to most every king/queen in history, have been what we would today call overprotective parents. Tech royalty isn't any different.

Whether this is the cause or not, children of the rich do very well in life, regardless of the level of control freak
Yeah, or I could move to Mars, I know.

I, for one, am happy to not fund the bombing of innocent people through the taxes I pay. I am not sure you could say the same. :)

And for the record:

> Renouncing U.S. citizenship doesn't free you from U.S. tax obligations and means that even after the renunciation, the IRS could still audit and assess taxes and penalties.
People _like_ doing something repetitively and getting random rewards. It triggers reward systems in the brain.
QIIP becoming a magnet for criminals and scammers, I wonder what kind of risks is there for the society in the long-term.
One Hundred Things Google Announced This Week
> That's more or less the entirety of a game's output.

Output is only a very small subset of a game. You need stuff like UI layout or Scene graph with transitions, tweening, texture atlases handling, animation, etc. A good game engine like Unity or libGDX provides all that without a game programmer having to reinvent the wheel.

See for example a list of classes the libGDX API provides:

https://libgdx.badlogicgames.com/ci/nightlies/docs/api/
Sad that documentation is missing, but looks interesting
For what it's worth, I agree with the headline as stated. Without controls, the scenario of NYC or Hong Kong appear.

One answer to this particular problem for Singapore has been public housing. Public housing is completely different concept in SG as 70% of all housing is "public".

There are no direct price controls but only PR or Citizens are allowed to own these places which places a natural cap on housing. New developments are handed out via lottery with preference going to first time owners.

This naturally limits who can buy into new developments allowing younger families to inflow into said locations thus keeping prices low.

US Cities would be hard pressed to find a scheme that works (article hardly proposes a solution), but I agree simply supplying more would not work.
I don't disagree with the obviously true statement, but this code comment comes to mind:

// Dear maintainer:
//
// Once you are done trying to 'optimize' this routine,
// and have realized what a terrible mistake that was,
// please increment the following counter as a warning
// to the next guy:
//
// total_hours_wasted_here = 42
You can still find parts on ebay for the 6p. And there are youtube videos on how to do the replacement, but it's not something I'd do myself.
It's easy to whine; it's far harder to do. If it weren't you'd whine less and do more.
> Microsoft did years ago: Platform convergence.

What other platforms did Microsoft have? I can only remember windows phone, but that never seemed that popular.
Yes I would be curious to know more insights on that automated process
I base that on a combination of two assumptions:

1. Coal is used for for generating electricity because it's the cheapest. Its buyers aren't loyal friends, its buyers want the cheapest.

2. The price for new wind/solar plants is dropping quickly, and if that goes on at the same rate as recently, then at some point in the next few years, building new wind/solar plants becomes a cheaper source of electricity than operating existing coal-fired plants.

The price might not go on dropping, but I think there's a real chance it does, and if it does drop far enough and coal's customers actually want the cheapest, then one of the two key markets for coal withers as fast as customers can switch.

EDIT: That ">50%" might be high. I glanced at wikipedia: "About 75% of coal mined in Australia is exported […] and of the balance most is used in electricity generation" and: "Coking coal generated A$22.4 billion of export revenue in 2012/13 financial year with thermal coal bringing in A$16.1 billion". But I mixed up value and volume.
Thank you, I was not aware of this, seems like Mercedes was gaming the system as well.
An idea whose time has come – European Commission conference on open source
It’s hard to sympathise with Amazon, but it seems very wrong to put the burden on the point of sale vs the supplier, especially for smaller stores.

The burden of not putting dangerous products out in the market should lay on the manufacturer, through certifications or some form of safety requirements. In this case no doubt Amazon has to pay if they’ve acted as an importer, but you wouldn’t expect your supermarket to randomly sample all their product.

maybe the US regulations need an update to make school supplies a more strict category?
AV1 has enough support from enough vendors that it has a very high chance of replacing H.264 as the ubiquitous video codec. The headline is a bit click-baity, but proposing new web standard "now" means it would be available everywhere in ~5 years.
"Technically only the last survivor coming out could answer that question"

And last survivor witnessed exactly this - quick evacuation without any issues with the luggage.

"people value belongings wrongly in case of serious accidents"

this catastrophe shows exactly opposite.
Discarded electronics are polluting Ghana’s food chain
Yes, that is the problem, and someone is hopefully working on it.

But if you start looking at those '12 users', you should notice that that the need is extreme.

This includes drug people and at-risk populations like sex workers: I'm not happy until drugs and sex work are decriminalized globally, so I want to protect sellers and buyers, a partial reason why I participate as a Tor relay admin. Then there are journalists and politicians. Apps like Signal, Wickr, Wire and Threema aren't as much the ecosystem we want as the silos we deserve.

That said, you'd be surprised how easy a sell Signal is in some cases.

I've gotten a bunch of friends over to Signal, from the likewise end-to-end encrypted Whatsapp. And after a family crisis, where a friend of the family died, I explained how the metadata of a mostly dormant Whatsapp group lighting up suddenly could be interpreted.

Facebook knows we're a family of aging parents and grown-up, mostly independent 25+ kids, so there might be a crisis or emotions whenever there are big bursts of activity. A crisis might make people more susceptible to predatory ads.

This was enough to convince my folks. So, family chats are now on Signal. The app is good enough. Granted, my parents and siblings are active in professions related to either legal or social services, so they understand the need for privacy and my overall desire to curb stomp the online tracking industry.
How about Lazarus (https://www.lazarus-ide.org/)? Drag and drop to build the GUI, compile natively to Windows, Linux and MacOS.
Did you create this because of your needs?
Are you managing some large groups on Instagram/FB?

I think I have read blog about the exact same product some time ago here on HN
Nope.

RFC 3161 timestamps - which is what we're discussing here - can be fraudulently constructed for any timestamp value by someone who has the private key for the TSA (Time stamping authority). So what your parent described is easily possible: A system that relies on RFC 3161 timestamps has to trust that

* any cryptographic hash algorithms used remain safe

* any public key signature methods used remain safe

* the TSAs retain control over their private keys for as long as you continue to accept timestamps from that TSA

This is a big ask, and in practice the code signing systems you're probably thinking of just don't care very much. A state actor (e.g. the NSA) could almost certainly fake materials for these systems, we know that this has been done (presumably by the NSA or Mossad) in order to interfere with the Iranian nuclear weapons programme in the past.

You _can_ build a system that has tamper evident timestamping, but it's much more sophisticated and has much higher technical requirements. That's what drives the Certificate Transparency system. CT logs can prove they logged a specific certificate within a 24-hour period, and monitors verify that their proofs remain consistent, the to-be-built Gossip layers allow monitors to compare what they see in order to achieve confidence that logs don't tell different stories to different monitors. But to achieve this a CT log must be immediately distrusted if it falls off line for just 24 hours or if an error causes it to not log even a single timestamp certificate it issued. Massive Earthquake hit your secure data centre and destroyed the site? You have 24 hours to get everything back on line or be distrusted permanently. Bug in a Redis configuration lost one cert out of 4 million issued? You are distrusted permanently. Most attempts to build a CT log fail the first time, some outfits give up after a couple of tries and just accept they're not up to the task.
This supposed “insight” is on its way to become just another tired meme. If, somehow, Amazon profits from this settlement, why did they not just implement its terms before? Or for other categories? There is nothing stopping them from requiring whatever lab tests they want from any seller they want, after all.

Regulatory capture is a useful concept, but please don’t just parrot it for any case related to regulation. As seen here, it is now used most often as a cudgel against any sort of regulation, and that’s exactly what they wanted all along.
Given that 2500 n1-standard-1 preemptible instances in us-central-1 would cost a grand total of $25/hr, it's certainly not a 'must be Google or taller' requirement
Looks like H20 achieved a score of 0.61312 against Google's 0.61598, just training on a single machine:

https://twitter.com/ledell/status/1116533416155963392
It seems a little disingenuous to say the evacuation was completed in 55 seconds. Over half the passengers perished - the evacuation was never completed. I think it'd be accurate to say there was a survivable window of 55 seconds, and 37 people managed to deplane in that time.

It seems very convenient to picture that rows 1-11 were just fine and rows 12+ were SOL. But it does seem just as likely that there's a shade of gray between the two - could row 12 have exited given more time? or did the smoke just form a wall at this point.

Of course, this is all based on zero information. If the accident investigators find a single body in the aisle rather than strapped into its chair, then it'd remain a worthy question.

But even if it turns out those in 12+ really were sealed by fate, I think it's still worth reminding people of every single time - because next time it could be you in row 12. "ignore the experts, it's probably fine" serves no-one.
Which is why PostgreSQL uses heap sort with a fixed max heap size for sort with a small limit (called "top-N heapsort" when running explain analyze). Then the complexity for getting the kth value is O(n log k) which is O(n).
Also, don't forget the hours wasted of the people having to learn another query language. :)
You may find this[1] a very interesting read.

[1] https://www.vanityfair.com/style/society/2013/04/mysterious-...
>This will simultaneously make it expensive for those sellers actually trying to comply (lab testing is not cheap)

If they have a legitimate and well managed supply chain, it's not actually that difficult. The onus should be on the paint (or other materials) manufacturer to certify their product, with third party verification, and the certification flows down the chain.

Of course compliant materials are more expensive and the certification isn't cost free, but otherwise shady outfits wouldn't flout the law. However there shouldn't be any need for a distributor to do lab testing themselves. They just need to be conscientious and organised.
The data you linked is for the entire Tokyo metropolitan area. The trend is that people are moving out of rural areas and into the urban core. It would be more appropriate to look at the central part of Tokyo, the 23 wards (former city of Tokyo):
http://www.newgeography.com/content/002923-the-evolving-urba...

From 1990 to 2010 (latest year in data), the population grew 9.6%.

In the same time period, SF's population grew 11.3%:
http://worldpopulationreview.com/us-counties/ca/san-francisc...

Not a big difference if you ask me. Yet SF prices have skyrocketed.

Tokyo may require citizenship to buy, but that doesn't mean foreigners can't rent. Rent prices in central Tokyo often start at around $1500/month, which is a lot less than that of SF bay area suburbs.
If that 2-5 second animated sequence is smack dab in the middle of an article I'm trying to read, because the author is trying to be "cool" and "in with the internets" by including some popular animated meme macro? You bet your bellybutton that I need to be able to stop it from distracting my eyes from the text.

Human sight has evolved to be attracted to movement.
You still haven't explained why SQL in particular has ruled over its problem domain for over 40 years. For example, in systems programming over that same timespan we've had assembly, c, c++ and rust.

Why is SQL the exception to the rule? You talk about popularity, but its really a question about stability. Remember, SQL is not that popular, as the NOSQL movement and comments like yours prove.
Not all humour, but Steven Wright certainly made an entire career out of sentences like this.
Are there high-performance matrix multiplication libraries, e.g. for fluid-dynamics simulations, that are implemented using persistent data structures?
It is similar, but it’s also different. I still think Apple wants to avoid mixed mouse and touch interfaces and also wants to avoid switching on the fly between those two interactions models on the same device. Their goal will be to give developers the tools to use a shared codebase, but still being able to provide the right accommodations for mouse input on the Mac. I don’t think touchscreen Macs are planned.

How well they can pull that off is a different question altogether.

Mac users feel neglected anyway, so I’m very willing to let them try.
Found the video and even posted it (before I realized that I should do a search). Kind of surprised I didn't see it when it was posted here though. Didn't know about VCF either, good stuff.
I read a few paragraphs and I still have no idea what "Marzipan" is supposed to be.
I generally used to flip channels or read something or talk during them, did anyone ever regularly sit through them attentively?
> Renouncing U.S. citizenship doesn't free you from U.S. tax obligations and means that even after the renunciation, the IRS could still audit and assess taxes and penalties.

Nice try.
Nitpick: I believe that is England and Wales, not the whole of the UK.

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

https://en.wikipedia.org/wiki/Right_to_silence#Scotland

I think NI is also different.
If the price tag is $4 million it will take a very cheerful and beautiful person to distract people!

https://www.reuters.com/article/us-health-sma-insight/u-s-be...
I also really hope that the non-integer scaling was a very temporary hack of a solution and not how things will be going forward.

For those not familiar, iOS generally sizes UI elements at a larger number of points than macOS to account for reduced accuracy of touch vs a mouse pointer. The solution in the existing Marzipan apps is to simply scale the output down by about a third so things seem more “Mac sized”. It’s very obvious in text-heavy apps like News, and looks awful.
Men see women's makeup – With All Women
Show HN: Core4os Open Source Python Insight Platform
Some people are so dazzled they will just remain in their seats and then go unconscious because of the smoke... I made some research about plane accidents, and here's what I learned: When entering the plane, take note where the exits are. If there's going to be a crash landing, brace your head against the front seat, so that you don't get knocked out. Also brace your limbs (legs under your own chair) so they don't hit something and break, there might be a lot of g-force, and you'll need your legs in order to get out.
As soon as the plane is on the ground, unbuckle yourself and get out! Statistically you need to get out within 20 seconds in order to survive! So just leave everything, climb the seats if the center is clogged. The doors are opened manually (by the flight personnel if they're able to) by pushing a lever, and might open slowly to leave some time for the escape slide to inflate. If you land in water, you only want to open the upper section of the door to not let in water.
Once out, go 100 meters or so away from the crash site to avoid smoke and be safe from explosions. But don't go too far away or you might get lost because of confusion and shock.
Personally, I haven't kept up with games on smartphones. What listed companies are there that are successful in the space? Seems like it might be worth looking at a few to round out one's portfolio.
Taxation isn’t theft, and trying to reframe it as such is intellectually dishonest. Theft is the unlawful taking of property, and taxation is almost tautologically lawful.

You can argue for lower taxes, or even against all taxes, although the latter will probably just get you ignored in polite company. But don’t try to tap society’s consensus against actual crimes for your libertarian crusade.
Fire trucks cannot instantly teleport to the place were the plane has stopped and is burning ;)
Investigating the Potential for Miscommunication Using Emoji

https://grouplens.org/blog/investigating-the-potential-for-m...

https://grouplens.org/site-content/uploads/Emoji_Interpretat...
Amazon CEO Jeff Bezos reveals plan to colonize the moon
Oracle to lay off 1,600 staff in China
And how is that relevant?
It seems like it depends on your threat model. If what your company is doing is valuable enough and you have a large enough organization, a motivated attacker will have access to the system’s source to run their offline analysis of it, regardless.

Background checks and interviews aren’t much of a barrier…
> Looping is up to the video player, not the format or container.

Says who? First of all, it really is debatable if animated gif even is a movie. It has no sound, is usually far shorter than the usual video clip, etc. Second, animated gifs are very often created solely for the purpose of displaying them in a short looping fashion. Third, the fact that all this can be done in a single image format makes them ideal for sharing through the web as well as private chat applications. And fifth, and this is what this is of course all about, sharing short animated gifs gives the user the possibility to share rich content not tied to any private business or entity. You can share 'em via Whatsapp, Telegram, e-mail, usb-stick, have a collection of them stored somewhere, without the need for a Facebook/Google/Amazon account and internet connectivity. You can look lovingly at them, even when your phone is in flight mode. Let's keep it that way. Let's not kill one of the nicest image formats around, and make everybody visit your website to see the embedded movie including horrid player that's supposed to be better but just isn't and never will be. Lot's of companies already did this (hi Twitter) and it's really disheartening to know that while I was able to collect a nice bunch of animated gifs over the years, my kids will probably never have that chance because the file format will just be walled off by the internet giants.
Mk.2 is still better to drive than the Mk.3 and Mk.4.

I've driven them all, 3 & 4 are bland compared to the 172/182, barely any faster too.
> Similarly, there is an error handling draft design than may replace the current bare-bones error handling.

I actually really like the error handling in Go and think it makes it easer to write good code. At least for simple programs.
I thought the developer had access to the ART software system, software written in ART and ART documentation - since that was what NASA was using already to develop rule-based expert systems?

Given that ART was written in Common Lisp and exposed a full Common Lisp inside, it would also be trivial to get large amounts of information about its implementation (data structures, functions, arglists, documentation, traces, macro expansions, disassemblies, ...). I'm pretty sure ART itself had extensive debugging&tracing tools for the rules engine.

Not having source to some Common Lisp software, says very little, when the full Common Lisp environment is available for introspection.

I wouldn't expect that ART was shipped in source to its customers. But I would expect that both ART and the underlying Lisp had excellent introspection capabilities.

http://clipsrules.sourceforge.net/WhatIsCLIPS.html

> The prototype version of CLIPS was developed in the spring of 1985 in a little over two months. Particular attention was given to making the tool compatible with expert systems under development at that time by the Artificial Intelligence Section. Thus, the syntax of CLIPS was made to very closely resemble the syntax of a subset of the ART expert system tool developed by Inference Corporation.

Since ART was what they were using.

> Although originally modelled from ART, CLIPS was developed entirely without assistance from Inference or access to the ART source code.

Sure, it wouldn't say anything else in their position.
EU and China are doing much more to push EVs than California.
I agree entirely, but nonetheless that's what they feel.
> I think perhaps travelers need more training

Perhaps they do need actual training? As in, you're not legally allowed to board a plane if you're under age X without supervision of a trained adult, and you're not allowed to board a plane at or above age X without a mandatory training. The mandatory training would be something like few hours at a training centre and included practical simulated emergencies in which you had to behave.

Airlines could offload this onto government, ticket prices would remain the same (after a brief re-training period), and maybe - just maybe - it would cut down on the amount of stupidity and extremely selfish behavior you see some passengers engaging in on planes every day.
The passengers in the New Zealand flight were jerks but one of them said:

"I have to say that if watching the safety video is so crucial and you can be escorted off the plane, maybe Air New Zealand should stop making 'Rachel Hunter ice cream ad' safety videos," the passenger said.

in reference to the the way Air New Zealand makes their videos with more an aim of going viral on youtube than getting across a safety message.

Their last video was actually withdrawn because people hated it so much.