skysight-inc/HackerNews huggingface dataset:
Unless you can directly see how a query can be optimized, first thing you do is get the execution plan (e.g: EXPLAIN query).

The execution plan will tell you how expensive is each bit of your query and help you adjust it.

From there, if things are not getting better, you have a lot of alternatives:

- Consider creating an index

- If the value doesn't change often, consider writing it into another table or caching it.

- Replication, partitioning, sharding, changing the schema.

- Reconsider the requirement being implemented in order to have a more scoped query or to perform the query less often.

Then... OLAP is not OLTP. If you can, do reporting in another database.

Finally, creating your own project in the end may not save you $50,000. How about maintenance? tooling built around it? integration costs? documentation? usability? new hires having to learn about it? You can hire people that already know SQL without having to incur that cost yourself. All the tooling is built, battle-tested and readily available. Plus, skills related to internal tools are harder to trade in the market because they're harder to verify and less transferable.
That's what Unity did before IL2CPP as well (not surprising of course since it was Mono). I think they didn't want to have to keep writing new native code generators for the AOT process for different architectures, which is why they went the IL2CPP route. That way they can generate the C++ code without worrying about what platform it's going to be running on and also take advantage of the C++ compiler's optimiser.
For advertising purposes it really only depends as a whole how truthful a picture the likes tell. If the likes are on average 70% truthful it is still going to be more effective targeting than not using them at all.
4 Best Types of Software Testing
Taibbi says, "The terrifying part of this controversy, to me, is the possibility that Facebook will ultimately engage in a kind of policing/censorship activity that all of these Senators may actually favor – perhaps driving down or eliminating certain kinds of alternative or dissenting speech in return for regulatory relief." What the heck? This is what Facebook already does! And about the absolute dumbest stuff too. I can't believe the banality and rubber-duckie-level controversiality of so much of the stuff I personally witnessed being censored before my eyes this past year. I mean, not that it was a shocker, but I had so terribly misjudged how low the limbo bar level of dumb went when it came to election censorship alone, not to mention censorship of the work of several Pulitzer prize winning journalists.
Yeah, you are so right. We sucked at that.
> one ring to rule them all

> may the force be with you

> call me ishmael

These are all in my password cracking dictionary.
If I believe that shares of stocks generally come with votes, which allow you to control the company if you have enough of them...and I believe that oil or gold futures do indeed entitle you to take physical delivery, does that mean I should not invest in cryptocurrencies, because I inhabit a different reality than those who do?
How to FIX “DETECT and MOUNT CD ROM” Kali Linux 2018.1
But what does it mean to "throw [the key] away"?

Are you operating at scale? I hope you have a very robust backup system (including enough that you can even recover from something like the Sony hack), and so you're going to need to ensure that you delete it from those systems. And then, you're dealing with 100s (1000s? 10000s?) of these deletions a day. Do you want that to be instant? Are you really that confident in your deletion that you want it instantly overwriting your backups? How are you resistant to the Sony hack in that case? ...
>Hate speech is speech that attacks a person or group on the basis of attributes such as race, religion, ethnic origin, sexual orientation, disability, or gender.

So if I say frat bros are idiots am I guilty? There are grey areas.
Your WoW observation reminds me a lot of my current job search experience.
> You generally can't horizontally scale two libraries in the same process independently of each other, but you also don't usually have to worry about library availability at runtime.

Are there cases where you need to scale one library possible without the network (IO and latency) becoming the bottleneck? The way most microservices get used as RPC mechanisms you hit the network bottleneck very quickly.
Did he have a choice to opt out of that hearing?
What is the collaborative editing technique used by OnlyOffice?
OnlyOffice provides collaborative editing on Words, Presentations, and Spreadsheets.

