skysight-inc/HackerNews huggingface dataset:
Definitely the default for me. I often do think in other ways - I have very vivid auditory imaging, especially with music training, but think visually for a especially anything spatial, navigation, etc., but often even narrate that to some extent (for example thinking through a route before driving and just narrating something in my mind like “yes, yes, yep, yeah, nope, no, ok, uh huh, yep” while I visualise each turn).
Here's an all-time great post about why you might consider SQLite in production with data about performance: https://blog.wesleyac.com/posts/consider-sqlite

I use SQLite in production for my SaaS[1]. It's really great — saves me money, required basically no setup/configuration/management, and has had no scaling issues whatsoever with a few million hits a month. SQLite is really blazing fast for typical SaaS workloads. And will be easy to scale by vertically scaling the vm it's hosted on.

Litestream was the final piece of the missing puzzle that helped me use it in production — continuous backups for SQLite like other database servers have: https://litestream.io/ With Litestream, I pay literally $0 to back up customer data and have confidence nothing will be lost. And it took like 5 minutes to set up.

I'm so on-board the SQLite train you guys.

[1] https://extensionpay.com — Lets developers take payments in their browser extensions.
>Or is this just the latest variation on "the Jews who claim to want democracy and human rights are really going to eat your children" and it doesn't really need to be internally consistent?

Yes. There is a direct line of inference in right-wing dialogue between "The Elites" -> "The Liberals" -> "The Leftists" -> "The Democratic Party" -> "The Socialists" -> "The Marxists" -> "The Cultural Marxists" -> "The Globalists" -> "The Bankers" -> "The Jews."

There are no right-wing elites in their parlance, because by definition all elites are part of the above framework.
SanDisk produced an archival SSD card that is supposed to be stable for at least 100 years. You could put that next to the instructions for reading through the SPI interface, which you can connect to with wires if a sd card slot were simply unavailable.

The card is write-once. They run around $90-100.

https://www.dpreview.com/articles/1049391591/sandiskwormsd
The interviewee suggests referring to oneself in the internal monologue as 'you' or by name, but to this it turns out that I am, as they say, Pagliacci.

(Alcohol and benzos can sometimes quiet things, but of course that's not sustainable)
So is there a general idea for why so many outages?

I’ve used GitHub for 10+ years and don’t remember these outages historically. I’m sure there’s more usage now, but usage has been high for a long time.

My initial guess is Microsoft monkeying with the tech stack to use inferior solutions from their own stack rather than proper architecture design and evaluation.
Show HN: Increase your email deliverability and never land in spam anymore
Possibly retention? A group of friends coming into something together might stick around longer than a typical new grad.

On the other hand, they might all bounce as a group if they're unhappy.
They’d make more money from me (and I imagine at least a handful of others) if I could pay to have no ads, tracking, data sharing, or “algorithms” that I don’t explicitly control sorting and filtering content.
I do not quite understand the premises:

> Given the complexity

Which complexity? It is the simplest possible widespread, reliable and effective solution. Which makes it a primary choice.

> it seems like there are use cases or needs here that I'm not seeing

On the contrary, the use cases for the traditional Relational DB engines are defined: when you need a concurrency manager better than filesystem access. (Or maybe some unimplemented SQL function; or special features.) Otherwise, SQLite would be the natural primary candidate, given the above.

Edit:

I concur about https://blog.wesleyac.com/posts/consider-sqlite being a close to essential read if one has the poster's doubt.

To its "So, what's the catch?" section, I would add: SQLite does not implement the whole of SQL (things that come to mind on the spot are variables; the possibility of recursion was implemented only recently, etc).
Pre-modern life was a meat grinder of poverty and back-breaking work for everyone except a small privileged elite. Sex or skill color could make things better or worse for you, but in general everyone was screwed anyway.
If abortion law, something you can simply drive to another state for a once in a lifetime event is in your requirements for where you can live, don't be surprised when people roll their eyes at you when you bitch about housing costs. Penny wise pound foolish.
Farming? Fruit contain seeds. Thrown on the ground they will sprout new trees.

Taking the bite might act as some sort of catalyst for germination.
For what it's worth, most CS degrees do involve building a programming language.

You don't need a degree to be a developer (I don't have one) but I think it's a good indication that it is actually reasonable to think that every developer could implement a programming language. (And I mean developer as in someone who writes code professionally as their main job, not necessarily sysadmins or designers or whatnot).

