skysight-inc/HackerNews huggingface dataset:
I’m not too sure if it covers table changes but MySQL comes with a slow log tool which tells you what queries are causing performance issues and if need be help optimize query requests itself, indexing even though is painstaking is perhaps the best way to fix the issue in the long run but to track down the slow queries in the first place and mitigate against them individually I’d use slow log.

https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html
US social media has deleted graphic pictures of US torture as "terrorist propaganda" before [0], even quite historical pictures are classified as "child pornography" [2]. For now, over 2 years YouTube has been heavily cracking down on "extremist content" by deleting conflict footage, also deleting evidence for war crimes in the process [3].

It's hard to even quantify the problem because most people are not even aware of it existing.

[0] https://www.mediapost.com/publications/article/327887/pbs-th...

[1] https://www.bbc.com/news/technology-37318031

[2] https://www.middleeasteye.net/news/youtube-ai-deletes-war-cr...
I love DuckDuckGo and use it by default but the results do suck. They are improving, however.
The Venn diagram of "devs" and "users who would like to tinker with the firmware of their iphones" is pretty much a circle.

Most users don't have time to do that; if the software of their phone doesn't work they'll get another phone, not another software.
Here's a thread from Stack Overflow on that topic. Google created a Java-to-Obj. C converter years ago. That's useful for Android, but the resulting Objective C code can also be used to some extent with Swift in iOS apps too. https://stackoverflow.com/questions/27920948/java-code-to-sw...
For now, you can simply block these subdomains in the ad blocker of your choice. The fundamental risk to ad blockers that these pose is that there will be too many subdomains to block in a list of reasonable size. But really that's not fundamentally different than other techniques like serving ads and real content from the same server, which has been happening for years.

(In theory, a site might generate new subdomains and DNS responses for them on the fly, making this approach unworkable. In practice however, most sites have moved entirely to HTTPS, which means that unless you give your ad host a certificate for *.yourdomain.com, all the subdomains have to be known in advance and show up in certificate transparency logs, making them easy to block.)
The university is fake, I don’t know why you would arrest the students.
An interesting fact about Sweet Home 3D is it employs the Java 3D API which was originally developed at Sun Microsystems. Sun/Oracle abandoned it a while back but the API is still maintained by a small but dedicated group of volunteer developers [1].

[1] http://forum.jogamp.org/java3d-f3728156.html
The Chinese people are happy in some ways, unhappy in others, and it varies from person to person. But they are forbidden by the government from expressing their unhappiness, at least many types of unhappiness. And I take it you think that is a good thing.
Tesla has always had somethings for those who do not care about environmental issues: looks (Tesla cars don't look like vacuum cleaners of the past), performance (fastest 0-100 of any sedan), technology (remote control, some self driving, OTA updates). In fact, the only way to appeal to general public is through these things. Environmental issues are just too hard to grasp in every day life, especially since their supposed effect are long into the future.
M$ would like their tired old 1990s business practises back, oh wait they never left. Just like the M$ shorthand which we see less simply becuase we talk about them less.

It's reputation they fully earned. You can write "Microsoft" in full whenever you like if you prefer too. I think it's pretty reasonable to casually express contempt at every opportunity for any business that puts money vastly further ahead of ethics than they need to. You can disgaree with that if you like too.

Facebrick is the new M$. What do we have for Goog? "do no evil" with strickeout for more money? $GOOG?
'TikTok Concedes Error In Removing Viral Video'
I suspect that it should be cheaper to make as well... very few curves make for easy to make panels. Not a lot of investment needed to manufacture these things.
There is even more on that website:

What could happen if something went wrong

Facebook has a history of betraying users' privacy and trust. They've faced record fines for this and have been caught
hiding privacy breaches from their users. This is the starting point for bringing a device with an AI-powered smart camera
and always listening microphone that is sending data back to Facebook regularly. They also say they do human review of audio
snippets unless you chose (and take the time to figure out how) to opt out. The question comes down to, does Facebook have
your best interests at heart when it collects all the data this device is capabal of collecting on you. In the past--from
Cambridge Analytic and beyond--the answer to that question has way too often been, NO.
Also wondering about that, I thought device IDs were randomized precisely to prevent tracking?
They still have a near monopoly when it comes to production within the US, and that status continues to be propped up by the government. It still isnt clear that Boeing's negligence will hurt their shareholders as much as it should. It's looking unlikely that the criminals who forced through the dismantling of essential safety measures while concealing their actions from regulators and the public will face justice. Management has no incentive to do anything except stay the course.
It's not just you. I sincerely believe in DDG's mission, but the sad truth is I just can't find what I want with it. Unfortunately there seems to be no good way to use Startpage with Safari either.
Can you clarify and quantify that statement? I'm not sure what you mean by Hot and Cold foods and temperature? And how are each integrated into the overall diet? Is there any information you could point us too?
You can see a bit of the gcc monolith and the llvm approach battle it out within the policy of what gets added to Emacs - https://lwn.net/Articles/632773/
Mostly related to spoofing and caching user agents from those sampled from unencrypted pub wifi connections or popular list available online and randomizing them on every http request, some stuff related to (nuking) css url calls, randomization of read outs from canva2d, removing all the stuff on the new tab pages, randomization of list of available fonts/plugins/langs/etc available. Next thing I want to do is block arbitrary http requests by default and make the list of blocked url calls available to the dom (and a way to unblock them from the UI, or config file loaded in at runtime).

I'll never pass recaptcha, but idc, i installed this on my wife's computer as well and i'm starting to explore a way i can make a ios build using the recent tethered jailbreak for ios devices (besides the most recent releases). One day, It would be fun to try a prank on a day I actually go into the office and exploin a vuln in the old cisco router firmware to try to get installed on other devices on the network and see if how many people actually notice the changes and/or start using the browser because the dont get ads anymore lol
Wonder how viable it is for a web search engine to support itself on paid subscription. It could also be $X per N search result pages.
I don’t get the point of this article. Essilor Luxxotica is a monopoly and they pretty much control the eye glass frames market. This is rather old news.

https://www.vox.com/the-goods/2019/3/6/18253555/eyeglasses-c...

[..] Essilor is a French optical company that’s been around since the 1800s but has spent the past 20 years acquiring some 250 companies. In 2017, Essilor bought Luxottica for about $24 billion. Although it got approval by regulators in the US and the EU, and even passed an antitrust investigation by the Federal Trade Commission, business experts have called the merged EssilorLuxottica a monopoly.[..]

Also: how does one be ‘in charge’ of their own exams. Walking around and operating with impaired vision is a danger to public safety. Is this a joke article?
Author here. Personally, I just don't. I tried doing it but it was too complicated. So I end up just hiring a tax accountant specializing in crypto, send them all the data I have, and pay a few $k. In case something goes wrong, it's their fault and they take the risk.
Is there a good "best of FLOSS drama" feed I can subscribe to? :)
> The GPL does not on its own have the power to "infect" the rest of your codebase.