I am curious how they implement the collaborative editing functionality, operational transformation (OT) or commutative replicated data types (CRDT).
Hacking Hedonic Adaption
`cherry-pick` is just plucking a single commit and adding it the commit history of the current branch, and `rebase` is what civilized people use when they don't want merge commits plaguing their entire code base.
Them, or the manager that hired them? If no one up the chain brings on a DBA what are they supposed to do? I hear ya. But this is as much a symptom of naive (and budget stretched) leadership as it is of the hands on deck.
"rebase" is not just "pull before push", though.

It's pull then rewrite all your personal commits to be based on the latest tip from that pull.
10 years of code
If you do business in CA you're required to file as a foreign corporate entity, and still pay the $800 in taxes. You can't open a bank account in a CA bank without proving that you've made that filing.
If your “SRE” team is only “unblocking deploying a solution” then I’m sad to say they are an operations team who has rebranded themselves to appear more relevant.
Yeah, I saw this. It's crazy, went trending on twitter too. wew.
Use the Cassini spacecraft to strum Saturn’s Rings like harp strings
I hope so as well. It's one of the reasons I advocate if not a CS degree, at least some kind of technical degree for developers. The courses that made the lasting impact on me from my college experience weren't the CS courses -- those were, regrettably, very forgettable and borderline outdated. But the ethics and the critical thinking courses from the philosophy department, (plus the more advanced mathematics required for technical degrees) all had much more lasting impacts on me.
How do you build up the incremental changes? By staging them into your working directory from the one giant commit?
Here's a fourth that was actually responsible for me starting to just use generated passwords for those as well. They told me my answer wasn't valid.

According to them, it's impossible for your mothers maiden name to have less than six characters :/
You haven't bought at $20000, so your optimism is irrelevant. If you continued to buy at any market rate under $20000, then the market rate would rise towards $20000 until you either went bankrupt or bought out every seller less optimistic than you, at which point you would no longer be the most optimistic buyer.
Any interface means you'll build an mental model of the system you're manipulating. How else could you possibly know what you want to do and what commands to issue?

So given a mental model is inevitable, seems reasonable that that model should be the actual model.
If you live in CA you're required to file as a foreign corporate entity, and still pay the $800 in taxes. You can't open a bank account in a CA bank without proving that you've made that filing regardless of where the corp was registered.
And the YouTube Title. “You won’t believe what happens next”
... and then you have to clone all the AWS services yourself. If you just need a few boxes, there are definitely cheaper options than AWS.
I know a professional hacker brianhackwizard@gmail. com who has worked for me once this month. He offers legit services such as clearing of bad records online without being traced back to you, He clone phones, hack Facebook account, instagram, WhatsApp, emails, Twitter, bank accounts, Skype, FIXES CREDIT REPORTs, track calls. He also help retrieve accounts that have been taking by hackers. His charges are affordable, reliable and 100% safe. For his job well done this is my own way to show appreciation, Contact him via address below...
Email...brianhackwizard@gmail.com
Text no..+1(571) 286-5929
WhatsApp..+1(628) 203-5734.
HOWTO: Be More Productive by Aaron Swartz (2005)
Mark Zuckerberg: EU Users Have Different Sensibilities on Data Protection
A hackathon is something that used to be a cool party for geeks (i.e., a Mathletics competition or an ACM programming contest) until the corporate overlords bastardized it and converted a good thing into unpaid overtime with free beer.
You always have to defeat the argument or people will see it succeed and be convinced of the opposite because they've never seen any good rebuttals. There are something like 9 lurkers for every poster and sometimes you're posting for them too.

You'll never stop trolling or spam whatever you do, anyhow.

For global warming, you can give a simple elevator pitch version about how we have data on a global rise in temperatures and while yes, it was really warm long ago, it's still bad for the people here now.

For Obama, well, what does it even matter at this point? I don't think anyone disputes his mother being a citizen so it's pretty much whatever at this point.

Regarding Facebook, well, there is a valid point that breaking the Facebook ToS probably isn't the thing we should be the most upset about, and we really do have to deal with the thousands of other companies who compiled massive databases of info whether or not they happened to break the Facebook ToS.

