MurphyA/hacker-news huggingface dataset:
Show HN: AI Enabled SQLite CLI
by theahura | 2025-08-02 19:30:35+00:00
I've been working with sqlite recently, and was pretty surprised at how bad a lot of the existing cli tools are. Most don't have tab complete or json pretty printing. Many don't automatically show table headers, which is imo very user unfriendly. And for me, personally, I kept finding myself tabbing over to Claude to ask it how to do basic joins and json extractions because I never bothered to learn/memorize SQL syntax, and didn't need anything performant for just looking through the databases.

I got to thinking it would be very easy to build a better client with AI, that also used AI. And it was -- in less than an hour I put together a cli that supports all of the above.

Most importantly, it has a built in LLM plug-in that has context for your database. You can do things like run `.ai give me the names of my customers` and the cli will make a call to Claude with your table names and table schemas as part of the context.

I've immediately found it useful in my day to day work, so I figured I'd share it here too for others to play with lmk if there's any other features you think are worth adding!
by masklinn | 2025-08-02 19:31:06+00:00
> I can't see any way this could be sold in Europe

It's 3860 x 1854mm, there are vehicles smaller than that being sold in europe right now (in the A segment, not quadricycles): the fiat 500e is 3632x1683, the suzuki ignis is 3700x1660. The citroen c1 (discontinued 2022) used to be just 3470x1620.

Hell there are B segment cars which aren't much bigger, the R5 e-tech is 3920x1770, the yaris is 3940x1745.
by in_cahoots | 2025-08-02 19:31:10+00:00
I was going to disagree with you as that hasn't been my experience, but I think you're actually on to something. The younger generation doesn't drink as much as they used to. I'm sure I would have thought twice about some of the things I did in college if every person present had the potential to film me and post it on the internet, ending my career before it even started. It's better prevention than DARE or prohibition could ever be- the risk of having one single mistake recorded and available for everyone to see for the rest of your life.
by albumen | 2025-08-02 19:31:16+00:00
Perhaps it is more a reflection of you, or of US (?) attitudes.

This 3,000 person study [1] in Germany matched pairs of strangers for private face-to-face meetings to discuss divisive political issues. It found asymmetric effects: conversations with like-minded individuals caused political views to become more extreme (ideological polarization); by contrast, conversations with contrary-minded individuals did not lead to a convergence of political views, but significantly reduced negative beliefs and attitudes toward ideological out-group members (affective polarization), while also improving perceived social cohesion more generally. These effects of contrary-minded conversations seem to be driven mostly by positive experiences of interpersonal contact.

[1] https://www.sciencedirect.com/science/article/pii/S004727272...
by pron | 2025-08-02 19:31:26+00:00
To be more concrete, event though two programs can both be meaningless in C++, i.e. C++ says nothing about what they actually do once compiled and run, we can sometimes say that one of them is much more likely to lead to a security exploit than the other. This is even used in practice in techniques such as this one: https://www.cl.cam.ac.uk/~tmj32/papers/docs/ainsworth20-sp.p...
by bbminner | 2025-08-02 19:32:39+00:00
A PhD dropout with an alright (passable) academic record, who worked in a 1.5-tier lab on a fairly pedestrian project (multimodal llms and agents, sure), and started a startup.. Reallyttrying to not sound bitter, good for him, I guess, but does it indicate that there's something really fucked up with how talent is being acquired?
by elric | 2025-08-02 19:32:48+00:00
I think optimising for thinness is a stupid goal. I get wanting to reduce weight, but volume and mass are two different metrics. Thicker laptops can have better cooling, bigger batteries, easier maintenance, a bloody ethernet port, and probably better keyboards.

For some reason Lenovo has made the ThinkPad keyboard worse with every new generation. They're still better than other laptop keyboards, but my goodness the margin is shrinking.

