skysight-inc/HackerNews huggingface dataset:
Ask HN: Isn't MySQL full-text search better than Elasticsearch?
I have built several apps, but I always use MYSQL search queries to build the search features. I have never felt the need to use Elasticsearch. Can someone enlighten me about the use cases where Elasticsearch becomes irreplaceable? Or is it just nice to have?
So this is all my opinion, not medical advice.

I am a type 2 diabetic. Weight is a factor, but it is not a direct cause always. The issue with type 2 is insulin resistance. That is caused by eating too much foods with high carbohydrate and sugar content. Carbs break down to sugar, sugar is processed by insulin. If you overload your body you start to produce a lot of insulin, after a while it starts becoming less effective - you begin to get insulin resistance, your body produces more insulin to combat the high blood sugar (which is absolutely scarily deadly in pretty low sugar levels) and your hit the point where your blood sugar can no longer be managed correctly via your insulin production and you start getting serious health degradation (eyes, kidney, liver, vascular, and nerve damage.)

Obesity is one of the side effects of high sugar - you can't process all the glucose your body is synthesising, so your body converts what it can to glycogen and the rest is stored as fat. So - being fat can contribute to type 2 diabetes, but type 2 diabetes also has weight gain as part of the process of becoming type 2 diabetic. It is a vicious circle.

Carbs and sugar are the real issue in my opinion and experience. We were sold a lie - that our bodies run on carbs, and carbs are the best fuel. This is not true. Carbs are actually the worse of the options. A better diet is based on less carbs, more natural fats. Our bodies burn fat for fuel more efficiently and insulin levels do not spike after each meal.

The best thing you can do as a Type 2 is cut down carbs and sugar. If you can cut them down to a minimum, you will lose weight quite steadily and as you do your body will effectively have some breathing space to try to get back to a reasonable level ground. I personally use keto and intermittent fasting (this is not an endorsement or recommendation - it works for me) and I've dropped 10 kilos in the last 2 months. Not only do I feel better (less headaches, more energy, more ability to function in the morning, less hunger) I also feel like I don't need the constant carbs and sugar being shovelled in to my body on a daily basis anymore. They are not even all that pleasurable anymore - usually anything "sweet" tastes like pure sugar to me now - and that is the best think I could do for myself - because I don't seem to be craving foods with sugar, I am not caught in the trap of worsening my condition.
Once you discover hand massaged wagyu crayons you will never go back to regular crayons. The craftsmanship is also exquisite, the barrel is crafted in such a way as to make sticking the crayon in your nose a magical experience.
Nice initiative! Hope the list grows.

It would be nice if you had a fast filter for remote-only postings.

Also, your mailing list software drops the part after a `+`, this breaks filtering rules. I'd also like your base to store my address in a form I provided.
Yes, this is my personal website, and a post regarding that happening without seemingly any reason. Hence the title, "Safe Browsing Troubles".

I should've added more context in the description, probably.
Ok, but some treated sewage doesn't seem like it's even close to the volume of water you get in a river. Of course, the Phoenix area is a really big city with 5M people.
There's a tension here:

If you don't insulate yourself from world news, it will drive you crazy. Most of it is not actionable anyway. Then again, people have made the mistake of believing "nothing has happened so far, so nothing will happen" time and time again.

As Sebastian Haffner describes the outbreak of World War I in his book "Defying Hitler":

"The last world war, with which my conscious life begins as if with a bang, hit me as it hit most Europeans: During the summer vacations."
One twitter comment points out that this was the last free-response question on the exam, and that a preceding question was harder than usual. So examinees probably wasted too much time on the earlier question and lacked time to finish the last question. It doesn’t mean the last question was particularly hard.

