MurphyA/hacker-news huggingface dataset:
by incomingpain | 2025-05-27 11:57:14+00:00
Most of my python projects use SQLite; 1 exception where i need multiprocessing access to the database and no locking problems and speed so i need to run the entire db in memory.

https://docs.python.org/3/library/sqlite3.html

The built in library makes it really quick and easy to use it. Whereas mysql or in my case id use postgresql if i needed a full db. You're looking for a third party library? I have used Psycopg before but its just not needed.

Yes, ive come up against the sqlite locked database performance troubles; and failed to actually get the multi user thing working properly. But I moreso just needed to reapproach the issue.

My new startup http://mapleintel.ca is db.sqlite3 based. thousands of lines in it so far and growing every day.
Show HN: AnyLM – ChatGPT-Like UI for Local LLMs
by quantas | 2025-05-27 11:58:23+00:00
Hey HN, I'm excited to share AnyLM, a desktop app I've been working on. I love tinkering with local LLMs (via Ollama and LMStudio) but often found myself wishing for a more polished, unified UI similar to what ChatGPT offers, where all my conversations are in one place.

Out of that frustration I've built AnyLM, which aims to solve that by providing a single, native application (currently for Windows, with macOS and more planned) to interact with your local models from LM Studio/Ollama but also models from api providers like OpenAI, Anthropic and Google.

This has been a fun (and challenging!) project. I'd be super grateful for any feedback, suggestions, or if you just want to try it out and let me know what you think!
by squidbeak | 2025-05-27 11:58:36+00:00
The thing is, as compute prices fall and AI advances in its capability, swarms of coding agents can sweat on every line of code, looking for cleaner implementations, testing them, 24hrs a day. Current models often produce spaghetti crap. But it's a bold assumption that will always be the case.

There's a pretty big herd of sacred cows in programming and this debate always surfaces them. But I remember similar arguments being made about Go once and its version of human beings' special something. We saw then that sacred cows don't live long when AI really arrives.
by Symmetry | 2025-05-27 11:58:39+00:00
If you're a student in a microarchitecture class who has to implement a core in a semester then the simplicity of RISC-V makes it a much better choice. And if you're a grad student trying to try out some idea in your thesis then you should also choose RISC-V for the same reason.

If you're creating a microcontroller for a specific product then RISC-V's ability to only implement the hardware features you need is a big benefit and its compressed instructions let you save money using fewer RAM chips.
by ecralx | 2025-05-27 11:59:03+00:00
A small tool I'm building for myself because I often forget what I actually did during the week, especially when it's time to summarize it, do my weekly review, or prepare for 1:1s or evaluations.

The idea is simple:

1. On the days I work, I get an email one hour before the end of the day (as I usually use emails as todo lists).

2. I reply to that email with what I did just like I would in a personal journal.

3. My reply gets saved and shows up on a calendar. It's nothing fancy, just the content of the email on the day it was written.

4. When I need to prepare for a performance review or a manager check-in, I can generate a clean report based on my past entries with summaries written by AI

That’s it. No login every day, no new tool to open. Just a little trace of my work, saved quietly, and summarized when needed.
by austin-cheney | 2025-05-27 11:59:09+00:00
No, AI is not yet able to architect. The confusion here is the inability to discern architecture from planning.

Planning is the ability to map concerns to solutions and project solution delivery according to resources available. I am not convinced AI is anywhere near getting that right. It’s not straightforward even when your human assets are commodities.

Acting on plans is called task execution.

Architecture is the design and art of interrelated systems. This involves layers of competing and/or cooperative plans. AI absolutely cannot do this. A gross hallucination at one layer potentially destroys or displaces other layers and that is catastrophically expensive. That is why real people do this work and why they are constantly audited.
by bhouston | 2025-05-27 11:59:10+00:00
It is aimed at a completely different market from RISC-V.

RISC-V advantages is that it is an incredible simple and extensible architecture aimed at low power / embedded use cases. It is also easy to customize (similar to ARM) for specific use cases.

