skysight-inc/HackerNews huggingface dataset:
"Declarative" is the correct word, as the input to the tool is a desired-state set of CREATE statements, and the tool figures out what DDL is actually necessary to make the target DB reach that desired state.

In other words, the engineer is declaring "make my schema look like this" and the tool makes that happen. That's the key definition of a declarative system, consistent with how this is described in CS classes.

Meanwhile traditional migration tools are "imperative", as the engineer must tell the tool exactly what operations (e.g. ALTER) to be run.
Grandparent commenter is one of today's lucky 10000 https://xkcd.com/1053/
The best solution here is for universities to become less involved with government money. They should have to compete for students and research on an even playing field, and we shouldn't be creating politically aligned fields through government spending.
> "Brain drain"

That's a good point; I wasn't thinking of that. Still, the number of immigrants to the US for 'brain drain' jobs I'd guess is relatively small, and Trump supports them to some degree - he likes wealthy immigrants, including in tech. Remember the recent (H-1B?) visa controversy.

> Those who love manufacturing

Is that really a passion for many people, working on an assembly line? I've read about it as a necessary job to pay the bills that almost nobody likes, and they want their kids to have someting better, etc.
It's true that low COQ-10 can cause muscle aches, which are a common side effect of statins. But if the alternative is a heart attack, then I'd probably rather take the statin and supplement COQ-10 if it's low. Given that the lifetime risk of a heart attack is >50%, the benefit outweighs the harm IMO.
> "They were able to in the 50s/60s/70s. So why not now?"

Because the 50s/60s/70s was the post-World War II economic boom for the US. Unless you're volunteering to endure World War III so that the next generation can enjoy that kind of boom, that is not going to happen again.
That does infringe copyright...you're just unlikely to get in trouble for it. You might get a cease and desist if the owner of the IP finds out and can spare a moment for you.
He's done this since at least 2016 so you can rest assured he's not a bot.

This is a real human being making these apologetics and using classic distraction and whataboutism techniques
Recently gave this language a spin with raylib and libtmx for loading tiled maps. Out of C3, Zig, and Odin, I've had the least trouble integrating C libraries with C3 (rolled my own bindings for libtmx). Overall a big fan of the language and am hoping it gets recognition on the level of the other languages mentioned here.
I don't understand why problems like this aren't solved by vector similarity search. Indiana Jones lives in a particular part of vector space.

Two close to one of the licensed properties you care to censor the generation of? Push that vector around. Honestly detecting whether a given sentence is a thinly veiled reference to indiana jones seems to be exactly the kind of thing AI vector search is going to be good at.
ContextGem: Easier and faster way to build LLM extraction workflows
I have just released ContextGem - an open-source Python framework that offers the easiest and fastest way to build LLM extraction workflows through powerful abstractions.

Why ContextGem? Most popular LLM frameworks for extracting structured data from documents require extensive boilerplate code to extract even basic information. This significantly increases development time and complexity.

ContextGem addresses this challenge by providing a flexible, intuitive framework that extracts structured data and insights from documents with minimal effort. Complex, most time-consuming parts, - prompt engineering, data modelling and validators, grouped LLMs with role-specific tasks, neural segmentation, etc. - are handled with powerful abstractions, eliminating boilerplate code and reducing development overhead.

ContextGem leverages LLMs' long context windows to deliver superior accuracy for data extraction from individual documents. Unlike RAG approaches that often struggle with complex concepts and nuanced insights, ContextGem capitalizes on continuously expanding context capacity, evolving LLM capabilities, and decreasing costs.

Check it out on GitHub: https://github.com/shcherbak-ai/contextgem

If you are a Python developer, please try it! Your feedback would be much appreciated! And if you like the project, please give it a to help it grow. Let's make ContextGem the most effective tool for extracting structured information from documents!
Presumably the artist is a human who directly or indirectly paid money to view a film containing an archaeologist with the whip.

I don't think this is about reproduction as much as how you got enough data for that reproduction. The riaa sent people to jail and ruined their lives for pirating. Now these companies are doing it and being valued for hundreds of billions of dollars.
There must be some statistical method or honeypot method to reliably detect cheaters. Like present the players with a bot who's purpose is to be un-hitt-able unless the player is cheating. I don't know, there has to be a way. Cheaters are disease in online gaming. I know that sensible people won't want to sacrifice their anonymity to provide ID to play a video game but if it is in the competitive scene and they are playing for money, surely it isn't a stretch to ask for ID and thus ultimate accountability.
This is very exciting stuff.

I’m curious: When you say FOR UPDATE SKIP LOCKED does not scale to 25k queries/s, did you observe a threshold at which it became untenable for you?

I’m also curious about the two points of:

- buffered reads and writes

- switching all high-volume tables to use identity columns

