skysight-inc/HackerNews huggingface dataset:
hi everyone,

I've been working on a web app (https://velty.app) that lets you organize your YouTube subscriptions and videos into folders and sub-folders. It helps you find what you want to watch more easily.

The idea came up when I found it hard to organize my growing list of YouTube subscriptions and finding videos easily. The YouTube playlists system is limited — it lacks hierarchy and search functionality. I wanted an app to organizing everything into folders and sub-folders to easily find videos by their duration or the channel they're from. Also, provide the same functionality on mobile and destkop.

I tried different methods like RSS readers, browser extensions, and bookmarks, but they all had drawbacks:

- Browser extensions don't work on mobile.

- With bookmarks, filtering and sorting are challenging.

- RSS readers have limitations in organizing folders and sub-folders and lack filtering and sorting options such as duration, published date, and channel names.

So, I decided to build my own solution to deal with these issues.

I'm keen to hear your thoughts on the idea!
And what about the users who trust services to protect their data? Safeguards like this are about protecting the users, not the developers.
Snake Defense Fanfic
I also started using Rails a long time ago (circa 2005), and I have become older too (46 years now).

But I must say I think there is not much bullshit, and quite a bit of stability, in what Elixir / Phoenix bring to the table (saying this after maintaining a production French state-owned service running on top of Elixir for more than 3 years now).

There are also not that much framework bugs, the level of retro-compatibility is huge compared to Ruby in particular (except for LiveView which is still a bit young, but the rest is ... quite stellar).

I quite find that I could use exactly your last paragraph to describe _why_ I wouldn't pick anything else than Elixir these days. The TCO is great, the maintenance story is remarkably stable at the moment etc.

Googling works decently well now with Elixir too, the community is mostly fairly responsive.
Postgres has a query planner, I mean this entire post is about improvements to it. So I think there either was some miscommunication or your friend doesn't know anything about Postgres.

There are very large Postges databases that seem to work fine, so Postgres can certainly scale. But SQL Server also has some features that Postgres doesn't, and if those are important for you it might work better for your use case. They are in the end different databases with different strengths and weaknesses.
Maybe it's more like reading a newspaper over someone's shoulder, but in a sneaky fashion so they don't even know that you're doing it.
It is not wrong though. Once you reify the return continuation, a continuation is really just a closure, the stack is implicitly recovered by recursively following the captured return continuations. And with closures you do not necessary have a stack anyway but any arbitrary directed graph.
I thought they came to a "no tell" settlement on that in 2021
Stop dreaming. Won't happen. Windows is a purely additive effort. WSL is what happened, and when it couldn't do some things they built WSL2.

As another commenter pointed out regarding the integration of this new "sudo" and UAC prompts, it will probably be done in a new, separate, different tool, because this new, freshly released "sudo" will now have to remain bug-for-bug compatible for the next four decades.
In most of Europe you should be able to access Gemini, at least in the EU it's available, the only thing restricted is the text-to-image model.
> PostgreSQL supports most of the major features of SQL:2023. Out of 177 mandatory features required for full Core conformance, PostgreSQL conforms to at least 170. In addition, there is a long list of supported optional features.

https://www.postgresql.org/docs/current/features.html

Clickhouse is simply a joke in comparison. No basic cursor support, no transactions, incomplete comparison operators, no single-row SELECT with GROUP BY and HAVING clauses grouped views, no procedures, no anti-joins or WHERE EXISTS, for that matter. The list goes on... it's basically impossible to write SQL to any degree of sophistication in Clickhouse.
Burnout: My story of chronic fatigue, neurodiversity, tech, and my shadow side
It's taken me years to write this post, but I think it's super relevant to HN peeps. Lost my old account here, sad times, but starting fresh.

This post collects all of my experiences with Burnout in tech & entrepreneurship and the things I've done to try to come back from it.

