skysight-inc/HackerNews huggingface dataset:
They were testing (at a different scale, with a different powerplant) their air intakes for the engine which are designed to enable conventional turbofan engines to operate at supersonic speed, plus some control systems. And no doubt demonstrating to investors that they could fly something at supersonic speed before they ask for the funds to design and build a new powerplant and airliner-scale airframe...

It was originally envisaged as a maiden flight that would happen within a couple of years of founding, but aerospace is hard.
From the article:

> What you hope happens is that Postgres will recursively inline every view, merge them all together into a gigaquery, and shuffle the predicates up and down to maximally optimize the query. That was the conceit. And of course that never happens.

The author seems to be describing a Progress-specific problem. Oracle, SQL Server (and probably other "enterprise" databases as well) are pretty good at inlining views and then optimizing the whole resulting gigaquery as if the views were not there in the first place.

> The central problem is that views have to be written for the general case, and then you filter on the view’s output. Views can’t take parameters.

SQL Server supports inline table-valued functions, which are exactly that - parametrized and inlinable views.

Unfortunately, they are not as composable as they could be. For example, a function returning table and a function accepting the same type of a table as input cannot be directly composed - you'd first need to store the first function's result in a temporary table or table variable. But despite the limitations, functions are extremely useful for constructing complex queries which reuse logic.
The reason being the interstellar medium is way less dense than we thought in 1960.
A large fraction of code I write at work is either network protocol reverse engineering or interfacing with physical devices. Peeling stuff open layer by layer is often the only way to approach a problem and if I had to document everything beforehand, I would end up writing the same program twenty times.
I could have been clearer that both descriptions were meant to be or statements.

Fast rivers or wide rivers are challenging, the former as they're inherently treacherous, the latter as they're difficult to bridge.

Narrow rivers can be bridged. Slow rivers can be traversed by boats, ships, barges, etc.

Yes, wide rivers tend to be slow, and narrow rivers tend to be fast, all else constant, but all else is rarely constant such that there are narrow slow rivers and wide fast / treacherous ones.
AIs are new search engines today. So, you need to decide if you want visibility or not. If yes then blocking is like hitting yourself in the balls. While legal it can be painful if you 'succeed'.
Same here lol! I ask it to write in bullet points every time
absolutely loving SublimeMerge!
Starlink probably takesover from the Core [0], while T-Mobile provides Radio Access Network.

[0] https://5g.systemsapproach.org/core.html
Yes, this always struck me as completely bananas. Types are a vastly superior form of test for certain conditions.

Duck typing with type inference would be nice but seems to be completely esoteric. You could have both the flexibility of being able to write "func(arg)" without having to specify the type, and the constraint that if you call arg.foo() in your function the compiler should enforce that you actually have a foo method on arg.

(special side-eye to the people materializing methods and properties all over the place at runtime. This seems to have been a rails/python thing that is gradually going out of fashion.)
Expand to OIDC and use session based mechanism with some kind of policy engine?

Never saw a good example of how to implement a proper access to pdf or other downloadable documents.

What is your approach? Any good code base in open source to learn from?
Tackling the C++ debugging UI nightmare with Pernosco
A response to the excellent recent Core Explorer blog post about why debugging C++ specifically is a UI nightmare --- explaining how some of the highlighted problems can be solved with a little creativity.
Yes, absolutely. I am just working on a new one built on my template Business Class which stays very close to Rails defaults. I really like all the 'small' things that aren't actually small like Action Text, Active Job, Turbo. And I deploy with Kamal too, ofc.
Configuration changes. With immutable image every time any parameter changes you have to rebuild and re-deploy image which looks like a waste of resources - to change even 1 byte you need to re-build and re-push an image (which could be a multi Gb one). Then restart a whole cluster which depending on the application can be either costly or disruptive (in case of long lived network connection, on in case if you have a database). And sometimes you need to change configuration parameters many times per day.