What do you mean by these? Were those (part of) the solution to scale FOR UPDATE SKIP LOCKED up to your needs?
I read that, but how can that API be used to notify the original tab to stop playing?
Phenek a new community Travel Experiences APP
Your ultimate travel companion to connect with fellow adventurers, plan trips, and share unforgettable experiences. Key Features:

Connect with fellow travelers: Find like-minded people based on interests and destinations.
Plan your perfect trip: Collaborate on itineraries, share recommendations, and book activities together.
Share your adventures: Post photos, videos, and stories to inspire others and relive your experiences.
Discover hidden gems: Get insider tips and recommendations from local experts and fellow travelers.
Safe and secure community: Enjoy a friendly and supportive environment.
Adventurous and Exciting:

Adventure awaits. Find your travel tribe.
To be president, leader of the executive branch.
He is using executive powers ignoring congress and actively ignores judges putting himself above all branches. That was not votes on
Oooooh @b0bben, you got me hooked with that awesome aesthetic! Please keep working on it! I'd be interested in using this app!

A few rhetorical questions:

* Will this be (similar to discord) centrally hosted/managed? That is, would it be like other chat apps in that there is a central server, and clients connect to/are dependent upon it? Or....will it be more federated (like email, matrix)...or will it be peer-to-peer? (I'm sure the more centralized, likely the easier for you to implement, but i figured i'd ask...since i tend to favor less centralized options...but that's just me.)

* If you go the route of open sourcing this, and possibly even enabling self-hosting...have you considered what techstack would be used, such that, it might be easier for folks to spin up their own, and hence you might get more participation from folks who more likely might be into this kind of approach (and cyberpunk aeshetic)? (I know docker, containers are a thing nowadays and may in many cases the techstack becomes less important and often eases the self-hosting burden, but, figured i'd ask.)

I should clarify: NONE of my questions are demands...This is your baby, and you should build it as YOU WISH! My questions are merely rhetorical, and you don't even need to respond to...merely giving you some food for thought. I love me some cyberpunk, and not only aesthetic, but especially the freedoms and approach to libre-centric "lifestyle"...so a cool-looking chat app like what your video showed would pair well with folks who think about at least some of the things i asked about above. ;-)

Anyway, cheers to you on this app, and keep on building it; looks great!!!!!
Every hardware vendor has problems. Suggesting that Apple is uniquely bad while others “stand behind their products” doesn’t hold up. The difference is that Apple, after enough pressure, actually fixes things. They create repair programs, offer recalls, and have the infrastructure to make things right. Most vendors don’t. Let’s look at the examples you listed.

Butterfly keyboard

Yes, a bad design. But Apple launched a repair program that covered every affected MacBook for multiple years. I was affected by this, and had my keyboard replaced twice. Compare that to Lenovo’s ThinkPad coil whine and sleep bugs, which they never publicly acknowledged and never fixed. Users were told it was “within spec.”

Batterygate

Apple throttled devices to preserve battery life and didn’t communicate it well. After the backlash, they launched a battery replacement program and settled a class-action lawsuit. HP had massive issues with failing batteries and Nvidia GPUs no meaningful recall, just silence.

MBP GPU failures

Apple ran logic board replacement programs for both sets of failures. They repaired machines years out of warranty. Microsoft, on the other hand, ignored Surface Pro 4 screen flickering for over two years, then limited their replacement program to a narrow window, leaving many customers stuck.

Bendgate

Apple initially downplayed it, but the iPhone 6 Plus was later included in a touchscreen repair program. Compare that to Asus ROG Zephyrus early models that ran hot, warped, and suffered fan noise issues. Users got nothing but “working as intended” responses.

“You’re holding it wrong”

A tone-deaf response. But they gave out free bumper cases to all iPhone 4 customers, no strings attached. Dell’s XPS 15, meanwhile, had persistent audio latency and trackpad issues over multiple generations, and they never rolled out a formal fix or support campaign.

Apple has problems, yes. But they also have stores, trained techs, and formal programs that actually address the issues. The service experience isn’t perfect, but it exists. With most other vendors, you’re stuck mailing your device to a third-party contractor who might show up late and leave you worse off.

Apple doesn’t get a free pass. But pretending they’re worse than companies who ghost their customers when things go wrong doesn’t line up with reality.
This is interesting, thanks for posting. I've been searching for some sort of 'real' usage of AI-coding. I'm a skeptic of the current state of things, so it's useful to see real code.

I know Python, but have been coding in Go for the last few years. So I'm thinking how I'd implement this in Go.

There's a lot of code there. Do you think it's a lot, or it doesn't matter? It seems reasonably clear though, easy to understand.

I'd have expected better documentation/in-line comments. Is that something that you did/didn't specify?
and a basic sandwich costs 3x that of in denmark :)
Political discussions for me are like programming. I enjoy them because I like finding bugs in people's logic like I do in programming.

I find a lot of people's political arguments wouldn't compile because of basic logic errors, and I try to point this out. But not many people are interested in this kind of analysis, they instead prefer the tribalist point-scoring like the OP mentions.

I dream of a world where political debates can be syntax-checked. I'm sure you could do it with AI today.

But in the end its all about feelings.

I can't describe how many times I will just go along with someone's passionate ranting on something I disagree with and egg them along because its makes them happy. This is tribalism. I will disagree with the group, and if you saw me you'd think I was the strongest supporter, but I actually vehemently disagree with everything.

There are very few people it's worth having a real discussion with these days.

I don't change my opinion of people for what they think, but it's very rare to find people who reciprocate this.
I will quote a recent exchange:

“How do you feel about this economic path? Are you concerned at all about the harm this will cause?”

“It’ll hurt but I’d vote for him again in a heartbeat.”

Certainly, always compassion and empathy for compassionate people. I am a very empathetic and compassionate person myself, I will give you the shirt off my back. For everyone else? Hard times ahead, as compassion and empathy have limits. Kindness is not weakness.
Good question. I tried to phrase a concrete-enough prediction 3.5 years ago, for 5 years out at the time: https://news.ycombinator.com/item?id=29020401

It was surpassed around the beginning of this year, so you'll need to come up with a new one for 2027. Note that the other opinions in that older HN thread almost all expected less.
I think the bureaucracies part is referring more to Deep Research than to MoE.
> OR use borrowing (e.g. current account deficit). If government spending drives productivity growth then it’s a net positive?

That's basically what already happens. The US has been running a huge deficit for a while now.

It also requires government spending to be the spending that drives productivity growth, which most of it isn't.

> OR tax wealth. If most return on international capital investment is being stored in the US, taxing this effectively taxes profits on international sales???

Why would they store the wealth in the US if the US had a wealth tax? One of the biggest problems with a wealth tax is that it has such a strong propensity to induce capital flight.

It's also not just a question of how you structure the tax. Wealth taxes are hard to avoid for things like real estate (can't move it), easy to avoid for things like factories or intellectual property (can easily move it), but the same is true for other taxes that apply to those things. It's easy to impose an income tax on rental income, so you don't need a wealth tax for that. The hard thing is how to impose any tax on all the money the Saudis have without causing them to just invest it in something else, possibly in some other jurisdiction.
Funny that one can login and claim a monkey, and customize its working environment. In an alternate universe where a version of you wants to make a buck, they'd sell "monkeycoins" that users can earn to get customizations for their monkey (like the fancy couch or a Macbook).

