skysight-inc/HackerNews huggingface dataset:
Thanks for mentioning bitemporal databases, I hadn't heard of anything like that before. Time-based mutable facts are so hard to represent well.

I think their definition of time-series database fits the common usage I've seen everywhere: the data has a time dimension and is append-only/immutable (well, ok, you can mutate the data in a postgresql table, but nobody's forcing you to).

Given the choice between selecting a specialized time-series only database or using a time-series pattern in your existing postgresql database, postgresql is often (usually?) the more pragmatic choice. That's what we do at mixrank with time-series tables approaching the 100 billions of rows.
Thanks, but "yes" would have sufficed. The operative keyword in your comment still remains "seems". Seems to you, I would add.

https://www.youtube.com/watch?v=VZrF7v6jfLw
i have a raspberry pi
Hi there - I'm the CEO of Gun.io. Shoot me an email at teja[at]gun.io. Our average rates on platform are 10x higher than that. In fact, that's why we started the business.
I second reading the Postgres docs. They're fabulous resources. Any time I'm attempting to apply a new SQL syntax feature I'm not 100% fluent with, I'll give the PG docs a read-through—not just for usage, but also for idiomatic examples, performance analysis, edge-cases to consider, and more.
Thank you for sharing this, very cool!
On the flipside, systems that are too cumbersome to use because of access controls lead people to do things like maintain shadow systems in Excel spreadsheets just to get their work done. Of course with no security at all.
> I think we all generally know what he did.

We all know stories about what appeared to or was claimed to have happened that reached the media through official and unofficial channels before any internal investigation.
https://www.marketwatch.com/story/the-31-year-old-queens-pro...
Diet. Exercise. Develop better monitoring tools to make the most of the mechanisms available.

But, in reality, reversing the laws or going to the black market is the most pragmatic approach. Diet and exercise and refining understanding takes more than 180 days to effectively implement and takes more discipline and control over your life than most people have.
"End-to-end-encryption"
has flailed us.
In addition to the points already raised by
ryan_j_naughton, another consideration is how to perform key rotation and cipher upgrades over time. This is a lot more complex if every application is doing it on their own, but is quite easy if you centralize all (or most) crypto to a single service.

See my reply to another comment: https://news.ycombinator.com/item?id=16236798
The article is proposing is that it can be quicker to drop the indexes and recreate them than to load a lot of data in an indexed table.
Have you tried a recruiter? Every job I've ever had in tech was through a recruiter. Also where are you located? I'm guessing your location is a big part of your problem.
A longtime Google engineer quits saying the company is '100% competitor-focused'
For de-anonymizing, the idea is to give the encrypted service the plain text and get a matching token. But then that will be more of a hash. If you are encrypting where all the tokens are different, you can't do a join or analysis. You can't for instance count how many unique phone numbers you have. If a user is using your app, how do they see their PI data?
If you have rules but don't enforce any consequences for breaking them, the rules pretty quickly get ignored.

If Lyft had fired a few rulebreakers early on, everyone else would know they were serious.
It's a custom Go application that proxies rest/json based APIs, as well as gRPC/Protobuf.
Well, it took a couple of years for the $2B team to do something new, unfortunately it's going to fall on it's face.
This article has reminded me that just because people proclaim to be a feminist, Christian, humanist or terrorist doesn't mean that they are often primarily that thing.

This particular feminist would probably identify primarily with being a mom and in certain scenarios one of those identities must take precedence. So even if you do feel Uber is anti-feminism it still seems compatible that a feminist who primarily identifies as a mother would take a job at a company like Uber to better provide for her own career which in turn allows her to provide for her kid(s).

Humans are messy.
Not if you have credit reports and other data that could contain PII as well. You don't want the name or address in the credit report to just point to your user's table, with an assumption that that was the name in the report. And if you don't know with certainty that the credit report pulled was for that person (there are collisions, mismatches, etc), then you want to store that data as associated to the report and not the user (which the report is then associated to the user).

For proper data integrity and data provenance, you want to know what you knew at each point in time. Thus, simply pointing to a user_id and hoping the data on the user's table was the data at some point in time in the past will result in leakage for data science (https://www.kaggle.com/wiki/Leakage).
We currently have the same problem in Node, where fork is still being called synchronously from the event loop instead of asynchronously from the thread pool.

Calling exec() or spawn() in Node is therefore not asynchronous and can block your event loop for hundreds of milliseconds or even seconds as RSS increases.

https://github.com/nodejs/node/issues/14917
> Why does anyone have an account at Bank of America or Wells Fargo? There is a community bank in every town in the country.

I used a credit union for a short period as a means for managing my finances during a rough period. I had to walk three miles to open the account. Same when there was a delay between signing up for direct deposit and I needed to cash my paycheck. I was also doing side gigs in my free time, so more walks for personal checks.

