skysight-inc/HackerNews huggingface dataset:
It is possible to move foreign keys and other constraints and consistency checks into the application. But that comes at a huge cost: Either you need to be generous with your use of transactions to ensure that no invalid state is ever written, and your application has to know and use those transactions. Which is something application developers in my experience often fail at. Or you have to accept that broken inconsistent data is a fact of life that can happen at any time, and will increase in times of high throughput and concurrency (where the business part of the company will care most about things running smoothly). Also, you will limit yourself to exactly one application using the database, because otherwise you will have to duplicate your constraint logic in any application precisely.

There is also a cost of doing constraints and consistency in SQL, the language is somewhat limited in what you can easily represent (anything is possible, but only some things are easy). And the handling of violations still needs to be implemented in the application, which often necessitates at least some duplication and fiddling to e.g. get friendly and useful error messages.

So imho, yes, SQL has its problems, but it is still the lesser evil in almost all cases.
Anything with Musk's name attached to it is also in danger of getting hit with bans and sanctions if Musk and the current US government keep operating as they've done since the inauguration, so I'd also see that as a risk with regard to availability of those services outside the US. Apple is pretty good at keeping their products out of political crossfire but Musk seems to pretty much be seeking trouble these days.
Found a Interesting Decentralized Rust Framework
Planned range for the Boom Overture is 4900 miles, so only a little better than the 4500 miles of Concorde, which occasionally had to make a refueling stop going westward over the Atlantic. So it won't have the capability for transpolar or Trans-Pacific flights.
Well, you said "many of". I thought you meant "a significant fraction of", not "at least a tiny fraction of".
The point here is that theoretical economic analysis presumes labor surplus. Academically trained economists do not, at the most basic level, understand or know how to reason about an economy that is not in labor surplus: it simply baffles them. The only policy recommendations that they can formulate reduce to "first create a labor surplus so that we can apply the formulas that we were taught."
I believe this knowledge is more common in Europe, less in US. People have no idea what all those populist powermoves by Trump actually mean. I see the US as a fallen country.

To strengthen your statement, people in the US also seem to forget that China has done some major investments through the Belt and Road Initiative (BRI). It has secured influence in 150 countries through massive infrastructure projects (roads, railways, ports, digital networks).

The US is excluding itself from the world. Quite literally.

Goeiemoggel
Neanderthals Kept Our Ancestors Warm
I don't recall a whole lot of "white lives matter." Rather a lot of "All lives matter."

Though I recall a lot of people treating the statement as if black lives were not included in all lives. Including ascribing intent on people, even if those people clarified themselves.

So to answer your question: the reason many didn't move on is because they didn't want to understand, which is pretty damning to moving on.
Definitely not everywhere. Starlink cares a lot about national borders, neutralizing the one major advantage it has over most other internet access technologies. This just begs me to say "you had one job".
I don't see people cancelling their Netflix subscriptions in a downturn; quite the opposite. Libraries could give very good value for money.
It's absorbed through the skin, so that doesn't actually solve the issue of having it in your body.
Module authors generally have fairly large test suites which are run often- sometimes on each file save. If you have a 1 or 2 second build script its not a huge deal. If that script starts taking 30-60 seconds- you have just hosed productivity. Also you have massively increased the load on your CI server- possibly bumping you out of a free tier.

The fix would then have to be some variation of:

a) Stop testing (so often)

b) Stop bundling before testing

c) Publish to a different package manager

- all of which would affect the overall quality and quantity npm modules.
Do not attempt to mill your own lumber for your own house. Unless you are building a log cabin in BFE Alaska where you can't truck anything in and need to remove the trees anyway it just ain't worth it for the labor you'll have invested.

Second, blocks and bricks are a massive f-ing waste of labor when working as an individual since you have to handle them so many times. It's worth forming up 10yd worth of stuff and paying for a truck.

You can probably get it done under $30k if you are super cheap and only buy materials at auction and buy used tools.
FOSDEM Hospitality Tips from a Local
here are a few tips :

Our languages are FR,NL, DE but... English is widely teached and learned. There is a good chance you will be understood.

Will you be safe ?

