skysight-inc/HackerNews huggingface dataset:
The default way we write applications is actually pretty scalable already.

It always hurts to build something that “won’t scale” because it was framed as a negative.

Realizing that something “scales” if it meets your current needs is pretty important.

Framing scale in terms of how many people can work on it, how fast they can work on it, and how well it meets needs is often a better way of considering the “scale” of what your building.

As you said, when request per second becomes a limiting factor you can adjust your scales but doing it from start rarely makes sense (largely because req / sec already scales pretty well)
GP is talking about cost-prohibitiveness of legal counsel

a large company can absolutely drain your small/medium business with frivolous lawsuits.

the point is that Western judicial system largely caters to capital not justice.
SQLite is one of those things that I hear people on hear advocating a lot but have never personally encountered anyone using other than embedded iOS/Android work. I’m talking businesses with 8 or 9 digit revenue, not side projects with 1000 users. I’m talking about teams in the hundreds of developers, not single person projects. I’m talking many services as dependencies, not just one. I’m talking extensive and robust redundancy, monitoring and observability. The list goes on.

There’s a reason for that.

- single writer even with WAL

- missing plenty of alter table functions

Those alone discount it for serious work. Yes, there are workarounds, but why workaround when you can work with Postgres or others that don’t require all of the hassle?

What’s amusing as well as the zealotry around it too. People getting worked up about pointing out obvious flaws. Sad. When did tech become religion?

FWIW SQLite is great for embedded applications, and it’s where it belongs.
The monotonic, scripted, forced-sounding narration doesn't help. Is it human or an AI voice?
That's not the same kind of trust.
The reason is you're not talking to the right people? It's not just talk, loads of us are using it for all sorts of interesting things.
This article makes two main arguments, both of which are (sorry to be blunt) just plain dumb.

The first point is that the claim that "SQLite can support up to 281TB in a single database" is wrong, because in practice you can't get a single disk that big, and therefore SQLite is a bad choice for storing 16GB of data.

The second point is that without indexing, retrieving individual data items is very inefficient. Therefore a big distributed MySQL cluster (which supports indexing) is better than a single SQLite database (which also supports indexing).

Most of the rest of the text only serves to beat around the bush and distract from how nonsensical the core arguments are.
Ya was gonna say the first thing i saw was basically a "correction" post and then you read that and hit

"The actual reason why I think you shouldn’t use SQLite is one of time constraints: Implementing a layer of SQLite will probably take you more time than simply to reduce the amount of files. "

Like no i'm sorry implementing a SQLite layer, vs implementing a filesystem layer is the same time or faster. I mean seriously he thinks trying to negotiate how to stop having 600,000 files is easier than just... ummm... using standard sql?
Can anyone explain why there doesn’t seem to be a market for high-end dumb TVs? I want speakers, tuner, multiple inputs, HDR, 4K. That’s it. I would absolutely pay a premium price for such a dumb TV. I know others in the same position. Am I just in an echo chamber? Or is there something more going on?
There are a ton of very specific pieces of functionality that are built into Microsoft Word that caters to business edge cases. Features that have worked the same way and have not been touched for years for compatability reasons and are not duplicated in other software/services. Word is a bloated mess, but incredibly feature rich.
I think you have to factor in your legal jurisdiction, skill level of yourself and close associates, and the network that builds from that, to compare legal costs.. one might say that as an active and functioning startup with employment, you attracted legal talent.. some outsiders, in various jurisdictions, might have some trouble finding legal services and for the right prices.
Ask HN: How do I bypass geological restrctions to buy a Panasonic OLED?
I live in the US, and I really want to buy a Panasonic OLED TV since they're better the ones in the US. I've tried finding a reshipping service, but none will do it. Also, I reached out to Panasonic themself (+ sales director) and UK retail stores, but they all won't sell one to me in the US. There's none on Ebay or other stores that support HDR10+/DV/DA (only their recent ones do).

