skysight-inc/HackerNews huggingface dataset:
And you think https://tech.marksblogg.com/billion-nyc-taxi-rides-clickhous... for example is something that can be considered fast? It takes the user 55 minutes just to load its data into a state so that it can be "queryable".

After importing then they spend 34 more minutes making the data into a columnar representation. Alright so 89 minutes in and we still haven't run queries.

Oh but its not distribute yet. Darn I have to run some non standard sql commands like

CREATE TABLE trips_mergetree_x3
AS trips_mergetree_third
ENGINE = Distributed(perftest_3shards,
default,
trips_mergetree_third,
rand());

Ok can I query my data yet? No you have to move it into this distributed representation and that takes 15 more minutes. Oh ok...

And now? Yes you can run your queries but they aren't really very fast.

SELECT cab_type, count(*)
FROM trips_mergetree_x3
GROUP BY cab_type;

Can take 2.5 seconds on a 108 cpu core cluster for only 1.1BN rows? Thats not fast. That's particularly slow given that requires you to ingest and optimize your data.

Maybe you want to show us an example of some simple tests you have run with blazing and clickhouse. As I read it now its not worth our time to look into becuase its so very different from what we are trying to offer which is:

Connect to your files wherever you have them
ETL quickly
Train / Classify
Move on!
Show HN: Cardtables.Online – Virtual Cardtables for Playing Cardgames Online
Vulnerability in Tesla Website Used to Find Details of 8500 Cars in US Inventory
Blood Music
https://en.wikipedia.org/wiki/Blood_Music_(novel)
I don't see how that could be possible, unless it is a transmissable disease that infects the brain.
Great White Shark Genome Decoded
Hm... confined plasma... could this be used to start a fusion process?
At Last, a Brexit Dividend – Shame It’s for the Pedlars of Fake Medicine
That's a good idea, thanks! I'll make an updated video of it and add a link to it in the README.md.
I think they were giving the example that given the same diet, one person might develop diabetes while another would maintain a healthy weight due to predisposing genetic factors.

But actually it does seem to be the case that the ability to put on fat is in some ways protective against diabetes. In other words, people that easily store calories as fat don't have the metabolic problems associated with diabetes, since their body is able to effectively store any extra calories they take in. Diabetes develops in individuals who are not effective at converting excess sugar in their blood stream into fat, so instead they suffer metabolic damage. That's not to say that they don't put on fat, but if you see someone who has an enormous amount of excess fat, they are likely to have a much higher threshold before they develop the disease.
Why Getting Enough Sleep Reduces Cardiovascular Disease Risk
iTunes appears to have stopped getting updates around 2012. The long description for podcasts appears in a tooltip bubble ~20 characters wide. It's unusable.

Ive must have burnt out.
I made this because I had to make a todo list and my other lists were in email but using email for todos was too much work.
Oracle Data Cloud Registry
What makes it hard to work in a cloud environment? The on demand nature of it? The fact that you only pay for the time you are using it? The ease of scaling or deployment?

It would be helpful if you could qualify some of these statements.
Google: The Back Button May Disappear on Android
What's funny is that Samsung actually made an Android DSLR several years ago, called the Galaxy NX.

It ran full Android, you had all your file management, Bluetooth and wifi, could play games if you felt like. Could encrypt the filesystem, too, which I think is super important for journalists.

Basically nobody noticed or cared.
Have you watched this video? https://www.youtube.com/watch?v=d-7o9xYp7eE

I agree it's not a great equilibrium though. Police need to be able to get info from the community to do their jobs. But the problem is, who can trust them?

I don't know if the arguments in this video apply out of the US or not.
Here reputable = discriminating

And these low-reputation journals are poorly discriminating. Status here has a reason.
You may find Control-F2 helpful.

It focuses the menubar, at which point you can navigate the menus by typing/arrow key, Spacebar to focus, and Enter to select.

It helps me avoid a lot of mouse usage.