Quick answer : 99% yes, but.

Longer answer : say you're sitting in a bar, sipping a sample of belgian beers and need to pee or poo ? Don't leave your precious smartphones, laptops, etc unattended. Use common sense, don't flash jewellery or valuables too much especially in the touristy area (around grand' place)

Emergency ? Call 112 (european version of 911) - there's an app for that : https://112.be/en

Area around Aumale metro station has recently grabbed the headlines recently by means of drug-gang on drug-gang violence and shooting. Don't book your AirBNB there.

How to get there :

- your STIB/MIVB single ticket allows you to travel as much as you want on all bus, tram, metro lines during one hour

- you can pay with a credit card, Bank card, smartphone or smartwatch as shown here : https://bx1.be/categories/news/la-stib-propose-le-paiement-sans-contact-avec-une-carte-bancaire-ou-un-smartphone-des-le-1er-juillet/?theme=classic - Tickets are either 2.20 euros (valid 1 hour) or 8 euros (valid one calendar day). Details here : https://www.stib-mivb.be/buy/your-bank-card-is-your-ticket
- you need to validate your ticket to access the stib-mivb network. Metro-stations : you validate at the sliding metal gates. Bus/Tram : you validate by swiping your tickets at a red box. Just follow the locals' lead.
- Do not expect orderly queuing at bus or tram stops.
- In most stib-mivb vehicles an automated voice will tell you the name of the next stop

Bus 71 : the stib-mivb line carrying the most passengers. Expect some company while riding the bus with "Delta" written on the screen atop the windshield from the centre to the Fosdem Location.

On the spectrum ? Claustrophobic ? Crowd-phobic ? Ride the Metro line to the Delta Station and board an empty 71 Bus with "De Brouckere" on the screen/ as destination.

Thirsty ?

Waiting staff receives a monthly salary and does not expect a tip. A little extra money is always a pleasant surprise so feel free to leave a tip.

Delirium cafe https://www.deliriumvillage.com/bar/delirium-cafe/ is in the heart of the touristy area and has plenty of beers to sample.

Brewdog just outside Gare Centrale.

Moeder Lambik has two locations : https://www.moederlambic.com/?lang=en

Lots of watering holes around Flagey.

Hungry for delivery ?

Order through https://www.takeaway.com/be-en (Uber Eat and other usual suspects available)

Hungry - restaurants

Flagey Area (a few bus stops from ULB) has a famous belgian fries fritkot and trendy eateries.

Rue des Bouchers is the tourist traps area where no local would be caught eating.

https://wolf.be/ is a trendy food market

In need of a bit of quietness ?

Cimetière d'Ixelles is about 500m from FosDem location. It is a cemetary with a who's who of 19th century luminaries - https://en.wikipedia.org/wiki/Ixelles_Cemetery

What to visit ?

https://www.visit.brussels/en/visitors (yes brussels has its own TLD)
> but my pending defense strategy was to download plain text copies of erotica novels and when I detect a chat bot crawler, just redirect it to that folder and let it go

Might I suggest https://tvtropes.org/pmwiki/pmwiki.php/Literature/BelindaBli...

As a bonus, beyond introducing the magic robot to the wonderful world of really poorly written erotica, it's also very anachronistic (widespread use of fax machines, pagers, smartphones, LinkedIn, and East Germany appear to coexist at a single moment in time), so will cause further confusion.
Diethanolamine:

General description. Diethanolamine (DEA) is an amino alcohol commonly used in the preparation of soaps and surfactants, agricultural chemicals and in textile processing. It is used as an absorbent for capturing CO2. Its toxic and carcinogenic effect has been studied.

Diethanolamine is widely used in the preparation of diethanolamides and diethanolamine salts of long-chain fatty acids that are formulated into soaps and surfactants used in liquid laundry and dishwashing detergents, cosmetics, shampoos and hair conditioners.
Congratulations! But does it support Google Account login? And ReCAPTCHA?
Sublime Text used to be my go-to editor when I didn't need a full fledged IDE. A rare gem in an arena of slow mammoths. I've since switched over to Lite XL, which is FOSS, just as fast (if not faster), and the plugins cover nearly all my niche use cases.

While I respect the effort that goes into creating quality software and am not averse to spending money, I'd rather not live in a world where the best softwares are closed source.
That's also why I use emacs. It was the first text editor I learned.
In my eyes, yes.

In Zed's case, it's already dependent on "Magik". It constantly downloads something to provide some functionality. I can't vet, follow, verify that thing all day long.

Moreover, if it wasn't doing that, again yes.

If they didn't provide the functionality to begin with, then they can move on to "let's evaluate whether it's acceptable" phase.
The most likely path to jail probably involves putting a bullet in a problem neighbor or government official rather than an accident of any sort.
Stop following the news? My recipe for success for 10 years now and counting. The news is meant to elicit views, clicks, and emotional reactions. Why would you subject yourself to that on a regular basis, or at all?
DeepSeek, AI Sovereignty, and India
'Super pod' of 1,500 dolphins cavort off California's coast
i believe it is related to the capabilities of the touch screen itself. something like "if no multi-touch available, fall back to the pan/scroll interface" makes sense to me.
That's what I'm thinking as well. Spotify ain't great but it's fine. Some people are recommending Apple Music but Apple Music don't even have a client for Linux and their website is awful. OTOH, I can use Spotify even through my terminal.
Nobody is building death traps to live in as their own home. The people who are only on a deathtrap budget are not engaging in those projects, they're renting. The people building death traps are slumlords dividing shit and fly by night contractors and flippers altering things <screeches in open floor plan>.
> Why anyone would think some future sentient AI would concern itself with what you did in the past with your software bots or chat bots??

This is some version of one of the more ridiculous things that has been thrown up by the nerd new religious movement on LessWrong and similar sites: https://en.wikipedia.org/wiki/Roko%27s_basilisk

(It's somewhat unclear to me whether anyone actually believes in this, but some of the more fanatical AI-will-change-everything people _seem_ to more or less accept the premise.)
jQuery is the WordPress of Javascript. It will never go away no matter what anyone says.
Hot take: there are no legitimate use cases for human face transfer.
This is similar to how I use Kate on Windows. The configs can be somewhat complicated but it is very flexible and nice to use.
£16 billion in inflation-adjusted development costs is peanuts.

You should look at the costs of the F-35 :)
I don't think that matters here. The involved public stations have their board regularly appointed by the government, this is just the outsourced collection agency with weird rules that keep on changing.

If it was included in the tax you'd not have to fight for an exemption as a student for example, or if they wrongfully want money if you live with someone who is paying.
> Who'd pay that kind of money today for a commercial flight?

People willing to throw money at connecting with others who do the same thing. That was the main value proposition back then I think, getting from continent to continent in a short time has never been more than a tangential benefit. Of course this type of business only really works when everybody involved claims the opposite.
Show HN: TUI Bluetooth Connector for Mac
Hi,
since sometimes my AirPods didn't autoconnect to my Macbook and I didn't want my hands to leave the keyboard. I looked for alternative solutions to quickly connect devices.

Found [blueutil] for MAC, but was not happy with writing long commands, so I build a pretty minimal inline TUI application on a beautiful saturday to:

- display paired devices

- pair/unpair devices

- connect/disconnect devices

- search devices

Ive used [textual], a very nice framework to create TUIs with python.

You can find the gh-repo here: https://github.com/Zaloog/blueutil-tui

Direct use with uv via:
`uvx --from blueutil-tui btui`

[blueutil]: https://github.com/toy/blueutil

[textual]: https://textual.textualize.io
It seems right now, assuming you're in the test (is anyone that is not working for Apple?), an emergency button (no voice, no text, no nothing, other than the fact that you pressed the button and a location, not sure how accurate) (I guess maybe it's as featured as the Google feature)

MAYBE in the future text messaging service. Text only.

Note: Text messaging currently actually works on some Samsung phones on T-mobile, if you request to join the beta.

https://www.pcmag.com/news/t-mobile-begins-cellular-starlink...

Emergency SOS over Starlink works on recent pixel phones, which appears to provide text chat with emergency services:

https://support.google.com/pixelphone/answer/15254448?hl=en
Typically, in the Weblogic days, session cookies were used to hold a server-side session containing the app state. If you just hold auth data in the session this is not a problem. But if hold state like form data in the session it becomes a huge source of errors. Virtually all non-trivial web-based applications had these issues 20 years ago (before „Ajax“). J2EE servers like Weblogic even supported stateful EJBs that brought server-side state to a new (insane) level.

While you could theoretically use JWTs for the same purpose, they are typically only used for authentication. And back then JWT wasn’t a thing.
I came here wondering if I am the only one not knowing what Diethalothingythings are. Thanks.
Pretty obviously.
Very soon all my memes will come directly from the edge of space and I think that's nice
for export! ffs
Wouldn't shock me if openAI was secretly building a "motives" classifier for all chatgpt users, and penalizing them if you ask for too many censorship related topics. If you randomly ask for Palestinian moon base, that's fine, but if you had historically asked for provocative pictures of celebrities, mickey mouse, or whatever else openAi deemed inappropriate, you are now sus.
You wouldn't ask a rabbi about the New Testament or an imam about the Torah and expect unbiased responses. So why ask a CCP-influenced LLM about things you already know you won't get an unbiased answer to?
The Phenomenon of No-Performers
Ha, that's amazing.

I wonder what's a way to detect ADs just from audio. Maybe by volume?
Yeah that's pretty typical. Every city has at least a few of those rich suburbs full of jerks that run the town that way. I bet they probably have a bunch of police policies that amount to "harass the crap out of anyone who can't just pay for compliance with everyone" too.
How about using QuickJS instead of full-blown V8? For example, Elinks has support for SpiderMonkey, QuickJS, MuJS: https://github.com/rkd77/elinks/blob/master/doc/ecmascript.t... and takes a few MB of RAM.
Now replace questions about Beijing with Washington in the prompts, and try Bing CoPilot, it also censors them.
Having just updated a project to use a newer version of the OpenSAML libs, this x1000. How something so fundamental can be so badly implemented (and documented!) is just mind-blowing.
Stop asking about the costs and think of the benefits, you as an American, being the center of the world your whole life has received from US influence and economy power?

Strange thing to be asking honestly.

America is home to over $750 billionaires who would be paying zero income tax. Personally I think that should be what changes.
At this moment this is what my system usage looks like:

https://imgur.com/a/yCk2YDq

This is with me running:

- Several browser windows

- Multiple Visual Studio instances (with ReSharper)

- Several Electron(-like) based Applications

- Outlook Classic

- Slack

- Teams

- Docker Desktop

As is plain from the screenshot, there is not MB/s of network traffic, furthermore, the CPU is also pretty idle as one would expect from my not doing anything heavy (like compilation) at this moment. This is very typical for my PC most of the time.

Based on my decades of using Windows full time and my screenshot, your comment is absolutely not representative of typical idle resource usage.

I do however acknowledge that there is a recurring scheduled telemetry collection process which when it runs pegs an entire CPU Core for minutes. I do find this annoying when I notice it, but that's maybe every couple of months which isn't enough of an annoyance to me to waste my time worrying about it, or I might have actually already disabled it in Task Scheduler.

Some people on principle dislike telemetry which is a completely understandable viewpoint, but for me personally I'm okay with Microsoft collecting essentially anonymous usage statistics to better understand how people use their software and where best to direct their efforts.
Government agencies would use dedicated infra anyways. Don’t many European governments insist on EU segregated cloud providers or open source software to avoid having critical infrastructure be under US control?

And the US is an official ally, whereas China is not.
Hi, I'm a UK based founder. Recently exited a mental health startup, called Sanctus. We pioneered mental health support in the workplace here in the UK. I was very public facing, lots of keynote speaking, linkedin following, TV appearances and wrote a book with Penguin (Mental Health at Work).

I wrote an Entrepreneurship course with a University here and realised, I have a lot to give founders (and want to help).

The link is a draft coaching page I'm creating to support founders who are on the path, I've been on.