To reiterate, I think many more people than think they can can develop their own language.
I've been told paper/plastic tape is actually one of the best archival methods.
With a million open, unsaved Notepad instances.

Lately I've been using Workflowy however and it's actually managed to minimize my Notepad-spam.
Not really, there were quite some people that suggested that in elite circles the classical relationships still dominate. Not applicable to media stars or hollywood but pretty much the high society beyond that. They were completely honest about it too. There are other elements that advertise patchwork families, as if that wouldn't be a huge compromise not only for the parents, but for the children too.
FWIW, 4 does sound a tad young to me. ADHD is supposed to be a diagnosis of last resort after all other possible explanations have been eliminated.

Sometimes bright children are mistaken for having "attention" issues because they are underchallenged and bored.

Unidentified health issues can look like "ants in the pants" and be mistaken for attention issues.

Sadly, drugs are all too often advocated for as a convenience for adults dealing with the child. This can cause permanent impairment because they impact the still developing brain.
Robots are creepy. Why trust AIs that are even creepier?
Any chance I could convince you to share some of those 'rare exceptions'?
I love a good exception ;)

Also they're where the real insights are.
Page doesn't load
I think it's like organizing the olympics or world championships of football; they cost a LOT of money, but with limited return on investment (these days). I feel like one reason is that the world is a smaller place, and countries no longer need big events and showpieces like eiffel towers to draw in the crowds.

I mean what kind of monument would you build nowadays to attract tourists? There are a few monuments that come to mind that have been built fairly recently, like the Statue of Unity in India.
I can't comment on my own use of SQLite as a primary database for anything (although the existence of SpatiaLite [1] may lead to me trying this out), but whoever needs an embedded database system should probably consider evaluating Firebird for that role as well -- it has an embedded mode with basically no feature compromises relative to the server mode. (They even put Interbase -- Firebird's ancestor -- in (not only) M1 Abrams' tactical data system apparently [2], for reasons of reliability.)

[1] https://www.gaia-gis.it/fossil/libspatialite/index

[2] http://web.archive.org/web/20190224100905/https://core.ac.uk...
How can you reject an idea if you do not listen to it first?
Me too, my inner monologue sometimes helps keep me on track. But it's only a mode of thinking.
Timber Mafia and Deforestation in Romania (2020)
I use it together with Rails and the horizontal sharding feature. Each customer has it's own sqlite database running in WAL mode. Since the app is internally used, traffic/writes are pretty predictable.

I also do backups periodically with ActiveJob using `.backup` on the sqlite3 client. It's simple and nice because I just have to worry about running the app, and nothing else.
You can load code written in different languages into different address spaces, you know. Nothing stops Emacs loading a library written in Rust or indeed Java/Kotlin.

