skysight-inc/HackerNews huggingface dataset:
I wish that I could upvote your comment more than once, because this rings so true.

There certainly are (rare) situations, where you need to provide hints in one form or another, but it's really a bloody nightmare to maintain and may completely bork, when you - say - upgrade to a new version of the database engine.

I work with relational databases since the early 90s and can give you a no-bullshit money back guarantee that you (not you personally, obviously) are not smarter than the optimizer.

Usually there are weird data patterns involved if you absolutely must provide hints. But basically:

Don't do it!
There might be no stipulations, but do you really expect Uber to be completely different to every other company when hiring actual employees? People that you are legally liable for?

>If these companies can’t turn a profit while complying with the law then they don’t have a viable business model. That is entirely their problem.

But let's completely ignore the part where companies lobby for laws that protect their market. Can't wait to go back to the old taxis.
Announcing forem dev
> I will cheer everyone who tries to displace SQL

Why? What are better alternatives, really?
The comment you replied to almost definitely relied on the data in the "Geology of Ceres" wikipedia entry[1]. This is from 1991, and was strictly an estimate.

The Dawn probe in 2017[2] got a better measurement, of 110K-155K.

1 - https://en.wikipedia.org/wiki/Geology_of_Ceres
2 - https://sites.nationalacademies.org/cs/groups/ssbsite/docume...
Yes. The reason is we don't expect to have as many similar explosions that would make laminating glass necessary everywhere.

If we'd expect that, then we'd have bigger problems in the first place.
I still tend to agree with fastaguy88, PDF's are still my preferred format for reading science data, even on my digital devices. HTML data just doesn't have the font quality, layout rendering, and ability to ensure all the appropriate data is saved without requiring some remote server (and login!). My preferred digital device is a 12" iPad Pro as it shows the pdf in native 8 1/2 by 11 size. That makes me happy! Change the device form to match PDF.
No, I'm with you and prefer SQL for many tasks.

SQL got a bad rap in many ways due to security issues, databases in general, and "web-scale".

SQL as a language within other languages is a nightmare from a security standpoint, and if language integrated query was more common across languages earlier on then this wouldn't have been an issue.

Databases generally depend on normalization, but normalization comes with interesting scaling problems and how do you replicate normalized schemas. Thus denormalization became a thing, and then the emergence of NoSQL and document stores started to infect everywhere. The JOIN was a killer too, and then the discipline required to do sharding made it annoying to manage, so easier to manage solutions became a thing.

I'm looking at databases in a different light these days with more appreciation, but now the hot new thing is GraphQL makes things... interesting. I don't view GraphQL as a server-side solution, but a client solution to overcome the limits of HTTP/1.1. However GraphQL clients are exceptionally complicated, and I'm not sure they are worth it. The only problem is that to overcome them requires engineers "to know how to do things", but that is a hostile stance. People want to go fast and make progress, and GraphQL enables that.
> Hiroshima was choosen to demonstrate the max destructive power. If tokyo would have been a better candidate, they probably would have gone with it.

Tokyo was not chosen because it's too important to nuke. Demonstrate isn't the only criteria.
The author seems to have overlooked the lindy effect behind SQL. SQL, like other ubiquitous technologies like Javascript and Excel hits the sweet spot of “satisficing” the user needs. Few things have the longevity of SQL in programming, and the fact that it’s battle-tested will always be a significant advantage over any new player.
yeah but dwarf planet is not a planet, this is like saying method is a function, outrageous
I do not really agree with the two cons the authors listed.

Null handling isn't intuitive in the beginning, but it makes it harder to let missing data go unnoticed.

The expression / table thing can be solved like we solved it in OctoSQL[0], and I think others have solved it in a similar way. Whenever you have more than a single scalar value in expression position, just create a tuple, or tuple of tuples out of it, which does act like a single value.

[0]: https://github.com/cube2222/octosql
> I fail to see how a bacteria would have any agency.

It does stuff on its own. That's agency.
I’ll parrot “Spacemacs” along with a few other here, but here are my two main reasons why:

- Spacebar “leader” key. If you’re familiar with Vim, space is your leader key, and many functions lie behind it.

- Layers. Spacemacs has a packaging system called “layers” that are a collection of curated Emacs packages. The great thing about layers is all the wiring the layer author has done. Many packages are condensed down to a one-line config. Just add “python” to the array of installed layers in your config file and it will install a lot of what you have above. There are a few config toggles (e.g., override the language server that is used by default), but they are pretty well documented in the Spacemacs docs.

Also, use the Spacemacs develop branch! I’ve been on it for years. Master has not had many (any?) updates in a long time. If you do this make sure you are reading the docs for the develop branch when perusing layers online!
You mean like an ORM?
The work I do lately tends to be missing an sql layer and yes, I miss it a lot. I loved organizing my data at that layer and having such powerful ways to query it. It felt like I could eternally find ways to optimize it, and I really enjoyed learning year after year.

Lately I use nosql for very light data and otherwise our API outputs heavily cached and extremely simple data. Adding a database as a middleman wouldn’t make sense. Still fun, but I miss Postgres!
At the scales we're taking about, bitmap image is both faster and smaller than equivalent SVG & CSS with media queries.
IHP Live Reloading: How it works
It could be time for browser maintainers to start removing support for automatic favicon.ico requests, and fall back to simply supporting the meta tag.
I think it was reported of fireworks explosion in the vicinity that lead to this event.
There has got to be a more legit pathway than crypto or westen union, right?

CA is on the path to legalizing sports betting. If there are no payment providers that are less seedy than that, then there is definitely a market for one.
> The main thing they failed on is that the court thinks that they exert too much control on the drivers.

No, the court didn't address prong A at all because it found that Uber/Lyft could not possibly satisfy prong B of the ABC test.
Are your contractor friends lower-wage workers?

It’s quite a different story being a specialist contractor compared to a easily replacable minimum-wage earner.
bandicoot looks interesting, and it feels spiritually related to a project I'm working on. I'm designing a programming language for board games: http://www.adama-lang.org/
Not sure about California, but here in France it's the kind of difference that would change the nature of the relationship. Although it would be evaluated as a whole, and would be under a lot of scrutiny to determine whether this change wasn't meaningless for practical purposes.
Relational algebra is functional programming: you map-reduce your way to a solution set.

Relational calculus is logical programming: you specify what the solution looks like and the query engine figures out the sequence of operations to find a solution.
Woz is still a rich capitalist profiting off the backs of poor workers. He is goofy and jolly though so he gets a pass I guess and should not be held accountable for his ill gotten fortune.
This and the fact that eyeglasses are usually not firmly attached to a huge chunk of reinforced concrete.
Yes, the difference between the two "what he wanted" is the point.
Such a good movie. I have a copy on my machine, and I'm sometimes sad that it's a 4x3 analog cable TV broadcast before HD. On the other hand, the fact that it's so good despite the constraints speaks to how well made it was.
The solution is not destruction and a lot of manual work. It's software. Make it more usable. Keep a record of last page updates and last page visits. Flag pages that according to your settings (default no views in a year, no updates in three years) for review for update or archival.

Archive old pages compressed heavily but in he wiki data store. Mark them as potentially obsolete but possibly of historical interest. Leave links to them intact and have an option to restore the page to intake status for viewing.
plus even if they were from sac, that's basically the east bay. its one hour driving on I-80 from davis to oakland (which is shorter than a lot of people's commute)
I see it often too, and most of the time, that sentence ends with Chrome. Chrome is truly the IE of our era.
Thank you for the clarification—I'd edit my comment if I could.
They seem to be the Malaysian equivalent of Battenberg cakes but more intricate and complicated
It's been a while, but I thought the Hulu documentary included a decent amount about fuckjerry. Might be worth comparing.
This is part of a super generic tradeoff between liberty and public good that differs from case to case depending on your culture and values. For example, should we ban smoking? What about meth? And so on.
There is an audio recording by L.A. Theatre Works https://beta.prx.org/stories/43614 and https://beta.prx.org/stories/43844
Shepherds and the Third Law: https://en.wikipedia.org/wiki/Et_in_Arcadia_ego#/media/File:...
You may like "The Physicists" by Dürrenmatt, then, if you have not read or seen it.

