skysight-inc/HackerNews huggingface dataset:
Does the celery SQLAlchemy broker support PostgreSQL's LISTEN/NOTIFY features?

Similar support in SQLite would simplify testing applications built with celery.

How to add table event messages to SQLite so that the SQLite broker has the same features as AMQP? Could a vtable facade send messages on tablet events?

Are there sqlite Triggers?

Celery > Backends and Brokers:
https://docs.celeryq.dev/en/stable/getting-started/backends-...

/? sqlalchemy listen notify:
https://www.google.com/search?q=sqlalchemy+listen+notify :

asyncpg.Connection.add_listener

sqlalchemy.event.listen, @listen_for

psychopg2 conn.poll(), while connection.notifies

psychopg2 > docs > advanced > Advanced notifications:
https://www.psycopg.org/docs/advanced.html#asynchronous-noti...

PgQueuer.db, PgQueuer.listeners.add_listener; asyncpg add_listener: https://github.com/janbjorge/PgQueuer/blob/main/src/PgQueuer...

asyncpg/tests/test_listeners.py:
https://github.com/MagicStack/asyncpg/blob/master/tests/test...

/? sqlite LISTEN NOTIFY: https://www.google.com/search?q=sqlite+listen+notify

sqlite3 update_hook: https://www.sqlite.org/c3ref/update_hook.html
To me it just signals what a bullshitter you are. Most people cannot claim these "outcomes" because it takes a whole team. How do i know you made any contribution to those outcomes?
This seems to have full support for Raspberry Pi.

- Type-C port supports 5V/5A PD (Pi does not comply with PD specs)

- keyboard and trackpad over USB-A

- Micro HDMI input
Every non-trivial Java project I've worked on ends up depending on Google's Guava and some combination of Apache Commons libraries.
I'm not sure what to do about this- how to relate to people whose single minded obsession with politics has tinted every aspect of their lives and thoughts, and they think people that don't see it that way are complicit with their "evil enemies."

It's becoming more and more common, and awful. I see this a lot- my family can't even have holiday get togethers anymore, because people that used to get along great have now "joined opposite sides" and can't talk or think about anything else anymore. They'll start lecturing each other loudly, and literally can't think or listen to other people anymore. They do this even if everyone present agrees with them!

What is actually happening is the opposite of what they seem think- it's not the other people that are checked out of real life and not taking a stand on things that are actually important-- it is them. Obsessively and angrily watching news doesn't solve problems, nor does blind application of any ideology. Ranting at people with your ears and mind shut down doesn't convince anyone of anything.

A simple minded obsession like that can't exist in a healthy person that is actually engaged with the things they care about, and have personal control over. They're not good parents, family members, employees, or community members anymore - the kind of people engaged with making the world better through direct actions - but angry closed minded zealots.

I'd like to help these people become human again, and stop obsessing over politics in a way that dehumanizes anyone that doesn't perfectly agree with them. My thought is that it is an emotional problem, and not about the politics at all. They seem to be projecting their own personal anxieties and fears into a political framework, as a distraction from understanding and dealing with them. Or conversely, politics has found a way to weaponize personal emotional problems as a way to engage supporters.
The FSF has substituted the phrase “modified works” in place of “derivative works” in v3 of the license, yes, but not to narrow the definition - the intent was to broaden the definition to cover additional classes of modification.

From the FSF’s licensing FAQ:

> Where's the line between two separate programs, and one program with two parts? This is a legal question, which ultimately judges will decide. We believe that a proper criterion depends both on the mechanism of communication (exec, pipes, rpc, function calls within a shared address space, etc.) and the semantics of the communication (what kinds of information are interchanged).
It is energy intensive. Studies I saw give 2 to 8 years to offset the PV alone, not counting inverters and the rest. One case of a heavy hail during that time and a panel becomes a net energy loss, a pure damage to the environment.