(The twitter comment: https://twitter.com/m_litv/status/1670144278708748292)

Also, the problem should state whether the candy grid is stored row-major or column-major: is it `box[row][column]` or `box[column][row]`? As far as I can tell, that detail isn’t specified.
One terrible thing about ObjC is that it considers it valid to call methods on null pointers. It just does nothing and returns 0/false/nil. This leads to especially frustrating bugs.
I don’t understand Slashdot.

I see links to people talking about the solution but I can’t see the question despite the title saying “this question”.

I would have expected a post like this to copy and paste the problem.
Just dropped a google pin on the site and the area is greener than I expected. Would a lake the size of that pit fill naturally and actually persist? And would it ever be of any use for drinking water?
In answering this, I'd look beyond just the language features and look at the background of how it caught on. What apps were built first. When did the "Rewrite it in rust" mantra take hold. What impact did <system tool> but with colors / nice cli / sensible defaults have on things (e.g. fd / exa / lsd / bat / ...)? What libraries being available made it easy (clap / argh)?

Then look at how the community was built (e.g. Mozilla / conferences / forums etc.)

I've only recently started writing rust (after years of C#, Java, JavaScript, Ruby, Python, and a variety of other languages), and once I got past the basics of understanding borrow checker issues I love it as a language. Personally (for reasons unknown) I prefer brackets over indentation based languages, so Nim is a pretty hard sell there.
Reminds me of this old skit article about Docker, "It's the future":

https://web.archive.org/web/20160817120102/https://circleci....

Discussion here: https://news.ycombinator.com/item?id=12303075

The single greatest thing about minimalism is the ease of replacement and maintainability in comparison with maximalism, to my humble experience.

"Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away." ― Antoine de Saint-Exupéry
This is not an endorsement, but Spring Boot has this built in (but not enabled by default):

https://docs.spring.io/spring-boot/docs/current/reference/ht...

I have been leaning towards a different approach. Rather than reading multiple config sources at runtime, read them at build time, and emit a single config file with everything fully resolved. Put that on the filesystem, and have the app read it. You have an easy canonical reference for the configuration, with no need to expose anything. The lifecycle of the config doesn't have to match that off the app binary, so it could (and probably should) have a separate build and release process.
What battery gets that many? Your comment is the only DDG hit for ["36,500 charge cycles"], and is the only relevant Google hit for ["36,500" "goodenough"].
>In a world where there are infinite possibilities and infinite attempts, all possibilities are an eventuality, including floating brains in space.

There's an absolutely hilarious episode of "Space: 1999" about this.

https://moonbasealpha.fandom.com/wiki/Space_Brain
Wikitravel: Mars
Got to mention the Pharcyde surely? https://www.youtube.com/watch?v=lnCeZY6nxjQ
There have been projects in Western Africa that have shown that cognitive behavioral therapy can markedly increase social integration and reduce violence of even former child soldiers, probably the most traumatized demographic you can think of. Even pedophiles can - with sufficient support and therapy - manage their urges, as can alcoholics, etc. The hard truth is that the U.S. prison system is making no effort whatsoever at reintegration/therapy and instead is designed to enhance traumatization.

I actually think that sterilization is an incredibly important tool in terms of family planning and should be offered for free to all interested and consenting adults. But prison is probably the worst place to offer it, because (especially in the U.S) it is a place of coercion that precludes meaningful consent for a non-reversible non-life-saving medical intervention. Like other attempts to use sterilization to solve social problems throughout history, it would just contribute to trauma under these circumstances, not alleviate it.
I want things to work this way, but often they do not. Often what happens on the Linux side is that the security patch, if any, gets silently put into the tree without disclosing that it's a security patch, and downstream never pulls it in. There have been numerous instances of kernel maintainers asking people to water down their commit messages so they don't sound as bad as they are :/

This doesn't mean Apple does everything right, of course, but the situation on the other side frequently sucks too even though it nominally should not. And given various choices in their ecosystem (lack of fragmentation, for example) they can and do end up with a better security story in some areas.
These days quite a lot of our problems are synchronisation problems (are you pulling mutable data regularly from a remote API and storing it? thats actually a syncronisation) but despite that synchronisation and how complicated it can be doesnt seem to get discussed. You don't hear debates about different approaches, we dont seem to have a taxonomy of different techniques.

People seem to forget how hard it is. So lets say you're pushing changes from one system to another. How are you detecting changes? timestamps or a direct diff? Or checksums? Have you remembered to think about deletions? Can you even detect deletions? How do you keep track of which bits have successfully synced and which havent? If something unusual goes wrong (network goes down) halfway through a sync can you recover from that? Incremental sync inevitably drifts over time due to bugs and downtime, so are you also building a full-scale wipe-and-refresh or compare-and-reconcile to accompany the incremental sync? And dont even get me started on two-way syncs and conflict resolution and how hard that is to do without some sort of review-by-human component.
There’s a link to “AP Computer Science A test”, which is a PDF, and the problem in question (question 4) starts on page 14 of the PDF.

Here’s the link again: https://apcentral.collegeboard.org/media/pdf/ap23-frq-comp-s...
I live in a small EU country, and at our largest universitey, there are ~50 more women enrolled than men (60-40 ratio). Does it bother anyone? Of course not... they are more worried why in a few colleges (engineering mostly) ther are still more men than women and try to encourage more women to go there.

Education (and a lot of other parts of society) has(ve) left men behind, and it starts in the childhood and never stops.
actually Bruce Byfield explains it in Linux Magazine:

Pass is available in the repositories of most major distributions. As usual, you can also compile from scratch, but, if you do, take note of the dependencies, especially GnuPG (GPG) [6], which creates encryption keys, and Password Generator (pwgen) [7], which generates random passwords that contain random combinations of upper- and lowercase letters, numbers, and special characters. Without GnuPG and pwgen, you will be unable to set up Pass, much less actually use it.

https://www.linux-magazine.com/Issues/2014/158/Command-Line-...
A side splittingly humourous take on the matter from a writer closer to the era:

https://biblioklept.org/2013/02/10/moral-effects-of-tea-tast...
I spent way more then 5 minutes with Rastafari. This does not enable me to guess what your unsubstantiated claim is hinting at. What I found rather weird is that many are still riding the slavery-victim-train, which was sort of weird for a european to witness first hand. I can imagine how this combined with the slave-trader-hunter-hero thing might feel a bit anti-peaceful, but I also understand the reasons for that attitude, histoically speaking.
This is a great comment as it reflects the situation quite well.
Same story with the influencial Bad Brains who people forgot that the band was a serial homophobe.
Zero 7 Triple Coincidence
Hmm, if generating new code is an easy task for GPT, why don't you ask it to create a new project from scratch every moment a user comes up with a new feature?

Who needs to maintain an old codebase if you can rewrite it adding new features at whim?
House rules. If you're a Lyons house and a Barrys drinker comes in, they have to put up with it. depending on how well you know them they will either quietly accept or start an argument to convince you how wrong you are
Why switch? Is it that weird to know and use more than a language?

In case of adoption, both answers are yes, because Rust and Nim don't occupy the same niche. The reason why Nim has not caught like wildfire is that its niche is often shared with Python or Go, which have a much larger mind share.

Which is why asking this question from the memory safety point of view misses the mark.
Neither? "Me" consists of both body and brain, so unless you could find an identical body somehow, neither resulting person would be "me".
The problem with advice is that it comes from someone in a different position. The depressed person might not be able to actually perform the suggestion due to lack of energy or other factors.
Mm it's not even pick-up really. Pickup is about a bunch of catchy and cheesy lines and hacks as you say and it's not what I was referring to.

I was mostly referring to the general idea tat woman are attracted to dominant, physically strong, confident men (that's for the 'good' traits') but also downright confrontational, insulting, mean and even humiliating with other people.

Since in my opinion women want to avoid being with what they perceive is a "weak" man, they will give a pass to all the bad traits because they see it as 'being a strong dominant man', and if you are nice or just not mean, they will be scared you are being weak
The problems in the Congo originated with colonialism [1], esp. King Leopold, and continued throughout the Cold War via the USofA's DoE proxy sourcing of very high grade uranium for nuclear weapons [2].

It's a region that has been actively destabilised by Europeans, Americans, and Russians since the scamble for Africa [3].

[1] https://en.wikipedia.org/wiki/Colonization_of_the_Congo_Basi...

[2] https://en.wikipedia.org/wiki/Congo_Crisis

The Congo's rich natural resources, including uranium—much of the uranium used by the U.S. nuclear programme during World War II was Congolese, led to substantial interest in the region from both the Soviet Union and the United States as the Cold War developed.

[3] https://en.wikipedia.org/wiki/Scramble_for_Africa
There's a rather long article here, from Sun, now owned by Oracle - probably easier to start from the conclusion and work back!

https://docs.oracle.com/cd/E77782_01/html/E77791/z4002282485...
If you really want to take the whole path for the sake of it, a quite agreed-upon path would look something like this (it's been referred to it a lot on Reddit, I think it's called the harsh guide to ML or something):
-Take the Elements of Statistical Learning by Hastie and Tibshirani; Really great textbook that has all the in-depth mathematics for all the classical ML you need plus exercises
- you can get Andrew Ng's Coursera course, it's still really good and relevant, and it takes you through all the ML you need plus exercises in both Python and R.
- Go through the Deep Learning book, it goes through the details of DL, why and why not it is related to ML.
- After that you're more or less in open waters, you have all the background, and you're left to figure out whatever you want for yourself. To get more into newer research in computer vision, just search ArXiv for all the still relevant papers and try to o through them and understand them. Trying to implement them yourself from an official Git repo helps tremendously, so definitely do that. Also if you're more into classical ML, go on keggle and try some of the contests out and see if you can manage to do anything. At the beginning, you won't, but read through the best solutions and see what they've done.

Good luck with the whole process! I believe it is quite challenging to learn it all from the bare metal maths but definitely worth it and quite rewarding.
> For my example in circuitry, signal based synchronization uses a clock, or a ready signal.

But clock is not a ready signal. The clock is just a periodical signal that keeps firing. If you squint your eyes, it is almost like an event loop performing a time.sleep(ns) before deciding to check the state. In the case of chips, the circuitry performs the next state transition after the very short delay decided by the periodical clock signal. The assumption that every pin would acquire a stable binary state before the next clock tick is a fundamental part of a chip design. Without that we'll have non-deterministic and ill-defined chip behavior.
MySQL's full-text ranking capabilities are quite limited and AFAIK full-text wasn't a priority for them lately. The related article is "Rankings with InnoDB Full-Text Search" [1]

If it works for you - great. If you need more flexibility in terms of data tokenization, matching and ranking you can consider Manticore Search [1] instead of Elasticsearch since it's a continuation (a fork made in 2017) of the Sphinx search engine mentioned in the article on mysql.com and has a better integration with MySQL than Elasticsearch (e.g. you can use Linux mysql client or any programming language mysql connector to make queries to Manticore).

[1] https://dev.mysql.com/blog-archive/rankings-with-innodb-full...

[2] https://github.com/manticoresoftware/manticoresearch
Maybe not getting enough rest might have offset the positive factors?
> Do you really not see any difference between Ansible and a shell script?

Surely they do, but how much those differences matter depends on where those tools sit in relation to what you're trying to achieve.

For example, I could write essays about the differences between bash and PowerShell, and about differences in productivity their various facets create, in both abstract and concrete terms. However, when my task is not about shell scripting per se, and the script plays only a minor role in the solution ("oh, but we can make the button launch a script that launches X"), and my main concern about that stage is to convince the team to use Bash and/or PWSH instead of making Python a dependency in the project - then bash and PWSH are really the same thing to me - any difference in productivity for that use case is dominated by one's familiarity with the tool, and none of it matters anyway if my co-worker succeeds slotting in Python for that use case.

Similarly, there are many differences between bare shell scripts and Ansible, and there are differences between Ansible and Puppet and Chef too. But they're also close to each other, so if your use case doesn't hinge on those differences, you can be excused for wondering why can't we just keep using a Makefile for this.
Children and attributes are different. Attributes are like fields to a record. Parent/child is a relation between records.

There are clear criteria for choosing attribute vs text representation. Text is for humans; all the rest is for the computer. If we see something like this:

<ssn>123</ssn>

this means the text is precious and we cannot alter it, only attach some records (‘ssn’) to some character ranges. And in most cases these records need more fields, so we add attrbiutes:

... <date date="2001-01-01">the first day of that year</date> ...

This is the usual case in markup: we need the computer to do something with the text and use the records as a guide.

But a notational case is different. With notational case we still need the computer to do something, but not about a particular piece of text. (This is actually the general case while text-handling is a specific one.) In this case we can command it directly:

<foo>
<bar id="a" />
<baz ref="a" />
</foo>

There is no text in these records, but we still use notational tools: 1) node type, 2) composition, 3) ordering, 4) naming/referencing. In this case we put everything into attributes.