The reason some people specifically want to avoid enhancing GPLed software is because they want to be able to modify software without the condition of releasing the source for their modifications. The fact that the alternative to voluntarily releasing the source is being sued doesn't make the situation any less burdensome.

> With proprietary software, if it's found out that you've misused someone's code, they probably will not offer you that viral option - they'll go straight for the monetary damages.

And this rarely happens in practice because people with proprietary software guard the source and don't intentionally let others have it.

All three options (proprietary, GPLed, permissive open-source licenses) serve different purposes and will be chosen by different entities based on individual circumstances.

None is a one-size-fits-all, and I think we've seen over the last decade or more that the size that fits many corporations is the permissive open-source license model which allows them to contribute back what they'd like without being forced into the choice between contributing back everything or being sued.
> it's that they _have actually had_ to retain information on an overwhelming number of new shiny things for professional reasons.

No, they have not. Not any more than the rest of us. Not any more than any other profession.

I really think this whole thing is borne out of Code Camp graduates coming into the job market thinking all they needed was whatever minuscule collection of shell scripting incantations they learned in the Code Camp to get a "Zomg 6-figure++ salary". And if that is all the training you've had, I can easily see how it will feel like it is inadequate (because it is). But the answer is not "keep feeding the inadequate way of learning".

And it's certainly not replying to someone's thread in which they present their hard work with "uuuuugh, woe is meeee".
For new users and really for anyone - I'd recommend Manjaro over Ubuntu.

I've been giving Linux desktops a shot for over a decade and I finally switched a year ago because installing software on Manjaro is so easy compared to any other distro I've used. It's also been rock solid on 2 of my desktop systems and 1 laptop, with all the features that I want working, including power management and advanced touchpad gestures.

Recently as an experiment I tried Xubuntu again when someone here pointed out how you can't get .NET Core 3.0 working on Manjaro yet - however, after (painfully) setting up Xubuntu with my standard kit of software including docker, vscode, beyond compare, programming languages, and UI tweakers like xdotool, wmctrl among very many others - after 1 or 2 weeks - it wouldn't boot (due to a bad update?) Not the first time I've had this happen with Ubuntu. Then I replaced Xubuntu with Manjaro, did the same setup in half the time in order to figure out which .NET Core 3.0 packages to install without messing with my other machines. I figured i out -the correct packages end in -bin, e.g. https://aur.archlinux.org/packages/dotnet-sdk-bin . Everything has been fine for a few weeks now, just like my other 3 machines...