> Solar panels are now cheaper than coal because you need to dig up coal and bring it to the power plant, which costs more than the 4cents per kwh which LCOE solar now costs.

You're taking again the LCOE of solar produced from coal. Digging up coal and bringing it to the plant requires very little energy.
- Microsoft Outlook as a replacement for Gmail is wild.

- Amazon Photos is just as bad as Google Photos.
> So you're saying women didn't tend to be excluded from the formal economy? That's news to me.

No I’m saying the 1-income household utopia was built on someone doing that work. Usually unseen, unsung, and poorly rewarded.

And for lots of people that utopia never existed. They simply weren’t allowed or able to partake.

For the record: I’m not saying whether this is good or bad. I’m trying to provide an alternative view of default expectations from a different cultural and socioeconomic background. In my neck of the woods, for example, we didn’t have America’s post-ww2 boom. We were too busy industrializing from a mostly agrarian pre-war economy while also building a new country on the ashes of the old country (we had a civil war on top of the ww2 occupation thingy).
La Banque Postale actually has a toggle button to make the computer read the code out loud as you type it.

It's no big deal... you'd need to be blind to miss someone nearby listening in!
This is exactly the kind of cringe-inducing content that I'd expect from a "PM career coach."

You can communicate understanding of the business without falling into BS slop.

Truly senior people have made such significant and real contributions that (a) their resume is mostly an afterthought and (b) the story
Rail prosecutions: The six minute train journey that became a legal nightmare
This thing might also be usable in the datacenter as a KVM console that can sit in a rack shelf or be carried around by technicians. It's certainly more compact than the typical monitor and keyboard on a rolling cart.
Google accounts are not a commodity.
Love this comment. Saw over and over again at Google that a lot of people can learn the latest correct thing to say, get a job, and coast on a trillion dollar behemoths standard growth mechanics. (case in point: me)

There's always that tension, but IMHO I watched it tip over into something ugly over 7 years from 2016 - 2023
I tried out Zed and really like it, but its still lacking things like EditorConfig support, so project switching sucks. Has strong potential to replace vscode entirely if they don't get carried away with fancy features
IMO the pendulum swung too far with Rust. The experience is better than C++, but the template generics system is not very powerful. They ostensibly made up for this with macros, but (a) they're annoying to write and (b) they're really annoying to read. For these reasons Rust is much safer than C++ but has difficulty providing fluent interfaces like Eigen. There are libraries that try, but AFAICT none match Eigen's ability to eliminate unnecessary allocation for subexpressions and equivalently performing Rust code looks much more imperative.
Does Syncyhing uses a third party relay, or coordinator server?
I wonder too if the data collected via that subscription is useful to monetize somehow? Maybe like health data from your watch?
He said this is for leadership position, so obviously he didn't do it all themselves. The leader is telling you they're capable of leading a team that can achieve things like that. Finding people who can lead well and reliably is a lot harder than finding people who can just do a job.
One answer may be that it’s not that slow for everyone. It could vary with the kind of computer you’re running it on, or what languages you’re using it for, or the size of the codebases.

I’ve seen people complain all the time about how slow VS Code is, and I haven’t really had that issue on an M1 Mac, at least not since some major perf work in VS Code a few years ago. And I know what a fast editor is — I’ve used Helix and minimally-configured Neovim for years.
Except, as I understand it, the collaboration features were one of the primary things they wanted to do with Zed. So this isn't a case of bloat. The first blog post on the site is "How CRDTs make multiplayer text editing part of Zed's DNA".
Don't people already have their laptop if they're planning on bringing a device with a screen+keyboard? I can see it as useful for a dedicated raspberry-pi screen and keyboard, but the adapter board looks easily broken if you move around with it.