We can have a notational piece with markup parts or a markup part with notational parts, but each has a clear purpose. There is also a third specific case: we want to switch to another notation and in this case we write it as text inside an XML element.

SVG is a good example. All data go into attributes, text inside elements appears only when 1) it is a part of the drawing, or 2) we are switching to another notation:

<!-- notational -->
<svg ...>
<!-- switching to CSS, still notational -->
<style>
...
</style>
<!-- markup -->
<text>... <tspan class="...">...</tspan> ...</text>
<!-- notational again -->
<rect ... />
</svg>
Meanwhile... https://www.eurometaux.eu/media/20ad5yza/2022-policymaker-su...
We use Realm for this. Very similar to Core Data, just removing some of the obvious footguns, but it works across both iOS and Android, and the real-time syncing is excellent.
I will add that the inclusion of ego is kind of unusual for Latin, which makes me personally inclined to translate it as "I will personally etc etc".
Nim does guarantee memory safety if you don't use unsafe features like raw pointers.
So the absolute killer features that I would say SQLite offers are: 1. Embedded (single, small library, very fast) 2. Portable concurrency using native OS/FS abstractions. Full SQL support is nice, but I'd also be happy if it only offered plain key values. I love that you don't need to manage DB processes, network connections, FS partitions, shard memory, mutexes — just point your process or thread to a file and it magically fixes atomicity, consistency, transactions, the whole enchilada.