What developers tend to do when forced to use immutable infra is to move configuration from on-disk files to RAM and query it using network API from a central system. The problem is that it makes systems less reliable. If a VM/server restarted it can practically always read a config form disk but if you service relies on an external system to get runtime configuration it would not work if this external system is down, overloaded, misconfigured, returns wrong config because of a bug e. t. c. And it does happen in practice even when system designers tell they configuration API is very reliable (in theory). After seeing such systems fail I like simple on-disk configs more and more.
I went and did my own testing with a trivial exercise: https://news.ycombinator.com/item?id=42863228
Matrix itself is extremely solid. The most annoying thing are the clients. Element is the only decent one although it still is far from perfect. As for the freedom vs polished service, it's a no-brainer for any organization because with matrix they have the full control over the data and the service
I wanted to copy out the "1 EUR = 0.961498 USD" part but once I end the selection (by releasing the mouse button) it selects the currency tile making the text selection go away.

I think a solution could be to make it non-selectable (as it works like an app) and instead provide a button to copy the information to the clipboard.
> Got any recommendations?

Find a good ORM that allows you to keep things at the "set logic" level for as long as possible and has a good internal query representation. Avoid or turn off any fancier features of the ORM like "navigation properties" or "implicit subtyping" or automatically detecting changes or anything that happens "magically" in the background: prefer simplicity and being explicit about everything. For C#, this is EntityFramework with most of its features turned off -- compose queries by joining IQueryables together, and only drop down into in-memory iteration when you have to.

If that's not available, I'd probably look for a library that presents a structured representation of the SQL abstract syntax tree (probably a subset) as an object, along with a translation to the various dialects. Pass those ASTs around and compose them together. I'd probably slowly build abstractions on top of this that eventually look similar to what I described in the first paragraph.
> China censors certain posts, the US banned a whole platform.

This statement implies that China does not ban platforms. This is false. China bans Facebook, Wikipedia, Google, Netflix, Steam, LinkedIn, to name a few.

Source: https://en.wikipedia.org/wiki/List_of_websites_blocked_in_ma...
DeepSeek R1 Appears to Be a CCP Cyberespionage Stunt Involving Possible Murder
DeepSeek R1’s rise may be fueled by CCP-backed cyberespionage, illicit AI data theft, and a potential cover-up involving the death of former OpenAI researcher Suchir Balaji.
Hi HN! We’re excited to launch JanusPro-AI, an open-source multimodal model from DeepSeek that unifies text-to-image generation, image understanding, and cross-modal reasoning in a single architecture. Unlike proprietary models, JanusPro is MIT-licensed and optimized for cost-efficiency—our 7B-parameter variant was trained for ~$120k, outperforming DALL-E 3 and Stable Diffusion XL in benchmarks like GenEval (0.80 vs. 0.67) 25.

Why JanusPro?
Decoupled Visual Encoding: Separates image generation/understanding pathways, eliminating role conflicts in visual processing while maintaining a unified backbone 2.

Hardware Agnostic: Runs efficiently on consumer GPUs (even AMD cards), with users reporting 30% faster inference vs. NVIDIA equivalents 2.

Ethical Safeguards: Open-source license restricts military/illegal use, aligning with responsible AI development

please checkout the website: https://januspro-ai.com/
Always love seeing WebGL and CSS tricks. Have you played around with using WebGL-generated content in things like PDFs? I’ve seen some interesting use cases where people render complex charts or visuals in WebGL and then export them to PDF for reports.
TFv1 or TFv2? AFAIK it's batch-first in TFv2
Matrix Calculus (For Machine Learning and Beyond)
> I think it's a dangerous philosophy for professional work. You know what happens to code that works? It ships.

It's worse than that this happens to code that appears to work.
But of course people who work on "prototypes" don't code for robustness, they code for "delivery time", then of course when you ship the prototype, the result is ugly..
And this is why OIDC and IDPs exists to expand more with nonce, user agent footprints and other validation mechanisms
https://archive.is/QA7qZ
What does this actually mean in practice? Internet service everywhere even when out of range of a cell tower? Does it work indoors?
The slippery slope is a legitimate risk consideration as often as it’s a fallacy.