Microsoft didn't go that way and again it feels like maybe JS limitations are the cause. Calling into a native library is tough in JS because there's no standardized FFI (browsers wouldn't allow it) and you're going to end up blocking the one JS thread you've got. Native code is going to expect the host to be able to spin up threads and use them because that's a super reasonable assumption, but one V8 can't meet. So they want everything to look like a web server because that's what JavaScript is intended for. That pushes them down a particular path, but it's definitely worth stepping back and saying ... does this really make the most sense, overall?
We've used it in cloud migrations of light SQL Server workflows which were previously run on shared servers.

We replaced SSMS + SQL Server with Python + SQLite run in AWS Lambda. The jobs fetch the database from S3, update with the latest deltas and write out the database and some CSV files to S3. The CSV files drive some Tableau dashboards through Athena.

The SQL usually needs a bit of a rework to make this work, but for the volumes of data we were looking at (we're talking less than a million rows, jobs run once per day) we've seen good performance at low cost. We used DuckDB for a couple of workloads which needed more complicated queries, it's stupid quick.
Handing out cash does not solve any problems. Cf. Afghanistan.

You don't just build a modern country or civilization by dropping some helicopter-dollars, that's not how it works. Unless you tell me you want to send doctors, engineers, school teachers, etc, there, to "civilize" them, but i thought you were against colonization ?
there is nothing scary in the concept of perpetuity when it comes to bonds. the experts may correct me, but I would think that a comparable instrument to this would be a preferred stock: you do not have voting rights, you agree to receive a fixed rate until the issuer buys back or goes bankrupt.

where they may differ - liquidation preferences (I would assume that bonds pay first) and taxation on proceeds (depends on your country of residence).
While not very practical (currently), for the sake of this discussion, it's worth including storage of digital data in DNA [0]. In theory, if the encoded data were inserted into an organism with a long history of survival, such as horseshoe crabs, it could be retrieved from their offspring in 100,000's of years.

https://en.wikipedia.org/wiki/DNA_digital_data_storage
I've used Instacart for a while now, and have never had my account deactivated.
It is a general capability to
modify C code at will,
example:
https://www.chiark.greenend.org.uk/~sgtatham/coroutines.html
Ask HN: Will Apple ever buy Netflix?
It seems like the industry is ripe for consolidation and Apple obviously needs to increase its library while at the same time it seems like Netflix is going to be struggling against emerging competitors like Disney, Paramount, etc. for at least a few years. Plus Apple has a ton of cash on hand that they don't seem to be leveraging so 'buying the dip' right now might be a worthwhile strategy.
https://archive.ph/VLiDt
If I were looking to build a service, not a mobile-first thing, because I don't believe in those, I definitely would.
s/drugs/guns/ there and the setup is mostly the same but the conclusion is far different.

And even with alcohol, we have a DUI problem.
Can you be more specific?

How is autocomplete better in Rider? Faster coming up with suggestions? More helpful suggestions? IntelliSense and IntelliCode in latest VS versions is pretty decent...

Performance in VS has improved since going 64-bit.

What refactorings are unique to Rider?

UI? What features?

Your statements smells of preference and sound vague.
It's way more expensive to get divorced than to get married. Even if you have a "normal" wedding venue and reception. It's not uncommon for a divorce attorney to charge tens of thousands, and of course the spouse has one charging that too.
Is it not possible to connect to tsserver directly? If so, do you have any information why?
Maybe one difference today is that academia is being increasingly flooded by careerists.

In 1950s, most people did not even go to college, let alone grad school. The people who went into science in 1950s were not in it to “get a job”.

These days, many students see grad school as the simple next step after undergrad, because the job opportunities are not good for many new grads (eg biology bachelors).

We therefore see a huge influx of phds and academics, but they are entering academia for different reasons (careerists) than when people did it in 1950s.
> A simpler language makes this more possible

This is false. Rust’s borrow checker is nothing else but an included proof assistant for rust code. The reason it can catch so many memory issues and data races is specifically due to a more restricted language. Also, sel4 is a relatively tiny program which was written for an unusually long time by domain experts. Formal verification simply doesn’t scale to global properties, that’s why some restrictions are useful as they allow local reasonings instead.

For a more hands-on example look at the quality of auto-complete in case of Intellij’s Java vs a dynamically typed language. This night and day difference in quality is yet again possible due to what the language can’t denote.

Re rust macros: I don’t get your point, AFAIK they simply expand to regular old Rust code and then gets compiled, so the exact same safety guarantees apply.
"If it ain't broken, don't fix it". If the apps are working, why should they be updated?
Autonomous driving is totally unrelated to EVs, an ICE powered car can be as (non-)autonomous as an EV one. There was a nice thread recently about Mercedes liability regarding "autonomous" driving.

Well, that the "sleakness2 of software is a thing now when it comes to cars might make an Apple car difficult, the "sleek software" crowd is covered already. And there I was build quality, ride comfort and maintenance costs were also important when it comes to cars... Stupid me. But then I'm German, not sure if me driving French and old British cars offsets my ingrained sense of superiority of German car brands.

But yes, I agree Tesla is on its own in tremendously over selling its self driving tech.
Very interesting, what's your workflow? And how big is the DB?

I've never (deliberately) considered committing a DB to git. Although there was that one time when I was straight out of college...

Pro tip: surprising your colleagues in the morning with a 40 minute wait to pull master (because you committed a ???GB db) is a good way to feel like a right eegit.
And the alternative is what? The SEC is an altruistic, diligent protector of consumers and investors? lol

It is hard to look at the SEC’s most public actions in the last few years and not believe Musk here.
Both, I suppose. It comes down to why we have biology vs physics -- there are emergent phenomena that don't make sense to study only at the level of more reductive elements. Yes, chemistry is important in experience -- or taking chemicals wouldn't effect our experience. But we can clearly understand how an experience is psychologically damaging without haven't a clue as to its chemical underpinnings. And the point is that drug experiences can be damaging -- even if the drugs themselves are non-toxic.
Alright, you cheeky bastard. It's on.

You can expect a deep (and public) analysis of everything you've done with V in a couple of months. We'll see who's right.
It's just projection. Anybody else's prominent people are "elite". Your own prominent people are just fine and only have your best interest at heart.

And yeah, for a lot of people that means Jews. There's a reason we've seen actual literal Nazis supporting the right. They know exactly what "elite" means to them.
Thanks a lot, tmerse! Yes, syntax highlighting is enabled by Treesitter. The colorscheme is `marko-cerovac/material.nvim`.
Sounds like points 1 and 2 can be elegantly combined using "next-gen" filesystems like zfs or btrfs. The hashing and scrubbing (automatic repair) happens in the background and the swapping to new/fresh media is automatic through replacing failing hard drives. Plus, the two are open and widely adopted standards.

I always thought a, say, zfs pool with 2-disk redundancy is not only redundant (RAID) but also servers as a backup (through snapshots). The 3-2-1 rule is good, but I feel like zfs is powerful enough to change that. A pool with scrubbing, some hardware redundancy and snapshots could/should no longer require two backups, just a single, offsite one.
Microsoft and moving things to Azure is my guess.
1 (biological) person = 1 vote. Unweighted by wealth. Anything less than that is a kleptocracy or a apartheid state, regardless of what the online obscurists will have you believe
It would be more like ephedrine.

The problem with alcohol is that it is extremely nonlinear in its negative effects vs amount purchased/consumed.

Prescriptions are pointless because no one needs alcohol to live.
https://archive.ph/5lUV5
Full disclosure: I am a londoner and this is basically how our tax system works except without any of the optionality.

I am not at all convinced that towns have a claim to the tax revenue of people who don't use it's services. The fact regions can force this onto Tokyo etc is a failure of democracy, not a success. We're living in a time when Cities work, and bigger cities work better than smaller ones. They're cheaper, greener, have better social outcomes, provide more opportunities etc. And the response is to try to starve them of revenue to maintain some strange tradition life of worse health, poorer people, less equality and more pollution.

/rant
I don’t know what your culture claims, but freedom isn’t a privilege, and the only good social contract is a voluntary one. Things are never going to work otherwise in the US.
Show HN: A service that confirms your vision status
I don't think there is any particular connection
Show HN: Crypto coin screener I build
Working on this for some time in my spare time.

There are already existing screeners but they dont seem to have the data/filters i wanted so i build it myself.

Would also like to add some backtest functionality later (and once there is more data).
That's not really true, there is a mathematical system (maybe even more than one) where "0=1", but when we say "1", we are not talking about what "1" refers to in such a system, we are talking about what "1" refers to in some mathematical system(s) in which "0≠1"
That’s interesting, I basically always have a clearly English monologue going on, even while visually thinking about things or thinking about sounds or music at the same time. The monologue becomes more sparse and simple the harder I’m thinking in another way (sometimes just reducing to words of agreement or disagreement to the visualisation of something I’m designing or a route I’m planning). But then as soon as I stop doing that I just revert back to monologuing.

I know a little Spanish and a tiny bit of German and I can purposely think in those languages, but I’m way too limited in what I can express that it takes a lot of conscious effort. The really fun thing that I’m not sure is normal is that I can very easily switch my monologue to different accents which sound (as I perceive it in my mind) identical to real ones I’ve heard for long enough to replicate. I’m quite good at doing different accents in real life so I expect that’s linked.
This was already discussed a few hours ago:
https://news.ycombinator.com/item?id=31135972
Apple's documentation for the XNU kernel describes the scheduler implementation. https://github.com/apple-oss-distributions/xnu/blob/xnu-8019...
OSSO: Obtaining Skeletal Shape from Outside (CVPR 2022)
I've always wondered about the inheritance argument. People tend to live a long time now, so that inheritance may come in your sixties or even seventies. The money will provide security in old age, but does not affect the decades when the parents are still alive (apart from the fact that you can make less, because you don't have to save for the old age).

BTW I wonder if financial sector will start offering loans against expected inheritance. They would solve this problem.
Drones are useful for observation, search and rescue as well as defense/offense if they are say kamikaze drones.

Surface vessels already are lit like a pulsar due to their radar…

Civilian marine radars can easily reach upto 25kw.

The AN/SPY-1 which is the radar of the Aegis Combat System has a power output of 6MW….
One of my previous employers was using SQLite as a large distributed database - they had their own custom sharding strategy, but essentially the idea was to shard A accounts * B tables * C num_of_days with a .db file for every shard.

When I first came and saw it, it...did not sound right. But I didn't want to be the guy who comes in and says "you are doing it wrong" month 1. So I went along with it.

Of course, eventually problems started to pop up. I distinctly remember that the ingestion (happening via a lot of Kafka consumers) throughput was high enough that SQLite started to crumble and even saw WAL overruns, data loss etc. Fortunately, it wasn't "real" production yet.

I suggested we move to Postgres and was eventually able to convince everyone from engineers to leadership. We moved to a custom sharded Postgres (9.6 at the time). This was in 2016. I spoke to people at the place last month, and it's still humming along nicely.

This isn't to illustrate anything bad about SQLite, to be clear! I like it for what it does. Just to show at least 1 use case where it was a bad fit.

SQLite was a tempting first answer, but what solved it was Postgres, and we eventually offloaded a lot of aggregation tables to Clickhouse and turned the whole thing into a warehouse where the events got logged.
Is there a tech angle to this submission? I'm not complaining or asking for one, but sampling the stream I wondered if there might be one that I failed to see: most of the time a random wildlife webcam would show a scene too boring even for slow TV, but if you have hundreds of them, some will likely have something interesting going on.

Continuously getting eyeballs on hundreds of streams to select one for the show would be incredibly expensive (the linked streams seem to be more condensed than a 24/7 selection?), but it would be the perfect ML playground: feedback is solved, viewer metrics has been an established field for half a century, wrong answers are zero cost and you could create something that simply did not exist before: real time wildlife where there's actually something to see. (or maybe almost realtime, because the human showrunner might decide to allow a few minutes of serenity from the ringbuffer before the action that triggered the detector walks into view, that would still be good enough for "today, at the current time of day")
I’m a Flight Attendant, and I’m Thrilled the Mask Mandate Is Over
In the US, the resources for the child can just be court ordered as child support even if you were never married. So the legal commitment to the child is there regardless.