skysight-inc/HackerNews huggingface dataset:
I am very curious how you are going to get SQLite working with piping, especially on extract... It's pretty common to do stuff like "curl ... | tar xvf -", so that you can start extraction the moment first kilobyte of data arrives. This really saves a lot of time, as disk + network work in parallel.

A less common tar's feature is packing on compress -- stuff like "ssh remote tar cvf - ... > local-file.tar", which skips temporary file on remote machine, and also saves lots of time in transfer.

But for both of those, sqlite's "memory" won't help you there - memory or not, you still need to have the entire file to read it. So if you just store file contents in the sql database, then you have to fetch everything up to the latest byte before you can get any data out.

Maybe you can have index in sqlite, and append data as-is... but where would you put that index?

if you put it in front (like squashfs), you need to produce entire metadata before writing first data byte.. and that should include compressed sizes too (assuming you want to support random extraction), which means you cannot stream file out until you finish compressing all the data. And also sometimes you will not be able to add files to the archive without rewriting the whole archive (if the index grows and you didn't leave enough padding). This might be OK, but definitely should be mentioned.

If you put it at the end (like zip), you will be able to stream file out during compression, but fast decompression would be impossible. Also, you'll forego any sqlite transitional guarantees - since the database will be created in-memory, and only written at the very end once all the files are written.

So frankly, I don't see how you can win on a streaming front, unless you really have a custom format and "sqlite3" is just a small part of it.

(Another problem is there is not even a short spec - how is sqlite3 used, what is your schema, and so on. And I am sorry, but I am not going to read the source code just to figure this stuff out).
Trust in SaaS
"people do not care" - Please stop repeating this false statement. When you repeat it you give it legitimacy, and take the time when other statements could be made.

Most people are helpless to make change. Greater than one million adults serve in uniform services of some kind where they literally must comply. The ad budgets and massive, overflowing volumes of money generated by "surveillance capitalism" buy the consent of the mercenary finance occupations. None of this means "nobody cares"
The Intel 8088 processor's instruction prefetch circuitry: a look inside
SSPL protects vendors from competition of likes of Amazon, cool, but is this what Open Source is about ? I belive first and foremost Open Source (term) is first and foremost about value for Users of Open Source Software.

As a vendor/developer you surely can chose not to provide software users some freedoms, but when lets not call it Open Source

More in this https://peterzaitsev.com/open-source-perspectives/
Sucks doing something you know is a waste. I value my time and personal growth more than my employer does.
Eh. You have lie-flat seating today which pretty much has the advantages without the disadvantages. It just comes down to cost.
My rule of thumb has generally been "if there's any chance I'll want to watch the movie more than once, I'll buy the blu-ray."

Until about two years ago, I was happy enough to pay for two streaming services (HBO Max and Hulu), along with Amazon Prime, and I treated that like my "rental store". The first viewing would be to see if I like the movie, and if I did then I would immediately order the blu-ray.

Now I've canceled all my streaming services because I don't want to pay for a million of them.

Just a note, I will very frequently put a movie or TV series on in the background while I work on other things, probably even more frequently than I turn on music. I just like having noise from a movie or show that's familiar for me.
That's that the original poster means with "Jellyfin", it's just an OSS version of the same type of software.
The problem is that government helping big corporations make piracy less effective (dmca, forcing telco to give up customer names) and the lack of effective piracy doesn't put enough pressure on media company becoming better and offering a decent service
Nominative Determinism is a hell of a thing.
Fun fact: if you still have a MySQL (MyISAM) database, the transaction commands return success but don't actually function, so you can't roll back.
Given how much the quality of the cleaning regime varies between airlines, I shudder at the thought of what you might find in, for example, a British Airways bunk bed.
Stuff like this always makes me think: what super structure do our brains form? Always end up concluding it’s the economy
Traumatised people often think their defence mechanisms are virtues
NASA is testing new designs right now to dampen supersonic booms with an eye towards changing that regulation.
Doing the least you can at work is also called "meeting expectations." Why are you going above and beyond to create value you won't capture?

If someone is willing to pay you a lot for not doing much and is happy with your output then what's the issue? People working multiple jobs is typically a sign of hard work. They could be playing Xbox instead but they chose more work. Spinning working on things that no one asked you to do to fill the free time can't be better for you or the economy than doing useful work somewhere else.

Like yeah sure it's probably a violation of your employment contract or whatever but ignoring the rules is practically the west coast hacker spirit. And ethically I have no issue with it at all. You can pay for hours or output, when I meet my output goals the excess hours are mine back.

Folks will unironically joke "the reward for hard work is more work," put zero additional thought into it, work hard and wake up 10 years later burnt out, getting 2% raises, with their job consuming their whole lives.
In the US, you're legally entitled to create a backup copy, but breaking the encryption on the disc to actually do so is illegal.
The license choice is interesting here - this means if there are many committers and there is no requirements like CLA it becomes impossible to change the license and have proprietary forks without all contributors agreements.

I agree though I would rather see them choose to stick to BSD and work on creating community of vendors (rather than Redis Labs monopoly) perhaps some purely Open Source, others proprietary.
This is a better link that gives some details: https://www.sterba-bike.cz/item/the-bike-collection-of-robin...
> What specific needs are met by daily status updates?

You are assuming (1) that standups are status updates, and (2) that they are scheduled by manager, and (3) for benefit of the manager.

In the last several teams I’ve managed, it’s the crew that has encouraged meeting daily, and in the standups they are mainly talking to each other. It’s where they cover hot topics and bugs for the day quickly, with the fluidity of spoken conversation instead of Slack, and also there’s a non-zero amount of friendly casual conversation.

Don’t force teams to have standups, but also don’t assume a team won’t like it.
In the US, stop requiring them to work for health insurance so they can take a few months off between jobs to recharge.
I believe in the states, it's technically illegal to break DRM most of the time, though I think there's a million possible exceptions, and I don't know how much it has actually been tested in court.

I figure, though, that if I'm buying a legit copy of the blu-ray, and I'm not distributing copies to people, I'm probably not very high up on Disney's "sue them" list, even if I am technically breaking a rule.
To the creators: I've already read three very interesting blog posts that I never would have read otherwise. Well done.
Show HN: Rotary Phone Project
Separately: we should be careful of carrying the right wing's water and adopting terms like "DEI" as negatives without thinking critically about it.

This is straight out of the Chris Rufo playbook; identify a well-intentioned but possibly flawed concept, create a caricature of it, and make that strawman the punching bag of every anti-inclusive political voice. Then, because it's a term liberals were already using, turn around and use it to attack existing institutions.

This is his explicit strategy for kneecapping "CRT" (formerly an academic subfield), "woke" (a social concept among American Blacks), and you can see it unfolding in real time against "DEI" (formerly the way HR departments tried to comply with the Civil Rights act, but now a catch-all negative term.)
Well, we don't have the tech to build such a simulator ourselves, so we'd have to be a leaf node of the simulation tree, that has yet to run long enough to discover how to spawn the next levels. But I guess not all leaves are successful at spawning - some just self-destruct.
Somewhat similar to Rich Hickey's talk:

Hammock Driven Development:

https://youtu.be/f84n5oFoZBc
Looks like the 4 CPUs are hardened versions of the VexRiscv cores that were already used as soft cores in their previous FPGA product line.

If I had to design my own FPGA, I would probably make the same choice. It’s one of the best CPUs out there in terms of area/performance/functionality and available under an MIT license.
I mean, I never build a query from front to back. Usually I build it FROM -> JOIN -> WHERE -> SELECT.
I mean I totally agree with you, I just don't think there's political willpower to swallow the pill and actually pass legislation that would increase taxes.

Because, all else equal, capital owners (who set the policy agenda in Congress) would prefer to keep their wealth continue rolling the dice until they can't anymore.
As with all compressed media, resolution takes a backseat to quality of mastering / compression.

I've yet to see a poorly mastered Blu-Ray, and only watched a couple Blu-Ray 4k discs, but online streams at 1080p or 4k are sometimes rather bitstarved so...

With DVDs, some, perhaps many look just fine on a larger screen, but there are some whose mastering is very poor, and those will look really bad on a larger screen. My copy of Forest Gump features closeups where the characters face translates around on their head. But most of the other DVDs I've watched are fine. Yes, Blu-Ray would be better, but not so much that its worth rebuying.
There are 2 parts to this argument, first being people are justifying their iPhone ownership,(and cult membership) with "Apple should do exactly what they are doing" because I like what I get, and I don't want the other folks in my cult ;).

Point 2 being the H in HN stands for Hacker defined as: "a person who uses computers to gain unauthorized access to data." Then the argument becomes why are people who are reading HN and, presumably, calling themselves hackers so interested in keeping status quo and letting Apple control everything? I think we go back to argument 1 and excluding others, green bubbles and such making a subset "better" than others. Elitist as F and some folks, like myself cannot stand for this and take time to explain the failure to others.

Pretty simple really ;)
> The point is, generative AI images are not widely regarded as good art. They're often seen as passable for some filler use cases and hard to tell apart from human generations, but not "good".