Then point out that, yes, privacy advocates have long been against Facebook hoovering everyone's data, including when Obama was president and people are freaked out now because 'privacy violation' didn't mean much to them before but after CA, it's starting to click.
"We also did not detect any effective use of these accounts to engage in vote manipulation."

Ok, so does that imply they engaged in ineffective attempts at vote manipulation, and what sort of actions would those be?
>It's less likely that they overengineered - we are probably just underinformed.

Based on 15 years in software companies in the valley it's much less likely that this isn't over-engineered. Nearly every decision I've seen chasing technology hype has been based on ignorance of existing solutions.
attributing spinoff projects is not necessarily a compliment.
When I try to eat as little as I can at lunch to prevent getting sleepy(700kcal), I usually really hungry at 5 and productivity drops, any one knows how to deal with this?
If they don't know how to look at a query plan and craft a solution can you really call them full stack?
Oh gosh this pattern. The first time I encountered it was in my first job where we used Magento. Super flexible. Also super slow. Does anyone have any advice how to make a db design like this work faster? Generally I thought when data is arranged like this it might be a prime candidate for document based storage. But I'm no dba so I have no idea if that would be correct.
I have another solution: just switch to mercurial. I switched some big projects to mercurial from svn many years ago. Migration was painless, tooling was similar but better, the interface is simpler than git, and haven't regretted it once.
What's the best way to do this in Texas for cheap?
This might sound a little out of touch, but am I the only one who doesn't think git is that hard? It is a collection of named pointers and a directed acyclic graph. The internals aren't really important once you have that concept down.
that sounds a lot like a feedback loop.
Facebook Can’t Be Fixed, It Needs to Be Broken Up
Exactly, it was no longer mysterious for me after I had to prepare a written branching procedure for our team starting from how to branch off, commit, rebase to doing resets and working with reflog. While doing that I've thoroughly read the official docs, examined lots of examples, created a local repo with a couple of text files to test various commands. An then it became so clear and simple! Especially the reflog – so powerful!

So, my advice is to try to write some instructions for yourself for all the common cases you might run into during your work. It will not only help you realise what you actually need from git, but also will serve as a good cheat-sheet.
Thank you for this detailed comment. Having looked at the GitHub ToS which includes a statement about third parties and Google Analytics I was wondering how important that was to people. Makes sense it would be very important. I appreciate also your perspective that having third parties might even be considered a positive thing for business prospects. Seems like a balance needs to be struck. Anyway my application will launch with only GA as a third party.
My experience with linear algebra is that it's possible to get an excellent grade in class, without learning anything, provided the tests are multiple choice...
I'm working on a piece to go into my portfolio. It's a guidebook for companies navigating crisis communication during and after security incidents occur, such as breaches. I'm only an undergrad so I don't have much experience, so a lot of it is compilation and synthesizing professional advice (properly attributed of course), but with my own recommendations and criticisms of specific cases.

note: if anyone has particular advice to give me with this project, what you might want to see featured, i'm all ears.
The column type would have to be the type of the encrypted value. The type of the unencrypted data could not be enforced by the DB and you would have to rely on code doing the correct thing.

I am however extremely wary of doing it that way. I don't know your requirements of course.
Rows by any other name would smell as sweet...
AV1 can also encode RGB color space. Such usage would probably be more prevalent in the still image use case.
Optical illusion: the Troxler effect
That's a lot of cheddar OP. As many people have already said, many of us think you're in an enviable position. I'm curious what makes this highly stressful for you though. I think "low happiness" is pretty common overall, as in I make a fraction of what you make, and it's a job pays the bills and it's all OK so I've come to terms with the job and doesn't really provide happiness, but one year into it it's not stressful to me in any way

Any reason why you can't start on your side gig during off hours, like many others do?
A lightweight and easy-to-use animation library with excellent performance
> QED offers no explanation for gravity

