skysight-inc/HackerNews huggingface dataset:
Why “bigint generated always as identity” instead of bigserial, instead of Postgres' uuid data type?

Postgres' UUID datatype:
https://www.postgresql.org/docs/current/datatype-uuid.html#D...

django.db.models.fields.UUIDField: https://docs.djangoproject.com/en/5.0/ref/models/fields/#uui... :

> class UUIDField: A field for storing universally unique identifiers. Uses Python’s UUID class. When used on PostgreSQL and MariaDB 10.7+, this stores in a uuid datatype, otherwise in a char(32)

> [...] Lookups on PostgreSQL and MariaDB 10.7+: Using iexact, contains, icontains, startswith, istartswith, endswith, or iendswith lookups on PostgreSQL don’t work for values without hyphens, because PostgreSQL and MariaDB 10.7+ store them in a hyphenated uuid datatype type.

From the sqlalachemy.types.Uuid docs: https://docs.sqlalchemy.org/en/20/core/type_basics.html#sqla... :

> Represent a database agnostic UUID datatype.

> For backends that have no “native” UUID datatype, the value will make use of CHAR(32) and store the UUID as a 32-character alphanumeric hex string.

> For backends which are known to support UUID directly or a similar uuid-storing datatype such as SQL Server’s UNIQUEIDENTIFIER, a “native” mode enabled by default allows these types will be used on those backends.

> In its default mode of use, the Uuid datatype expects Python uuid objects, from the Python uuid module

From the docs for the uuid Python module: https://docs.python.org/3/library/uuid.html :

> class uuid.SafeUUID: Added in version 3.7.

> safe: The UUID was generated by the platform in a multiprocessing-safe way

And there's not yet a uuid.uuid7() in the uuid Python module.