I managed to get through it, but I was lucky. This was during a time of year when the weather was accommodating, but it easily could have happened during the winter.

There is a Wells Fargo less than a five minute walk from me, however. I can easily imagine that some people can’t take the time (kids) or don’t have good enough health to make the sacrifice involved in choosing a small institution over what is geographically accessible.
Pantheon is one of the world's greatest buildings, but not because of concrete. And it has been repaired.....a lot.
>If Mr. Musk were somehow to increase the value of Tesla to $650 billion — a figure many experts would contend is laughably impossible and would make Tesla one of the five largest companies in the United States, based on current valuations — his stock award could be worth as much as $55 billion

Except that as the article says, he already owns 20% of Tesla, so his current shares would rise in value by $110B. He could fail to meet any of performance targets and still be pulling in a billion dollars a year in capital gains.
WAIT WAIT WAIT!

Do some stats on the data before you blow it away. You know, just for fun.
When I looked into Thrift's generated code for Objective-C when we started working on gRPC (so 2014), RPCs were all blocking, which made for a non-idiomatic API. I haven't looked if they've added an asynchronous version since.
How many vehicles do you think Tesla will sell in 2021?
Oh? Chase was actually the bank I was thinking of, since they waived the fee on my account as a result of transfers from another account. Been a few years though.
"HEMA can’t publicize the actual screen because of security concerns — the system could then then be vulnerable to hackers, Rapoza said."

The level of incompetence is astounding!
I think outgoing wires are almost never free, maybe you are thinking of ACH transfers? The rest of the things sound unfortunate though, and potentially illegal in the case of converting to a fee account without notice.

Customer friendliness can vary a lot even within a bank/credit union depending on the customer and personal banker, since a lot of fee waivers are discretionary. E.g. if a banker has a fee waiver limit per month then they can help you at the start but not later in the month.

Part of the issue is that since rates have been so low, the traditional net interest margin of banks has been squeezed so they turn to fees to compensate.
Legal advice, most like. Or he could have done it on purpose, mentioned his plan to someone, and is scared as hell now. I mean, we don't know anything.
Yes, there are two lessons to be learned here. One is about interface design. Or maybe more broadly about system design.

The other is how to deal with being arrested, or targeted in an investigation. "Refusing to cooperate" is always the smart move. Because cooperating will always make it worse, notwithstanding claims to the contrary. And it's sad that this person is being criticized for being smart.
I recommend you benchmark against ScyllaDB, not Cassandra.
Hmmm, so you think it's possible that the UI was designed with the proper checks and the government officials in charge have decided not to correct the public narrative because...?
Angularspree updated to Angular5+ and ngrx store4+
Angularspree updated to Angular5+ and ngrx store4+ https://github.com/aviabird/angularspree
If anyone is interested in solving LP's, I'd suggest taking a look at the JuMP library in Julia. It has a lovely interface for specifying math programming problems.

http://www.juliaopt.org/JuMP.jl/0.17/index.html
I am all for locally based ISPs. It would be amazing if local municipalities could create incentives for financing the last mile of connectivity exclusively to local ISPs.

I absolutely abhor the idea of government supplied Internet. I’m too cynical to believe that there is some magical force field that differentiates local government ethics from federal level ethics. If Snowden tells us our internet habits are snooped at a National level, I expect it at a local level. The current proposals are binary in a stupid way.

Incentives local ISPs, not municipal ISPs.
Couldn't this come under violation of terms of service under Lyft's end and open them up to class action, so there's no need for new regulation at least for this current issue.

Not that I'm against new regs, I'm for it.
>I would also bet that if your game is only 2 hours long, you would have coffee-level pricing, and users probably wouldn't bother refunding if it's that cheap. Maybe I'm wrong about that though.

You are very wrong about that.
Everyone "in the know" already knows HI-EMA has incompetent management because such a bad user interface was allowed to be in use. This hunt for a scapegoat just sends a signal that the management also has no intention to improve themselves.
People who get USD do not expect it to gain value on the long term. They do not see that as a speculative investment. Some will use it as a reserve currency, most simply as a currency.

I guess you can argue some way or another that this is a scam, but certainly not of the Ponzi form, where the returns are funded through the new entrants.
That makes no sense at all. How can you make that conclusion without knowing what that screen shows? Maybe even blurred out arrangements of shapes could give something away. Further, why is everyone so God damned smart on the chat forums but so retarded in real life?
Also, I believe no one is doing linear programming without vectorized operations (SIMD) nowadays.

I know JVM optimizes small methods, so maybe their JIT optimizer does that automatically, but I'm not sure that optimizer is better that manually optimized code like in numpy.
...Because "HEMA can’t publicize the actual screen because of security concerns — the system could then then be vulnerable to hackers"

http://www.civilbeat.org/2018/01/hawaii-distributed-phony-im...