I'm excited to see the row is keys on the right with Home, pgup, pgdn and End. Very useful for someone who spent their early computing years on non-gimped keyboards. I had a laptop with that layout in about 2009, was easy to adapt to.
How much money are people spending on toilet paper? Worrying about cost per wipe seems like one of the least economically productive things one can do.
Dictators and tyrannical governments are perfectly able to make their own tools. Hitler didn't need to edit an existing law allowing the government to kill Nazis, to target Jews and gypsies. He didn't need an existing law giving chancellors unlimited powers. He simply wrote those laws he needed, then used them. If the government prior to his one had a law giving Nazis the death penalty, it could have saved a lot of lives.
The format of the system prompt and the question is highly dependent on the model itself. So when using a model, it is of utmost importance that the system prompt and any interaction with the model follows its training.

The interaction flow and the model being used for that flow should be a dynamic construct, not a static one.

Lets say you have 10 different ways you could perturb a prompt and some of those are pathological, meaning extra punctuation or the lack of a newline gives non sensical outputs. How would I "rewrite" my application to account for that when changing a model?

Given that new models are coming out so quickly, what affordances does your framework have in targeting the same application at a different stack of models?
Skill of the Week: Use Chopsticks Like Mr. Miyagi
It's not the same as a non-micro-library, because a non-micro-library is a bunch of internal code that isn't as well-documented and isn't self-contained, and maybe come and go as the non-micro-library continues to churn. I can't easily change a large monolithic library or project do better optimize for my use case. I could do that much easier though if the large thing was composed of a bunch of small self-contained things.
How would this be different from, say, https://www.reddit.com/r/problemsolving/, or https://www.reddit.com/r/problemhunt/?
They probably should have the option to change the tab size on an open file, but my point is, why wouldn't you have autoformatting on for YAML and JSON? You have a preference for indent size, and you want the same for every file, barring an edge case.

"languages": {
"JSON": {
"tab_size": 4
},
"JSONC": {
"tab_size": 4
},
"YAML": {
"tab_size": 4
}
}

Edit: Yeah I see your point when you are not in control of the project and have to stick to someone elses style, I guess that only seems like an edge case to me, but could be normal for other people. In that case you would want a convenient way to override your formatting settings, like an auto detect indent button that only applies to the current open file.
> having a 1 billion dollar facility including its workforce doing nothing 70% of the time is expensive

We work normally only about 33% of a day.
It's not a password, it's an encryption key. You don't want to use a password because if you can derive a key from the password it means there's one key per password. You can salt them but then the server can crack your key because it's exactly the same complexity as cracking a password (since the server has the salt).

If you're doing e2ee, anyone you chat with needs to exchange key material with you (like diffie-hellman). Your private key decrypts messages sent to you, while the public key that you share encrypts messages that can be decrypted with your private key.

The process has little to do with authenticating with the server, it has everything to do with exchanging keys with the people you talk to. And you can't just trust the server to do it, since a malicious server could just send its own public keys to the chat participants and man-in-the-middle the conversation.

If you want to use Signal on your laptop instead of your phone, your private key needs to get to the laptop without going through the server. You could encrypt it, but then you need to encrypt it using a key derived from a password or PIN, and now you have the same problem as before.
I wonder if this inspired the VMWare VM record-and-replay functionality that came out in 2008. They discontinued it in 2011, but it's important to me because we used it at Mozilla to great effect and that made it easier for me to get Mozilla to support the development of rr, which started in 2011.
It's foolish to judge someone from a single statement. Give them something to do and see how it works out.
This is kinda what I always wondered about these "show the numerical impact of your work" stats.

How exactly do you know that? Unless you're a manager or something, how do you know that the company got say, 30% more users and 20% more repeat views after they changed the sign up process?

For an awful lot of companies, the tech department flat out doesn't know what the stats are like for their site/app, or care enough to track the direct impact of their work.

Is that a good thing? Absolutely not, but it seems like a depressingly common one nonetheless.
Show HN: Dive into Transformers and LLM World – Llama 3.1 in Go, Step by Step
Hi HN!

I’m so excited to show the updated version of my latest open-source project here. The previous version was built for Llama 2 and was now updated to support Llama 3.1 8B-Instruct model.