Power ISA is a super computer chip, while RISC-like, has a lot of legacy baggage and isn't designed for low-power nor is it designed for embedded situations. It also is not designed for customizability, it is more like a monolith project.

Power ISA will have space at the top of the market for very high performance CPUs. But I think it will be stuck there as there are no benefits over RISC-V in the areas where RISC-V is growing right now.
Show HN: Open-Source "Semantic SQL" Web IDE for Analytics (DuckDB/BigQuery)
by efromvt | 2025-05-27 11:59:17+00:00
DuckDB/Bigquery/Snowflake as backends.

Based around Trilogy, a modified SQL syntax with embedded semantic binding layer for query resolution.

Supports adhoc querying and visualization.

Optionally AI accelerated. (BYO API key)

MVP, feedback appreciated.
by amiga386 | 2025-05-27 11:59:40+00:00
He does not.

https://dreamsongs.com/WorseIsBetter.html

> One day in Spring 1989, I was sitting out on the Lucid porch with some of the hackers, and someone asked me why I thought people believed C and Unix were better than Lisp. I jokingly answered, "because, well, worse is better." We laughed over it for a while as I tried to make up an argument for why something clearly lousy could be good.

He then wrote Lisp: Good News, Bad News, How to Win Big (https://www.dreamsongs.com/WIB.html) for his EuroPAL keynote speech

> JWZ excerpted the worse-is-better sections [from Lisp: Good News, Bad News, How to Win Big] and sent them to his friends at CMU, who sent them to their friends at Bell Labs, who sent them to their friends everywhere.

The excerpt: https://www.dreamsongs.com/RiseOfWorseIsBetter.html
by dakiol | 2025-05-27 12:00:02+00:00
I think that until LLMs can assertively say "no" to your requests, we won't be able to rely on them autonomously. The greatest downside of ChatGPT, Copilot, and similar tools is that they always give you something in return, they always provide some sort of answer and rarely challenge your original request. That's the biggest difference I've noticed so far between working with humans and machines. Humans will usually push back, and together you can come up with something better (perhaps with less code or fewer processes, or less dependencieS). Chatbots (as of now) just throw at you one of the thousands of potential solutions to shut your mouth.
by joshmlewis | 2025-05-27 12:00:07+00:00
It's nothing groundbreaking nor particularly exploitive about MCP itself (although I have my thoughts on MCP), it's just a clever use of prompt injection and "viral" marketing by saying MCP was exploited. As I build agentic systems I always keep the philosophy of assume whatever you give the agent access to can be accessed by anyone accessing the agent. Never trust the LLM to be doing access control and use the person requesting the LLM take action as the primary principal (from a security standpoint) for the task an agent is doing.

This article does make me think about being more careful of what you give the agent access to while acting on your behalf though which is what we should be focusing on here. If it has access to your email and you tell it to go summarize your emails and someone sent a malicious prompt injection email that redirects the agent to forward your security reset token, that's the bad part that people may not be thinking about when building or using agents.
by chris_st | 2025-05-27 12:00:23+00:00
Two things:

1. There's almost certainly a port of Sqlite3 to WASM that would be more than glad to run in your browser.

2. I'd really love to know what applications fit in the "we had replication from the browser, peer-to-peer, I think we'd be living in a much more useful world" situation. We've had GunDB, IPFS, etc. that live in the browser for decades (and projects like Urbit), and the killer app just... doesn't seem to exist? Let alone anything useful as just a basic demo? Anyone have anything to point to? I just don't see it, personally.
by TrackerFF | 2025-05-27 12:01:43+00:00
For the vast majority that enroll higher education: Because they want a job. They need a job.

The degree is the key that unlocks the door to a job. Not the knowledge itself, but the actual physical diploma.

And it REALLY, REALLY doesn't help that there are so many jobs out there that could be done just fine with a HS diploma. But because reasons, you now need a college degree for that job.

The problem isn't new. For decades people have bought fake degrees, hired people to do their work, even hired people the impersonate themselves.
by noduerme | 2025-05-27 12:02:01+00:00
Are these things just running sql.js? Doesn't that use a kind of unstable webstorage instead of writing client-side files? I don't have a good handle on the state of SQLite these days as a way to store semi-permanent data on the client. In a locked-in environment or a backend I feel like it might make sense, but... isn't there like a 50Mb limit on localStorage, and how does that play nicely with a potentially larger DB...?
by Dumblydorr | 2025-05-27 12:03:28+00:00
It can’t actively become a coding agent and make the changes, but it doesn’t do that for individual scripts now, and yet we say it can code.

And yet I can ask it how to architect my database in a logical way, and it clearly has solid ideas that again, it doesn’t script itself.

So really it teaches us or instructs us one way to do things, it’s not executing in any realm…yet
by xnickb | 2025-05-27 12:04:03+00:00
This is actually a very good point. Although it's indeed not hard to imagine AI being far better at estimating the complexity of a potential solution and warning the user about it.

For example in chess AI is already far better than humans. Including on tasks like evaluating positions.

Admittedly, I use "AI" in a broad sense here, despite the article being mostly focused on LLMs.
by shireboy | 2025-05-27 12:04:22+00:00
Totally understand why it’s not in the post, and it did help me understand mcp more. That said, that’s the issue: most articles I’ve seen are geared toward how to do a local-use-only mcp. In the ones I want to build I need to deploy into an enterprise and know the current user and am not quite clear how yet. The answers on using oauth help though. Maybe a future post idea :)
by infecto | 2025-05-27 12:05:03+00:00
Wish this was higher up. I fully agree and it’s the same camp for me. I am not sure why but the vast majority either treat it as a magic bullet or says it’s pointless and nothing but flaws.