> It's not not-there-yet because AI sometimes generates sixth fingers, it's something another level from Gustav Klimt

My point is: yes AI is different — it's better. (Or, less provocatively: better by my specific standards).

Always? No. But I chose Der Kuss specifically because of the high regard in which it is held, and yet to my eye it messes with anatomy as badly as if he had put 6 fingers on one of the hands (indeed, my first impression when I look closely at the hand of the man behind the head of the woman, is that the fingers art too long and thumb looks like a finger).
> Except, for Google, I did not use the "how do I" etc. and just threw some keywords at it: "python f-string wrapping", "python f-string folding", etc.
The MySQL client has an --i-am-a-dummy flag that won't let you run a DELETE (or UPDATE, I think) without a WHERE.
IDK, the degrowth, anti-progress posters are giving them a run for their money
Getting fired by whom? He is both the majority shareholder and controls the board
Health insurance does cover normal maintenance on the rest of your body. Mental health, sexual health. Regular check ups. Regular blood work.
Styledown is a simple markup language for representing styled text
> If you take the entire quoted search sentence from your third paragraph, then Google also presents a complete solution.

Which one is the complete solution you're seeing here?
https://www.google.com/search?q=how+can+I+create+f-strings+i...
Nice demo! I wonder whether GPU acceleration is actually beneficial for real-world examples, i.e. once you add network overhead, real world data sizes, the more complex data structures that Redis/Garnet offer, etc.