It does; gravitation in perturbative QED on time-dependent curved backgrounds has exactly the same explanation as General Relativity. [1] This generalizes very well. [2]

One can look at it the other direction too: General Relativity guarantees flat spacetime in the neighbourhood of every point on the manifold with signature 1,3 or 3,1. As long as the radius of curvature is large compared to the system under study there is no trouble at all (QED systems are usually pretty tiny, so you're good down to and through astrophysical black hole apparent horizons). This is implicit in laboratory tests of QED.

> But any physicist who’s being intellectually honest knows that we only have a rudimentary understanding of these concepts

Everyone should be honest about how much she or he really knows, and how much he or she can judge how much someone else really knows.

"The first principle is that you must not fool yourself — and you are the easiest person to fool" -- Feynman

- --

[1] [BirrellDavies] N.D. Birrell and P.C.W. Davies, Quantum fields in curved space, Cambridge University Press, Cambridge U.K. (1982).

[2] [BGZV] A.O. Barvinsky, Yu.V. Gusev, V.V. Zhytnikov, and G.A. Vilkovisky, SPIRES-HEP:Print-93-0274(Manitoba), (1993). https://arxiv.org/abs/0911.1168
- Roger Wicker asks whether Facebook can track browsing activity even when a user is logged out of Facebook. Zuckerberg responds that he's not aware and he'll have his staff follow up, then later admits that cookies exist. They obviously do track this, as stated in their documentation: https://www.facebook.com/help/186325668085084

- John Cornyn asks whether all of a user's data is deleted when their account is deleted. Zuckerberg says, "We should delete all your information." Cornyn: "Should, or do??". Zuckerberg: "We do".

- Later on, Cory Gardner reads parts of Facebook's terms of service stating that backup copies of data may persist for some time after an account has been deleted. Zuckerberg pulls the old, "I'm not sure how it works, I'll have my team follow up". He really seems to want to avoid saying outright that 100% of your data is deleted, because it isn't, "log records" (open to broad definition) are only somewhat anonymized: https://www.facebook.com/help/125338004213029

- Gardner also asks whether Zuckerberg thinks users are aware that they are tracked every time they are logged in in another tab and visit a website with a Like button on it. Zuckerberg says, he thinks people are aware, they should be able to infer that from the context we show them about their friends liking the page.

- During questioning by Sheldon Whitehouse, Zuckerberg says users can download all data Facebook has about them. This is false. The "download your data" button only gives you data from your direct interaction with Facebook, and definitely does not include the sites they've tracked you on around the Internet.

Not sure whether any of these dodges bordering on lies could be prosecuted for lying to Congress, but sure would be interesting to see that tried.
Yes. As soon as you use an untrusted computer, there is no telling what you are vulnerable to. But:

(1) people frequently (and rightly) do that anyway, so we might as well make it less bad.

(2) Building a trustworthy computer is largely about isolating different components in a way that hurts malware more than it does the user-experience. Sticking keys on a USB key is one instance of such isolation.
Millennial super fund Spaceship (backed by Mike Cannon-Brookes) fined by ASIC
Or they bleed you so much you don't have the resources to attempt a rewrite.
Probably just a bad oversight. But this serves as another reminder, especially for the millennial target market who are new to the industry, to DYOR.

The CEO, Paul Bennetts, sent an email to investors today and here's a snippet:

"ASIC raised some concerns around a portion of content on our website. After hearing their concerns, we quickly saw that we should have been clearer about our investment decision process and we amended our website. We are proud that we acted immediately to address their concerns.

There has been some press yesterday and today in relation to this and we are a little disappointed that the coverage seems to be throwing rocks at the new kid on the block rather than holding a discussion about portfolio transparency and investment decision making across the entire superannuation industry."
:-). I was trying to be careful in not using absolutes. Guess I missed this. ;-)
Incompetence was trying to convince developers to use that Flash ripoff Silverlight for mobile app development or trying to debug that horrible XAML pile of garbage or trying to build UI's with that bug infested piece of garbage expression studio. With Windows phone development you could never get comfortable because they were always osbourning the OS once they realized what a piece of garbage it was.
What are you afraid of more? A failed venture or taking your regret to the grave? There's no right answer.
Google Play Bans Binary Options Trading
How long does that take? In BK it's as fast as you can click. If git is like that what tools are you using to do that?
It is noteworthy, though, that a woman's employment status does not affect her likelihood of being divorced at all.
Yubico Launches Passwordless Login with New Security Key and FIDO2
icicle.io – write asynchronous code using synchronous coding techniques in PHP
The way I explain this to beginner programmers is that there are three types of equals in math and programming:
The math "=" means "these are equal"
The programming "=" means "make these equal"
The programming "==" means "are these equal?"
The problem is not that Git supports staging partial changes. The problem is that Git has shoehorned a tool that "at some point you're going to want"—to help you deal with a rare occurrence—into the default workflow, forcing you to deal with the overhead of staging every time.
Mark Zuckerberg's notes for his Senate hearing, revealed
> This gives them the freedom to add more properties to the user without always having to add a column to the users table. When querying the database you'll have to do unions or joins.