UUIDv7 leaks timing information ( https://news.ycombinator.com/item?id=40886496 ); which is ironic because uuids are usually used to avoid the "guess an autoincrement integer key" issue
this title makes me want to shout

"Call J. G. Wentworth, 877 Cash Now!"
If you are building tools, long term availability is more important than free.

If I had a transcript workload, I would want a stable process. A tool that might not be around tomorrow because of economics would not provide that stability.

That’s what I mean by what’s-next? It’s cool that you built it and all. But how do you provide the service 18 months or five years from now?
The key to your statement: “the ghosts of…”
Obviously that's not a problem in general: the salt comes from the ocean, and the salt as well as the fresh water extracted go back to the ocean just by different paths.

But the salt (in the form of brine, as I understand it) is generally localized, and thus can be an environmental issue that needs to be addressed.
Paying for a tech product and telling people about it.
Where is here? We can't see your geo coordinates :p
It allows individuals who do care about competition to stop funding oligopolists.
"Conflict of Interest Disclosures: Dr Ferencik reported receiving grants from the American Heart Association and serving as a consultant for Biograph Inc."

The American Heart Association is funded by pharmaceutical companies that produce statins.
How I avoid document clutter with paperless-ngx and Synology Container Manager
I don't know the math here specifically, but being hard to guess is a different quantity than chance of collision when following the algorithm.

That is, if you aren't trying to have a collision and following the algorithm that has that aim, a collision can be exceedingly unlikely; but they can still be easy to guess if you are trying to predict someone else's assignment.
I think people don’t like constructors because of the potential side effects of something happening in constructors, especially if the constructor is big or doesn’t finish properly.
So, do you think that there is not a conflict between labor and capital, where the first is provided by workers that want to be well paid, and the second having the objective of growth and reproduction, and so wants to minimize coasts like salaries? I see this conflict happening a lot when workers begin a labor strike, or when company owners do union busting and anti-union activities. When for the workers, the ideal percentage of unemployment should be 0%, but for capital owners, it should be higher, or the labor price becomes too high. I think there are lots of examples of conflicts between labor and capital.

Related:

https://en.wikipedia.org/wiki/History_of_union_busting_in_th...
There's a joke somewhere in here about trying it locally, but I can't quite... Nevermind.
> Now how do we translate this into ten or more English words?

I think it's fair to say that written Chinese simply allows to encode more information than English. So it's "physically impossible": translation from Chinese is a lossy operation.

We can only provide a reasonable approximation.

Even at the character level, some information just can't get through. "道" for example contains both "辶" (to walk) and "首" (head, chief, first (occasion, thing, etc)). In addition to the usual meanings, we could derive some further meanings, coherent in this context, with a "philosophical" approach to life (e.g. "the state of mind of someone who moves forward, one step at a time, without rushing").
*whose mission
The biggest hurdle to passkey adoption is going to be, how complicated they are to implement for developers (relative to their advantages). I think that's the much more pressing matter than user adoption.
They did mail me SIM cards, three times, for three different numbers each time.

Their system didn't work when setting them up, and I had two different support operators tell me that my only option was to drive to Cranbrook. In the middle of winter. This is a drive that involves 3 mountain passes.
I don't think it is a mistake for Lua. The convention to zero-index arrays is not sacrosanct, it's just the way older languages did it (due to implementation details) and thus how people continue to do it. But it's very counter-intuitive, and I think it's fair game for new languages to challenge assumptions that we hold because we're used to past languages.
Why are there two sets of records and why do they need to match?
Failure to defend (e.g. against economic espionage) national treasures is not the same as never having them, or not having a creative culture that gave birth to tech assets worth stealing. Are future generations going to mourn fallen Canadian technology, or rebuild and learn from past mistakes?
Sorry we won the war and overshadowed the Empire.
But congratulations on your July 4 2024 Independence Day win against the Tories. Perhaps after November you'll come to dominate the Anglosphere again.
Nah, if they need to believe in homeopathic cure-alls it most definitely needs to cost $400. Compared to a Medbed, I'm offering a total bargain.
"Obsolete" is a word with a cultural stigma attached, which is the belief that things which are older are worse.

A label printer ought to be judged on its ability to print labels first and foremost. If it is designed such that it eventually must be discarded because it is no longer good at printing labels, that should reflect poorly on it.

My label printer sits next to my stapler. The stapler is a Swingline from the 70s, I think my parents gave it to me when I was in college? Regardless, it cannot really be considered obsolete, because it staples just as well as it did when it was made. The latest advances in technology do not make new staplers function any better. Similarly, my label printer has a qwerty keyboard and does not need to keep pace with modern wifi standards, as long as 12mm ink/label cartridges are available (and they have been the same since the 90s) and the NiMH battery can be recharged, it will work just as well as when it was new.

The smoothness of the gradient on the CUPS internal web server is so irrelevant to the merits of the label printer that it does not deserve to be mentioned. Some printers and chart plotters are very large, very expensive machines that can nonetheless function for decades, and fortunately, the CUPS project still supports them.

It's unfortunate that one of the most desirable attributes of a printer is that it supports wireless networking, and that wireless networking security standards have as much churn as they do, which causes label printers like this one to become e-waste.
Is "looks a bit like a human from this angle" what we classify as "having intelligence"?
If you have to ask you may not be one.
Funny thing, I lived outside of Canada for many years though I am Canadian born and raised. I moved my family back for a "better quality of life".

Jokes on me. ;)

I love the land and the people, but, the country itself is a mess. We have already planned our exit.
I was having trouble understanding what they are.

Summary: It's a password manager on your phone. You sign into your password manager with something easy like biometrics or a PIN. Then all the 'real' passwords for sites are autogenerated and those are what's sent to sites when you log in.
> The July 2022 outage was not the result of a design flaw in the Rogers core network architecture.

Talk about some grade A gaslighting here. Reading the post mortem they first tell you it wasn't a design flaw then say they routed all their data through one core router ( including a lack of a management network). Then they say they are going to fix things by separating out the wireless and wired traffic.