Be well my peers!
Its “appeal has become more selective”
Nice list. It would be much improved if there were approximate prices right there, and an indication of which ones lie on the current Pareto frontier.
Yes there is. If what you need is a database that will do pretty much anything well enough, then MSSQL and Oracle are going to manage it. They solve this by throwing money and hardware (more money) at the problem until it works. There's some clever stuff happening in there of course, but fundamentally they've just had much more engineering work over a long time. They can scale out more than Postgres can reasonably do.

That said, Postgres is catching up, and arguably MySQL/MariaDB has always had a good story here. Scale-out options are improving all the time. The landscape has also changed in other ways too, now you can easily have a multi-terabyte Postgres cluster on a small number of machines serving large traffic volumes, and then put your "big data" into a more specialist database. The old world of shoving everything on MSSQL/Oracle may be a bit old-school.
I'm a WFH worker. My company is fully remote. They are really great at managing departures and make sure everyone's aware and has a chance to say goodbye.

However I can't shake this feeling that the mindset that got us from treating servers like pets to treating them like cattle is creeping into workforce planning, and the WFH movement is making it that much easier.

Why plan capacity when you can scale resources up and down on-demand on a whim? With the emotional and morale implications of letting people go hugely reduced it becomes easier to think like that.
Yes terrible move which will lead to much confusion and consternation in the future.

But honestly I'm most amazed by the fact that there wasn't previously a way to run commands with elevated permissions in Windows. How did people work like that? Just run everything in an admin terminal super unsafely?
Introducing Word for OpenBSD
Pretty sure this phenomenon is actually a subset of "Transfer Appropriate Processing" from psych class: https://en.wikipedia.org/wiki/Transfer-appropriate_processin...

The "doorway effect" seems to be one expression of that larger phenomenon in which memory recall is largely influenced by the context in which it was encoded. It's the reason that if you're cramming for an exam, to the extent you can recreate the exact conditions of your study environment to mirror those of the test-taking environment, you'll do better.
Whatever the domain, a query isn't necessarily critical or sensitive. It only is if it contains personal information (eg querying by a bank account number or a name), or if the query itself is part of your competitive advantage (unlikely)
> but the least we can do is wish her best wishes

I wonder how many times in a row it would take of you being fired by the CEO who completely mismanaged the company, while massively increasing their own salary multiple times, before you stop wishing them well.

In fact maybe the problem is that you are wishing her well. She's exploited other people enough to be doing well enough on her own. She doesn't need anyone to wish her well. Maybe the least she deserves is to not be doing well at other people's expense. What about those people?

Being nice isn't always the right answer. When people do bad things, there should be negative consequences for them, otherwise that signals to them that their behavior was appropriate. It wasn't. You are doing the morally wrong thing by wishing her well.
They have manual install instructions [0], and judging by those, what it does is set up a SystemD service that automatically runs on startup. But if you're just looking to play around, I found that downloading [1], making it executable (chmod +x ollama-linux-amd64), and then running it, worked just fine. All without needing root.

[0] https://github.com/ollama/ollama/blob/main/docs/linux.md#man...

[1] https://ollama.ai/download/ollama-linux-amd64
Ok, so here is variation that contains zero JS and (ab)uses the "invisible_anchor:focus + sibling_anchor_pointing_to_previous_anchor" trick [0]. I'd prefer the original version, though. This is more or less a hack.

[0] https://myfonj.github.io/sandbox.html#%3C!doctype%20html%3E%...
You might be right, a LLM alone doesn't improve by itself. But when it is part of a system like GPT's, then it can use web search, local RAG, code execution and also get human guidance and corrections. Clearly superior setup that improves over the LLM alone. I believe that is why OpenAI created GPT's, to lift a model at level N to level N+1.
If you don't care about the electron app and just want the API, you can `go generate ./... && go build && ./ollama serve` and you're off to the races. No installation needed.
As anyone with a boat knows, salt water is insanely corrosive and gets into everything. Even large container ships have to be regularly serviced.