Did I say earn? I mean buy...
US markets' worst day since Covid pandemic: Apple and Nvidia lose combined $470B
I think the unstated assumption is that there's a block list somewhere being fed into a guardian model's context
Tends to be a lot of Holy Grail fans at Valve one would surmise.
> Human brains lack any model of intelligence. It's just neurons firing in complicated patterns in response to inputs based on what statistically leads to reproductive success

The fact that you can reason about intelligence is a counter argument to this
I assume that if it’s done at scale it will change trade balance and middlemen country will see their import taxes rise. It actually creates self interest for countries to prevent this behavior and block such activity as it will hurt genuine export.
Retaliatory tariffs from the EU have repeatedly targeted things like Bourbon, in order to target specific parts of the US (likely mostly aimed at certain politicians, but also at voters I imagine).
This type of approach is called protectionism, the Wikipedia article is pretty good and goes into the implications of it: https://en.wikipedia.org/wiki/Protectionism
> attacks on universities

This really feels like bad phrasing, when people read that they roll their eyes. Basically every major republican politician went to college, nobody is attacking universities, they're trying to help the students.
so basically this framework only excludes spot commodities. yeah its not common for people to be permanently bullish on commodities outside of a few niches like bitcoin and precious metals, so you don’t hear too much about that aside from those communities.

yeah that makes it easy to adhere to, while many other asset classes dont really revolve around scarcity of the asset’s existence and ownership does convey access to a productivity. I understand your criteria now.

For me I don’t have that criteria and don’t mind zero sum things. Its an entertaining and stressful player versus player match in a massive multiplayer game. Some kinds of trades I make are not zero sum, but it’s not an important distinction for me.

I do have a criteria related to human suffering: I mainly avoid exposure to some sectors like defense contracting and publicly traded prisons. Because the incentives are out of whack and dehumanize people while hoping they suffer, said in obtuse terms.