https://en.wikipedia.org/wiki/The_Physicists
Those 3 people establish a lower bound for the amount of people of Japanese descent who would have aided Japan, given the chance. I've heard people argue that no American of Japanese descent would have aided Japan which just clearly isn't true.
>These days you can even just tune pgsql to support kv store formats

And you can turn off fsync! Though if you do, disable synchronous_commit instead for most of the performance but none of the potential data corruption (you're still risking data loss, of course, just not corruption).
it would be (very) expensive to make laminate glass bottles.
It is absolutely stunning to to see people in here holding water for uber and lyft. Where do you all work and who is paying you?
That's the bill that cost hundreds of freelance journalists their jobs in California, right? I wonder what the full consequences of it are going to be.
A bit of a hyperbolic headline. I don't think that China will completely sever the connection to the broader internet as that limits their ability to conduct international trade/research/etc, but certainly their push (as well as many other nations) towards a much more tightly controlled and restricted internet seems almost inevitable at this point
No no plagiarism the same subject but not the same article the source was stated
Do you actually think hooks are worth dropping? I see the appeal of classes, but I really enjoy hooks too.
I suspect that in practice there seems to be a political consensus in Californian that Uber is evil. The rest is just trying to find ways to punish them.

If the existing laws can be interpreted to punish them, they will be used. If not, the coalition against Uber will look into getting new laws passed. (As they already have.)

Thus rendering any discussion about whether existing laws can justify punishment somewhat moot.

(Of course, even a moot discussion can be interesting. Just like people can have fun arguing whether the Stark Trek Enterprise would beat a Star Wars Destroyer.

The legal discussion is also very important to Uber lawyers. Even if they lose in the end, any delay is worthwhile.)
Quibble, far as I understand the law in California doesn't force you to be a contractor. But it's hard nosed about when someones an employee. If the law allows you to be a contractor you're free to choose whatever. Currently I'm an employee being paid twice a month. I could get overtime if I ever worked that much, which I don't.
Furthering their original point
Thanks for posting this, repeated Google searches resulted in absolutely useless results! Especially as all I had to search on was '26 second pulse' and 'gulf of guinea'.

Google is becoming worthless for 'serious' search queries. :(
It is nice to see some BSD asm for a change (I know, someone will probably say this is about C, not asm). If one is hoping to learn anything about assembly language from reading the internet, most material found will focus on Linux or Windows. Even the HN comments on a blog post about BSD asm are about Linux.
One of test in so called ABC test says

"B test requires that the worker performs work that is outside the usual course of the hiring entity’s business"

Isn't this a bad test in the first place. Let's take game studios, they need contract developers for a game, wouldn't that make them fail the test and make them an employee?
> That may be the author's point, but what he says is that PDF is unfit for human consumption. Which is absurd.

You're quoting the click-baity title, but failing to actually read past the article summary's first sentence.

The summary's very first sentence states "Research spanning 20 years proves PDFs are problematic for online reading." This sentence alone frames the problem, and explains the whole point of it.
Yea, I hope the author was just saying that as it expaded, the shock wave slowed to a subsonic pressure wave with a resulting less sharp pressure rise, and the majority of the blast damage was caused by a subsonic pressure wave.
Gatsby is another very popular SSR framework that uses React.
> As a mostly Python and only occasional JavaScript developer, it always felt like the biggest challenge in the JavaScript community was how fast everything moved

Those of us who were doing Python web dev in the years 2000s might remember that Python went through a similar period where it seemed that every week a new backend framework came out: Zope, CherryPy, web2py, Pylons, Django, repoze.bfg, TurboGears... to name a few. Nowadays it seems that everybody has settled for either Django or Flask. It might not have been as crazy as what happened with JavaScript in the years 2010s but still I tend to see a similar pattern. People try a lot of different things, going in slightly different directions and eventually interesting approaches get identified and communities build up around a couple of solutions.

Meanwhile the Ruby community was able to build consensus around Ruby on Rails, with just Sinatra on the side for small projects.

I'm wondering if this ability to try many different things might have been the cause for Python building numpy and eventually winning the scientific computing area as well.
I read that -30F, converted to C (5/9 of -62, like -35) and ughh, no way. That "planet" is too far away.
Aside:

> To prevent U.S. citizens’ most sensitive personal information and our businesses’ most valuable intellectual property, including COVID-19 vaccine research, from being stored and processed on cloud-based systems accessible to our foreign adversaries

I find it an interesting choice to specifically use COVID-19 vaccine research as an example of intellectual property.

What about all the talk that COVID-19 vaccines should be developed in global collaboration and that vaccines should become available to everyone worldwide?
I would strongly suggest upgrading to an SSD.
I've been using Windows on SSD's with other data stored on larger HDD's for several years. Windows hangs in weird and wild ways when accessing data on HDD's now more than ever and as a result, I retired all my HDD's and replaced them with SSD's, now plugging them in only when I need specific data via USB.
Check my other comment, I do recognize tuulipuku as exactly the style of 90s Finland. The 90s was 30 years ago.
It has already happened. 2028? More like 2008
in case you’re wondering: That’s between -163,15 and -118,15 °C.
Your link includes post-WWII "regime change". Would you rather live in Western Europe or Eastern Europe? North Korea or South Korea?

The point is, the United States has done a lot of things across the world. Some of it may be havoc. It may be responsible for many deaths. It's also responsible for many improved lives.

China today is involved in territorial disputes involving military mobilization with more than half of its neighbors. In a few decades, we're probably going to look back on Xinjiang as an event comparable to the holocaust.

Boiling this down to "USA = imperialist = bad" and "China = not imperialist = OK" is silly.
Maybe great if you want to own JDM cars?
Ergonomics of a language I don't know is always worse than that of I do know.

As long as there's nothing valuable in the technology itself why would I bother changing things?
3. Oil is not something that you can change in your own car unless you're ready to permanently ruin whatever concrete you do it on. Sounds like the author gets their car maintained with an app. ;)
For those who won't read the article... too much liquid intake can dilute the sodium levels in the body and lead to swelling of the brain which itself can cause all kinds of issues, some of which can lead to death.
Contrary to OP, my problem with a browser (or Electron app) consuming a lot of RAM is philosophical not material : I have 16G at home and 32G at work so it's more than enough to accommodate any gluttonous browser.
People who use PDFs generally do it because they want to have a fixed layout. If you tell those people to use HTML, they'll find a way to produce a non-reflowable webpage.
Thought this was about another planet elsewhere, didn’t realize they were referring to the dwarf planet
It was! I looked it up and the summary matches what I remember.

I found the list, it may be missing some poems but this is largely what we covered:

A Canticle for Leibowitz - Walter M. Miller Jr

Arcadia - Tom Stoppard

Dulce et Decorum est - Wilfred Owen

Frankenstein - Mary Shelley

Kindred - Octavia E. Butler

Life of Galileo - Bertolt Brecht

Pygmalion - George Bernard Shaw

Suicide in the Trenches - Siegfried Sassoon

The Beekeeper's Apprentice - Laurie R. King

The Lady's Not for Burning - Christopher Fry

The Mortal Immortal - Mary Shelley
This is the best way though to meet some guys who never wrote a book, but are competent enough to delve into details that barely any book mentions. If you want to know one thing deep, sure, get a book or two. But if you want to create your understanding on numerous topics (wide learning), your way is a very long journey that might not even end before you retire. I don't think someone learns here as in a class, we just discuss matters of our interests. You start with replying to tfa, and then it turns more and more whatever it turns into. Nothing new for a forum-like, really, many do not even need clickable headlines, since they do not click on them.
Xiaomi 11 अगस्त को Mi 10 ultra आज लॉन्च करने की संभावना है
> But if you want to exploit all the features digital devices and the web offer, PDF constantly gets in your way.

I agree, PDFs are indeed poor and ill-suited for online reading. They are not reflowable, and PDF authors force a pagination format that more often than not are only readable in a device by chance or if readers use a large format device such as a large tablet. Hell, some PDFs are even unreadable and impractical to read in 13' laptop screens with 1980*1200 resolution.
What you (and I) like is not SQL per se but what comes through of the underlying relational model, that SQL hasn't screwed up. SQL as a syntax and semantics is a mess. It could have been better.
How far back do you want to unwind? Should all non-aboriginals be disenfranchised or removed from Australia? At some point you have to work with things as they are and move forward.
BBC routinely runs articles rationalizing the positive sides of colonialism in India.
Nearly a decade ago I was working on Xen (or rather XenServer). We had lots of fun implementing these kinds of wonky devices for the virtual machines that would randomly drop network packets or fail to read the hark disk in arbitrarily bad ways.
I'm having flashbacks now of programming in Windows 3.1 and the 64k limit for contiguous allocation. We rolled our own Vector template in C++ in order to get around it, but it still made things a pain, like sorting.

And then there was the dreaded GPF... General Protection Fault.
Recently I tried using SQL directly on the frontend: https://medium.com/@unodgs/sql-on-the-frontend-react-postgre... as an alternative to GraphQL which I also find too complicated. You might find this interesting.
Pretty sure ravens aren't related to this discussion ;-)
> Some of it may be havoc. It may be responsible for many deaths. It's also responsible for many improved lives.

If we're making those kinds of tradeoff, China is just as responsible for many improved lives, just look at the Road and Belt initiative, projects against poverty and involvement in Africa.
I think one of the challenges with sql is that beginner developers can create naive sql queries that "work" but are extremely complicated for the optimizer to "get right". So in some cases (talking from own experience) the developer can, with the use of hints, "be better" than the optimizer when the problem all along was the overall structure of the query.

Edit: don't do it
The most important questions to ask when running automated UI tests
Yes, most likely your scale is based on the pieces of media that you received when you grew up, and not what is actually happening.

For example the Aalto University in Finland is currently one of the best ranked universities for art, design and fashion. None of the other nordic countries are even in the top ten. Sweden is not even in the top 25.
> As long as there's nothing valuable in the technology itself

You're assuming there's nothing valuable. I'd say there is. Whether that's enough to displace SQL I really doubt.
Watch advertisements. :-(
What would happen if both Uber and Lyft would stop providing the service in California? Would other States follow with that kind of legislation or would it make them less likely to introduce such legislation? I can't imagine the customers would be too happy with Uber and Lyft gone.
As a low 懐石, these cakes would be nice to eat after reading: https://aeon.co/ideas/is-there-any-real-distinction-between-...

Bonus battenberg track: https://www.youtube.com/watch?v=eELH0ivexKA
I wouldn't call getting 1000 delegates, winning several states, earning a sizable chunk of the popular vote and a clear 2nd place a "hilariously one sided defeat"

If more democrats stayed in the race after South Carolina instead of all dropping out like flies the day before super tuesday, there is decent chance he would be the nominee right now.
Seven Essential Messages in the Time of Coronavirus
> He's fucked.

He declared victory with nearly 80% of the "vote".
Definitely above my expectations. What a great man.
In this subthread: "Well, yes, but we're the good oligarchy!"
Unfortunately it doesnt solve the biggest issue, which is actually getting the demand in.