I can only what hot molten salt does to industrial processes.
Why doesn't Apple do servers?
It seems to me that Apple Silicon would be particular well suited in a server. Including for AI; Apple laptops are widely popular amongst developers and Apple could use that popularity to promote an alternative to NVIDIA CUDA.
Yep. So-called "ethics" patronizing users by "looking out for our best interests" as if all users were children and lacking in critical thinking skills and self-control.
Django, SQLite, and the Database Is Locked Error
East-Asia chiming in here, Microsoft dominates enterprise, Google is a tiny player, single digit percentage market share for any enterprise product. Only on cloud does MS have competition from AWS and local players, everything else is Microsoft. And even in cloud Azure is rapidly eating through AWS marketshare.
You either use TCP or re-implement TCP over UDP i.e. QUIC
Yt-dlp ftw!
I really wish the postgres query planner would gain the ability to replan a query mid way through execution...

Frequently the most pathological queries (ie. the dreadfully slow ones) are because the query planner didn't have some knowledge required of the data distribution and couldn't accurately estimate the cost of some approach to planning the query. This can easily have a 1000x impact on execution time (ie. 1s rather than 1ms).

You will never have 100% accurate table stats - there is always some odd joint distribution you will not capture.

So instead, allow the query to start, and if progress isn't as fast as the planner expects, feed current progress info back to the planner (pages scanned, tuples matching), and replan with that new data. If the updated plan shows it's quicker to discard current results and restart with a new approach, do that.

Unfortunately, postgres does streaming queries (ie. the first results of a query are sent back to the client before the query is done), which means that significant infrastructural changes would be needed to allow a midway change of plan. Any new plan would need to keep track of which results had already been sent to the client so they aren't resent. Postgres also allows a client to, midway through a query, request that the query reverse direction and re-return previous results in reverse order. That adds a lot of complexity.
Hope you’re right because I feel like modern civilisation needs a bit of inspiration.

There has to be more than ecological destruction and shareholder greed, right ?
That professional responsibility falls entirely on the developer[s]. Not on an inanimate object.

To make a non-tech analogy. This is functionally equivalent to locking up books in safes, so people can't abuse the knowledge they contain. Sure: if an incompetent person used a structural engineering handbook to build a bridge, and did it incorrectly and it collapsed, that would be a bad thing. But most people agree that's not the fault of the book, or negligence on the part of the library for failing to restrict access to the book.

Me, I'm against book-banning in all its forms. :)
we have the word in Danish. It is used to express 'No' with a bit of slang-vibes to it. Kinda like 'Nope'.

We also say 'Niks'

I think Niksen is the 'cute' word for Niks. The ending -sen is the familiar -sen from 'son (of)' found in 'Jensen' 'Hansen' 'Larsen' or in swedish 'Hansson' 'Larsson'
The Sankey Photography Archive
Thank you for your opinion - it's proven reliable over the last decade.
AWS' Aurora seems to be handling things pretty well tbh and is meant as a drop-in replacement for Postgresql and MySQL.
>You just need to read one blog post that tells you to avoid regular expression matchers that use backtracking, and you are good to go. You don't even need to understand why matching via backtracking is bad.

Yeah, no.

You might not be able to avoid using your standard lib's regex, or your project's chosen regex dependency - based on team/company policy. So it's not as simple as "use a regex engine that doesn't has this flaw".

Then if you want to avoid the cost, you need to know what backtracking is, to the level of understanding which kind of expressions can give you those performance issues.

>Why?

Because there are tons of factors that can affect your regex experience with unicode, normalization, different lower/upper case treatment, composite characters that don't match even though it looks like you typed the same character in your query, handling new unicode characters (ASCII 7/8 bit has been fixed for decades) and so on.
"...that my parents were incredibly diligent in making sure I learnt how to touch type at the same time, which I can't thank them enough for."

You're very lucky indeed that your parents encouraged you to type, clearly it's put you in good stead.