If you are curious like me about how the LLMs (Large Language Models) and transformers work and have delved into conceptual explanations and schematic drawings in the sources but hunger for deeper understanding, then this project is perfect for you too!

You will not only find the details of the Llama architecture but will find explanations of a wide variety of related concepts in the documentation directory. From reading a Pickle, a PyTorch model, a Tiktoken tokenizer model files at byte-by-byte level, to the internals of BFloat16 data type, implementation from scratch of a Tensor structure and mathematical operations including linear algebraic computations.

This project was initially started to learn what an LLM does behind by running and debugging it and was made for experimental and educational purposes only, not for production use.

The goal is to make an experimental project that can perform inference on the Llama 3.1 8B-Instruct model completely outside of the Python ecosystem (using the Go language). Throughout this journey, the aim is to acquire knowledge and shed light on the abstracted internal layers of this technology.

This journey is an intentional journey of literally reinventing the wheel. While reading my journey in the documentation, you will see the details of how Large Language Models work, through the example of the Llama model.

I will be happy if you check out it and comments are welcome!
Code and documentation: https://github.com/adalkiran/llama-nuts-and-bolts

And now, the documentation is available on Github Pages: https://adalkiran.github.io/llama-nuts-and-bolts
you just equivocated / moved the goalposts on that climate comment. are you a software engineer at Union Carbide?

also would you point out an example of ProPublica being as grossly unscientific as you claim? i'll wait
Very true, but that's why it's important for GOOD leaders to know how to sell themselves, so we can push the monkeys in suits out of the way. Learning how to talk about myself in a way that really communicates with business people is the single greatest aspect of my career success. Yeah, I'm smart and highly capable, but that's useless if I can't get in the door.
How Google Search Ranking Works
I agree, the only people I would take this pitch from would be ex-founders or at least a CXO or the head of the business unit .
Things are obviously not as simplistic. The left was also promoting something new: the renewable and less consumerist society where people are less wasteful with energy and more conscious about not screwing up the environment. Nuclear is an appealing option for people who want to maintain the consumerist society and/or avoid calling into question the fact that the current ways of working may not be ideal.

I think the right was both okay with nuclear, but still also sympathetic to coal and gas industries.

Also, not sure that "conservative = against something new" is the correct understanding of the usual definition of the conservative. The conservative is usually to maintain the traditional balance of power where bosses get the big slice of cake. If their rich friends are coming with something new that profit to the communities currently in power, the conservative is usually totally up for it. And if we are currently in a situation where the cake is more equally distributed, they usually are totally for new things that re-give power to the previous elite (it looks "new", but the goal is to come back to what existed in the past).
I don't get how rr isn't more popular.
chiming in to say VLC is the best audio clip player I've found. every time in past I surveyed the space all other options I tried had one or more showstoppers like too buggy or not the right API. VLC (and driving it via either Golang or CLi) has been reliable, decently documented and ultra configurable.
What hits hard is realizing that most features are not worth it. They just shouldn’t be developed.

Unfortunately biznes wants features and more of them and if possible for free.
Well to be pedantic, if I'm in a car and I'm "starting to overtake", I'd still be behind the overtake "target", but I just started speeding up...
We had a Snoo for our kid. I cannot see how anyone knowing our kid was a poor sleeper when he was born, and improved over six months, would be worth anything to anyone. “Parents are sleep-deprived” is a pretty well-known fact at this point.
From the repo:

> This is amazing. Started as a small project just for myself, it now has > 15,000 lines of code, > 600 versions published, up to 8 mio downloads per month, > 300 mio downloads overall. #1 NPM ranking for backend packages. Thank you to all who contributed to this project!

It's fair to blast Discord here, but not the library's authors. When you want "production code", maybe do better* than npm-installing a project with lifetime donations of, let's see, $624.