...come to think of it, I should probably give that a binding on my ErgoDox somewhere.
And if it's not the microbiome it's probably something to do with quantum entanglement.
Even better, If you can turn potasium into uranium you will be rich (or killed, or both), but this is bananas.
I think those can quite coexist in the same space (especially if said space is a 100M euro building ;)). The library can function as that communal place of shared culture, and host cafés, exhibitions, concerts, rooms for community events, rooms with musical instruments (the facility I make the most use of in my library)... and also quiet study rooms and places to focus without noise or distractions. There is no incompatibility between these two aspects.
Oodi is in the most central place in Helsinki. I think it's perfect location for public space library where people and groups can meet and work together.

Helsinki has exceptionally good libraries for quiet studying. If you have a book and need to sit down, read and study, I would recommend National Library, Rikhardinkadun library or Kaisa library. All of them are walking distance from Oodi.
Will AI Achieve Consciousness? Wrong Question
That’s not true and that’s not what he did.

1) you can criticize Israel all day on campus, no one will stop you.

2) you shouldn’t promote mass murder on campus, which is what SS did. Saying the population deserves mass murder because they’re evil is what he did. Fortunately that was deemed beyond the pale.
Coming in the current sprint. We have a PR open agaisnt CUDF that brings string support to many of the CUDF algorithms. We will be using this branch in the meantime in our engine while we wait for the PR to be accepted.
You become time-constrained by the very virtue of living. As a 40+ noob, you're worth much less for an employer than a 22-25 noob. You have about the same experience, but younger noobs have more energy, less health problems, much less expectations, much lower costs of living. Also, at 40, you're supposed to be halfway through your expected career; deviating from a standard life looks weird, and from what I can tell, most entry-level jobs don't like weird.

Such is the job market.
Russia Has a Case. As Does America. So Save the Nuclear Treaty
Spectre Chip Flaws Can't Be Killed by Software Alone, Google Concludes
Or maybe casing places/people for something they want to do later. You know...pre-crime.
This really depends on what you're doing. I suppose most of the code I've written in the last two decades wouldn't have profited from using coq. BUT then there's CompCert, an optimizing compiler written in coq [I'm affiliated, but not working on it directly]. If you're building safety critical stuff (like in failure == people die) something like this might be interesting.

Of course, for a C compiler the requirements are less prone to change than e.g. some SAP-style business application. As a dev, coq is just another tool in your belt and being a good dev means knowing when to use what tool.
Calendar. Not To-Do Lists: Viewing Time as Space
I'm totally jealous about https://www.monokai.nl/ and https://shauninman.com/pendium/. IMO some of the best personal sites.
Emailbin.org a Place for Anonymous Emails
> I wouldn't have upgraded and I know for a fact there is really no difference after using it for several months.

No difference between what? X and XS? Sure. But in the same way that there is “no difference” between 6/6s, 7/8. It’s a speed bump (which from the X isn’t really relevant unless you use your phone for everything), camera improvement, and display improvement. All things that are noticeable if you have the two phones side by side, but that you will forget about in regular use.

I do agree on everything being too expensive now. All the MacBook lines are about $200 more than they should be, and the same goes for iPad. iPad now has much more amazing hardware compared to the mac lines, but it is hugely limited by its software.

With Apple’s recent leadership changes I think we are going to go into another era of lower cost hardware (while still keeping the newly formed top end, like the xs max.) All while they try to find what will sustain growth in the company post-iPhone.
Number of things DEC missed out on: personal computer, DOS, search engine, networking, storage.

How can something having so much lead keep missing out on so big? What they could have done differently?
There is a "filter similar message" option available (it is hidden with the answer /transfer / print / etc options).
To me the most interesting and convincing part is that fecal transplants from schizophrenic patients to mice changed the mice's behavior in ways that are similar to schizophrenia, as well as changes in glutamate levels. This shows some kind of causal link more than just correlation.

I feel like all the comments are ignoring this part of the blog post
One of the main reasons why a lot of startups fail is that they produce their product or start offering their service without even first making sure that the customers in their target market want what they are offering. Therefore, before doing anything else, make sure that you understand your customer’s wants and needs without copying what some other company is providing or has attempted.
Here I read an article might be helpful: https://cabstartup.com/why-startups-fail-and-how-to-run-a-su...
Long Does It Take to Recover After Abortion
Do you remember the year this happened for you?
creator here:

emailbin.org is running on elasticsearch with a hideous frontend of pure raw html hahaha

usecases:

* email signups

* posting of email threads to government

* your ideas

it is and will always be a free place to lay your emails to rest :-)
I like some of their apps, I wish they would publish them for other distros to use. Namely their own editor is kind of nice, if it supported scripting for plugins (I havent used it in a while so no idea if it does) it would probably really take off as one of the nicer GUI editors if it ever gets adopted by other distros. I think my ideal setup would be POP_OS! with some ElementaryOS apps.
They didn't say people are gouged by phones. They said:

>You either consent to being exploited by Google, or you pay a pound of flesh to Apple.

Meaning you're in camp 1, unless you've run lineageos or something similar. Also if you're just on the regular os, a $180 phone from 2016 probably doesn't get security updates at this point.
Canvas fingerprinting on the web
With Lenovo you would get the 3 years onsite warranty with accidental damage protection at the time of purchase. Then a technician will come to your office or home and to replace the broken parts of your Thinkpad. That beats having to go to an Apple store IMO.
My favourite bug is the one where your audio gets randomly panned until one day you realise you're only listening to the Left channel of the music, and you have to go into audio settings and pan it back to the centre
exactly this. The module infrastructure of Julia is designed purposefully to be like R which is great for data exploration and statisticians. However, its a horrible architecture for building modular large scale software.
Gpt-2: Code for the Paper “Language Models Are Unsupervised Multitask Learners”
I really don't find it hideous. This definitely looks like the kind of building I'd like to check out.
source code:

https://github.com/emailbin/web
I always argue that Apple went with USB-C a little too early, but it IS the future.

More and more monitors now support it, and a single cable to both charge your laptop, and extend your laptop to the display is a killer feature.
> Python is not made for this.

Maybe, but there are ungodly big and crufty codebases in Python all around the world, and a lot of stuff depends on them. And it turns out that Python was never meant to be the thing that is being depended on. That's unfortunate. Hence the whole gradual typing (mypy) and other kinds of safety efforts.

You're not forced to use this. But it seems pretty useful, even for scripts.
The Game of Archetypes: How Storytelling Works for Tech Brands
>There's countries where the percentage is lower, yet it's basically illegal to criticize the government.

Don’t you see how deeply ironic that statement is? There are countries where even trivial things like criticising the government are illegal, and yet somehow the United States manages to imprison more of its own population than anyone else.

