skysight-inc/HackerNews huggingface dataset:
I wonder if you or the other Postgres users here could give me some tips.

What would be the best way to use the data from a huge Excel file into my web apps?

Currently I'm converting it to CSV and use `BULK INSERT` with MSSQL. I know that with MSSQL I can also use Excel files as "external database" but AFAIK, Excel files are not indexed and are super slow when used as an "external database".

I wouldn't mind switching to Postgres. I actually prefer Postgres.
What kind of efficiency do human muscles get?
You're correct, it is a barrier, it makes things more difficult for the requester.

How you request it or where you are when you make the request doesn't change the legal status of the record itself if a data set has been made public by your state legislature.

If your local laws say you have to make the request in person, so be it. It's still an open record that can be queried and retrieved by members of the public.

If your local law say you may make your request online at a specific web address, so be it. It is still an open record that can be queried and retrieved by members of the public.

The mechanism or methodology of requesting a public record does not change a public record factually and legally being public unless local law says so (or FOIA if we're dealing with a federal agency, but since the context here is 911 calls, this is much more likely going to fall to a how a state legislature decides to protect/expose public records).
>I was amazed there was even a Resist@Google group within Google.

If I was google, I'd allow it. For a while. Then get rid of everybody in there. Good riddance.
If your politics are encouraging or even accepting of sexual harassment and pay discrimination based on gender, then your 'politics' aren't worth acknowledging, honestly.
I can't tell sarcastic comments from serious ones anymore, deluded wannabe saviors who actually think like that are abound.
It doesn’t go deep into the biological aspects but, Sapiens: A Brief History of Humankind by Yuval Noah Harari, is an enjoyable read.
They're not hiring these people because they need them, but because they want to avoid other companies from hiring them and doing something big and disruptive.
With what? I look periodically and I never find anything.
When joining tables from 2 different data sources, is the join performed by loading two tables in full into memory ? If yes - any plans on improving this, so that it does not OOM or kill the remote database ?
If no - how do you handle this case ?
Yep, and doing the "right thing" doesn't mean everyone will be cool with it (Snowden &c.), especially in highly hierarchical institutions like google. You don't get to light a dumpster fire in your own office without inhaling some of the smoke. At that scale any move outside of what you're allowed to think/do is a workplace suicide. I wouldn't be surprised if these people end up in other renowned tech companies though, google is losing on all fronts.
Google is (thank god) not the government and this analogy is bogus.
Walking up mountains - a typical Saturday for me is 2 hour drive, 8 or 9 hour walk then 2 hour drive back so usually about one non-abridged audiobook per week.

NB Only slightly odd side effect is I now associate particular mountains with specific topics....
They way the build cars with manual labor is pretty much how cars are built. The automated to much and now they went back to something that is more industry standard.

They are defently not the best in production of the actual car assembly, but its not like they are on all that inferior.

And I don't know what you mean with 'cut corners'. What corners?
Yeah. Do not underestimate the amount of technology that goes into bicycles.

Wright brothers were bicycle mechanics, before they pivoted into inventing heavier-than-air flight craft.
TypeScript is already similar to WebIDL, what we are missing is having it as part of the browser engines, with more optimizations based on type information, instead of being yet another language with a JavaScript backend.
> ... hence the beaming back to trucks.

Almost all of the television/radio broadcasting stations have their own uplink trucks (and directing rooms for their own camera's) on site. My guess is they send it there to allow the stations to intermix their own signals before sending it out, as well as to give the live reporters (which are at the finish) to view the most recent image without going though satellite delays.
You end up with campuses in different areas and different products centered in each.

Happens naturally.
"The most fundamental difference is thinking about the factory really as a product, as a quite vertically integrated product," said Musk. "It's treating it as more of an engineering and a technical problem as well," added Chief Technical Officer J.B. Straubel.

"Which is the Toyota Production System," replied Johnson.

"Yeah, we don't think so," countered Musk.
I think this is just a perceived prisoners dilemma where you don’t actually win if you cooperate.

What people probably think: If I install the plugin, Amazon can always beat the target and walmart price for me.

The reality: this lets Amazon increase their prices on cheaper goods to within a tiny fraction of what walmart and target offer, and also build a psychological model of the consumer to charge a bit more depending on their state of mind (Tired? Rushed? Pissed off at Trump today, and therefore red-state-headquartered Walmart?), etc, etc.

Most people that install this will only see the first order effect though — $10 and more convenient comparison shopping.

Of course there is another category: People that understand the game, and think they can beat the house. They should install it too (and then go try to make money playing slots at a casino).
> I don't really understand why it's surprising

I don't think anyone is that surprised, but that doesn't mean that it's right.

> I would try my hardest to change the direction from the inside out or I would leave and then criticize. I don't understand the desire to stay with a company and accept paychecks while simultaneously publicly denouncing and leading protests against them.

Good for you, but they decided to do something else. I don't think they were denouncing Google as heartily as you seem to suggest. They obviously had hope that they could change things. We're also talking about old veterans of the company. How do you know that they didn't do everything that they could internally before escalating things publicly?
The car production lines are working just fine right now. The current constraint on their production numbers is battery production, which is largely up to Panasonic.
Has anyone analyzed the coding style of E4M and compared it to the original Bitcoin release?

Coding style may not be as unique to an individual as prose, but it would be an interesting smoke test.
The Racist Politics of the English Language – How We Got to “Racially Tinged.”
I participated in HackI/O, Ohio State's hackathon. It was an incredible experience. Even with corporate sponsors, the competition was open and reasonable.
My point is simply that globalization doesn’t have to be a bad word.

Trade between Canada and the US left both countries better off. Largely because we have similar standard of living so neither country was being exploited.

If lawmakers did a better job putting in safeguards into trade laws then globalization wouldn’t be a synonym for exploitation.

I do agree with your point that under current political realities nothing is likely to change. I’m simply hopeful that if enough people become aware of this then policy will eventually shift—rather than respond with a knee jerk cancel all trade reaction that we see today.
I'd argue they quit practicing it when they IPOd, but technically the removal of the phrase from their Code of Conduct was more recent.

https://gizmodo.com/google-removes-nearly-all-mentions-of-do...
She reported an incident of sexual harassment that was ignored and then she was fired?
Creating Languages in Racket
Hyperledger Aries to Enable Blockchain-Agnostic, Self-Sovereign Identity
incredibly politicized concept as "equal compensation" (which doesn't exist [...]

Take a look at https://en.wikipedia.org/wiki/Equal_pay_for_equal_work
Based on what? They are selling WAY, WAY, WAY more cars now and have a MUCH, MUCH higher valuation then they would if they only built S/Roadsters.
Excellent example of Racket' s unique features used to build a language for making text based adventure games.
HAProxy Layer 7 Retries and Chaos Engineering
The average new car in the US sells for about $37,500. Slightly above average doesn’t seem too absurd for “mass market.”
No, currently we support only lookup joins. We're planning to add table/hash-joins based on table-size heuristics.
Motor Trend's track test impression of the M3P was actually quite positive: "In our testing, we found the Model 3 Performance to be a joy around the track."

https://www.roadandtrack.com/new-cars/road-tests/a22625274/t...
Yeah an Drill has been around for a few years. Will likely continue to use Drill over octocat (no offense OP)
We use PostreSQL. We ran into the issue with Google Cloud SQL (PostreSQL-flavored) that we can not make it multi-region, only multi-zone. With Google Cloud SQL (MySQL-flavored) you can do multi-region.

I would feel much better if we had multi-region failover with PostreSQL just in case a Google Data Center region (which contains the multi-zones) goes completely down (as it did in early June 2019.)

We have some manual solutions to this, but I would have prefered one that just worked with Google Cloud SQL out of the box. I think I am not the only one in this situation with this problem.
I personally love my apple mouse, they did a great job with it
It's also worth remembering that innovations in manufacturing are quite often 'short cuts' that have the same or better result with less process.
Cool! Does she want a medal or something? I'm not sure why people feel like they should be rewarded by their own company for publicly going against them. Talk about entitlement.
Someone could create an ad-blocking list for AWS IP ranges, for the purpose of such a boycott. (It is actually easier than boycotting most other commodity suppliers.)
Way to chop off my sentence at the perfect point for you to counter it, while ignoring the rest of the context it was said. I’ve edited it now so it won’t be.
It looks bad in so much as there will be angry tweets for a while and maybe some Medium articles written. But it's not bad in the sense that it won't blow over, anything will change, or there will be any real punishment of anybody at Google over it.
Well at least you're being downvoted.

Where do you draw the line at bigotry and perversion?

Homosexuality, transexuals, polyamory, eating meat, necrophilia, cannibalism, bestiality, pedophilia?

There's people who non-ironically believe that each of the above is no worse than any of the others and should be treated as such. Unless you take a live and let live approach that I have never met anyone in real life admit to you will want at least some of those criminalized.
> It's literally illegal. There are laws against retaliation against whistleblowers. That is why it is surprising.

There are many ways around the law. It happens everyday: "oopsie your team has to work on something else, double oopsie you're no working on AI anymore you'll just work on our CSV parser, that's were the money is these days. Ah ? What are you saying ? You don't want to work on that ? Well feel free to resign, we'll sign you a $200k check if you forget about it", &c.
You can resell a copyrighted book, but you can't make copies and sell those.

Presumably kpU8efre7r is thinking of something similar - which would obviously make life hard for companies like Equifax.
Everything you say is true. Nonetheless, as someone who makes political contributions, it matters to me whether a Rumanian hacker can get my home address while sitting in their basement in their underwear, or if they have to get a U.S. visa and travel to my home town in order to do it. That is a salient difference to me, irrespective of the legal status of the information.
Because they will lose money, since their margins are already very slim now with at their current labor cost.
this was an interesting read for sure
Hey HN, I built this using GitHub pages and a few lines of JavaScript, you can see the source here https://github.com/jminjie/thumbpoems
Of course it is. So is JavaScript. I've done stuff in C, C++, Haskell, python and am now writing primarily in js. Nothing weird there. I fight more with libraries than with the language.
Also, Google’s R&D blatantly steals innovation from female inventors

https://patentpandas.org/stories/company-patented-my-idea
This is a good site: http://tutorial.math.lamar.edu/

Also, if you have interest in a specific subject, exploit your own interest and start with what you're interested in. Don't force yourself to relearn from the beginning just for the sake of starting from the beginning.

Also, your goal will be one or more of: pass a math class, learn to solve real world problems with math, and/or learn math for fun. All of these are possible even if you have some gaps in your knowledge.
>There are exceptions of course, but statistically, leftists are better at tech.

Citation needed.
It doesn't sound like scraping. What they do is they fetch the prices for their own products when the users browses a competitor. The prices of their competitors' products are already in the open, they won't need them. What they need is the browsing history of their customers in order for whaterver they want to better understand about the shopping process.
They mention it in the article and couldn't come to any conclusions.

I don't see anything that stands out as saying these couldn’t have been written by the same person (especially separated by a decade),” he wrote. “Nor do I see any similarity that wouldn’t also be true for many other authors and codebases. At a minimum, however, if they were written by the same person that person’s styles changed a lot (either due to time or intentionally hiding them).
> Sounds pretty normal to me.

That's the thing about retaliation. Unless the retaliator is really bad at this, it is always going to look gray-area, because you're shading available policy to reach a desired outcome.

You want to do it that way precisely because it plays on some peoples' preconceptions, completely aside from not breaking black-letter law.

A lot of folks will see a enviable company, assume the Powers that Be must get most of it right, and assume the person they already knew was a troublemaker (they were contradicting their betters, weren't they?) was also bad at their job.
MOAI had the ability to target WebAssembly, and that was about as Flash in the 21st Century as you could want ..
You have been highly active in this thread and it doesn't seem like you are trying to understand the other viewpoint. Do you have a personal stake or other underlying assumption in the matter that might be biasing you to a particular conclusion?

If you don't see privacy implications to releasing recordings of e.g. people experiencing medical emergencies (medical records are otherwise clearly protected) then perhaps you need to reevaluate your understanding of what privacy means to different groups of people.
President Issues Third “Buy American” Executive Order
Thanks. I hadn't gotten that far in the article yet. :)
BBC iPlayer – “Can It Be Done in React Native?”
Is this right? (Disclaimer: I'm about halfway through the Rust book, so I'm just a bit above useless when it comes to Rust) but my understanding was that since WASM can't do DOM manipulation, you still need JS and something like Emscripten to call WASM code.

The data and business logic of your code can be written in a WASM-targeting language, but I don't think you could make a React/Vue/Angular-esque UI library (or even a jQuery clone) purely in Rust.
You have a valid concern. I do not intend to dismiss it but I will offer this is why I put forward the caveat previously that absent legislation that acts as a buffer against unauthroized or illegal use of public records (which almost every state has provisions in their record keeping laws over already), the mechanism doesn’t change or alleviate these concerns.
What else do you expect from a company where an investor retconned himself into being a founder, including in the Wikipedia entry?
Your 'work' on military drone technology and censored search is political by nature.

If you want politics out of your workplace, stop working for the company that spends more on political lobbying than any other tech company.
Snyk security tool for open source
Qt has an experimental WebAssembly backend, already discussed at least twice on Qt's developer blog.

Microsoft is busy pushing Blazor for .NET, and Unity is working on a 2D WebAssembly game engine already demoed multiple conferences.

C and C++ can make use of Emscripten and even use SDL, POSIX subset and OpenGL mapped into browser APIs.

D's LLVM based compiler, ldc, can target WebAssembly. Thus you can also write the logic in D, and do some mapping into browser APIs like canvas and WebGL.

Unreal can also target WebAssembly.

There is TeaVM for Java.

Go compiler supports cross compiling for WebAssembly now.

So plenty of information around.
*should?
I'm thinking it must be the "conspiracy theorists" that don't exist. Must be a false flag - I mean, after all, there's NO WAY a real person would believe these conspiracies. The government is trying to get us believe in the dogged stupidity of the common man. Wake up sheeple!
From the Motor Trend TM3P track test drive:

You'll kill me for saying it, but this sport sedan has the same toss and catch that makes the best front-drive hot hatches such a joy to hustle—bolstered by no-joke instant horsepower and the predictability of vectoring all-wheel drive.
It's not sarcastic at all. I appreciate the ad-hominem for having an opinion, however.
Study links social media and TV, not video gaming, to teens’ mental well-being
I would have thought it obvious that friction is very much a part of the equation that has historically gone into deciding what information should be public, what should be formally sealed, and what should be actively expunged from the public record to the degree possible.

Suppose I hire an investigator to conduct a (legitimate) investigation into a political opponent, high-level hire, etc. including past addresses, any arrests, mentions in newspapers or online, anything they've written, etc. They'll dig up a lot of information, some of which are public records and some of which is simply publicly available information.

Are you seriously trying to argue that there is no difference between an in-depth targeted investigation of an individual and that same information being available about everyone to anyone on the planet with a press of a few buttons?

Sure, you can argue that there is no privacy and people should just get over it. But there is a significant practical different between information that there's some friction to access and information that's indexed and freely available to everyone with a computer.
Nothing, but we're not talking about contextless for-loops here, and you know that.
Ordered mine from Element14 at 5:30am Eastern the morning it was announced, and my order status has constantly said "Shipping " + two days out from whatever date I check. Still hasn't shipped! The demand for this thing must be incredible.
Sounds like getting rid of troublemakers who bite the hand that feeds them. If anything this will make googles stock price go up.
When MySQL didn't have stored procedures or triggers and I finally ran into a use case that required them, I switched to Postgres.... then a decade later MySQL was caught up and stable, and I switched back.

Don't leave MariaDB out of the conversation... that is basically the MySQL team that forked the project after oracle bought them out.
This is correct and one of the best high-level descriptions I've read recently of why American-style capitalism's ultimate conclusion is pernicious social rot.
Apache Drill vs Calcite? Seem very similar.
Albert Einstein is surely more famous? Imagine coming up with two theories that barely anyone understands, but they still want their kids to be like you?
Thanks, didn't know about it! I'll make sure to read up on it!
It’s clear that tesla stories (especially negative ones) = more clicks

At the bottom of auto/EV articles, I frequently see a sentence or two soliciting stories from tesla employees specifically. Often times the article isn’t even about tesla!

I can see disgruntled employees jumping at the chance to share their story with a journalist incentivized to write about it.
s/resist/quit
Even a law isn't 100% effective. Physical limitations are significantly effective, and and a lot closer to 100% than to 0%.
>Because you don't want to see the thing you worked so hard to build misused to build killer robots and "war minds"? Seems reasonable to me. Google's got a different mission and sometimes the leadership forgets it, and needs to be reminded.

The question is not why would you publicly protest actions of your employer. The question is why would you expect, or even want, to work there while you do.

Also, do whistleblower laws protect you from retaliation if what you're blowing the whistle on isn't illegal?
While this is technically true, we have libraries (js-sys and web-sys) as well as tools (wasm-pack and wasm-bindgen) that handle creating that JS for you; you don't have to write any of it yourself. Additionally, they're implemented as polyfills for the eventual way to do this kind of thing without the JS, so once that lands in wasm proper, your code won't need to change, and things will just get faster.
Near Stonehenge they found a 4000 year olds dagger. Its handle "was decorated with 140,000 tiny gold studs, each almost as fine as a human hair and set into the wood at more than 1000 to the square centimetre."

Even 21-century craftsman would find that impressive.

https://www.independent.co.uk/news/science/archaeology/stone...
I don't believe the are the absolute highest-end quality, but there are dedicated audio hats for the raspberry pi.

https://www.hifiberry.com/shop/#boards

EDIT: Amazon reviewers seem to think the sound quality is extremely good for the price. I guess I know what I'll be playing with next.

https://www.amazon.com/HiFiBerry-6009-DAC-Pro/dp/B01MF77LH9#...
> So as long as you have good intentions you should be free to bring whatever politics to work?

(IANAL.) Gender discrimination, and sexual harassment in the workplace are against the law in California. I believe the law also protects against retaliation for claims of violations of these things. This is hardly "bringing politics to work".
The Mighty Mouse wasn't so bad. The ball would get dirty and need to be cleaned occasionally, but you could kind of clean it without taking it apart (flip it upside down and rub it on paper), but you could also take the mouse apart to clean it more thoroughly.
I like this model a lot.
The bit I fight with the most is how to package it all up for distribution. I'm not a frontend dev, and I vaguely understand that the answer is "webpack" but it's not clear to me what the happy path is for configuring this for distribution. It's also not clear to me whether these $LANG->WASM toolkits will solve this problem or whether they'll also need something like webpack.
I recently migrated a small side project from MySQL to PostgreSQL. I wrote a short blog post about how I did the migration, issues I ran into etc:
http://blog.minimum.se/2019/07/09/upgrading-node-mysql-to-po...

I'm overall very happy with the migration and PostgreSQL also ended up taking less memory (RSS) in prod, which was a nice bonus (this is useful for me because I'm running this on a low-end Digital Ocean droplet).