Maybe I setup Xubuntu incorrectly. I didn't use the Snap software distributions available through Xubuntu's default GUI installer. I used the command line at first and i installed Synaptics, added separate repositories for various publishers... I might have used a mix of CLI and GUI to install stuff. If I had only used what the default installer offered, things might have been stable for longer... But I used both CLI and GUI to install stuff on my other Manjaro stations and didn't have any of these problems, so that's why I recommend it.

Also, XFCE does a clean and simple Windows style GUI better than Windows 10, where I normally have to install "7+ taskbar tweaker" to get the taskbar features that I like, such as middle clicking to close a window in the taskbar or allowing me to drag and drop taskbar items to arrange them instead of forcing them into groups.
The most damning thing your link says is that it's not a best practice.
There's a plugin for Chart.js that does something similar was well: https://github.com/nagix/chartjs-plugin-rough
Humans and the Sixth Mass Extinction
Odo: OpenShift CLI for Developers
Does anybody have any infos about Qwant?

It's the only EU-based search engine with its own indexing engine ( https://en.wikipedia.org/wiki/Qwant )

I don't care if it's EU or not, but is the index real or kind of half-fake? (like "yes, we have an index, but it's 10MBs big...")

I started using Qwant ~2 months ago and it isn't bad: the snippets that are shown in the search results often don't contain the search terms that I used but the links were so far good - but I did mostly lookups for e.g. functions and other reference data - the few times that I challenged it with exact searches its results were similar to the ones of Google, meaning that it didn't return the websites that contained such exact sequences of characters.
> "Could a human beat a computer at chess?"

If you start from a winning position, even something as stupid as a random-mover will eventually play a perfect sequence of moves and win, given enough attempts.

However humans are not very good at being random, so this may not apply :)
Any other example of consumers products that haven't improved dramatically for a couple decade and exist contrary to the technological progress?

What comes to my mind - a great adoption of electronic dictionaries in Japan （電子辞書）. Many are Japanese who study English, find it more convenient.
Social games yes. For example, charades requires conversion of meaning to human movements. It's not to say it can't be done at the moment, but it's not something you would easily come across or that would provide the same experience as if you were playing with other people who are physically present. If you talk about actual physical robot doing the moves in front of you, then I'd say it's either cutting edge or not possible right now.

And it's certainly not accessible either way. With chess, and other games, you can simply download an app on your phone which you'll never be able to win against.
He’s a smart, successful person who has spent some time thinking about it. It’s as useful as anyone else’s opinion. People who are ‘experts’ in these areas also tend to have biases. Nobody that works for any of those companies is going to give you a straight answer.
Is there a free / open alternative for exterior / architectural work? I know there is AutoCAD, and Chief Architect, but they are all quite expensive.
Of course that was not done at the behest of the US Government. Criticism of the US, US politicians and Government officials is rampant on Western social media. The US Government doesn't try to censor this.

Meanwhile, Chinese tech companies are beholden to the whims of China's CCP leaders. China's internet is completely controlled by the CCP.

There is zero moral equivalence between the US Government and China.
Could you please stop posting links to your company? You've been overdoing it, which is why your comments are getting downvoted and flagged.
If one needs GCC, they can install GCC. I don't get the insistence that "the tool I like should come in the default install." Not to mention, Apple would routinely let their installation languish at older versions of various utilities, necessitating upgrading via package manager.

Being 'inconvenienced' by the removal of GCC from the default install is exactly that: an inconvenience.
> It isn't like there has been time for anything to change

Wrong, other buyers or sellers could have put in orders in that time changing the price.
I too use DDG first and I'm just willing to suffer a bit 'till I use Google. Using DDG first at least keeps Google honest and they are only a click away on Firefox.

The thing that's saddest is not only are DDG results not as smart but they also seem dumbed-down in the fashion of Google - ie, too much "your search" --> "what we imagine you really want" --> "here's our curated list of things like this (and screw your actual keywords)"
I suppose I was lucky dabbling in one of my side-projects because I had money to burn. I put it all in Google Cloud and then learned just how much you have to complicate the stack (beyond the complication of K8S) to lower infra costs.

Suddenly I wasn't using basic Kubernetes any more, I was setting up a new ingress controller so Google wouldn't launch a new load balancer instance for every public service I exposed. Those things aren't cheap.

It was an amazing way to experience just how much you can suffer in the cloud, and just how far you can go down the rabbit hole with this kind of tech.
No, please don’t straw man my point. I’ll assume you know what ai is and that you understand there is a huge difference between that and human intelligence. I am arguing that ai will never be able to DM a D&D game. For that, a computer will need human intelligence.
The GPL is considered viral because linking GPL code into my application imposes legal requirements and restrictions on all the other code in my application. Most licenses don't do this. If I bought a proprietary software license that said "you must not use this code in a program that implements DRM", I would call that viral as well.
Even if it’s a mundane problem, if your product solves a valuable need for an underserved market you shouldn’t have problems making a market rate hire. There are plenty of people who would be happy to work on a good opportunity while enjoying the freedoms of a small company. Substance is more attractive than marketable hype any day.
Is it normal in the US to refer to optometrists as "doctors"?
Would you please review and stick to the site guidelines when posting here?