And while David Hill may claim that Lenovo TPs are as good as (or better than) IBM's, the number of repairs mine have had tell a different story. Since the x230, every single ThinkPad I've owned had to have its mainboard replaced. Sometimes even twice.
by duped | 2025-08-02 19:33:08+00:00
That's extremely uncharitable. I think slack and discord have pretty great UIs, and that's all "web tech." Figma just IPO'd at a $58 billion valuation - is that not proof their UI is good? If it wasn't good, no one would use it. VS code became the preeminent text editor and IDE over the last decade - all web tech.
by unstuck3958 | 2025-08-02 19:33:37+00:00
ditto. I have talked about it before with someone who shared the opinion that falling birth rates is the end of the world, but to single that out is creepy indeed. I do understand that it can be seen as a symptom of decay, but when I them people on why exactly birth rates are so important, it does seem like they implied a sort of existential thesis where procreation is supposedly the end goal.
by lsuresh | 2025-08-02 19:33:54+00:00
Not the one you asked, but here's what I would have told my 17 year old self.

* "Slope beats y-intercept." The best computer scientists and engineers I've ever worked with and/or mentored embodied this principle more than anything else.

* It can be tempting to over-optimize for short-term milestones (e.g., an important admissions exam, the next job or promotion), but there is a significant compounding value to knowledge accumulation and truly learning your craft well. Read and learn as much as you can, all the time, even if it isn't immediately necessary or useful.
by marsupial | 2025-08-02 19:34:06+00:00
> Ahead of Trump's second term, Project 2025 wrote in a detailed memo foreshadowing the president's agenda ways the administration could pull funding for public broadcasters. The Trump administration started taking actions to scrutinize public broadcasters shortly thereafter.

There's no mention of why they want to defund CPB beyond "Trump administration efforts to strip funding." Muh Project 2025 is referenced briefly, but the rationale isn't explored.

They provide quotes from those opposed "unwarranted dismantling of beloved local civic institutions,... gutting" without the For Side saying anything e.g. that this is no longer necessary due to media landscape.

It doesn't consider whether it's necessary and while saying it will be a loss to rural news never looks at the fact it's used less and less there, whether gap will be filled and in part has.

It centers the negative consequences, it has very limited perspective by supporters and centrally frames Project 2025 despite questionable connection. There's clearly a tilt, but it performs neutrality that less critical might accept.

"The choice of what to include and what to leave out, what to emphasize and what to downplay, inevitably reflects a point of view."
by drivingmenuts | 2025-08-02 19:34:21+00:00
I saw this on JerryRigEverything and was thinking that this is the perfect city pickup. Compact, yet with a reasonable payload size. It has a good range (which, in my case, is not as important) and the horsepower is good. The dash takes a bit of getting used to, but OK.

It's the second electric vehicle I actually like (Rivian being the first - but it's a full-size).
by SoftTalker | 2025-08-02 19:34:28+00:00
This seems so weird. When I think about how I learned to read, in the 1970s, it was (as best I can remember) first learning the letters and the sounds they make. Then starting to read words by "sounding them out." I never remember learning about "context" or "what word would make sense here" or "what do the pictures show." Pictures were just there to make the pages more fun to look at for a 7 year old.

Of course after some exposure and repetition you start to recognize whole words at a glance. That's just natural, but I never remember learning to read by memorizing whole words.
by mananaysiempre | 2025-08-02 19:35:16+00:00
> Another friend kept all of his 1980s computer magazines (Byte, etc...) and moved these extremely heavy boxes through 30+ years of moves.

I don’t think IA has all early issues of the Microsoft Systems Journal (later MSDN Magazine), among others. So this can be useful. (Also, what kind of person do you think put the magazines up on IA in the first place?..)
by pjmlp | 2025-08-02 19:35:42+00:00
Lets not forget that after five years Project Reunion was announced, WinUI 3.0 is yet to achieve feature parity with the Visual Studio experience developing C# or C++ applications, or UWP components features.

The WinUI map component is a Webview2 instead of proper native component, Win2D is only a subset of the UWP one, ink is yet to be migrated, and lots of other issues.

Github repos are filled with thousands of issues, and they already did a cleanup a year ago where they simply closed enough tickets to bring it under 2000.
by trinix912 | 2025-08-02 19:35:47+00:00
> Also, drinking in public is not allowed in much of Europe. Don’t go there and assume it is.

I live and have traveled a lot around Europe, and have never ran into that rule, but have almost always seen people drinking alcohol in public parks. From what I could find online it's only Norway, Ireland, and perhaps Poland, plus a few places in cities in other countries (Vienna, Milan, Barcelona, Riga...) which is far from "much of Europe".
by throwaway290 | 2025-08-02 19:37:26+00:00
The historic lesson is that men and especially men in power commonly abuse their position ranging from harassment to rape and legal system will fall over itself to serve them. That lesson led to metoo and stuff. Look it up.

> This is shuffling which innocent gets to suffer, but is not fixing anything.

Bro I really really hope you are not trying to compare wrongful cancellation and rape.
by camel-cdr | 2025-08-02 19:37:50+00:00
Cool idea.

For the sake of being pedantic:

> The whole bowl has fewer calories than two slices of garlic bread

Really? Idk what the sizes are, but I looked up the weight of one of those micro wave popcorn packages, which usually fill the bowl we have at home. That seemed to be 100g, which is about ~350 kcal not including oil/butter. I'm getting about ~275 for 100g of bread, which is more than two slices. That's about 6 inches of baguette.
by throwanem | 2025-08-02 19:38:46+00:00
I restated them yesterday in https://news.ycombinator.com/item?id=44757634, assuming at the time that if you found any error there you would say so. Here's another chance to explain where I've actually failed to grasp your thesis, rather than that I'm pointing out you have overdressed a triviality with pretentious overcomplication.

But it's less interesting to me that you brought up Alan Watts seven years ago than that you did so again yesterday. What do you need from him? Why bring him up if you don't want to talk about him? Or is it that no one is allowed to have an opinion that contradicts yours, including when that involves looking askance at needless reference to dead prophets?
by soulofmischief | 2025-08-02 19:38:51+00:00
In high school we regularly threw 100+ person parties under bridges and along the river, in random lots, wherever we could, really. However, it required a lot of coordination and trust between a lot of people to avoid surprise police encounters, and the local police personally had me and some of my associates on their shitlist which further complicated things. It was an environment I thrived in, but I wouldn't want my child to have to encounter the same level of risk and paranoia just to hang out with their friends.
by CharlesW | 2025-08-02 19:39:39+00:00
If you aren't already (1) telling Claude Code which flavor of SQL you want (there are several major dialects and many more minor ones) and (2) giving it access to up-to-date documentation via MCP (e.g. https://github.com/arabold/docs-mcp-server) so it has direct access to canonical docs for authoritative grounding and syntax references, you'll find that you get much better results by doing one or both of those things.
by jama211 | 2025-08-02 19:40:20+00:00
People by and large don’t really know what they want, they purchase based on vibes and manipulation. If people in general really wanted these trucks they’d be more popular outside of America. The truck has been a boiled frog, slowly growing in size and people haven’t realised it. Also Americans in general have a bit of a cultural issue with ego, individualism and all that, which doesn’t help.
by hackyhacky | 2025-08-02 19:42:07+00:00
Maybe I'm just missing something, but the "domain expert" that is described here is just... a function? The big win in Clojure is apparently using code instead of types?

