d1l

Bro this is just slop.

Bro, this was the only reason I opened the comments, and I'm so happy to see someone else noticed. Even if they removed that, the utter sloppiness of the prose is unbelievable. Offensive, even.

The question that resonated with me was whether open source even matters anymore.

I think it does but there are weird dynamics I don’t fully understand. I’m curious about HNs thoughts.

My theories: Centralization around key projects due to AI pointing new users towards them. (At the same time this drives up the PR deluge onto these projects. Especially from newer users already heavily using llms.)

So many low effort AI-generated open source libraries that it becomes harder to tell signal from slop. More movement to the bigger projects because they are perceived as safer bets.

There are obvious tells that this was heavily curated by AI, the very thing it criticizes in the opening paras and roasts throughout as a life-destroyer.

I don’t disagree with the premise, and I appreciate the roasts of the SV pseudophilosophers (he left out Ayn Rand tho).

Oh man I wrote this exact comment before trawling far enough to find yours. It belongs at the top. That HN cannot discern the obvious is more alarming than the blatant hypocrisy of the authors. Yeesh!

This post reeks of being written by Claude. Surely you all feel it, too? Are people who write these kinds of posts lacking self awareness, integrity? Does it matter?

15 years ago GitHub was a strong signal for like-minded devs who were of the “let me code and slide pizza under the door” variety. The signal became less meaningful over time so people started optimizing for other things…stars, whatever. Brand. I think the venn diagram of front end marketing types and the explosion of js frameworks probably was the driver for this. Now with vibed out projects everywhere it’s a real task to separate the wheat from the chaff. And I still use gh because I imagine those stars are still current in some markets but maybe I’m deluding myself.

Or, Perhaps the invention of the rocket emoji most likely was the cause of this phenomenon.

I didn’t follow the article’s thesis. It felt written from a defensive crouch and claimed not to be punching down but it seemed to be radiating hostility the entire time. Something about vibe coding only replaces the lowest level of mechanical work involved in creative pursuits (including coding)?

I’m not a booster a doomer or a boomer but I think it’s a reasonable litmus test for LLM coding to implement 80% of an existing app or service. It’s not an accusation against anyone using LLM (I do) nor is it an excuse to take shots, it’s just a way of framing SotA capabilities.

Weird article, perhaps I missed something.

Didn’t know the sackler family was Chinese.

Yeah, I had the same instinct - this feels very much like a "nice idea" but the execution falls short. I mean - busily banging on sqlite like this? Shit at that point just use Redis.

What on earth is this guy saying doesn’t he own like every kindle?

Read Moby Dick some time my friend.

100% bro

If you can't tell then I'm not sure what more needs to be said. I took a look through the commit history and it was glaringly obvious to me.

To trust something like data-storage to vibe-coded nonsense is incredibly irresponsible. To promote it is even moreso. I'm just surprised you can't tell, too.

It's a nonstop slop funnel as far as I can tell. Only ashamed I've been here for more than 5 minutes.

Are you using ai for the comment replies too?!

Vibe coded trash.

that credulous hn readers will upvote this is alarming.

Beethovens 17th piano sonata is based on the tempest. I recommend Richter if you’re curious!

https://youtu.be/qeL3tAb7yV4

I’d imagine there’s an extremely long tail of features and quirks that will take time to iron out even after SQL compatibility is achieved. Looks like it’s still missing some important features like savepoints (!!!), windows and attach database.

I’d be more excited and imagine it would be more marketable if it focused instead on being simply an embedded sql db that allowed multiple writers (for example), or some other use case where SQLite falls short. DuckDB is an example- SQLite but for olap.

Fuck, my wife got a notice that she would have to increase her iCloud storage so last week began the process of ordering a backup of all her pictures so I could get them off iCloud and organized on some drives at home. We got 12 zips of the pictures along with csv's and some metadata, and I literally just finished iterating on the script to sort them into year-based folders and convert all the HEIC shit into JPG. It's running literally right now.

Guess I should've searched harder!

I still use it (shout out taviso iykyk).

https://github.com/zy/zy-fvwm/blob/master/fvwmrc/taviso.fvwm...

Someone made a full cde style desktop with fvwm: https://github.com/NsCDE/NsCDE

It’s too bad tech seems so much to take away this kind of configurability in the name of “we know better”. There’s so much to be said for software that can last so long, as opposed to the constant treadmill of forced updates.

Fuck gnome eternally for destroying gtk and fuck Wayland.

This is disingenuous and probably was written this way for HN cred and clicks. Sqlite's test suite simulates just about every kind of failure you can imagine - this document is worth reading if you have any doubts: https://www.sqlite.org/atomiccommit.html

That's even crazier - so you're using asyncio because you have a ton of slow network-bound stuff - but for your database access you are running every sqlite connection in it's own thread and just managing those threads via the asyncio event loop?

This is strange on so many levels.

SQLite does not even do network I/O.

How does sharing a connection (and transaction scope) in an asyncio environment even work? Won’t you still need a connection per asyncio context?

Does sqlite_open really take long compared to the inevitable contention for the write lock you’ll see when you have many concurrent contexts?

Does sqlite_open even register in comparison with the overhead of the python interpreter?

What is an asyncio SQLite connection anyways? Isn’t it just a regular one that gets hucked into a separate thread?

Similar thing in 2019-20 in Colorado. There is a ton of FOIA stuff released if you search.

https://en.wikipedia.org/wiki/2019–20_Colorado_drone_sightin...

24 zx6r to replace my clapped r6, which had nearly 50k miles. Love it even though the rev limit kicks in at 14k (as opposed to the 17k on the r6). Now that it’s cold I’ll be sending it off for a flash to get that raised to 14.5… Love the ninja, though. That bike only wants to go fast.

Site calculates a 40deg forward lean but the best is full tuck behind the windscreen with the throttle pinned.

If you maintain a library you’ll hear about this kind of shit early and often.

The last thing anyone needs is “visual” “designers” shitting up our useful applications.

Stick to your todo list apps and stay in your lane.

This is just yet another attempt to piggyback off the HN crowd's enthusiasm for Sqlite in order to advertise fly.io.

Man does not live by bread alone. If you want to make technology and the standard of living a god, that might be rational, just as communism may be an earlier rational attempt in the same vein. But I believe these ideas are naive. The central idea seems to be “eliminate enough of man’s animal suffering and cater to his animal wants and you’ll have paradise” but I think these schemes undervalue the human need for freedom, love, self discovery, and meaning.