I think there is a flaw in the resource exchange logic you presented. Where you owning 1 kg of gold means the effort to extract that gold had gone to waste. In spot commodities the scarcity and continued demand at higher prices of the commodity is what justifies the further investment into extracting that commodities from harder to reach places. If a single market participant finds utility from the use of that commodity, distinct from hoarding, then acquiring access to more is beneficial. Your hoarding helped. The main difference here is that you are looking at the resource expenditure to acquire the unit you are owning, as opposed to the future utility created by the scarcity you contribute to. That’s a choice, I wonder if there is room to re-evaluate that principle, as I’m not sure we are operating on the same information.
Unsurprisingly you will not find anything about this on your regular news websites, not even explained in non-technical terms. That's why Ursula thinks she can get away with it and she's probably right. Write to your MEPs!

It's getting hard not to be ashamed to be an EU citizen.
You aren't clever for re-inventing autarky.

It's a bad idea for the same reason.
Taxing the rich is wishful thinking. They don't just give up wealth. They will simply look at it as an additional cost and hike the prices of their products up causing more inflation and that means even more trade deficit.
> food is not imported from China

No, but components used everywhere from agriculture to transportation to producing food products from raw agricultural output are imported from China.
Identity theft...more of you exist!
I don't see much talk of donors? My impression is that, as in many situations, the super-wealthy are forming a dominant class - as if it's their right - rather than respect democracy and freedom, and attacking university freedom. Didn't some person engineer the Harvard leader's exit?

Roth says the Wesleyan board is supportive; maybe they are just lucky.
For what it's worth, I found the Zig community on the biggest Zig discord very nice and welcoming. But that said, there is a lot of "you have to understand Zig" sentiment. Also, there is a lot of "I discovered Zig and it's finally showing me how to program" echoed as well.

I don't find this an unfair judgment but rather an observation.

I think this naturally arises from the language claiming to be "a programming language designed for robustness, optimality, and clarity" (See for instance https://www.recurse.com/events/localhost-andrew-kelley)

If you feel that this is an optimal programming language that gives more robustness and clarity than other languages, then it's natural to be preachy about it.

This is similar to Rust being sold as safe language, where similarly the proponents of Rust feel that the advantages of Rust need to be spread.

As a contrast, Odin focuses on "joy of programming" as its main goal, and the author does not make any claims of the language having killer features to choose it over something else.

However, it seems to be successful in that new users tend to remark how pleasant and fun it is to program in the language.
Guardrails seem to be ass ..... that or certain IP is already licensed
The new p150 cards linked in the OP have 32GB GDDR6 @ 512GB/s for $1,300. Which isn't bad on paper, I guess. They're meant to be networked (quad 800GB QSFP-DD) like Nvidia GPUs, so two of them would get you 64GB of VRAM at $2600 for ~600W which is basically what you're asking for? The power usage isn't good enough yet at scale I think, but for a workstation it's quite manageable.

Real workloads remain to be seen, but if they can actually get a working build of vLLM and their cards remain actually buyable, well, they're doing better than some of the competition...
> This isn’t a rant against AI. I use it daily

It is, but it adds disingenuous apologetic.

Not wishing to pick on this particular author, or even this particular
topic, but it follows a clear pattern that you can find everywhere in
tech journalism:

Some really bad thing X is happening. Everyone knows X is happening.
There is evidence X is happening, But I am *not* arguing against X
because that would brand me a Luddite/outsider/naysayer.... and we
all know a LOT of money and influence (including my own salary)
rests on nobody talking about X.

Practically every article on the negative effects of smartphones or
social media printed in the past 20 years starts with the same chirpy
disavowal of the authors actual message. Something like;

"Smartphones and social media are an essential part of modern life
today... but"

That always sounds like those people who say "I'm not a racist,
but..."

Sure, we get it, there's a lot of money and powerful people riding on
"AI". Why water down your message of genuine concern?
My method to discern between beliefs with intellectual backing and those from the community is by presenting them with some bizarro counterargument. If they copy/paste specific phrases and keywords, it's from the community. If they engage with the argument and refute it, then they have given them proper thought.
Not all migrations are as simple as adding and removing columns.
6. ensure there are no nulls in firstname and lastname
7. alter the columns to be NOT NULL

Because no non-statistician uses nullable columns, right?

Of course, some dbs (SQLServer?) infer NULL from the empty string, or am I misremembering?

Always having the columns be NOT NULL is a fundamental cheat, after always having a PK, or is that too old school for 2025?
> Still, the number of immigrants to the US for 'brain drain' jobs I'd guess is relatively small

Right, but it's the converse that is the issue: Americans wanting to do jobs that aren't found (or only found in a limited way) in America. Trump also supports them. The intent is to see things like manufacturing jobs happen more often on American soil so that Americans can do those jobs.

> Is that really a passion for many people, working on an assembly line?

The idea of it is, at least. I know a lot of people who have impressive manufacturing facilities in their garages just to support it as a hobby. Manufacturing is clearly a relatively common passion. You may have a point that they might come to hate the work if it became their daily reality, but the emotions that drive this sort of thing are never grounded in logic. Besides, it is not like they love the burgers they are flipping right now.
The thing whose outcome can go either way.