It’s not perfect it might write buggy code but I write buggy code too and would guess most engineers do. It takes a lot of the menial tasks out of the way. Sure I might spruce up some of the code it writes but why is that a deal breaker?
by wrikken | 2025-05-27 12:06:20+00:00
Wonderful to see all kinds of nefarious world domination plans are attributed here.

The gist from inside: * Whether restaurants want a domain is an onboarding yes/no question. * If they no longer want it, removing them is a simple message to the customer service from the partner.

Whether they fully understand the yes/no question is debatable at times, however, for that I point you to the easy fix in the second part should they change their mind. Feel free do disbelieve me if that aligns more with your world view.
by metalman | 2025-05-27 12:06:44+00:00
It will take acouple of years, but there will be strong proof of which type of education system works best.Estonia has made the hard choice to volunter there children is test subjects to an experimental technology with no track record, in the face of many other european countrys banning phones in schools, where at least the use of computer aids is limited to domestic settings where presumably there is a large variety of conditions and expectations in how technology is used.....vs, the many school districs world wide where internet access is still to slow and sporadic for use as a crutch to real learning and basic skills in traditional subjects. The whole thing will be self explecatory soon enough.
by Qem | 2025-05-27 12:07:16+00:00
> We are not yet sure there is no life on Mars. The question of how ethical it is to engineer new life and then spread it to other bodies in the Solar System for our own ends is deep and complex. But these conversations need to happen.

If it turns out Mars has indigenous microbial life, it becomes quite simple, IMHO. It would be deeply unethical to let invasive species loose there, just as it is on Earth.
by a_imho | 2025-05-27 12:07:55+00:00
My point today is that, if we wish to count lines of code, we should not regard them as "lines produced" but as "lines spent": the current conventional wisdom is so foolish as to book that count on the wrong side of the ledger.

https://www.cs.utexas.edu/~EWD/transcriptions/EWD10xx/EWD103...
by miki123211 | 2025-05-27 12:08:05+00:00
The only software project I donate to is NVDA[1]. It's an open source screen reader, AKA software that makes it possible for the blind to use computers through synthesized speech.

It's one of the few open source projects (besides Blender and GIMP) that is used directly by non-technical end-users and that has managed to surpass its commercial brethren , both in features and popularity. This is partly due to its extreme, almost Emacs-like hackability and a vibrant plugin ecosystem, which provides everything from better speech synthesizers to accessibility enhancements for other apps.