Why would you fix things if it wasn't a design flaw?

Out of band access is like resilient architecture 101. Hell even homelabs generally have some way to do it. It's appalling that Rogers didn't have a way to access the core IP routers out of band. Yes it might mean having to use a competitors infrastructure but they ended up having to do it anyway. And with the failure of the service now all the infrastructure providers are under additional scrutiny. Rogers should be striking some agreements with other providers to carry core traffic in case of an outage such as in this DR situation. For example Visa, MC, Amex all have agreements in place to process each others auth data in case the other party goes down. The thinking here being an outage for credit cards makes everyone look bad.
My Dream Web Framework, which for a variety of reasons was never and never will be built, has built-in functionality for obscuring IDs in some session-level map, so you can indicate through some sort of type that something is an ID and it automatically allocates some sort of randomized identifier on the way out and converts it back transparently on the way back in.

Thus, not only would DB ids in principle never show in the UI, they wouldn't even be stable between sessions.

This would protect against a number of security attacks. (I don't know what I'd do about bookmarking, though I suspect most apps have a 80/20 solution they could deploy.) DB ids going out to a user really ought to be considered at least a smell, but it's pretty ingrained into our culture.
I think this is incorrect. Don't centuries start with the 00? In that case the first year of a century is 0, and the 76th year would be 75, not 76 as the author writes:

> starting in 1776, not in the 76th year of the 18th century.
Let me put it this way: Can you really blame someone for not knowing a historical fact that is completely irrelevant to their life, especially when they probably have more pressing concerns to learn and care about?

We only have so many hours in a day and so many days in a lifetime, while knowledge is practically infinite.
I get that maintaining browsers is hard, but it feels like Firefox has been slowly falling behind in terms of supporting and expanding on its core functionality. I experienced this copy bug for a long while now (for some reason, visiting Wikipedia seems to trigger it most often), and any such hitches seem to take months to resolve. It took five months[1] for Mozilla to fix an issue that made YouTube borderline unusable, especially on higher resolutions. Features like HDR video support have been requested for years and are seemingly not coming despite every other browser supporting it for ages. And yet, there's no viable non-Chromium alternatives.

[1] - https://bugzilla.mozilla.org/show_bug.cgi?id=1878510
Well, while we obviously were both upset and sad about the situation, she was very understanding, for which I am thankful. We were in it together. It helped that she managed to find a slightly better job pretty shortly thereafter. Nevertheless I felt really guilty about it and as a result the obvious relevant professional programming lesson was instantly and indelibly burned into my brain: you can fix bugs, but you may never be able to undo the real world user level consequences of the buggy software's time in production before being fixed. I was just out of college then and it solidified more respect for the power of the machine.
> Judging by the comments a lot of people in this thread have been affected by this issue.

I'm sincerely surprised by how many people on Hacker News are apparently copy/pasting with the context menu rather than using Ctrl+C.

PSA for some common keyboard shortcuts:

Alt+Left to navigate back (Alt+Right to navigate forward)

Ctrl+T to open a new tab (Ctrl+Shift+T to reopen previously closed tab)

Ctrl+N to open a new window (Ctrl+Shift+N to reopen previously closed window)

Ctrl+Shift+P to open a new private window

Ctrl+W to close the current tab (Ctrl+Q to close all windows)

Ctrl+R to reload the page (Ctrl+Shift+R to do a forced reload of cached assets)

Ctrl+Plus to zoom in (Ctrl+Minus to zoom out, Ctrl+Zero to reset zoom level)

Ctrl+Tab to focus the next tab in line (Ctrl+Shift+Tab for the previous tab in line)

Alt+One to focus the first tab (Alt+Two for the second tab, etc.)

Ctrl+F to search the text of the page (/ (forward slash) for quick find)
I am definitely curious about a tool like this. I work with a lot of video streams and this collective knowledge of quirks might be useful as a QA tool
> You don't have a right to buy stuff that works or that you can trust

We're not talking about rights here. You claimed, and I quote, "You can buy whatever you want unless the DEA has an issue with it." I am simply pointing out that that is not true. Whether it should be true as a matter of right is irrelevant to that factual question.

> you keep acting as if getting a prescription is some sort of actual barrier or burden for non-prescription drugs

Um, no, I said no such thing. Obviously having to get a prescription is not a barrier or burden for non prescription drugs. But, as you yourself have pointed out, a huge number of those non-prescription drugs, for which there is no barrier or burden, don't work. And, as you have also pointed out, routing around things like prescriptions to get, for example, antibiotics means you can't trust the product. So there are barriers and burdens in the way of getting things that do work and can be trusted. Which was my point, and which contradicts your original claim that I responded to.

The question of whether there should be all these barriers and burdens in the way of buying things that work and can be trusted is a separate question. Your argument for why there should appears to be that without such barriers more harm would be done. Of course there will always be people who make stupid choices, and giving people more freedom by removing barriers and burdens will increase that. But you are not recognizing the other side of the barriers and burdens, which is that they prevent people from making good choices, choices that could save their lives. For example, look up the harm done in preventable deaths by the FDA's slowness in permitting beta blockers.

The post you responded to that advocated a libertarian approach was saying, in effect, that, on net, the harm done by regulation is greater than the harm done by individual people making bad choices in the absence of regulation. I happen to agree. You apparently do not. But I do not see that you have given any reason to believe that the opposite is true. I certainly don't see anything in what you've posted that makes the opposite claim the slam dunk that you appear to think it is.
If anyone is curious about another 'fun' Windows only bug: https://bugzilla.mozilla.org/show_bug.cgi?id=1856462
For one thing, the selection state is visible to the webpage. For another thing, the webpage is where the text lives. Put that way it sounds funny, but think about it. You have a bunch of content processes, each of which is in charge of loading some number of webpages that the user wants to have open. There is a single UI process that the user can interact with. When the user actually initiates a copy, the UI process doesn’t know what text to put into the clipboard. The text is all in the content process! The UI process merely has to figure out which content process to send the messages to, so that the right text ends up in the clipboard. And that's more complicated than it looks because any given page you are looking at might be stored in multiple processes. A page on domain A with a frame that has content from domain B will often have a different content process for both domains, to ensure maximum separation of state between them.

The bug appears to be a race condition in how the state of which content process has the most recent selection is synchronized with the UI process. The patch at the end of the bug report changes it so that when the user unloads a page no message is sent to delete that state. Instead, only whatever page gets loaded or switched to next will send a message to replace the state. This should eliminate the problem.

Left–over tooltips are a completely different kind of problem.
You don't need to worry about a collision in a UUIDv4 that you created on your server. But I have seen a surprising number of applications that took a UUID generated client side and basically upserted it. Allowing taking over resources who's ID was known via the insert API (even if the update API has proper access control).
Most websites I interact with use the mouse only (writing text aside) - navigation alone can always be done with just the mouse. So, it's often easier and faster to use the context menu if your other hand isn't already on the left side of the keyboard.
Not really a difficulty, just different enough that I never wanted to try it for anything real.
This post has 100 points right now and there are already 10+ people in the comments saying they have experienced it. Given the typical distribution of lurkers, I’d say a good proportion of the votes come directly from people who think they’re affected. Probably more people wrongly attribute this kind of annoyance to websites. Bugs in popular software just affect more people, hard to reproduce or not.

Not sure why you’re so defensive and eager to shut it down that you have to post a barrage of comments to this thread, including saying roughly the same things in three comments.
I don't know how/haven't seen an attempt to approach this question by a method other than "my hunch", but as a software engineer "my hunch" is it would cost at least 10-50x as much human labor (not just engineers but designer and UX researchers as well as all the other support roles like project managers etc) to build the software "well" (including more customization for individual enterprises or uses), and that it would become an unsustainable portion of the GDP.