I think you're right. Oh ... my ... god ...

I wish I could say this is the worst example of a database schema I've ever seen, but it isn't.

Technology cycle:

X gets invented -> idiots abuse it -> X "is bad" -> Y (strictly worse than X) is "so much better" -> idiots abuse it -> Y "is bad" -> ...
Reading through it, that situation doesn't appear to be specifically addressed, but I _suspect_ that it would depend on the specifics of the case:

* If you are suing an LLP, you are taking an action against an individual member of the partnership, thus they can appear as the defendant. Though 12.40.080 can be read as excluding attorneys regardless of their status as the defendant, I believe that has to be read in conjunction with the notice that the court issues under 12.40.060. The defendant is "direct[ed] and requir[ed ...]to appear personally in the small claims department", thus granting the permission described in 12.40.080(1). Even if that is not the case, it would seem inequitable to prevent the defendant appearing, thus I would expect the judge to grant permission to appear.

* If you are suing a larger company that ISN'T operating as an LLP, it would seem likely that they would have staff beyond the attorneys/legal paraprofessionals, thus they can represent the company.

* If you are suing a corporation that is truly made up of 100% legal professionals, that seems to be the case where things get somewhat murky, though that really does appear to be a corner case. The restriction in 12.40.080 is quite clear: "A corporation may not be represented by an attorney-at-law or legal paraprofessional", and I suspect it gets into the minutia of interpretation that I am not equipped to determine. However, I do note that 12.40.060 requires the defendant to appear, not _necessarily_ participate in the hearing. Thus, perhaps the hearing can proceed WITHOUT representation from the defendant, allowing the judge various options to achieve a equitable result (transfer the case to the district court where the restriction is lifted, issue a judgement if the facts are clear or it seems the company setup is deliberate in order to try and avoid the small claims court, summon employees as witnesses -- so even though they are not representing the company the facts of the claim can be established, make an order permitting a legal professional to represent the company--depends on the extent of judicial powers/making an equitable case to overrule the restriction etc.).

Note that this is just based on reading through the linked laws, and is likely wrong/inaccurate in some ways. However, it does appear that a law firm would have options beyond a default judgement.

12.40.080: http://app.leg.wa.gov/RCW/default.aspx?cite=12.40.080

12.40.060: http://app.leg.wa.gov/RCW/default.aspx?cite=12.40.060
Turns out it's not profitable to encourage understanding, rather it's better to be a hosted service provider, keep knowledge in a walled garden and charge for it.
Father of VR: Facebook and Google are dangerous 'behavior-modification empires
This looks like a good chair lift: http://gitless.com/