It has been created by two guys in Australia, mostly in response to the outrageous prices of commercial screen readers (~$1500 for noncommercial use). The situation has gotten better since then, Windows now comes with Narrator, which is... usable, but NVDA is still the top contender for most (non-enterprise) use cases.

[1] https://www.nvaccess.org/support-us/
by dunkeltaenzer | 2025-05-27 12:08:19+00:00
Well, their framing isn't actually a lie. AI can replace people doing actual jobs. We have lots of work around the topic of Bullshit jobs, to have a clear picture, that a huge percentage of jobs isn't actually there, so someone to DO work, but for someone to HAVE work. AI has essentially no way to replace those jobs, because AIs don't feel proud or excited about the idea of uselessly helicopterdicking around for a business card with a pretty job title and a nice salary.

The thing AI WILL do though, is making that situation more visible and clearly stating "yo guys. If you want me to optimize profits for this company, please leave your jobs and allow me to organize the few people remaining, who DO actual work and not just siphon money and power to feel better about their own uselessness
by noduerme | 2025-05-27 12:08:41+00:00
I've used sqlite3 in node, and it's nice and performant for small cases, yes. Mostly I've used it for things small enough where a user could download an entire sqlite file of their data, and then re-upload it in case their data got lost. But ultimately this data gets stored in a true MySQL DB. I don't think I'd trust it to run a whole system with thousands of users and millions of entries... honestly, maybe my issue is that I don't trust NodeJS enough...
by Lutger | 2025-05-27 12:09:12+00:00
Between "no" and "yes sure" also lie 50 shades of "is this what you meant?". For example, this older guy asked me to create a webpage where people could "download the database". He meant a very limited csv export of course. I an wondering if chatgpt would have understood his prompts, and this was one of the more obvious ones to me.
by loa_in_ | 2025-05-27 12:10:22+00:00
I love tools like this. While this particular one is very unimpressive, vibe coding will finally allow people to make convenient tools with accessible UI for common life related things. Let's face it, no corporation or startup is going to make good quality of life app, because people running a division or a company are wildly out of touch with what run of the mill computer literate person in their 20s needs to make the devices they own assist them day to day.
by ghusto | 2025-05-27 12:10:53+00:00
I've always though that the education system was broken and next to worthless. I've never felt that teachers ever tried to _teach_ me anything, certainly not how to think. In fact I saw most attempts at thought squashed because they didn't fit neatly into the syllabus (and so couldn't be graded).

The fact that AI can do your homework should tell you how much your homework is worth. Teaching and learning are collaborative exercises.
by fluidcruft | 2025-05-27 12:10:55+00:00
In the '00s triggered by a stock market tumble, GE declared MRI was mature technology, put its MR products into maintenance mode, gutted R&D, laid off their coil lab (which other manufacturers used to contract with), canceled all new product development, sent platform software to India, and got rid of the US development team. After the breakup, GE's been trying really hard to catch up (which is good!). They're leading on the new deep-learning recons due to ties with SV but all their kit is dated and old and built for a different era. Even now it's still just new lipstick on the old tech because it takes so long to get stuff out. The new software platform that doesn't suck has been in an eternal state of "real soon now". Having said that... my sense is that they seem genuinely hungry while their major competitor has become a bit too well-fed in GE's absence. I do really like the things GE has coming, they're... just not here yet.
by piva00 | 2025-05-27 12:11:50+00:00
I don't think comparing Go to developing systems to be useful, Go has a very clear goal to be achieved, it can be easily iterated over to achieve that singular goal. Developing systems is a much more complex task involving a lot of human subjectivity to even define a goal, there's whole swaths of attempts in methodology, processes, tools that try to even achieve some kind of definition of a software development goal, and none so far have been good enough to automate this process.

It can happen that AI will get good enough to help with the human aspect of software development but using playing Go as an analogy doesn't really work.
by IshKebab | 2025-05-27 12:11:59+00:00
These kinds of articles are arguing against nothing. Anybody can see that AI can't really replace developers today (though it can certainly save you huge chunks of time in some situations). But what about in 5 years? 10 years? Things are changing rapidly and nobody knows what's going to happen.