Maybe this would be particularly useful as an embedded KV store in another larger application where perhaps the limitations of the VRAM size are less important. My guess is the main beneficiaries of that would be ML training, but as they're already using the VRAM it might not work out there.
Financial Times tests an AI chatbot trained on decades of its own articles
Indeed. Just looking at and zooming around is incredibly thought-provoking.
You don't need a RAID. Just have 2 hard drives and copy stuff from one folder to another. Click skip all for identical files that already exist.

I've had jellyfin serving my music, family videos and youtube rips (e.g. university lectures) for years. Haven't had to touch it since I set it up. I just plop files into folders and it picks them up.

I got a lot of family videos from my mom, who keeps them on her computer plus an external hard drive, which she brought to me to copy. Copying files to USB drives as a backup and sharing that is pretty understandable for non tech people.
The fact that we never legislated to force providers to allow any client connect to their streaming API (keeping software like Winamp, VLC, relevant for new world) and instead doubled down to allow complete control of content providers over our culture is one of big societal mistakes of last decades.

Following the example of Hollywood which forcefully split content studios and cinemas would create a much much healthier market.
Pretty sure that these mugs had warnings against being microwaved. That’s one big reason I stopped buying Starbucks mugs. I like to be able to use my mugs in a microwave.
It's not ~too~ geeky to maintain a NAS. I got a Synology. It has 5 drives, and the ones I have are fairly quiet so the thing goes under the TV counter.