(defn apply-shipping-rules [order] (cond-> order (and (= :premium (:customer-type order)) (> (:order-total order) 100)) (assoc :shipping-cost 0)))
by lukaslalinsky | 2025-08-02 19:42:41+00:00
I really don't know what is it, but Claude Code just seems like an extremely well tuned package. You can have the same core models, but the internal prompts matter, how they are looking up extra context matters, how easy is it to add external context matters, how it applies changes matters, how eager is it to actually use an external tool to help you matters. With Claude Code, it just feels right. When I say I want a review, I get a review, when I want code, I get code, when I want just some git housekeeping, I get that.
by HaZeust | 2025-08-02 19:42:56+00:00
Rent, household items, cost of external activities, and health insurance (sometimes, see parents' insurance plans) are still subject to that group - which my sources show clear outpacing for - even with youth's increase in wages.

For someone that lives with their parents and works full time, yeah - they've probably never had it better. But a lot of youth right now have expenses drawn out in such a way where, even if they're making more than their predecessors, they have less upwards mobility for today, let alone any potential to invest in assets that afford them any upwards mobility in the future.
by fcpguru | 2025-08-02 19:43:09+00:00
Usually thoughout the day I'll be watching many different videos and then one will stick with me. Someone will have made a really good point at like time code 3 mins and 17 seconds or something. If I have to right then and there pause the video and start a download it takes me out of the moment. I like it so much better to just at the end of the day go back and find good moments and place them in a their own videos. Examples:

https://www.youtube.com/watch?v=ksHaSnEs4WM

https://www.youtube.com/watch?v=KRfsAufKrzk

https://www.youtube.com/watch?v=6EoH-Qy_xw8
by illiac786 | 2025-08-02 19:43:22+00:00
I would argue that living with roommates may be harder than living alone, from a financial responsibility point of view. You not only need to be responsible for yourself but you need to deal with roommates which may not be.

Of course, you could be the financially irresponsible roommate, but I think your date can figure this out quite rapidly then, based on how much your roommates will hate you ;)
by mattlondon | 2025-08-02 19:43:44+00:00
Scooters kill people too (often the drivers themselves but not always).