We already have laws about toilet flow rates and lighting types in the US, and other countries have more.
I completely lost taste and smell around 2022 too. It wasn't like a clogged nose, I could absolutely not sense anything with my tongue and nose (except for touch). I read stories about it not coming back for some people and it absolutely shook me. At that moment I realized how much I love delicious food and that smell is a great indicator for things you might not expect (e.g. heat).

It luckily fully came back in my case, but it took many months. But it was properly scary! So weird that a viral infection (that didn't even make me very sick) could have such long-lasting and potentially life-altering effects.
I guess you've carefully examined the literature on this topic and decided that contributors reporting positive results are either deluded or charlatans.
> Its distance from its star changes significantly, causing the planet to move from the outer edge of the habitable zone to the inner edge throughout its year

Too bad that the year is relatively short. If it were hundreds of Earth years that could be like Helliconia https://en.m.wikipedia.org/wiki/Helliconia
> The judges should apply the law, and the same case should ideally lead to the same verdict regardless of the judge.

hmm.. :) I like this. But the reality is very different and some factors which shouldn't matter can change the outcome dramatically. Like skin colors of defendant and judge. Pointing this out can be punished as well.
Reasons Meta will struggle with community fact-checking
my guess the idea and intension of .well-known was good, so generic end-user libraries can be implement ... the reality is ugly and generate lot of man hours for cyberops consultancies
Show HN: AI Personal Financial Advisor – TestFlight Beta Available
I’m a solo developer on a mission to create an AI-powered personal financial advisor that’s accessible to everyone and provides real value. This is the MVP version, and I’d love to get your feedback!

Test the App: The app is available on TestFlight, and anyone can try it out now.
Feedback Matters: Your insights will help me refine and improve the app. As a thank you, testers will receive lifetime access plus future rewards.
Contact Me: If you have any feedback or questions, feel free to reach out at aymanov913@gmail.com.

Looking forward to your thoughts—every bit of feedback is incredibly helpful!
I agree and I do use Vim for all quick edits I need. Just wanted to challenge the idea that Sublime Text was better than alternatives in the space of GUI text editors
There is also the Lit approach which really doesn’t have any meaningful misalignments with the underlying web platform primitives and allows people to have the same developer experience without the trade offs.
> Then they pivoted to "Open source with closed source collaboration servers" thing, and they claimed rights on anything passing through their servers (collaboration / zed-ai).

Does this apply if you use it same as Sublime? That is without collaboration / ai.
So is there a straightforward solution to keeping this out of our system and we just...don't?

"Where is this diethanolamine coming from? Well, it's not known to be a natural part of either human or bacterial biochemistry. Instead, it is an industrial contaminant, sadly, whose ability to be incorporated (at low levels) into animal and human lipids through the apparently-not-so-picky enzyme cardiolipin synthase has been confirmed for decades now."
+1

My phone is ideally for

- Call

- Text messaging / WhatsApp / Discord of few groups, etc

- Alarm clock

- Taking pictures or videos.
(Likely family oriented)

- Booking tickets - document, shows, travel
(the main reason I have email setup on my phone)

- Travelling - Geolocation / map (gmaps, etc)

- Exception: Internet if working on laptop with no internet (ie in cafe)
(This could also be youtube videos or similar)

If smart phones were banned tomorrow then my life would not change that much. The above is mostly for better convenience of what is other methods and requiring a some paper or printer, etc.

I do wonder what the percentage is today that rely on their smartphone (even if not serving a decent purpose other than "social") and struggle with daily life if a ban started tomorrow.... waking up to no smart phone.
I think it will be pretty high even for people in their 40s. Its rather sad.
It’s arguable that even the stuff we consider to orbit the earth like the moon is really orbiting the sun.

MinutePhysics did a great video on this: https://youtu.be/KBcxuM-qXec?si=VngVwXeRKFPjnh15
You could _do that_?
felony interference with a business model, if i had to guess
Robots are already in agriculture, they are using drones in Thailand/Singapore iirc.

Automation and AI use in these respects contributes to a far greater problem, the socialist calculation problem.
I think we agree. Transformations and views bring code to data (if you are willing to consider them code, which I am). Then when you say 'Distributed DBs where you could do processing on each node in code for example' it also sounds like exactly what I have in mind - code brought to data, not data to code.
Yeah, I'm also interested on this. I don't know, but my gut feeling on this is that no, you can't mix other audio or use a software volume control with DSD audio. It has to be converted to PCM first.

But, with Pipewire you _can_ play DSD audio, here's how:

https://wiki.libre.moe/linux/pipewire/dsd-playback

And yes, you need a DAC that supports it. They are not that hard to find though.

Edit: just noting I do not have hardware that can play DSD audio. The audio files started to be available, and there are shops that sell them such as High Definition Tape Transfers. Space is cheap, and if I would have them in my collection it would be great to play them with the best quality. Although, I probably don't hear the difference even with these Hifiman headphones, but it's the nerd in me that likes to see this to work.
I have been burnt out for almost three years now, was mostly bedridden at first but I can do much more now.
I can do moderate training 1-2 times a week, go out to get socialization 1-2 times a week and do much more at home.
So it have gotten better, just a very slow pace and it's really hard.
You have to learn to know when you have to rest and when to push yourself and that line can be super thin.
Not good to do too much and not too little, very hard to read signals imo.

Hopefully we will see more breakthrough in understanding and reading the signals of the body in the future
Vite does statically replace the `browser` variable with `true` or `false` based on whether you're on the client or server, but this shouldn't affect the correctness of your code. It does allow Vite to remove any unused code, however. E.g. `if (browser)` turns into `if (false)` on the server and any code within that block can be removed. This can avoid shipping unused code to the client.

Astro is also built in top of Vite and the same thing happens there. If you reference `import.meta.env.SSR` it is statically replaced during build and unused code is tree-shaken out: https://vite.dev/guide/env-and-mode#env-variables
Still does in CMD.exe
> "I never thought the leopard would eat MY face" sobs man who voted for the Leopards Eating People's Faces Party.

One of the all time great tweets. People might well want a chaos agent on their TV, because politics has become wrestling. They absolutely will not like it when the chaos comes back to them, which they have assumed it won't. Look at how many people were complaining about the price of eggs before the election; now watch how the US responds to avian flu with a nonfunctional federal government.
So could this hypothetically open a mail client on your iPhone and read your emails?
AWS: Top Architecture Blog Posts of 2024
There's a, community supported, Copilot LSP plugin for Sublime. It can be rough around the edges - but I tried it and it was enough to get me to buy a 1yr Copilot seat (at current pricing).

Completely understand if Copilot is enough to make people want to switch over - but for me it wasn't, and I don't feel like I'm missing out with this setup.
That would sound a lot like the languishing native STEM talent in the US if it weren't also for the fact that most of the DeepSeek team doesn't have PhDs.
Regarding "can't immediately think of how I would have worked bulk processing in a way that maps to this article think of how to map composibility" ...

I believe stored procedures where you construct dynamic sql and execute the results can basically provide the composability/performance described with bulk non row-based logic. If you keep it simple it can work ok.
The naysayers about LLMs for coding are in for very bad times if they don't catch up at leveraging it as a tool.

The yaysayers about LLMs replacing professional developers neither understand LLMs nor the job.
I am in the exact opposite boat - AI is significantly improving my programming flow and having to use VSCode (well, VSCodium in my case) rather than something lightweight like Sublime is suboptimal - I would love a good plugin for LLM integration ala Cody and frankly that's the only way I could see myself as a paying customer.
Setting up a reverse proxy with ssl is a decent challenge for people new to this
I agree that this particular aircraft / project has limited potential. What I am most excited about is the potential for advancement of the field that could lead to realizing the potential benefits in supersonic transport.

It’s like props vs jets. Jet aircraft were less efficient but faster… until the altitude benefits made them more efficient and faster. Flying at the edge of space is the next step in that speed/ efficiency curve, and that is necessarily supersonic.
> representing the things you absolutely dont want another part of your app doing via FKs is...pretty normal

"Normal" has never been compelling in a world where most software sucks and most projects overrun their budgets.

> If you are arguing it spreads out your business logic into multiple places, that's fair, but so does... a lot of things

Stop doing those things too!

> Databases with decent fks and constraints have a tendency to outlive the apps that build atop them

This is oft repeated, but I think there are some flaws with it:

1. I'd ask the question: is that because those apps sucked? It's possible to have a mediocre database and then an even worse app on top of it; in that case it wouldn't be surprising if the app itself died first.

2. Did the next app use the existing schema as-is, or did it adapt/migrate the schema to a different form that worked for that next app? There's a big difference between saying "this data turned out to be useful for other purposes" (of course!) and "this data representation turned out to be so perfect and elegant that we kept using it"

3. Do you have an overly narrow definition of "apps" here? I'd argue if six teams are all doing their own things with the database -- some writing code, some building views, some hooking into it with Excel and PowerBI -- then I'm not overly interested in the fate of the "OG app" that the database was built for. If that one dies, you still have five other "apps" using that database. We're not talking about a schema sticking around because it's so useful, we're talking about an entrenched, locked-in tech that nobody can change because it's too costly. That's a predictable symptom of a bad representation! That's exactly what happens with bad code! Good systems can handle change in isolated parts without breaking things for everybody else. Database schemas are so entangled with themselves, and SQL is so bereft of proper abstraction, that they can't change easily once they have many users.
Users are people other than you who use the website. HTH.
Likewise!

The only reason I moved away from subl is that I got access to a big ass machine and I needed to work remotely. The performance of VS code here is so good that often times I forget that the code and terminal is not my local machine.
DeepSeek status: ongoing outage "due to large-scale malicious attacks"
I even created a tutorial for making the Grooveshark logo

https://www.tips4design.com/2010/08/ai-draw-grooveshark-logo...
jdkoeck is right.

Storing-events-and-calculating-state is the dual of storing-state-and-calculating-diffs. It's an implementation detail, and if it works well, who cares?

I personally use git as an event log.

When I commit something, I write out a description of what I changed, not the current state of the whole repository (even if that's what a git hash is supposed to represent).

When I pull or push, I send and receive only diffs, not the state of the multi-GB repo.

When I rebase, I grab the latest diffs that went into master and put them under my feature branch diffs.

When I run 'git show {commit}', I see a diff, not a state.

It doesn't matter which way it is in any case: the evergreen debate about fast-mutations vs slow-immutations is that it's easier and faster to just mutate someone's bank balance in-place, rather than the slow way of appending transactions, or just quickly delete a bad transaction rather than slowly append a refund event to the log.

Taking that debate over to git land, "it would be faster" to just mutate the state of the codebase in some single, central location rather than the "slow way of sending commits" back and forth - regardless of whether those commits are technically states or diffs.
> SQL can be fixed, has been fixed

It has? Can you point me to an example?
Unfortunately basically every business i support has some horrible app that takes an ip address and expects to be able to send unauthenticated email to it. If it's not payroll software, it's hr or legal software.
Right? What’s next, bringing back asbestos? Should we start putting lead in everything again?
Deploying DeepSeek-R1 on Amazon EC2
vscode keybindings are insane. There are couple of thousands of them turned on by default with multiple duplications and no abstrations. So you have to negate them all first (that takes around 5000 lines of json) and then carefully go over around 500-700 definitions which might be important for you. So, my custom keymap in intellij has 44 definition, the vscode equivalent takes 675 and 2000 lines of json.