However, if you want to rip 4K blurays, you've got to flash the firmware on your bluray drive and then run MakeMkV + handbrake (or much harder CLI stuff) to process a disc into a useable media file which can THEN go into Plex. All of that takes time and effort, and usually some trial and error.

I also keep a bluray player next to the NAS. Simply because it's too much of a pain to deal with ripping sometimes. I still have to get through my 30-disc Ingmar Bergman Criterion Boxset that I bought 2 years ago. Much easier to pop a disc in the player!
carbon-free will take a really long time to be cheaper.

As soon as demand for oil starts to drop, so will oil prices, and I suspect they could go down by a factor of 10 or more and oil-rich nations would still think it worthwhile to exploit at least some reserves.
> You have lie-flat seating today

And Finnair are probably demonstrating the likely direction of travel in that area. Finnair are in the process of replacing all lie-flat seats with non-recline slouch seats that you can lie flat in by shifting your body rather than mechanically modifying the seat. Search "Finnair non-recline" on YouTube, lots of videos, here's one randomly picked[1].

[1] https://www.youtube.com/watch?v=jSKb48_zKqU
You can write a using macro to automatically create a behaviour from specs in a module with https://hexdocs.pm/elixir/Module.html#spec_to_callback/2

It's been a minute but I've done it.

The behaviour/implementation setup reminds me of Java, especially when they're exactly the same.

I do recommend only using mox as far down as possible (only around libraries).

Hammox is Mox on steroids, check it out too.
Anyone know how to donate a movie or audiobook to a library (in situations where they don’t have them)?

I’m interested in the concept of donating media to the library instead of buying it for myself. However, it doesn’t seem like there’s a simple way to do that…
Given all the talk here, it seems like the state of the business and the state of the stock market are grossly out of whack. Of course, that happens from time to time.
The problem for insurers is adverse selection and the long timescale of dental problems. The only people likely to sign up for plans that cover $10,000+ dental bills are those who know they have such a bill coming up in their future, which would cause the market price for such a plan to be so high as to make self-insurance a better prospect. This is less of a problem with health insurance since the most expensive ailments can’t generally be put off for an extended period of time (and because of universal coverage requirements, such as they are)
Someone could be willing to work for a lower than average rate if it’s the right company though.
Effect Handlers and Mathematically Inspired Language Constructs [video]
What does speaking with impact entail?
"The airline did not respond to a request for an update before this piece went to press" ... Would not have guessed that aircraftinteriorsinternational.com had such tight deadlines

Which is a pity because it's a very interesting article
Understanding the Wiring of the Human Genome
> Where I see it as the same thing: the SELECT columns, like the variable assignment, are the interaction point with the following lines of code.

Indeed, which is why source(criteria) -> results makes more sense: the results definition is right next to the code that's going to be using that definition. If you put the results definition first as with SQL, then you have to scroll up to find the context (although perhaps Python's indentation sensitivity is the tripping point in this case). Not even mentioning the fact that the SQL way completely destroys any chance of code completion.

I'm going to boldly state that the SQL way is literally objectively wrong, in that there is no world in which SQL's choice is superior for general querying.
There are NAS devices from a bunch of manufacturers where you can just buy them, plug them in, run through the setup wizard, and click install on the Plex app in their built in App Store. Not much more difficult than getting printer drivers installed.

That’s certainly more than many people are able (or willing) to put up with, and it requires a several hundred dollar investment. But NAS ease of use for common tasks is pretty good theee days.
The crux is that I doubt they intended this.