SQL databases are not great at storing huge chunks to data (petabytes of video) but those are easily handled by the native filesystem. Just make sure the write access is safely wrapped in a DB transaction, RAII style. This works and scales well enough except for the failure mode: over stressed egress (typically SELECT queries) will starve ingest (a more or less constant load of UPDATE & INSERT queries).

At that point, you want to scale horizontally. As mentioned, replicating the SQL backend file over NFS or rsync is simply a horrible idea. Surprisingly we ultimately discovered that SQL-level replication did not solve the problem reliably either: scale improved, but the starvation failure mode (read locks blocking DB writes) persisted (be it less frequently).

The replication layer we needed was at the application level where it's much easier to express that actually we did not need the real-time coupling between media ingest and egress. Eventual consistency is good enough: if the system is about to collapse, simply fail by adding latency so you can always keep ingest healthy.

Worst case, people watching a popular sports event will see players buffering. Which is bad — don't get me wrong — but far better than a catastrophically blocked pipeline and congested video encoders.
This is extremely neat and I will probably try it on one of my actual Windows 3.1 machines :)

A suggestion (which seems easy enough to implement, I might give it a try if I can get the build environment set up): make the system prompt customizable in the Options dialog. Having it be 1992 is fun, but kinda limiting. I might actually use this at some point -- if you're on your retro computer, trying to solve a problem, it might actually make some semblance of sense to use this rather than dig out a modern computer or smartphone.