My mother had been a professional typist and stenographer and knew Pitman shorthand to a tee. She could type multiple pages without a single mistake for she learned in the days before wordprocessors and correction fluid—a single mistake would mean retyping the whole page. Also, she worked in a law firm where cross-outs and corrections were just not acceptable. Simply, she had to be accurate and word-perfect every time and she was.

Yet at no time did she take the time to teach me to type nor teach me shorthand. It's not as if she wouldn't have done so had she known better but it just wasn't acceptable to teach boys what was then considered women's work.

This is one big regret of my life as my typing is at best still scratchy and I do not know shorthand which in hindsight would have been a godsend.

I need to correct my point about handwriting and learning. I'm now not sure whether the story was linked from HN or not but it's definitely on Sabine Hossenfelder's Science News YouTube channel here: https://m.youtube.com/watch?v=7PQbidoBPBc
Of every major issue with the AVP the fact that they not only avoided but made impossible to have a wired connections to anything even though they laughably made the battery pack external is really the most stupid thing ever.
As a display replacement for more powerful hardware, we will never overcome the bandwidth problem (heck, it's already hard enough to do 5k at high fps with a wire) no matter how good the compression is.

It makes no sense that they built and advertise this "feature" when it could have been so much better with a thunderbolt/usb c input on the battery pack...

It doesn't spell much good for the future of the device, because it seems it will be largely locked down and limited like the iPad but even less enticing uses cases...
I wonder if one could make a neural net play human-like, at various levels, by for instance training smaller or larger nets. And by human-like, I don't mean ELO level, but more like the Turing tests - "does this feel like playing against a human?"

I wonder how many time-annotated chess play logs are out there. (Between humans, I mean.)
I don't think anybody disagrees that the correct place to fix that is the planner, people just want an escape hatch so that when poor queries happen they can do _something_ instead of waiting for a fix to be written, a release to include it, and upgrading their database. It's a pretty reasonable ask, I think!
https://archive.ph/r0uuX
If you liked Redux, you'll love the old J2EE!
A couple of years ago my elderly parents got feature phones with KaiOS. It was slow (at least on those devices), cumbersome, and some basic things such as SMS felt quite unintuitive and complex to operate. Think old feature phone OSes where you have to navigate from one menu to another with arrow keys, a few buttons and limited screen space, but without the relative polish of those actual old phone OSes from the days when they were standard. And with tangible sluggishness added.

n = 1 and I don't know how much phone vendors customize KaiOS. Maybe it was only cumbersome due to customizations or limitations from that vendor. Maybe it works better on touch devices. Maybe the hardware just wasn't up to the task. But it didn't leave a good mark.
The rules on this vary across Europe, though broadly speaking accessing an employees mailbox is “something you only do after speaking to legal”.

The patchwork of national laws and national interpretations of EU regulations is quite interesting, and rather confusing especially if you do offensive security work or DFIR.

As an example, when doing consultancy we would do the usual phishing as part of an assessment. Usually this is followed by dumping the users mailboxes to look for further credentials/access to corporate resources (eg: are they emailing passwords around?) - but in some countries such as Germany that’s often explicitly ruled out due to fear of breaching privacy regulations.
Soon they will ban Hackrf boards and open source code?
So what stops people making their “backup of files” before hitting send on the email?
> Everyone should know enough about LDAP to build a login service that binds against it for internal apps. You can exploit the groups the sys admins maintain to control permissions in your app. It's very powerful and an easy way to get up an running in no time.

Sure, if you want to be the next SolarWinds.
prod·uct·ize
VERB
make or develop (a service, concept, etc.) into a product:
"additional development will be required to productize
the technology"

Google has top notch research labs and output. Their productization sucks small planets.
I searched for "UN agenda against breathing" and "UN agenda against farting" and didn't find any results. Can you link to what you are referring to?
Yeah, I first checked out the chat only then I read the description.
This right here, it's just crazy. On one project we invested in a private cache of prebuilt/binary pip wheels, as much as it complicated the build and maintenance, it saved us so much time and effort in the long run, and was ultimately a productivity boost.

I really like it that the x86 monoculture is being disrupted, and enjoy the benefits of low-wattage high-performance systems, but we still have a long way to go.
That's probably due to the absence of an effective AQM as the bottleneck, rather than the transport protocols being unfair. See https://datatracker.ietf.org/doc/html/rfc7567 for the current best practice
Or “your sales guy is making a little backup of the leads from the CRM before handing in notice”.

Though with sales orgs I think this is almost an expected practice - sales people are often hired on the tactit, never officially acknowledged basis that they will bring their leads list.
Just in case you meant otherwise Epitaphs is not my tool, but I agree it is very useful :)
naïvely, 14 kibibytes sounds like a factor of 2½ worse than c:

$ cat smallhello.c
#include <unistd.h>

int main()
{
char hello[] = "hello, world\n";
write(1, hello, sizeof hello - 1);
return 0;
}
$ diet gcc -Wl,-z,noseparate-code smallhello.c -o smallhello
$ strip smallhello
$ ls -l smallhello
-rwxr-xr-x 1 user user 4864 Feb 9 06:47 smallhello
$ ./smallhello
hello, world

but that's mostly overhead of dietlibc and linux elf rather than overhead of c per se. it's pretty easy to use c to build embedded firmware that fits in 512 or 1024 bytes (though not always advisable)

i would argue that this is 'with no linker optimizations' because -z noseparate-code was the default until a few years ago. linker optimizations can save another 200 bytes or so in this case

note that this is without dynamic linking. there's no giant standard library being swept under the rug here. most of the executable code in the resulting program is _start pulling in stackgap, which calls find_in_auxvec, __libc_open, __libc_read, __libc_close, __setup_tls, getenv, strstr, and finally main, and strstr in turn calls memcmp (as does getenv) and strlen. main() itself is only 61 bytes of code, __libc_write is 6 bytes, mostly a tail call to __unified_syscall, which is 34 bytes. so we're already looking at overhead that's 40 times the size of the hello-world code itself, which rust apparently expands to 100 times?

but possibly not; it's easy to accidentally compile something with c that ends up 14 kilobytes too

but basically c's required runtime is just memset() and memcpy(). everything else only gets invoked if you call it explicitly
Wow, I just read https://fourmilab.ch/documents/strikeout/ and I'm stunned. I'd really love to see how other people react to this and whether they agree with his, in my opinion extreme, focus on correct use of language. But sadly, I cannot find any online discussions of this article. Are there perhaps other people that take a similar viewpoint that expand a bit more on why they take such a stance?

Practically, striking out texts at first mistake also seems like such a fundamentally unworkable solution to me. The first glaring problem is that he says you can easily spot the kind of mistakes that non-native English speakers are likely to commit. But to me that's obviously ridiculous unless you have a more than passing familiarity with the structure of all common languages of the world. I'm aware that this was written in 2005, but nowadays the chance that a given piece of writing is written by a native English speaker is certainly less than 50%. And the ones who are skilled at writing English will have reached some plateau where they can easily communicate with anyone. But that will be below a native speaker's level, and going beyond that is a massive time investment that has no practical benefit for them. Other than being able to talk to John Walker I suppose.

Other than that, I'm also not sure how you would even define proper English beyond "what I grew up learning". And given he would "strike" frivolous things like "xp" (The windows operating system) instead of "XP", it stood out to me that he used the term "on-line", a spelling we would "strike" nowadays.

And finally, given the brain's ability to seamlessly decipher even extremely scrambled words, I feel like the ability to even spot slight misspellings in text is something you specifically have to train yourself to be able to do. That seems like the most profound waste of time, to train yourself to spot mistakes in text you'd otherwise not even have noticed and that would've never impacted you.
This is a much better article that captures the niks of niksen.
I’m not sure if this response was simply for the sake of replying, with the claims of writing perfect code all the time or how backtracking implementation is uncommon or insane (most languages use backtracking implementations of regexes).