A company that sets out to obtain VC money and blow it all on open source software without turning a profit, is going to leave behind smoking guns. Those will turn up in discovery and make one's life rather difficult.
To squish more ppl in an aircraft while not creating deal breakers of problems is quite the interesting Problem to solve i think.

Like i would be totally ok to have 50cm heigh bunks like in an uboat, but most ppl would probably get quite anxious in such a coffin.
If you are not thin you cannot rotate in such a bunk or even put your hand on your stomach, or even fit into it.
conservatives aren't included in "diversity"?

Who else is excluded? Who keeps the list and how often is it updated?
> It just comes down to cost.

I want 5-high bunk beds in specially made planes with lower/no cabin floors. Then lay-flat flights can be even cheaper than regular seating.
The actual ISO standard falls well short of being useful/sufficient to anyone who isn't an incumbent player. It's effectively a moat and therefore a direct impediment to competition from teams who have novel technical ideas but don't have access to significant capital - building a SQL implementation is a long, expensive journey. This is why many startups resort to building Postgres extensions, or using Calcite or DataFusion.

If SQL weren't so (needlessly) complex we would see much more competition across the database space.
Very interesting. Did Robin Williams ever talk about cycling or share his views?
NIST has a similar setup. There’s an exemption for e.g. summer students who are issued temporary non-PIV badges, but they’re issued a yubikey that’s required to access the network from off campus
where I live in Portland Oregon there is a store called Movie Madness that has about a 80 thousand titles on dvd and vhs (you can rent a vhs player with an adapter). The films are sorted by director country and genre. It’s pretty amazing. I’m there every week because it’s a few blocks from my place, it blows away streaming because they have everything I come across online.
Isn't "quiver" the proper collective noun for bikes? (but does it include, as according to TFA, unicycles?)
Very cool! Though I'm not convinced this isn't just some covert furry sneaking his gear into the mainstream.
When all those creative, skilled IT people found they could make double the money moving out of higher ed into start-ups and industry at the same time that the administrations realized that crazy IT stuff was actually mission-critical and that they needed to use what cash they had to double-down on reliable rather than creative the die was cast.
Ask HN: Classification of Parallel / Concurrent Programming Methods / Offerings
I looked a bit but could not find anything useful so here goes: Anyone know of any classification / organization / taxonomy of parallelization / concurrent programming techniques and / or offered tools / libraries / languages? Something such as arranging the offerings like MPI, Rust, openMP, CUDA, gnu parallel, xargs, pthreads on some kind of spectrum of usability / expressivity / power or paradigms such as shared memory / distributed memory?
I don't want to search. I want to filter your ridiculously large database to find
certain information.
This is cope. those applications are there because they work. Mistakes in "20M LOC monoliths" are exceedingly rare in the financial world. Look how bad "hipster" software is in comparison! Billions in profit means billions in quality
I spent more than a year living with the numerous downsides of high level CDE (containerized development environment) tools. I must admit that I am very skeptical about all options available right now and that I have rolled back to using plain, old school, docker compose based CDE.

Both .devcontainers and .devfile managed to create more effort than they took away. Some key points:

- long lived containers

- abstracting away the fact that you run stuff inside containers in the IDE and abstracting away the container life cycle

- cryptic error states and error messages, especially when setting up new projects from scratch. This often boiled down to bad plugins (even Microsoft's own VSCode plugins wet the bed often)

- only superficial support for podman

- bad support for arm based HW (and arch translation issues, like a tool requesting arm containers but the host running docker is x64)

At this point I consult teams to try out a plain compose.yml as a CDE and skip the "enterprise" stuff.
Ha, I assume you are joking but of course this is a valid point.

If you use your own domain, that should equal self-hosting.
Using another domain than your company's does not mean it can't be self-hosted, but it is a strong signal. And AFAIK, Slack does not offer anything like redirecting to on-prem instances from slack.com.

And conversely, there is no way to self-host Slack, right? Which was gp's point.
In what way? It seems to me like big business won the internet