Hacker Newsnew | past | comments | ask | show | jobs | submit | empthought's commentslogin

How about

  for wmv in Path(sys.argv[1]).rglob("\*.wmv"):
        print(wmv, end=" ")
        r = subprocess.run(
            ["ffmpeg", "-i", wmv, wmv.with_suffix(".mpg")],
            stdout=subprocess.PIPE, stderr=subprocess.STDOUT,
        )
        lines = [l for l in r.stdout.decode().splitlines() if "kb/s:" in l]
        print("\n".join(lines) if lines else f"ERROR {r.returncode}")
?

If you go outside stdlib you can use the sh library instead of subprocess.run.


Not bad, but the subprocess invocation is too verbose given this is a staple of shell script type work, and the string mangling is a bit painful.

“No one is required to follow The Rule, to know The Rule, or even to think that The Rule is a good idea. The Founder of SQLite believes that anyone who follows The Rule will live a happier and more productive life, but individuals are free to dispute or ignore that advice if they wish.”

As the first section notes, the only reason they posted this is to fulfill a checklist requirement for certain commercial users. The external requirement for a code of conduct, which requesters never read and don’t actually care about, is the actual nonsense here.

Hardly. It may be annoying for commercial users to require a checkboxy code of conduct from the software they choose to use, but taking that opportunity to shove religion down people's throats is very strange behaviour. It also makes me suspicious of SQLite: if they're that brazen, do I need to look out for potential implementations of these rules within the code? Will certain words, like "gay", cause queries to fail? I don't think so and I hope it never will. But this is a SQL database engine and they chose to publicly affiliate it with religion. That's concerning.

I've been considering switching to H2 for a while now to avoid depending on a fat-jar full of binaries. This nonsense has persuaded me to make that switch.


The source code is in the public domain. You can inspect it, fork it, and redistribute it as you like.

Nothing is being shoved down anyone’s throat.


I'd rather just not use the thing than maintain a fork just to monitor for the influence of its official religion in its code.

Good luck! It’s the most widely-deployed database software by far. I’m sure you have hundreds or thousands of SQLite files among devices you own.

https://sqlite.org/mostdeployed.html


I think you have vastly mistaken what I'm saying. You seem to have leapt from me merely switching away using SQLite in my own projects, to me attempting to purge SQLite from every machine and piece of software I own or something? How odd.

Even with their strange choice to give a SQL database engine an official religion, I'm under no illusion that they'd turn it into actual malware. The example concern I gave was about queries failing, not it rm-rfing my computer. Sheesh.


I don’t know, wouldn’t you be pissed if you tried to search your browser history for “gay” and nothing was found? After all, that’s the threat model you’re proposing that you’re worried about — the thinnest of excuses for your clear and deep bigotry.

When I wrote my example, I was more thinking of database and table names, the schema itself, rather than cell content. There are already various limitations on such things, usually in the form of reserved prefixes. It doesn't seem out of the realm of possibility that a piece of software that officially affiliates itself with a particular religion might infuse that religion within itself. In fact, I find it suspicious that you seem to disregard this possibility entirely. Most explicitly religious software does this.

Instead, you attempt this weird switcheroo where I'm a bigot? Let's recap: a piece of software has officially affiliated itself with a religion that has made no secret of thinking we're evil and persecuting us for it for multiple millennia. I state that this is off putting and wish to switch to alternative software in my own projects. And you call me a bigot for it. Great job, Sherlock.


1. There is no religious affiliation for this project, official or otherwise. It is not “religious software.” The project founder is a Christian, that’s all.

2. You clearly are bigoted against Christians and likely all religious people. Every comment is infused with bigotry. You likely don’t even notice it because you’re swimming in it like a fish.

3. You are free to ignore the code of ethics and the software as much as you like. The code of ethics is not intended to apply to you. This is all clearly spelled out in the document, but you saw the word “Christ” and let your prejudice guide you instead of exercising basic reading comprehension.


If you say so. You seem desperate to cast me as a bigot to explain away my objections. Since we're assuming things about each other's character now, I'm just going to assume you follow this religion and feel attacked by my objection to it being officially adopted by a database library. God forbid, right? Oh well, I've endured a lot worse from you people. Goodbye.

I am an atheist.

There's no desperation and no casting here. I am just pointing out objective facts.

https://www.dictionary.com/browse/bigotry