(Quite a load of BS, that statement.)
You're correct that it does make certain kinds of analysis more difficult.

However that doesn't mean we can't ever get access to the original data.
Most of our current BI needs to can be met using the un-encrypted data, but for example, if we did want to answer your phone number question, we could craft a special purpose program to perform the analysis without compromising user privacy.

1. Select all phone number tokens

2. Decrypt

3. Produce counts (total unique, etc)

Said program would have to go through normal code review and approvals, and then deployed into the secure zone (so it could access the encryption service).
>You don't want the name or address in the credit report to just point to your user's table, with an assumption that that was the name in the report

Well ok. In your example, call it a "credit report subjects" table.

>Thus, simply pointing to a user_id and hoping the data on the user's table was the data at some point in time in the past

References can be versioned or even hashed, i.e. Git. You would run the same risk with tokens, no?
> For years, Painter was responsible for America's cyber policy. He resigned last August. 'We'd never expected that the Russians would do this, attacking our vital infrastructure and undermining our democracy.'

Horse. Shit. They've been doing it to us, and we've been doing it to everyone else, for a LONG time.
Ask Greg Maxwell. He is "popping the champagne" for reaching his goal of having a always full mempool (Greg is CTO of Blockstream and GitHub repo owner for Bitcoin Core.
I don't know about any secret circles (would appreciate an invite if there is one), but you could try the HN freelancer thread, submitted by the account 'whoishiring (the February one will be up next week). I have had good results through there.
you’re arguing nonsense just for the sake of arguing. if someone hasn’t used react before then the title is meaningless.
Refusal to cooperate in a investigation shows the operator messed up. How come everyone wants to blame the system.

This comes down to accountability. This person wants to collect a check even though he did his job wrong.

I have no problem sending him/her to gitmo.
You terrorized an entire island with your fat fingers.
Now time to pay.
Agreed, too bad humanity's level of maturity as a whole is very far away from ideal. If everyone did what they should we would probably be living in an utopia. But that's not the case.

I don't mean that everything should be super-locked down to the point where it's inaccessible, just tweak it enough to not be misused.

The idea of an audit trail is good, since you can go back in history and make any misbehaving parties accountable. Or design a system where the client authorize a rep to look into her records ---just like banks do when you ask for your balance.
yes please clarify. Northern and southern skies are different, so yes not all humanity has seen the same stars. But ‘stars’ as visible phenomena in the night sky are a universal human experience. Ditto was someone said about venus mars jupiter and saturn.
Python 3.6's optional types are pretty great. Block out your solution first then start constraining it where you need to.
This is the biggest point I've been making to all my friends. What they believe Uber is so evilly doing, it will probably show that companies like Lyft and Didi and Grab, etc are all engaged in the same sorts of actions. Uber is the whipping boy for ridesharing, but I'm willing to bet that they are do basically the same thing.

My question for Steve Yegge is:

He seems to somehow believe that Grab has the moral high ground over Uber and Lyft. What is he going to do when he finds out that Grab behaves in exactly the same manner as Uber?
The question I ask when deciding between component state (via setState) or application state (via hoisting / redux / mobx) is simply whether the state is relevant to the application as a whole.

One example is the text I’m currently typing - that would only be relevant at a component level, maybe including an adjoining word counter. Once I hit reply, though, it becomes part of the application state.

An exception would be if I was continuously storing what was typed for offline use - in that case it’s always application state.
The goalpost is pretty well-defined: "The Doomsday Clock is a symbol which represents the likelihood of a man-made global catastrophe."

Climate change certainly falls under that aegis.
Have _you_?

I’ve stayed in both ‘international’ hotels that cater to foreigners and in business hotels which explicitly discourage foreigners by having literally everything in Japanese and they’ve all had fairly standard sized rooms for a hotel.
and I think that's what what johnny555 is questioning - isn't this common knowledge already? apparently not.

here's another tip, at least on mysql, but possibly other databases that have memory tables. Import stuff in to memory tables, then insert from the memory table to a disk-based table. I took a process that was naively importing data via SQL commands which took close to 24 hours down to around 20 minutes by breaking it up, chunking imports to memory tables, then copying those to permanent disk. This was years ago (12?) and mysql is probably better about insert handling than it was, but that approach (plus the drop/recreate indexes) meant this was a smallish process vs a 24 hour import cycle.
>> I think it’s bad science, that will one day retrospectively be viewed as invalid scientific method.

> that's a claim without any evidence to back it [u]p.

You are correct. The irony is rich here.

I always welcome a good argument (whether in dispute or affirmation of an issue), but just saying "I think <XYZ>" doesn't make it so. Reading through this thread, all I see is the common HN Default Skepticism / Negativity -- but more so; skepticism with less scientific rigor than the work being criticized.
There's a lot of ifs in your statement. I don't necessarily think that raising real-estate prices is a bad thing. It will encourage building of more real-estate. Laws that precent so artificially should be abolished. Using regulation to prevent a private owner from exploiting his property to the maximum degree ought to only be reserved for matters of commons (such as environmental polution/degredation etc).
Yes it's centralized by any reasonable definition of the term. You rely on a set of trusted third parties to establish consensus on the ledger's state.
I hope to God no one's paying you to design user interfaces.
Den of Thieves (2018)
Survivorship bias makes us forget about the other dozens of "taxi/carpooling apps" that did not succeed.

"The Upstarts" [0] talks about some of those.

[0] https://www.amazon.com/Upstarts-Airbnb-Companies-Silicon-Cha...
Daniel M. Burkus' Chanoyu to wa
Glad to see the last of the old 32bit legacy go, of course the good thing is if someone did want to run some ancient software that’s 32bit or even 16bit you can still spin up a VM of a legacy OS that can run those binaries.
No you couldn’t set off the “emergency alert system” with DTMF on 144MHz. (Or even mhz whatever they are. mHz are ‘millihertz’. I’m not sure what ‘mhz’ are.)
This is not true. Nokia sold over 450M phones per year in 2007-2010, but started to lose marketshare quickly, and from 2010 onwards the number of phones sold dropped fast. Then Nokia sold it’s phone business to Microsoft.

Now it is returning, but it’s not anymore core focus of the business and the numbers are small.
Is it cool if I ask a question not related to selling your company? If so, if you could go back to the justin tv days, what would you do differently?
I know plenty of C masters, and a few C++ masters. If you want to meet C++ masters, go to cppcon or get a job writing systems software at a respectable C++ shop.

I’d say I had a working knowledge of C++ after about a year ramping up on a codebase based on a mature C++ framework.

That was after years of writing reliable, performant C code. My C++ is now significantly better than the C I can produce, on both fronts, and at the same time.

I’m also much more productive as a side effect of that.
There is no mention of specific electoral interference in the (google translated) version that I read. There is a play by play hacking attack on the state department, with an attempt to install malware on state computers, but nothing is said about the election or how this attack might influence it.

Meanwhile, of course, AIPAC continues to spend millions of dollars per year to directly influence US elections, drawing no such scrutiny.
Word is truly dreadful, not just to use but the code it generates in each document is a mess, it’s no wonder there’s so many formatting problems in docx files.
I thought this is pretty common knowledge and I don't even do much with databases.
> one big landlord that owns all residential real estate.

AKA, the gov't.
LocalStack: Develop and test your cloud apps offline
I haven't tried it, but that goes against the grain of gRPC. I understand it as an integration point between legacy REST and gRPC. I don't know, and from what I've read, wouldn't use it for greenfield development.

The only issue I have with full HTTPS + JSON is CRIME. I'm not sure how that works.
Been beta testing this for quite some time, if anything it’s getting worse. The performance of outlook and word is abysmal, random crashes, high CPU usage under no activity and the list goes on.
OpenBSD has done a great job, especially if you look at what they achieved, how fast they got there, and what resources were at their disposal.
Heres-what-you-need-to-know-before-you-buy-a-dna-testing-kit
It’s possible they are considering cost of living (e.g. you can live “as well” nowhere near Silicon Valley on half the salary, depending). If that were true though, they should also be expecting to “up” their offer if you were remoting from downtown Manhattan or something.

Ultimately, you decide if the offer is what you wanted.
I love Python, but after working on a large Python project I saw first-hand that JVM scales way better to large codebases.

Currently Python took a niche between quick ad-hoc exploration tasks (land of R) and production pipelines (land of JVM/C#/C++), but for large pipelines it's not so suitable IMO.
A database would already provide a layer of security (most people, including many "professionals", would not know what to do with it).

Customer data is often stored in a large, denormalised table in an Excel file called "customers" which contains the entire set of customers past and present, including those who unsubscribed or have not ordered for years, with all attributes (phone, address, etc.).

There is also no oversight on who has access to this file, since "marketing needs it for Facebook" or "customer service needs it for returns" or whatever the excuse du jour is. Even the newly hired intern with a stronger than usual interest in every system's credentials gets a copy.

You get some measure of security when there are more than one million customers and they need to start partitioning.

The most secure setup I've seen was a company whose entire repairs department ran on paper slips. Since nobody had the time or inclination to enter the information somewhere digital, no internal staff knew how to find customer information, even if they walked to the shop floor. I think a couple of old timers knew how to navigate the pile of slips and were the de facto DBMS engine.
Pragmatic == close enough to all of the popular and contemporary assembler flow control constructs.
> So the actual support required will be minimal to zero, it's just a software app

Sigh... Where can one start with this? It’s like trying to argue with flat-earthers, where logic and infinite ost experience don’t matter.
Park Named After a Little Girl at Childrens Hospital