It's entirely possible that in 5 or 10 years at least some developers will be fully replaced.

(And probably a lot of people in HR, finance, marketing, etc. too.)
by mjmas | 2025-05-27 12:12:34+00:00
> DEPRECATION NOTICE: This crate will be abandoned in 6 months as per Rust ecosystem best practices. Start migrating to:

> • yes-rs-2 (rewritten with different dependencies)

> • yes-rs-ng (Angular-inspired architecture)

> • yes-oxide (WebAssembly-first approach)

> • yep (minimalist reimplementation)
by aketchum | 2025-05-27 12:13:18+00:00
It is always interesting to me when people say they are "bad test takers". You mean you are bad at the part where we find out how much you know? Maybe you just don't know the material well enough.

caveat emptor - I am not ND so maybe this is a real concern for some, but in my experience the people who said this did not know the material. And the accommodations for tests are abused by rich kids more than they are utilized by those that need them.
by noduerme | 2025-05-27 12:13:28+00:00
I'm not sure about this, I may be exaggerating, but aren't all four apps you mentioned (Spotify, WhatsApp, AirBnB, Uber) built on Electron? So they'd be using SQLite in the Node portion as their storage. That's their "server side", not client side.

For that portion (the locally-run mobile backend - the middleware) I guess it would make more sense... so I see what you're saying.

[Edit: Of all 4 things - Maybe only Spotify is actually an Electron app...? Although I'm confused as to how the rest could leverage NodeJS locally]
by TrackerFF | 2025-05-27 12:13:52+00:00
Back in the day, when I first tried college, I simply could not comprehend higher level math. We had one professor, and a couple of TAs - but it was impenetrable for me. They just said to me Go to the library and try some different books", or "Try to find some students and discuss the topics". Tried that, but to no avail.

I was a poor math student in HS, but I loved electronics, so that's why I decided to pursue electrical engineering. Seeing that I simply could not handle the math, I dropped out after the first year, and started working as an electricians apprentice.

Some years later YouTube had really taken off, and I decided to check out some of the math tutors there. Found Khan Academy, and over the course of a week, everything just fell into place. I stared from the absolute beginning, and binged/worked myself up to HS pre-calc math. His style of short-from teaching just worked, and he's a phenomenal educator on top.

Spent the summer studying math, and enrolled college again in the fall. Got A's and B's in all my engineering math classes. If I ever got stuck, or couldn't grok something, I trawled youtube for math vids / tutors until I found someone that could explain it in a way I could understand.

These days I use LLMs in the way you do, and I sort of view it as an extension of the the way I learned things before: infinite number of tutors.

Of course, one problem is that one doesn't know what one doesn't know. Is the model lying to you? Well, luckily there are many different models, and you can compare to see what they say.
by mystraline | 2025-05-27 12:14:45+00:00
Almost?

I've been running a programming LLM locally, with a 200k context length with using system ram.

Its also an abliterated model, so I get none of the moralizing or forced ethics either. I ask, and it answers.

I even have it hooked up to my HomeAssistant, and can trigger complex actions from there.
by psychoslave | 2025-05-27 12:14:46+00:00
I want peace and thrive for all members of humanity¹ to the largest, starting where it makes reciprocal florishing and staying free of excluding anyone by favoring someone else.

See, "AI" don't even have to guess it, I make full public disclosure of it. If anything can help with such a goal, including automated inference (AI) devices, there is no major concern with such a tool per se.

The leviathan monopolizing the tool for its own benefit in a detrimental way for human beings is an orthogonal issue.

¹ this is a bit anthropocentric statement, but it's a good way to favor human agreement, and I believe still actually implicitely require living in harmony with the rest of our follow earth inhabitants
by analog31 | 2025-05-27 12:14:56+00:00
>>> Here's what the "AI will replace developers" crowd fundamentally misunderstands: code is not an asset—it's a liability. Every line must be maintained, debugged, secured, and eventually replaced. The real asset is the business capability that code enables.

This could explain the cycle by itself. Dynamic equations often tend to oscillate. Anything that temporarily accelerates the production of code imposes a maintenance cost later on.