https://news.ycombinator.com/newsguidelines.html
Einstein Cross
This is not the whole HK stock market crashing.
Because they’re illegal aliens?

As an external observer I have to say that I am deeply confused about how the basics of enforcing immigration law became controversial in the US.

In the rest of the world, the answer to “should we catch and deport people who are in the country illegally?” is a blank stare and a “umm, yes? Why are you even asking this?”

What’s really odd is that the US was the same way up until very recently.
In the same way as the Go master (perhaps) feels disillusioned by being beaten by the AI, I think people in general will not accept humans being replaced with machines in some "special fields". In those fields, the customer/user, will not experience the same utility if a robot is doing the service compared to another human, even if they are indistinguishable.

I think an interesting issue here is that in the (far) future, many services could be performed cheaper by AI/robots and in such a way that the customer is unable to tell wether a human is involved or not. And in this future, humans will probably be a premium service.

Take motor sports for example. We can probably now/soon replace F1 drivers with algorithms and cameras, but nobody would pay 1000's of USD to watch them drive around in Monaco. If it would turn out someday that the drivers had been replaced (for safety reasons or whatever) without telling the fans, the outcry would be tremendous. And even if outcry does not always equal "true utility", I think it highlights my point: humans made of flesh and blood risking their lives or performing extraordinary feats have an intrinsic economic value that can't be replaced.
I don't think I've ever seen the rpi apt repository offline, so I'm not sure why you're so worried. Embedded computers tend towards lean rather than heavy and that is the mindset you're going to encounter.
ACAB. Fuck the law
In the US, even chiropractors (who are pseudoscientific quacks) are called “doctor”.
This comment seems rather disingenuous to me, and puts words in the mouth of the grandparent post. It’s not that my data should not be sent to any third parties ever, it’s that (as the GP said) my should not be sent to any third parties without a specific business reason that benefits me.

I do not consider any form of ad targeting to be of benefit to me. Therefore, my data should not be sent to any third parties for that purpose.
Eye doctors, yes.
Apple sells out to the Despots and Crooks . . . .
Wait so the government set up a fake school and gave its students a student visa and when they showed up for school they were arrested and deported? What was the point? The people thought they were going to school and obtained student visas and the government got what out of it?
This is what I do, and it works well.
To answer/comment in reverse:
“How are you going to get someone to hire you?”

For this question, I fall back in a fundamental belief system I have: value for value. Everyone looks for value when they make a major purchase. You expect to get more “value” then it “costs” you when you buy something. Same is true with employment.

The easiest way to guarantee employment (in my experience) is to ensure the value you provide greatly exceeds your total cost. I am talking ideally a 5-10X multiplier (minimally).

For your cost, keep in mind this is your total cost, and I am not just talking about your “fully burdened rate”, I am also talking about the “Emotional/drama/personality” you bring. If you are a model worker, and the person everyone likes, then you have positive karma, if you are someone that makes things harder, that is an additional “cost”.

For the value, be very honest with yourself. What do you bring from a technical/personality point of view. Are you really a 10X programmer, or if switching fields, how good will you really be on day one, 10, 100.

As long as you can give a positive ratio, with a high multiple, I suspect finding a job won’t be hard.

Okay, to your main point:
Finding time/motivation when none is there.

I personally have been through burnout. It sucks. The only surefire way I have found to get through it is time and finding meaning in the day to day.

But to the finding the time: the simple answer is if this is really important to you, then you make the time, every day. You don’t have to spend a ton of time, but even just 30mins a day can get you somewhere if you are diligent. It just comes down to how disciplined you can be with yourself. It sounds easy, but I know from experience that it is usually the “easy” things that are the hardest to really do.

Hopefully this helps...
Chiropractors may be psuedoscience quacks, but they sure as hell can make your back feel better if it's out of place.
The article says they were in the US on student visas. That’s not illegal immigration.

> The students had arrived legally in the U.S. on student visas, but since the University of Farmington was later revealed to be a creation of federal agents, they lost their immigration status
Would you please not take HN threads further into ideological flamewar? It leads to nasty and stupid discussions that we neither need nor want.

https://news.ycombinator.com/newsguidelines.html
I don't personally have a fomo, but I'd certainly argue that it is very much rational and not necessarily a phobia. My impression is that it's just a cynical reaction to a lack of interest derived from lack of diversity in the problem domain. Your reaction would be irrational, perhaps derived from insecurity or feeling that your personal belief has been attacked repeatedly. Would you say that you personally love re-inventing the wheel, and would you prefer to have your viability in the job market depend on variable your knowledge is on the narrow scope of re-inventing the same wheel?