Vizio supports the formats, but it would require an external media player to play HDR10+/DV content from other apps/Jellyfin.
Supernova has fixed a number of the performance issues with large mailboxes, but that was fairly recent. People steeped in Windows still prefer the sleek/modern UI in Outlook over TB, in my experience, but the biggest benefit in Outlook is just the tight integration in MS/365 land.

Calendaring in TB always felt like a bit of an afterthought compared to email, and for personal use, that makes sense. For business, strong calendaring with meetings/shared calendars/availability and the tight link to meetings (Teams)is not done as well anywhere else.
Disability augments.
its that Andreesseen is engaging in what most would describe as security fraud with crypto and that he feels emboldened by it.

lot of voices in washington to make an example out of him. not sure if he's aware
> Do you know how large the biggest hard disks or SSDs are nowadays? [...] no single disk will have 281 Terabytes of space. And that is what you need: Since SQLite files are single, continuous files on your file system, they have to be stored on one, physical hard drive. You could theoretically split them up, but then they wouldn’t work anymore until you pieced them together again.

> So the practical limit of the size of an SQLite file is much lower than the theoretical limit.

I agree with the conclusion, but the argument is horrible. 281 TB are easily doable on a single file system (not hard drive, which is entirely irrelevant) is very much doable. You can actually build a rather cheap consumer system that will do that. It won't be good, but the problem is not the continuous allocation of space.
Hardening the kernel against heap-spraying attacks
We are in a infinite growth economy. Numbers must go up 20% year over year otherwise your business is failed and you should just file for bankruptcy. Gotta squeeze as much wealth out of the market regardless of everything else. Short term gains over decent nice to use product.
Lots of people use sqlite or derivatives of it lol. If it wasn't we wouldnt have stuff like pocketbase, rqlite and other derivatives that build on top of sqlite.

The thing with sqlite is that no one sees a need to "advertise" that they are using sqlite... it just works not fancy, (there are fancy things build on sqlite like rqlite, dqlite, litestream etc) but for the base sqlite at the end of the day its a quick file based db that just handles itself well.
>or because of the temporary artificial economic situation of that period that doesn't apply anymore?

A mix of both. Clearly if they thought they could get double the money with the same amount of people they would not have gone on a hiring spree.

If you want to take an inference: most companies post layoffs are still larger than 2019. So that implies that the inflation wasn't all temporary.

>but most tech companies aren't there to provide social services, but to make a profit,

Sure, companies will be as evil as regulation allows them too, nothing new. As I said, just becsuse people are numb to it doesn't mean we shouldn't call it out.

>There are plenty of tech jobs out there that won't crash or won't let you go the moment the shit hits the fan, but they also won't pay anywhere big-tech TC.

Oh it's okay. I work in games. I get the worst of both worlds, this isn't about chasing total comp for me.

My #1 goal is growth and it just feels like it stagnated in the professional conrext. Spending as much time looking for a job these past 2 years as I am working jobs.
I've just kind of accepted the plataeu and am doing some indie work. But I still need some stability, and it's not like "lower paying" (so, well paying but not close to 400k total comp) are biting any better in this market. So may as well apply yo what I know.

>People aren't complaining about making bank, earning orders of magnitude above average pay during the good times, right?

My sector is :)

>why do they expect sympathy when the charade that made them bank for a while comes crashing down?

Outside of the above reasons: becsuse it's not sustainable. Stability is a big factor in any job market and in All sectors it feels like an all time low. Loyalty/tenure is dead and that's going to cause a huge brain drain across all white collar work as the seniors who live in an age of proper retention take off. It's a ticking time bomb.

I don't care about sympathy, we're on the internet. I do hope at least some people can look at the grander picture of it all, though. A storm is coming, not necessarily I the next 5 years, but maybe 10-15.
What on Earth difference does this distinction make to "Joe Public", exactly, given that they lack the wealth to navigate these systems?