Just "my hunch", but one I reflect on a lot these days.
I try to use Firefox a lot. One of the main issues I have is 4K video on YouTube gets stuck and skips a lot of the time on Windows 11 when using Firefox. I’ll then just play it on chrome and it plays flawlessly. It’s not the internet connection (1 Gbps) and not the graphics card (4080). Anyone else having this issue?
This is not even getting to that; but that is actually pretty simple, to be fair.

The negation is: 非常道

非 -- fei, this has been a negator for a very long time in Chinese

常 -- chang, this means something like common, usual, normal, or nominal (I suspect that translating this as "eternal" is a creative move on the part of some westerner)

道 -- dao, the way again

Nowadays, 非常 as a compound is used to mean "extraordinary" ("not normal", "exceptional"); but it is not hard to see how it might be taken to negate 道 here.
Any chance we can see the code? I'd love to do some work in Nerves and that sounds like the perfect project.
> 道 -- dao, it means literally a road or path; metaphorically, it used to mean a spiritual way of life

Some relate Tao to Logos from the Greek, and as in the first chapter of the Gospel of John. The meaning of Logos is quite complex[0], and the typical translation into most languages as "word" is grossly inadequate.

And so, if Christ is the Incarnate Logos, and Tao is Logos, then Christ is the Incarnate Tao. And John 14:6 reads "I am the _way_, and the truth, and the life.". (Hieromonk Damascene has written a book on exactly this subject[1].)

These have also been related to Rta, Asha, and Ma'at.

[0] https://www.perseus.tufts.edu/hopper/morph?l=lo%2Fgos&la=gre...

[1] https://a.co/d/0btyDy8i
It's actually neater than that. It's a cryptographic public/private key that is generated uniquely per service. It removes any risk of a login credential being leaked from the sites, as they just have a public key, which is entirely useless to actually auth with.
I (born and raised Canadian) moved my family to Canada 5 years ago.

We've been on a waiting list for a doctor ever since. My only option to see a doctor here is to go the emergency room at the closest hospital.
It's important to remember "Clarke's three laws"[0]:

The laws are:

1. When a distinguished but elderly scientist states that
something is possible, he is almost certainly right. When
he states that something is impossible, he is very
probably wrong.
2. The only way of discovering the limits of the possible is
to venture a little way past them into the impossible.
3. Any sufficiently advanced technology is indistinguishable
from magic.

Depending on one's background and when they entered this field, there exists a non-trivial probability that previous abstractions have become incorporated into accepted/expected practices. For example, at one point in computing history, it became expected that an Operating System with a general purpose file system is assumed to be in use.

The problem I think you are describing is the difficulty one experiences when entering the field now. The prerequisites in order to contribute are significant, if one assumes the need to intricately understand all abstractions in use.

While this situation can easily be overwhelming, I suggest an alternate path; embrace the abstractions until deeper understanding can be had.

0 - https://en.wikipedia.org/wiki/Clarke's_three_laws
Show HN: Listen to Mechanical Keyboard Sounds with Every Keystroke – It's Fast
It works on my machine!

Repeating that joke over and over again is key to a full career in software engineering.
Shaw Mobile on the other hand, did go to Rogers.
And also macOS' FileVault .
This is exactly why I'm not using passkeys. I even trust Apple's statements that they can't view the key material, however, if Apple ever decides my account is no longer in good standing, I still want to access all my other accounts and as it stands now, you'd lose access to everything.
No, because there was no year zero. The first century started in the year 1 AD.
That is not really translation, though, once you start doing that.
In addition to incidental use and and law enforcement and investigative purposes , copyrighted music in a YouTube video could also be Academic Use, journalism / criticism, sufficiently transformative, a mixtape-style compilation,.

Someday hopefully the musical copyright folks on YouTube will share revenue with Visual Artists on there, too.
What doesn't get spent on quality goes down as profit. This is why we have fake mobile games. Vaporware is the real software crisis.