Put another way, you are more likely to have your liberty completely revoked if you live in the United States than if you live anywhere else in the world, both by population and per capita.
There are other options, or will be other options, i.e. the librem 5 (https://puri.sm/products/librem-5/)
The problem is that "out of the box" it's more or less a similar experience to the first iPhone. It's a phone, with messaging and a browser.
None of the apps you've come to depend upon are there.

Here in Denmark, where digitization of the society is well underway, you're pretty much lost without official apps. You _can_ use a browser for most things, but since there are apps, almost none of them are optimized or even usable on a phone screen.

Below is just a small portion of the things that would be impractical to live without with a "non supported phone". (impractical, not impossible!)

* Our country wide common sign on solution, NemID (https://en.wikipedia.org/wiki/NemID) also has a smartphone app. The solution is used for authentication with all government and financial institutes, along with a lot others. The keycard remains a viable solution, for now.

* Most mail is delivered through e-boks (https://www.e-boks.com/corporate/en), which includes bank statements, insurance policies, tax records, building permits, sanitation and other. The solution is open for every company to use. It is also possible to reply to a sender through this solution. (requires NemID signon)

* Banking is done through an app. (requires NemID signon)

* Person to Person payments (including the option to split a bill), and to some extent in-shop payment is being handled by MobilePay (https://en.wikipedia.org/wiki/MobilePay). It's kinda like PayPal, but a local solution. (requires NemID signon)

* Communication with schools and kindergartens is done through "SkoleIntra" and "Børnenettet", or "Tabulex" for when school is over. This includes teacher to parent communications, homework assignments, parent to parent communication, vacation registration, calling in sick, and more. It's probably the most hated system in the world :)

* Even receipts from a wide selection of shops are digitized and delivered to an app (https://en.storebox.com/#/), allowing easy access (and tracking of your shopping habits / credit card usage)

* Even emergency services has an app that will allow you to call emergency services, and it will relay your position to the operators so they know exactly where you are.
"write it down."
Runbooks, code comments, test cases, etc. Also, avoid silos: pair programming, knowledge sharing sessions, demos, etc.
Same goes for most Governments though.
We store data for you in a way that's considerably more secure and paranoid than how other providers work -- quite similarly to CryptDB. We can access your data when serving it to you, but your medical data is never stored on disk with a key that we store (it's derived from your password, and we throw it away after serving you through HTTP).
Huawei Tried to Discover Apple's Secrets
I did my thesis on one possible cause of this illness 20+ years ago and then never looked at it again.

After just reading up on the possible causes of schizophrenia it seems many more discoveries have been made which has only resulted in more confusion and we're basically nowhere near having a clue.

One of the most important points that rarely come up in these discussions is that schizophrenia is not one illness but a bunch of different ones grouped together that we haven't figured out how to differentiate. You can find several patients that share very few symptoms.

https://en.wikipedia.org/wiki/Causes_of_schizophrenia
> And they don't eat much of the vegetables, because they are expensive and hard to come by

Nearly everything you said is incorrect, this one in particular. Vegetables are not expensive in the US compared to other nations of similar incomes.

The US is a leading producer of vegetables such as cauliflower, lettuce, spinach, broccoli, squash, potatoes (/tuber), onions, turnips, soybeans, carrots, pumpkins and tomatoes (/fruit). Globally the US is third in vegetable production, behind China and India. For one example, the US produces about 15% of all lettuce globally (with 4% of the world population). Vegetables are more than plentiful in the US, we unfortunately waste enormous amounts of vegetables.

The US consumes more vegetables per capita than these European nations:

Germany, UK, France, Switzerland, Sweden, Finland, Norway, Russia, Austria, Ireland, Iceland, Hungary, Czech, Bulgaria

US vegetable consumption is almost identical to the average of the EU. It's also essentially identical to the consumption in Canada, New Zealand and Australia.

Interesting fact: the poorest countries in Europe typically consume 50% to 100% more vegetables per capita than the wealthiest countries in Europe.

Source: FAOStat
I'd probably argue the opposite. Dataflow is a natural way to think about ML activities. The problem is that no mainstream languages offer dataflow as a first class construct; at best it's a set of libraries. That creates some impedance mismatch between intent and implementation. That compilers already do dataflow under the covers would hopefully mean that implementing a first-class dataflow language wouldn't be too hard.
Eh, I'm in two minds about the touch bar. Once you get used to it there are SOME good uses (IntelliJ has a pretty good touch bar implementation, for example).
Ask HN: What Happened to Placeholder.com?
A disappointment wrapped as a question:

Compare what placeholder.com looked like in in Sept of 2018 vs now after it was acquired:

Before: https://web.archive.org/web/20180902234223/http://placeholder.com/

Now: https://www.placeholder.com

Someone bought this nice little service that I've used from time to time and made changes.

Do these sort of changes actually make the site more profitable? What can motivate someone buying something so simple and clean and making it so confusing and dirty?
Digital Ethics by Futurist Gerd Leonhard – Issue #4
https://read.amazon.com/ works but it's only for Amazon books
Why is it a tautology, and why would it be ignoring the fact? I am not. I am only stating that it will be less of an issue, because well, it will be... that is, if everything turns out to be working as ITER "predicted". Isn't this correct? We are aiming for "cheaper" and "greener" electricity, some even call it "infinite electricity".
Honestly it looks like a shopping mall. Shame considering the budget and Finlands rich history of architecture/design.
Ask HN: What Are Some Useful/Nifty Design Patterns in Programming?
I have seen a general disdain for Design Patterns (GoF etc.). But are there any design patterns you have found very useful in programming?

They could be one of the standard design patterns defined by GoF or others, or patterns that you had to create on your own to solve a particular problem.

These could be Object Oriented or Functional Design patterns. I am not talking about any System level or Web scale design patterns here.
I'm curious to find out what people define as fizzbuzz, do you have a good example of something you've asked in the past?
It made sense for a long time that picking robots are coming, whats more interesting for me is the timing: it seems like they will mature at the same time as self driving cars
Python2 will be at end of support next year. That means slowly it will become harder and harder to make calibre runable on modern systems. 3rd-party librays will decline and receive no updates. Python2-interpreter will not be installable out-of-the-box. There will be no security-updates or new features.

Python2 as a platform will slowly die and any application depending on it will die with it. Though, this won't become a serious problem in the next years, but more like 5-10+ years.

It's sad, but the reality now.
With a file manager, you'll probably only be able to find a book from its author, and title. If you have a small collection, this is fine.

When your collection grows though, issues start to show up. Being able to sort, and find a book based on other information becomes much more useful: date of publication, genre, custom tags, etc... While you could always integrate these in your filename/directory structure, with the help of symlinks, it's very cumbersome to manage and use.
> Their iPhones have reached a peak, where it appears people are no longer willing to pay so much for them.

They may have reached peak growth, but the numbers show that outside China (which in hindsight appears to have larger economic issues), millions of people buy iPhones.

Are all the current iPhone users going to suddenly switch to Android? Very unlikely.

By all accounts the XS is a great phone. If I had anything other than the X, I would have upgraded.

> Apple is the richest company in the world, and instead of paying their engineers top wages, they are wasting it on stock buybacks.

You realize that Apple has so much money they can do both. This is not a binary decision.

A much bigger issue for Apple is that they need more stores. They have a huge advantage over any other phone maker in that people can walk in and get service and support. The stores are so busy now, that it has become a challenge. Hopefully the departure of the head of retail shows that Apple has realized they have not grown the store base fast enough.
You can't just write a comment like that. links please. ;)
Working with Environment Variables in React PWA
Very little content, but sure: https://www.timboswell.co.uk
Jeff Bezos at YC Startup School 2008 [video]
All criminal investigations start with group of innocent people. That's the only way to investigate.

Police collects data from security cameras, road cameras, credit card purchases, witnesses, and now from mobile service providers.

I agree that privacy erosion is real, but you argument was not convincing.
While you don't have to pay slaves, they were not free. They were expensive to buy and you had to provide food etc. (And they might rebel and kill you.) The Romans did use things like water mills, so they might as well have used steam engines if they had actually been practical.

I'm not sure the Romans ever realized the device could be used to perform work. It is really just a curiosity.
Speculation is not really a point. It's a temporary method of popularization, because people can't be reasoned with in other ways.
And here I am switching to Mac after a lifetime on Windows.

All the things you say about Apple might be true, but the alternative is substantially worse. Microsoft dropped the ball way more than Apple ever did with Windows 10. And hardware quality among laptop manufacturers is frustratingly inconsistent, even within the same brand.

My last Lenovo worked great for 5 years despite being a low end machine. My much more expensive new Lenovo has had a keyboard replacement and significant performance issues in one year.
I was also wondering about Polarized vs Bookworm.
You checked in the wrong place then.
StartUp Failure Due to Culture
Nasdaq’s Bitcoin and Ethereum Indices Solve a Major Problem for Crypto
Okay i was wrong. I looked at some other pictures and it is okay.