* Like donate, audit and upstream improvements, or build it yourself from scratch.
Micro libraries are fine (well... not really), the problem starts when each of those depends on 10 more "micro" libraries and so forth. The branching factor quickly leads to bloat. Libraries have a duty to minimize their footprint in ways that applications do not.
Interposer to fix the Symmetricom SyncServer S200 GPS week rollover problem
You aren't the target audience. To the target audience (professional bullshitters) it signals you're part of the in-group.
I came very close to buying a similar device recently (Nexdock), but ultimately decided against it. I mostly work from home on my desktop computer, and only very occasionally need a portable computer. Since I own a SteamDeck with a plenty strong CPU, lots of storage and a fully functional Linux environment, it felt like such a silly waste to need to buy a whole laptop, when all I really wanted was the keyboard, trackpad, and screen.

Ultimately decided against it though, and got a Framework 13 laptop instead. Less fuss to use it rather than fiddling around with connectors and lugging two devices around in tandem. I also hope that Framework's modular approach means that this laptop won't have been a wasteful purchase and I can keep it as a 'laptop of Theseus' for the next decade or so.
Google's Pixel phones are usually known for having good security (from on-device hardware to fast and long - 7 years - security updates). And in this case you'd able to install the app even if it was banned from the official store... and no, my grandma never sideloaded malware, she uses the Play Store like everyone else.

It doesn't sell as well as iPhones or is only available on a small number of countries, but that's a different question. Most people don't buy iPhones because their security is good... they just want an iPhone.
Heh, I saw this thread just recently:

https://www.reddit.com/r/webdev/comments/1euwht3/webstorm_is...

Most discussions I've seen, including that one, say that VS Code is slower than most lightweight text editors but faster than most IDEs (including WebStorm which is IntelliJ). I don't personally have experience with IntelliJ, but in my experience VS Code is very noticeably faster than Eclipse.

That linked thread also mentions that compared to IntelliJ, VS Code has better remote development, a less cluttered UI, better support for multiple languages in one project. And _many_ people mention the better performance.

Personally, running an open-source project with a lot of contributors who are young or from third-world countries, it also matters a lot that VS Code is free.
This would be so immensely useful. I’d estimate that there are so many cases where the producer is Node or Rails and the consumer is Python.
> text rendering is done using the DOM.

And most of the animations, and layouting. So "only" all the performance hotspots.

> Every program on your computer is GPU accelerated in that sense.

No, not really. At least not on win32 and anything Linux/BSD-y, some toolkit( version)s can do it, but that by no means implies every program uses it.
Tell that to my wife (:
For me it was the diversity. Even though the machines themselves were similar, some did some things a lot better than the others. Some had ridiculously fast disk IO (the Suns, usually), some had silky smooth mouse movements (the SGIs), and so on. Also, there were the different GUIs - I loved Sun’s OpenWindows - and SGIs could use better font smoothing (but only NeXT was doing that back then).
Ideally it should be on the server side, so you're right there. Client side A/B testing isn't the best way to handle things.

However, it's sometimes a necessary evil due to:

1. The original company not budgeting time/effort from their existing dev teams to work on A/B testing, and wanting to outsource it instead.

2. Said company and their tech department being nervous about letting outsiders actually access the source code for their site/app.

3. Or said company wanting the analytics/features that VWO/Target/Optimisely/whatever offer, and not wanting to have code up the same analytics toolbox themself.
Not everyone owns a laptop, nor do they really see a need for one very often.

Phones and other devices are plenty powerful these days for most tasks most people are doing on laptops. The input format is the only reason most people own them.
Surprised me too..
Why would the hacker care about that?
Very expensive industrial facilities don't.
Machine Learning Meets Ketosis (2016)
My understanding is that the attention in all transformer layers is "causal" - that is the output of a transformer layer for token N depends only on tokens from 0 to N.

This means that every attention layer can use previously calculated outputs for the same prompt prefix. So it only needs to calculate from scratch starting from the first unique token in the prompt sequence.