> stubborn and complete intolerance of any creed, belief, or opinion that differs from one's own.

You:

> But this is a SQL database engine and they chose to publicly affiliate it with religion. That's concerning. I've been considering switching to H2 for a while now to avoid depending on a fat-jar full of binaries. This nonsense has persuaded me to make that switch.

It's textbook. Your decision is not based on any actual technical consideration, but rather "stubborn and complete intolerance." You can't conceive of a publicly Christian person who wouldn't use the software they wrote to somehow attack you, even though Dr. Hipp would never dream of doing anything like that.

Why can't you conceive of this? Because of your bigotry.


> stubborn and complete intolerance of any creed, belief, or opinion that differs from one's own.

What an odd definition, where did you get it from? Bigotry is being unreasonably intolerant. Your definition would cast intolerance of naziism as bigotry (Godwin's Law, yes, I know). But this doesn't surprise me since you don't seem to understand what "goodbye" means either. It's a shame this site has no equivalent to a block feature.


We're not talking about Nazis though, are we? We're talking about well over two billion people (possibly more than six billion if it extends beyond Christianity). Your prejudice against them is almost prima facie unreasonable.

Hetzner astroturf?


Are we getting paid for that?

I need to collect my paycheck.


Engineers that didn't move past src.v35.final.zip version control don't really have jobs today, either.


You would be absolutely shocked how many software projects are still run, to this day, without source control at all. Or automated (or manual) testing. And how many hand crafted artisanal servers are running on AWS, never to be recovered if their EC2 instance is killed for some reason.


Sure, but that’s a small and shrinking market. Not a source of economic security or growth for its employees, nor for most of its companies (though some have defended niches).


I've seen growing companies running multiple million ARR through systems like that. It's way more common than you'd think if you're a professional software developer.


I seriously don't see how version control and LLMs are comparable. A deterministic way to track code changes over time, versus an essentially non-deterministic statistical code generator that might get you what you want, and might do it in a reasonable time frame, and that might not land you in a minefield of short-term-good/long-term-bad design points.


> an essentially non-deterministic statistical code generator that might get you what you want, and might do it in a reasonable time frame, and that might not land you in a minefield of short-term-good/long-term-bad design points.

Sounds like a human? The ‘statistical’ part is arguable, I suppose.


There is an absolute embarrassment of modern tooling in other categories I have no problem whatsoever embracing. I'm not a holdout for being stuck in my ways. Maybe I value things other than expediency at massive cost. Maybe I speak just as well to computers as I do to humans.

I'm sure I will have no problem whatsoever remaining in the employ of a firm that trusts me to make products and tooling that still push the envelope of what's possible without having to resort to the sheer brute force of trillion parameter-scale models.


There is no massive cost. For 80% of the brute work that needs to be done day in and day out LLMs provide code as good as a senior engineer provided you have sufficient competency in steering the model, but done at breakneck pace.


He absolutely is.


You're trying to turn flexibility and the ability to adapt to new circumstances into a vice.

You're wrong. It's a virtue.


Adaptability is a virtue, flip flopping is being disingenuous.


You don't need a special feature for this. Just tell the coding assistant what to do.


Then watch it f'up half your codebase because it thinks it's slightly related to your examples. The alternative, giving it 10 examples, is actually more work.


I don’t think you’ve actually used any of these tools. 10 different examples in the same session would almost certainly make them perform worse.


You should try using the existing agents for your semi-manual editing. You don't need editor support. The coding agent can find "things like this" faster than you can. Just tell it what to look for and how to change it.

What I did was make one commit by hand (involving multiple files), and then told Codex (last year's Codex!) to make the equivalent changes to other instances in the code base.


> But ultimately, the only situation in which LLMs could meaningfully democratize access to software development is one where they achieve a true silver bullet, by significantly reducing or removing essential difficulty from the software development process.

The author didn't seem to read the Brooks essay for comprehension. There is an entire section about expert systems that foreshadows agents. While there is no singular silver bullet, Brooks explores the most promising techniques to reduce essential complexity that were anticipated in 1986.

> The most powerful contribution of expert systems will surely be to put at the service of the inexperienced programmer the experience and accumulated wisdom of the best programmers. This is no small contribution.

Furthermore, his objection to automatic programming was simply an argument from incredulity, which is an understandable opinion at the time, yet quite vacuous in hindsight.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: