jkeisling/hacker-news-corpus-2007-2022 huggingface dataset:
Yes, absolutely. You can check requests from pg_stat_statements, slow query log, and any other source as you wish. If the SQL repository stores query in separate files, you can check these queries (e.g., before they are merged into the master).

It is crucial that you add the actual database schema (DDL) before checking.

This functionality will appear soon (client cabinet, API).

Please note that analysis is performed using static methods only! No connection to the database is required.
In particular, statistics and other environmental parameters that may affect the query performance are not taken into the analysis. I would like to be able to enrich the data obtained by static methods with data from the database production, but at the moment, this is a very far-reaching plan.

The tool will make recommendations that are necessary, but not enough.

The actual database parameters affect the real query plan. There are a lot of such settings, and the impact changes over time.

Keeping an eye on these parameters and adjust them - there is a significant layer of work that is not a priority at this stage. Excellent tools have already been made for this purpose, such as postgres.ai.

DBA work is divided into two parts - to monitor the quality of queries and database schema and configure the parameters of production servers.

My tool covers the needs of the first part and does not cover the second part.

I talked to product owners of companies producing products or services related to the second part, and they agreed to integrate our products when I come ready.
Before you say "I could do this in a day these guys suck" I suggest you reread this article: http://www.codinghorror.com/blog/2009/07/code-its-trivial.ht...

The devil is always in the details, and you probably could get the first 90% done in a couple days and then you'd have to do the other 90%, make sure the design is perfect, and test it thoroughly. It's a lot of work, and I'm sure the team (which is probably smaller than you think) is working crazy hard on keeping the app up to date with all the changes at Facebook. I'm pretty sure they're going to be working hard to add the "seamless messaging" feature they announced to the app, not just writing a simple xmpp client.
For some work that requires light attention, having a startup podcast going in the background can be very inspiring.
Down-vote? Interesting.
What is trefis?

I can't figure out where they came up with the $391B market cap number, much less why they came up with that estimate?

It's certainly not based on the current stock value.
If test tube people that the deserving ones and natural born people are the savages, what does that make the poorly educated self righteous kid and the retarded mother?

At least it had nothing to do with the fact that natural born people need to have sex to do so, but I'm sure it'll happen eventually.
Tech companies buying media companies seems like a bad idea to me. It reminds me of Sony -- remember when they tried making MP3 players that didn't play real MP3s? That was because they owned Sony Music and were in the awkward position of trying to sell MP3 players and records at the same time. Because they didn't pick a side, they ended up losing both battles.

If Google bought a content company, they would be on both sides of the battle as well -- and if they really wanted to liberate the content, then they would have to explain to shareholders why they bought a company only to hurt its revenue.
More Firesheep fallout. GitHub goes to all-SSL access. Now you can't generate new Rails applications from templates hosted on GitHub.
Very interesting.

Wonder what all of these senators have in common? It doesn't look like party, section of the country, or left-right leanings.

Usually when you get a wide dispersed group like this, the next thing to do is look for businesses and organizations (either inside the senator's state or not) that use money and votes to heavily lobby. Wonder who would lobby for this?

Just thinking aloud. I don't mean this to be a slam of the senators -- they're incompetent enough without my slamming them -- just trying to figure out if there is a commonality.
>falsely identifying accounts as fake only 0.0058 percent of the time (or about 6 out of 10,000)

That may sound impressive, but if there is 554,750,000 twitter users [1], 554750000 * (6/10000) is still 332,850 people who would have a false positive.

[1]: http://www.statisticbrain.com/twitter-statistics/
Iron seeding of the oceans to increase producer activity is currently being done but on large enough scales to sequester enough CO2 to make a difference it's basically impossible.
I think there is room for three types of folks along this dimension. Yes, some people enjoy the validation, but there are plenty of obsessive folks who simply don't care for the validation. They take delight in the subject matter independent of peers.
But the title of the thread insinuates that Kape is known for distributing malware, not the company it had acquired. I personally believe that there's a big difference between saying: "PIA bought by company that also acquired a company known for distributing malware" and straight out claiming that PIA's acquirer distributes or has distributed malware at some point in time.
Or normalize your data and use clickhouse.
Does it ask your HN (or any other) credentials? How would it be a phishing attack then?
If you can make pure graphene in uniform, big sheets - I will buy any amount. There's plenty of applications.

The problem is we can only make small pieces. It's like trying to sell shredded paper when people want something to write on.
> It's not merely that the returns from following a path are hard to predict. They change dramatically over time. 1830 was a really good time to be obsessively interested in natural history. If Darwin had been born in 1709 instead of 1809, we might never have heard of him.

This risk might be somewhat mitigated by the changing level of societal interest in different areas over time serving as a guide to interesting fields of study. If Darwin had been born earlier, surrounded by an entirely different set of books, writings, and people, he might also have been a lot less likely to be interested in natural history.
Reeks of cowardice is close. Reeks of maximizing shareholder value is more accurate, and this is The West's Achilles heel. Well, one of many.

It certainly won't happen overnight, but I see a checkmate forming, with no realistic way out.
The big names involved are all heavily involved in ARM so I expect that's what they'll use.
In the short-term, it seems very likely that if ethanol plants do not sell that ton of CO2, it will end up back in the atmosphere. In the long-run, we have the opportunity to clean those emissions up with either new technologies that can produce ethanol without huge emissions (of which many people are working on) and/or regulations requiring carbon capture at ethanol plants.

But, we have to break the reliance on that method of production for the CO2 industry to help push all of that along. If companies are still getting their CO2 as a waste product, it may make regulation or incentives for new tech harder in the future. Just like EV's are getting power from the grid which is, in some places, still heavily reliant on fossil fuels, switching to EV's is breaking the need for fossil fuels in the transportation itself. We need to do the same for the CO2 industry.
That's why it says "In another 20 years" and not "today". Because you can bet that it'll be on everybody's minds in 20 years.
It’s not that hard to understand. People usually die several weeks after exposure. Only 27% of the population has received both doses; a few weeks ago that number was much smaller. In addition, the ultra orthodox community has continued to flout rules on a nearly universal basis. I’m going to go check your comment history — pretty sure you’ll have been wrong about everything related to COVID so far.

Edit: shocked (not shocked) you were an early COVID vaccine skeptic, justified your belief with poor interpretation of statistics, and now that a huge amount of data have validated initial findings, you have instead decided to double down on your original gut feel!
When I started with Salesforce 6 years ago,I looked at Flow, I thought 'screw this' and went on learning Apex instead. Even. after all these years I barely touched it.
People often critique btc by saying that it is slowly re-creating the existing banking system. That's largely true, but what makes it interesting is what this re-creation is built on top of. Or perhaps: what it's _not_ built on top of. Nic Carter does a nice job of discussing this [1].

[1] https://www.coindesk.com/what-bloomberg-gets-wrong-about-bit...
Correct -- so when thinking through your idea, be mindful of your dependencies.
Graal uses a complete different implementation model.
Is it difficult to break into all the homes in your neighborhood and shred the phone books?
How is actually committing a crime and going to prison somehow worse than being wrongfully accused and affected for life?
The stock market is not about buying ownership in long-term stable, profitable companies, unless you zoom wwaaaaaaaaaaay out on the charts.

Day to day it's about riding hype up and jumping off before anyone else.

CISCO was a great example of this back in the day. https://www.fool.com/investing/2020/12/27/2020-incredible-st...
Assuming now tongues, toes, or ears.
Right, but if you’re willing to rent, might as well just rent a truck on demand. At this point you’ve shifted the goal posts to, “why do people buy things and underutilize them instead of renting on demand”?

Why have a guest room when there are hotels you can send visitors to?

Why have a 4 door car that incurs most of its mileage in a commute with 1 or 2 people?
Here you can find all the different models of Pravetz http://www.pravetz.info it's in bulgarian but it's the most complete source of information
I DID read the link. As with everything bitcoin related, the actual meat of the problem is hand-waved away with marketing BS.

>Strike then takes the bitcoins and automatically converts them back into Euros using its real-time automated risk management and trading infrastructure.

Really, they convert Bitcoin into Euros with a "real-time automated risk management and trading infrastructure"? That explains literally nothing. Who owns the Euro currency that is willing to sell it for bitcoin? Where is the liquidity coming from?
While the particular issue of network namespaces and locking the os thread was fixed, there is still c code that must run before the go runtime starts to work around the issue that you cannot do some of the necessary nsenter calls once you have started additional threads. The c code to make runc work is encapsulated in libcontainer/nsenter[0]

[0]: https://github.com/opencontainers/runc/tree/master/libcontai...
I tried Wallabag [0] but it didn't feel as polished as Instapaper, or Pocket. Especially the mobile application.

[0]: https://github.com/wallabag/wallabag
> Down 6% after hours, for reasons that I don't understand

"Buy on the rumors, sell on the news". Sell on the news part I think
https://archive.vn/1jZJ6
There’s been some form of notebook support in VSCode for a while, but nothing that I liked enough to start using vscode over a notebook server. But I’d love to be able to double click a .ipynb file and start editing and exploring.

Can you link the the recent support you talk about so I can compare it to what I’ve already tried in vscode?
Yes, this is the exact thinking! But, I would like to make the most educated guess what subject matter would work before writing two chapters of a book. Programming graphics on Canvas is a niche and I would love to know if it's a 10K programmers crowd or 100K in size?
That design looks like straight from the Tron movies, which perhaps is just the aesthetic and associated nostalgia Tesla is aiming for here.
A lot of it is possible for sure. I used to do a lot these things in a Subaru WRX (minus the towing of course). Even drove home from Lowe's with an assembled grill on my roof rack once.

Always hated filling a sedan with trash, yard garbage, or landscaping materials though.
You can pre-order it in Belgium, Germany, etc. Not all countries, but a significant list.
As far as I know, the service telcos provide is the ability to make calls, receive calls, send text messages, receive them, etc.

Telcos don't get paid to securely provide SIMs. They make hardly any claims regarding the security of your calls, text messages, etc.

So it is rather odd to hold telcos reponsible for the failure of some security mechanism they where never part of.
Obvious answer: because they started at 1 and have had less than 100,000 orders.

I know of a company that had enough trouble with vendors after their PO numbers rolled over that they modified their EDI transmissions to add 1,000,000,000 to every order number.
My evidence is mainly from an infosec perspective: you aren't going to get your front desk to report suspicious activity if they have no incentive, or if they feel like they are fobbed off every time they try to report a potential issue. Every report of a problem, no matter how big or small, should at least be taken seriously enough to record the report and investigate its credibility - otherwise you'll set up a culture of issues going unreported because they get poo-pooed when they are reported. I'll see if I can find the talk where this concept was first put in such plain words to me, but I believe it was a Defcon talk called "Steal Everything, Kill Everyone, Cause Total Financial Ruin".
> You probably wouldn’t be passing it on to several million people, so that comparison isn’t even close.

If freedom of speech and the press is curtailed precisely because the speaker or publisher has a large audience so the curtailment most efficiently gives government control of messaging, that doesn’t make it better.
You can actually use it for any type of file, but the main / most popular use case is video.
“ Of course no one believes that there is literally no fraud. Why do we need to be so perfectly specific that the amount of fraud that does happen is less than .0001%?”

To be fair to the person your replying to I think that percentage you wrote is the crux of the whole thing. Quite large segments of the american population believe fraud >>0.0001% whereas other quite large segments share your view that it is ~0.0001%. And perhaps there is a segment that truly believes it is <<0.0001%.

Though I am unsure what the null hypothesis should be in this case it does seem that the probability of the reality being >>0.0001% is above zero.
> [The spokeswoman] said there will be no change in how WhatsApp shares provides data with Facebook for non-business chats and account data.

That sounds a lot less alarming, in the third to last paragraph, than the headline or first few paragraphs?

Don't get me wrong, I ditched Facebook years ago, and wouldn't use WhatsApp but for family and a pre-Corona club I wouldn't have (much at all) contact with otherwise. That quote just makes me much less annoyed than my initial reaction was. Which is of course her job, but assuming it's true...
I don’t agree with your assessment. The difference between the 5% and 45% isn’t about belief, but opportunity. Look at this poll: https://today.yougov.com/topics/politics/articles-reports/20...

> Supporters of President Trump have stormed the US Capitol to protest lawmakers certifying Joe Biden’s election victory. Based on what you have read or heard about this, do you support or oppose these actions?

45% of Republicans said yes! Now I am not asserting that half of republicans are about to engage in sedition. But is it because they have different beliefs? No, instead I think it’s just that the 5% you describe has nothing to lose.
It's not fair to portray this as if a corporation removed someones means of communications.

The POTUS will be able to appear on any mass media, the only difference is that the media that he will appear likely will be moderated. When he says something, there would be a few people commenting on it and analysing it. This someone could be someone from CNN/FOX/Breitbart etc, so anyone can choose their own moderator that they trust.

This is essentially removing the unchecked propaganda channel of a politician that is causing real life problems.
> What do you do about folks who don’t have the luxury to choose to isolate?

What's being done about them now? How is this better? They're losing everything they own, their house, and getting $600 from the government? Many would take a chance of corona over that.

> What about all the nurses who die in the line of duty treating all these new infections? Should they be allowed to opt-out of infection risk?

Nurses (along with all healthcare personnel) should always receive priviledged treatment. One nurse dying is not a person dying, it is many people dying.

> but so long as there is community spread the lockdown can never end, and the virus would never go away.

Vaccines will hopefully change that.

.. all good points though, and I thought of them too as I was writing out my thoughts. I'm not fully satisfied with these answers, but I do not believe the direction we're headed in right now is much better.
So I guess the Biharis are what, chopped liver? You should remember that Mujib ended his famous speech with Joy Bangla, joy Pakistan but the last part gets left out.
That might have more to do with the state of the Japanese economy this year than the location of Sony headquarters.
Yes, that's the one. Probably ignored because it doesn't have any harmful implications.
>even a 55-year-old swimmer, cyclist and marathoner can die of this

...but on average, they won't. It's way more than a pious "this exceptional case confirms an non-existing rule" thing. Let's get past the fear mongering.
Yeah, I definitely agree with this. The corporate media is a hive mind of sorts, and look at the unhinged hysteria presented on CNN. I'm definitely not a fan of FOX, but during the Presidential debate, their panel contained two Biden supporters, two Trump supporters, and two never-Trumpers. That diversity of opinion was lacking on all of the other major networks.

I think we're seeing a sort of religious phenomenon here in regards to the corporate media. They're pushing narratives everyone know are untrue, but no-one can come out and say it publicly due to the religiosity of the mob.
The advantage of legs is for use in environments set up for humans with working legs. Things like a normal flight of stairs, walking over a moderate sized gap in the floor, etc.

Those sorts of things can be a real pain for wheeled robots (things like stair climbing wheel assemblies, and just larger wheels can overcome some of these, but have their own downsides), while spot has no issues handling them.

If you can design the environment to fit the needs of the robots, then sure wheeled or even on-rails will likely be a better choice (less expensive, greater load, etc) But for retrofitting robots into existing environments without totally reconfiguring them legs can be rather useful.

The question is are there enough such circumstances that Boston Dynamics can actually make reasonable amounts of money? I'm not sure. It is possible there are some fields with a lot of killer applications for such robots, but few spring to mind.
Not symbolic, and also nowhere near the same degree of severity.

At worst, the Kavanaugh protestors committed trespass and pleaded to swing voters; whereas yesterday's mob broke property, assaulted police, looted, and had the intent to overturn the democratic process. While flying confederate and Trump flags and tearing down American flags.
I live in the UK. I understand that people arrange items via WhatsApp but it seems baffling to me. Why not just use email to notify people??

When you sign up to any service, they ask for an email address. They don't ask for a mobile number necessarily, and there is never a "my mobile number is on WhatsApp" checkbox. Why is the assumption of the organiser that you're on WhatsApp your concern? They have assumed you're on a certain platform, and it's their mistake.

It reminds me of the tidal wave of people suddenly abandoning their own websites and instead using "Find Us On Facebook". They might as well put "Use this keyword on AOL".

Facebook is not the internet, and WhatsApp is not the only communication method.
Not just Europe + UK, LATAM is all WhatsApp.

Net neutrality not existing helps WhatsApp and other services here, one cell provider for example offers 1 year unlimited WhatsApp+Facebook including voice and video calls for a total (not monthly!) cost of 3USD on a prepaid chip. So you can't call, you can't write SMS, you can't use the internet but you can use WhatsApp for almost no cost. If you are on a budget this is a no brainer, for comparison - 5GB full internet access on the same chip is around 5$.

How are you going to break such a monopoly supported by providers? At this point it is something all providers do so if one starts offering it all other providers have a competitive advantage because everybody is already using WhatsApp. I am not sure if Facebook pays these providers, my guess is not - they are pushed into this by their competitors.

Net neutrality is very important to not let this happen. Similar deals exist for other popular services: Instagram, Youtube, TikTok, Spotify, Snapchat, Twitter, Netflix to name a few
Do you hear yourself? I assume you are a rational person.

Why wouldn't you expect the count of votes entered into a system to be off before everything is entered into the system? Of course it's off.

Hell, why not just launch this claim on Nov 10 and say that the count is off by millions of votes? It's a braindead argument.
For (2) I'd try to work in:

- multi-agent systems
- knowledge representation/reasoning
- machine learning
- CSPs

"Learning" probably captures the bulk of it.
As long as nobody comes along and closes your development platform of choice, there's really very little to be afraid of when it comes to cross-compilation and emulation.

No man is an island, and certainly no corporation the size of Apple is one, either. Vertical integration shouldn't be considered a religious matter.
Every problem can be solved by breaking it up into a series of smaller problems.

A good ballpark, but not entirely true. At some point you'll end up with a smaller problem that cannot be broken up further. For the most part these may be solved problems, like `increment foo`, but at some point you might hit an unsolved atomic level problem that you either need to spend a lot of time working on, or forces you to find an alternative path.
http://images.memegenerator.net/willy-wonka/ImageMacro/18009...
I think the "uncopyrighted" statement could be misleading.

Does Leo really intend to mean that the free version of the book is being released into the public domain or is he simply highlighting the fact that it's not locked down with DRM. No DRM does not equal no copyright and works shouldn't have to be in the public domain to be shared by people.
> Most programmers strive to write cross platform code.

On what planet? Surely not this one, as most programs are very tightly coupled to particular operating systems.
Your aggressive posturing in this snarky response caught my attention. Seeing your bio, I was intrigued to discover that you work for a multinational agricultural biotechnology corporation? I had no idea that makers of "Roundup" were involved in info security. Looking forward to learning more from you.
The only thing I know of like this is Space-A travel. (http://en.wikipedia.org/wiki/Space-A) Obviously, if you've never served in the military, this probably isn't that viable, though I do think this is the concept you're after.

You might also inquire with Intrepid Travel (http://www.intrepidtravel.com/) to see if they could help put together something a bit more random for you. I've used them before and been quite pleased.
This is disgusting. The fact they get away with it. But, I sort of see them as an unethical startup...