"Ooh wow, I better understand how the system is specifically structured to grant inherit privileges to those with wealth, now I feel... ???"
You also shouldn’t use sticky headers that take quarter of a mobile screen and do nothing apart from screaming h1 in your face. Couldn’t finish neither article because of that.
The EPA can only do what Congress says it can do. The law Congress wrote deliberately creates a distinction between existing uses and new uses. And the law deliberately makes it harder to ban an existing use than a new one.

The environmental laws are full of those distinctions. For example, under the clean air act, the emissions control technology you need to use for new emitters is different than for existing emitters. Congress doesn’t like to disrupt industry because voters care vastly more about jobs than they do about the environment.

Why would it be “reasonable” for a court to leave an illegal agency order in place? That seems like the opposite of reasonable—that sounds like lawlessness.
Thank you for sharing your projects with the world. I'll leave this here as a hint to the parent commenter:

https://simonwillison.net/tags/dogsheep/
KDE6 release: D-Bus and Polkit G(al)ore
If I understand correctly, you're concerned about using older peripherals with a newer motherboard/CPU? If so, the PCIe spec requires backwards compatibility so it should still work.
Interesting, what systems are you asking questions to? I find GPT-4 is pretty much always correct about simple questions I ask. I just avoid using it for anything really deep and refer to documentation instead.
Human lifesoan hasn't changed, only average age of death has. (You may be alluding to this)

Average age of death has gone up, due to asprin, antubiitics, vaccines, improved hygene, and so on.

I don't buy the wear and tear side of thibgs, and zoo animals, pets have vaccines, health care, medicine, and checkups too.
I tried using Libre's alt to MS Access (database). It couldn't open an Access file (couldn't create a connection).
somehow I think there is more to this story than what is presented.. meanwhile, amateur skydiving among able-bodied people was fun in the 1970s.. there was a street musician in my neighborhood who was experienced .. in more ways than one! he is fine and has lived a long life.. airplane people seem to attract legal type-A characters, it seems..
Office is Final Cut Pro. It is brimming with features and power.

But lots of people aren’t working at some corporate office. Mom and Pop can get far with the iMovie option like Google Sheets and Docs.

Actually now that I say that… what I want is a LibreOffice equivalent of Google Docs and Sheets and Presentations. Google is the only bad part of my Docs experience.
Wikipedia: Content Disclaimer
Does that include voice to text when users yell at the computer and chuck it at a wall?
Bad move. Libre office is awful for an employee coming from MS
Is it just about the default font? Most office workers have 0 sense of aesthetics and sometimes official guidelines actively make things ugly (like forcing fonts like Times New Roman on everyone). Or the cutesy Calibri on official notices.
Ah yes, makes sense. I use a stovetop pot on an induction plate. It heats up super fast.
Yeah, how dare people be upset when you wave capital in their face and say "stop being poor and then you can take advantage of your peers like I do. It's okay, its The System". Come on.
I'm not sure if uour answer is sarcastic, or serious. I suspect you got a downvote for that ambiguity.

Yes, I think there are people who ascribe negative connotations to making use of financial systems. Where I've encountered them, for the most part, they tend to be less-wealthy folk looking for some external reason for their perceived lack of success. To be honest I don't really care what they think.

I do care somewhat about making people's lives better, and some of that "better" means less risky. Having insurance doesn't make you a bad driver. Structuring your finances well doesn't make other people poor, and doesn't make you somehow riskier.

Yes there are those who infer that, and that's fine. I'm not spending my retirement worrying about folk who didn't agree with my life choices. I'll spend it spending the assets I have left.
But that’s wrong. It comes from a tradition where judges were “dispensing the king’s justice” in an undemocratic society. We are more civilized now.
CXL is nice. It doesn't change my belief that accessing RAM over PCIe will not be a win for very long.
Wallace and Gromit: Enter the Matrix [video]
Feels like I'm quite wrong when I said (and got flagged for saying),

"Gonna cause quite the firestorm, creating something new everyone will be expected to support and maintain, after Google balked at bringing in jpegxl because they would have to support it."

I still really find the messaging here to be awful. There's tons of comments asking how this related to JXL. @JyrkAlakuijala chimes in in https://news.ycombinator.com/item?id=39921484 that yes it uses JXL techniques, but also it's just using that repo because it had infrastructure which was easy to get started with (absolutely cannot argue with that).

I'm not sure what my ask is, but this felt like a really chaotic release. It's unclear how much good from JPEG XL got chopped off. I'm glad for the iteration, this just seemed really chaotic & unexpected, & NIMBY-istic.
What are the 5 companies? If most of them fall under, "the biggest and most valuable companies on the planet" then no, that's not low barrier.
C++ coroutines do not spark joy (2021)
Heavy characters in Mario 64 have tighter handling than lighter characters and can cause them to spin out when bumping into them.
Thanks for the recommendation！;)
How is that different than a dishwasher? The problem is collecting the dishes and putting them away, not washing them. Unless you’re imagining something to scrub pots and pans?
Location: San Francisco Bay Area
Remote: Yes, Hybrid or Onsite in Bay Area is fine

Willing to relocate: Yes

Technologies: Python, Java, Springboot, Rails, React, JS/TS, NLP

Résumé/CV: https://tinyurl.com/32xmm96y, https://www.linkedin.com/in/matthias-lee-dong-en/

Email: matteolee72@berkeley.edu

I am a Software Engineer from Singapore that is currently in the Bay Area. I am looking for a summer internship and am also open to work beyond the summer. Most of my experience is in web dev with a focus on backend. But I am more than willing to pick up new technologies quickly on the fly!

I am on an F-1 Visa and unable to be paid in the US, but what I am looking for is instead being able to work alongside passionate engineers that are excited and invested in what they are building! If you are hiring I'd love to chat more about the possibility of contributing to your company, whether over coffee or a virtual call. Let me know what works best for you! Looking forward to connecting.
> Are you from 1950?

First tv ad in 1941, first radio ad in 1922, first newspaper ad in 1704, first known written ad in 3000 bc.
It's not so easy to get non-rich people to pay, either. The court can order it, but the court doesn't do enforcement. The party owed the money has to go pay another outfit to do wage garnishment. Of course, the debtor can just quit and go get another job, and that step has to be repeated.
My opinion is that Apple started from a position of “self driving vehicles are coming, how can we be a competitor in that experience?”

They were 6/7 years into the project before realizing that self-driving was a tougher nut than anyone had thought. And a couple more years ended in c-suite saying “prove to me this is with continued investment”

The closure of the project was a grim willingness to admit they couldn’t solve the problem. The fact that they spent so long on it is (I think more than anything) a sunk-cost fallacy.
And this is why you keep the academics away from industrial systems. Dentists curse: because they're so knowledgeable about their own area, they un-self-critically transfer that confidence clean outside of their own domain, and then having a nice engineering conversation becomes impossible as their ego becomes involved in the opinion.
> I wish it was more socially acceptable to ice skate recreationally with safety gear.

That depends upon where you live.

However, I am sympathetic to your concerns. One idea: Find a lake or river that is frozen and go skating with a friend that also wears safety equipment. You will feel less social embarrassed for being the only ones with safety equipment.
This podcast with SQLite's Richard Hipp was fascinating as I didn't know the backstory and deeper history:

https://corecursive.com/066-sqlite-with-richard-hipp/
Maybe part of the problem is that people aren't having grandchildren anymore.
I can remember the same or very similar news from Germany appearing every now and then for over a decade.

This time I almost believe them as there seems to be no alternative to LibreOffice given the changes Microsoft introduced during the recent years - forcing everyone to log-in with their Microsoft account at best, also moving from a classic desktop app to a web app. Conservative users like me and probably German state institutions consider classic desktop apps and web apps distinct tools for different tasks and don't want their desktop to depend on cloud.

It is also worth mentioning that LibreOffice became much better since the time the discussion began.
Can you share more about your near-death experience?
JWST has solved a lot of puzzles, and created a few more
All Tux, no bucks?
Upon consideration, I wonder if this is an artifact of the incentives that drive academics towards a career rooted in /being right/. Contra, in my industrial experience, working in empirical contexts and actively invalidating tiny hypotheses.
model https://huggingface.co/jetmoe/jetmoe-8b
Now this is ~~pod racing~~, uh, game theory
two cups of coffee from Starbucks
here's the thing and i had my share of arguments on twitter around this

if your work is not generating $$$ its probably not worth anything to sue over

all these artists are rightfully upset that Stability is making money off them by scraping their copyrighted content from Deviant Art or Tumblr

but without significant revenues, you are at the mercy of eager class action attorneys who will take most of the winnings and are just as quick to settle for a 99% probability of cashing out.

so it is a "crime" like it would be if you would run gameboy ROMs on emulator.js and sell advertisement. It won't even register on the politicians minds.

Hollywood studio finding their work used to train LLMs? Well you saw how eager biden was taking down Megaupload.

Money talks and your content if its not owned by a large studio and not raking in significant tax revenues, its probably worthless in the minds of the judge/jury/politicians
Blender represents an outlier in the OSS landscape, largely due to its unique product vision. Its development was driven by practical use in creating open movies, which provided a built-in customer base. As a niche 3D software, it was subject to less conventional expectations in its presentation, allowing it to stand out. Despite this, Blender’s UI/UX design has faced criticism, suggesting that if it were applied in other domains, the reception might be even less favorable.
This thread reminds of a competition I once joined where we were supposed to fine-tune an LLM to fill out trivia answers, and we were expressly disallowed from training on the validation set.

However: we were allowed to pick any base model in a given repo. All of the teams that “won” did so for the same reason: they had all picked the same base model (whereas a majority of teams picked the given default), presumably the one that had at some point been trained on the most favorable data for this particular challenge.

It was quite silly. Had everyone had the same base model we’d have a bit more of an interesting problem (more around NLP and alignment than picking the ‘best’ model).
> no drag from a partially deployed chute

As I recall, free fall is about 120 mph, while a tangled chute can cut it to 60 mph. I know this from a newspaper article about a man who survived a tangled chute fall onto pavement.
I don't think this is true. My startup had a couple desks in the Palace of Fine Arts when they had an ill-fated attempt to convert part of it to a co-working space. They shut down co-working to turn it into a full-time event space. The building is basically one giant room, with a raised mezzanine floating above part of the floor. It has one small permanent theater on the north end, and they convert the southern end into a larger theater for music shows, and this is the seating chart being shown in the above link (I saw a Ninja Sex Party show there one time, but this theater isn't reflected on the tour photos. When I was working there in 2016 it was an exhibit for Hunger Games).

https://palaceoffinearts.com/tour/
I don't agree with your comment about scuba diving.

Not to be a shill, but I always use World Nomads Travel Insurance when I travel for scuba diving. It is simple to apply online and pay with a credit card. They have two levels of travel insurance: one for low risk activities, and another for higher risk activities, such as scuba diving.
It stayed at #1 for most of the day. Naively, I quit my job to work on it full time. Pretty sure it’s also what got me a YC & Sequoia interview. Alas, making something HN viewers find cool != PMF… at least not yet.
The name “shader” screwed me up for so long. But once I better understood what they really are I think they’re incredibly powerful. “Kernel shader” is amazing.
Well it really depends on how you use the programs you are comparing.
Thank you for making SQLite such a delightful way to share research through datasette.
GPS is a colloquial synonym for navigation, as in "I'd like to rent a car with GPS".

When GPS is trash talked, nobody understands that to be the satellite system.

And you can trash talk that all you want; it is immune to bad PR because it has no competition.
I've been using libreoffice for maybe 10 years now? I don't remember what I'm missing, could you name one or two killer features of ms office?
Because Google Docs only has 10% of the functionality? Also your anecdote is user error.
The Xz Issue Isn't About Open Source