The problem with escooters is that basically any accident is "bad" since you have no protection while you toodle along at 15.5mph. Not just slamming into the ground, but into street furniture, trees, building, bikes - you name it. A helmet (which no one wears) is not going to help you if you wrap your abdomen around a solid metal bench at 15.5mph. The real world has a lot of hard sticky-out bits (and perhaps ironically cars don't due to crash testing rules, so I guess crash I to a stationary car is your best bet)

It's a bloodbath in London.
by mlinhares | 2025-08-02 19:44:38+00:00
You drive everywhere, so it's optimized for drive-through experiences, so you don't have to interact with people. Third places are hard to find, and when they exist, they're paid (movie theaters, restaurants, bars, museums, gyms) and they're not necessarily good places to make friends.

There aren't natural places where you see the same people as the communities are very dispersed, with mostly single-family homes in large lots. So it takes a lot of effort not to be lonely. I've seen many people that moved here from other states/countries and now regret the decision as building community is incredibly hard.
by SoftTalker | 2025-08-02 19:44:49+00:00
My parents read to me when I was very young, but never tried to teach me to read. So all I knew of reading was that it was something my parents could do. I learned to read in first grade, at school. I found it compelling and did it on my own at home without much prompting or "enforcing."

That didn't really change until High School, when I found most of the standard reading assignments in English class to be tedious and hopelessly old-fashioned. If I'd also had trouble reading from a technical standpoint at that time, I have no idea how I would have gotten through it.
by kazinator | 2025-08-02 19:45:23+00:00
> Modifier o means that the first time a literal regexp with interpolations is encountered, the generated Regexp object is saved and used for all future evaluations of that literal regexp.

That is crystal clear to me. It means that on the next execution, the new values of the interpolation will be ignored; the regexp is now "baked" with the first ones.

Like this in C++:

void fun(int arg) { static int once = arg; }

if we call this as f(42) the first time, once gets initialized to 42. If we then call it f(73), once stays 42.

There is a function in POSIX for once-only initializations: pthread_once. C++ compilers for multithreaded environments emit thread-safe code to do something similar to pthread_once to ensure that even if there are several concurrent first invocations of the function, the initialization happens once.
by Animats | 2025-08-02 19:46:00+00:00
They've been through a few generations of test machines. They have something called "Polaris". It was supposed to be finished around the end of 2024.[1] Their own site still talks of it as being under construction.

Discussion on Reddit.[2]

They previously built something called "Trenta".[3] That generates two balls of plasma and fires them at each other. There's no fusion or fusion fuel. It's a test rig for plasma generation and manipulation. That was running two years ago.

"Polaris" is a scale-up of Trenta, with something to fuse, and with energy recovery. It's very unclear how far that project has progressed. If they were getting energy out, that would be big news. Helion is vague about how that's progressing.

[1] https://www.helionenergy.com/polaris/

[2] https://www.reddit.com/r/fusion/comments/1hlojqu/any_news_on...

[3] https://www.youtube.com/watch?v=_bDXXWQxK38
by mgraczyk | 2025-08-02 19:46:07+00:00
The best data I could find shows a decline of around 25% from 2006 to 2023 in restaurant visits. However, a big portion of this is because of meal delivery which is more expensive than restaurants, so the cause is probably not mostly increased cost.

Other related things like concert attendance have gone up.

My take is that the main reason young people don't go out is not price, they often seem to be making choices that cost more when they avoid going out
by tome | 2025-08-02 19:46:28+00:00
Oh Dan, come on, really?! OP has been making all sorts of claims and failed to justify them with any more than "just look it up", and also making all sorts of assumptions about me. Saying what I said was about the most kind I could be in response. I guess I could just simply not contribute, as I had planned, but tomhow did explicitly ask me to here: https://news.ycombinator.com/item?id=44720318
by sirwhinesalot | 2025-08-02 19:46:55+00:00
I agree with the article, but I will note that we have a great tool for this problem that is (or at least can be) "statically typed": the relational model. Databases are precisely what you want for this sort of problem (even better if it's Datalog and you can encode rules that derive relevant information).

Most mainstream languages are very poorly equipped to do relational modeling. ORMs are a disaster (object-relational mismatch) and you don't necessarily need an actual database running in the background.

Clojure's approach is superior to the class hierarchy or sum type solution for this sort of very loose business domain modelling, for the reasons stated in the article, but it's also a local optima, and so is the "fat struct" solution (which is the statically typed equivalent). Even entity component systems are but a shadow of the relational model.
by dragonwriter | 2025-08-02 19:47:03+00:00
> You are missing the point.

No, I am disagreeing with the point, because it's completely wrong.

> Copyright law and the copyright act, not general contract law, governs whether a contract provision relating to AI output can be enforced by Anthropic

No, it doesn't. There is no provision of copyright law that limits terms of contracts covering AI outputs.

> It's not different than if Anthropic included a provision saying you won't print out the text of Moby Dick.

This is true, but undermines your point.

> Anthropic doesn't own copyright on Moby Dick and can't enforce a contract provision related to it.

Actually, providing services that allow you to produce output can enforce provisions prohibiting reproducing works they don't own the copyright to (and frequently do adopt and enforce rules prohibiting this for things other people own the copyright to).

> Like I said I can be convinced I'm wrong based on a legal analysis from a neutral party but you seem to be arguing from first principles.

You seem to be arguing from first principles that are entirely unrelated to the actual principles, statutory content of, or case law of contracts or copyrights, and I have no idea where they come from, but, sure, believe whatever you want, it doesn't cost me anything.
by w10-1 | 2025-08-02 19:47:34+00:00
If it's a great house or location or deal, people will stay notwithstanding conflict.

When housemates go from single to partnered, it's an unsolvable conflict because housemates are not the priority and the partner is mostly unwanted in the house.

If you as a single person join a house with committed partners, you'll forever have to accept what they want.

When people disagree, the stakes of one's living space is typically higher than the problem, which the aggressive are happy to hostage to get what they want.

Housemates learn a lot about you that you don't really want to be public, but they're not committed to keeping your secrets and might even use them against you.

Housemates can start depending on you emotionally.

Having friendly housemates can reduce the pressure to find a partner, precisely when othees are partnering. Your choices only get more narrow from delaying.

Long-term living together requires commitment, mutual respect, and effective governance that can't be abused. All that is quite the opposite from the usual drivers: convenience, shared cost, and lightweight human contact.

Worse, shared housing is always better and cheaper than buying, so after decades of living well you'll still be a renter (unable to control your destiny) rather than an owner.

You might think you'll share for temporary situations, but not make it a lifestyle. But the more you get used to it, the less tolerance you'll have for the sacrifices necessary for a committed partner and home equity.

What would your future self want you to do?