I'm noticing how I'm more averse to doing "Founder Coaching" and cringing a bit at it. A friend said to me, "that's a British thing" and another friend said to me to yesterday "you'd do so well in the US - the only people as open about their feelings as you are American"

SO, it's a long winded way of me sharing this here, looking for some feedback. I've always LOVED US startup culture and this forum is one of my only ways to connect.

Looking for feedback on:
- tone and authenticity
- proposition
- price
- anything that feels vague/unclear

Thanks!

p.s I once had a blogpost trend at the top of Hacker News for 3 days. That's my claim to fame. It was about mental health in startups, many years ago.
True about "formality" - especially for me, I use long-form emails as documentation. Screenshots, links, backgrounds, explanations - that if required, I can then later paste into a document. While I was "always like this" (sorry not sorry), it firmed-up when I was required as a roving "field engineer" to prepare end-of-day detailed status reports when onsite with clients.
I have had the same issue for about as long and it's been a bear of a time to get anything done with it. Kudo's to you for taking a trip to have a treatment that might work done! It is very hard to take a lot of initiative and keep pushing (at least for me) with long covid.
Not confirmed and the fact we do tax payer funded research is what stopped the situation from being worse than it could've been?
For the typical spammer, this was pretty good.

For the typical hacker or foreign service this went as expected. Just that they detected it very soon, so not much harm done. Only VPN
I was interested in the value that it brings you. I'm a former Sublime Text user and I switched to VS Code some time ago.

Do you also use Sublime Text as your primary IDE just like author does?

————

Mirroring the structure of the article:

1) Regarding the section about LSPs: do you also have the need to be able to “just add an LSP installed as a binary in on your usr/local/bin” even though by the author's own admission “VS Code is the LSP king”?

Kind of ironic to have the author say in the introduction about VS Code that “it probably has taken inspiration from Sublime. So why not check out one of the OGs” and then a bit later proceeds to say that the LSP “tech originat[es] with that editor [VS Code]”. I'm returning the question to the author and you: why not check out the OG?

2) Regarding the section about snippets author says that “VS Code can do this” and even that “the syntax for it is a bit nicer”.

3) Regarding workspaces VS Code does all of that. Author admits that he “ha[s]n't used it personally, so [he] can't speak to it much”.

4) Regarding build systems VS Code does all of that and it's easier because contrary to “the Package Control [that] is not part of Sublime” (and that you have to uglily inject in the Sublime Text console to get working), the VS Code plugin repository has everything already ready-to-use so that you don't need to reinvent the wheel. You can if you want though; Sublime Text doesn't provide anything extra in that regard.

5) Regarding the “Multiple cursors” VS Code has it as well.

6) Regarding the block-level key bindings, have you ever needed them? For me the last thing I want is for my shortcuts to change dynamically based on which block I am in the file. Note that in Sublime Text “they cannot be saved on a per-project basis”, which is awkward to say the least. I would (much) rather have project-level keybindings rather than only block-level keybindings that apply globally.

7) Regarding using “Python all the way down” rather than JavaScript, I'm surprised that the author finds it to be a good thing considering that they primarily use it for “web-dev” and all their examples are frontend Javascript code.

8) Finally, the author complains about the terrible documentation of Sublime Text, the lack of a plugin system, and the fact that for the 3rd-party hacked-together plugin management system he finds that getting them on the “Package Control site to be quite a chore”. I have a ton more complaints about Sublime Text to add on top of that.

I would rather directly donate money[1] to small developers rather than — as another commenter puts it — “supporting and using the products developed by a small team of dedicated engineers ...”

————

[1] And I do! Currently sponsoring 14 developers on a monthly basis[1]: https://github.com/devnoname120?tab=sponsoring
Aerospace is hard, one step at a time. Every generation knows that.
Initially thought Infrastructure As Code achieved this discovery.
I find this sentiment weird.

You don't want to pick low hanging fruit first?

You don't want to deliver value to the org fast?

You don't want to get the 80% solution done so that you can work on something else that needs more desperate attention?
America won a world war because Europe, Russia did a lot of the early heavily lifting of and because the USA was already an economic and industrial power?
Donald Trump asks Elon Musk to 'go get' NASA astronauts stuck in space