skysight-inc/HackerNews huggingface dataset:
> It’s probably also fast because you have a warm cache - e.g. there’s enough memory for the DB to have the indexes 100% in memory, which is just not feasible with large DBs in the real world, where you can easily have >100GB of indexes + hot data, and the DB can’t keep it all in memory.

That's the point? Sure there is a scale where it's infeasible, but you can quite easily (albeit it's pricey) get DB instances with hundreds or thousands of GiB of RAM. Even if you can't get everything into it, your working set is often not the size of the entire data set. My company's main MySQL primary has around 800 GiB of storage, and only about 1/3 of that in RAM. Disk read IOPS are usually 0.

Nevertheless, I recreated this in Postgres 15.

The total index size of the two tables is 790 MB according to `\di+*`, so I'll set `shared_buffers` to 263 MB, then restart and re-run.

For reference, time with current settings is about 6.8 msec for `is_primary`, and 1395 msec for `NOT is_primary`.

After a restart, I ran the query for `NOT is_primary` first, which took 1740 msec. The first run of the query with `is_primary` took 21 msec.

My DB is hosted on older hardware, and the files themselves live on NVMe drives presented via Ceph over 1GBe.

EDIT: I forgot that Postgres uses OS cache for a lot of its memory, not just its own. Re-did this, running `sync; sync; sudo sh -c 'echo 3 > /proc/sys/vm/drop_caches'` in between shutting down/starting up Postgres. 16726 msec and 79 msec, respectively. So yes, a lot slower, but a. I don't think this is realistic for a production database b. I'm still not clear about how you think JOINs enter into this. The slowdown comes entirely from having to run a table scan.
> Again this is your viewpoint.

What is my viewpoint? Exactly what that I have presented as if it was an objective fact is subjective? Please enlighten me, because I have no idea what you're trying to say.

>Very naive of you to think that religion, scripture, or existence of God are unprovable problems.

When did I say that? What I said was that society provably exists, and I said that to emphasize that the subject matter of law is something real, not to imply by omission that the existence of god/a god/gods is unprovable.

>Many people don’t agree with you on the both sides. Many think there is definitively no God and many think there is.

Cool. I'm not talking about the existence of a god nor about what people think about the topic. I'm talking about theology and philosophy as fields of study.
Somebody has to pay for all those failed politicians going into the ever-so bloated college administrations.
Locked bootloaders.
Investment in space has historically led to a disproportionate return in economic growth.
> So, developers will have to do more.

Do what? As I said at the end of the article, there's no way for a non-sandboxed app to preserve the granted file access across launches.
The thing to remember about that is that we can measure tiny amounts of radiation very cheaply, and tiny amounts are harmless. In fact we are bathed in a constant, but tiny, background level of radiation all the time. Thousands of nuclear weapons were tested all across the world, in the United States, in the Soviet Union, on Pacific Islands, etc, etc. The radiation from that certainly caused a small uptick in the background level of radiation, but it hasn’t actually harmed people.

The main reason that the US was secretive about it was that nuclear weapons were a secret, not because there was a shameful health problem to hide.

Incidentally, the best way to reduce your exposure to radiation is to move away from the mountains and go live at the beach. Mountains are mostly made of granite, and granite always contains small amounts of uranium and thorium which decay to radon gas. Also, live as far away from coal power plants as possible, those things are horrifying.
Yep, that's the same output that's emitted in the sqlalchemy.engine logger. If you use the logger you can use Pytest caplog to capture it.
> The reason I think this is needed is because a large percent of Internet users cannot afford hosting personal websites.

"For as little as $0.25, you can set up websites at NearlyFreeSpeech.NET, the masters of only pay for what you use hosting since 2002." [1]

Are you telling me people who can afford a smartphone cannot afford some simple static hosting?

[1] https://www.nearlyfreespeech.net/
Cobra

https://en.m.wikipedia.org/wiki/Cobra_(programming_language)

And pushing it a bit as "a language":

Anaconda
Again, community colleges typically don't offer the same degrees as public or private universities. They're great for knocking out general education requirements like history or bowling, because why pay the full price for the requirements outside your major. They're also outstanding at trades like plumbing or HVAC. But at least in the states I've lived in, you usually can't get a 4 year degree from them. If you want a bachelor's of math or comp sci or chemistry, you'll have to get it from a university.

I graduated from a public state-run university and I've been completely happy with the quality of my education. It was actually affordable. A community college is something different.
Worst case is they’re ordered to shut the entire archive down. It will be like the burning of the Library of Alexandria only the arsonists are the IP lobby and the reason it happened is ego.
"Legend of the penis"

"Rob a Mexican" etc
They have so many windows nowadays though ;) in too many cities
Ah, that's a general zfs problem thought rather than a nixos+zfs then.
Vim's addition of .vimrc and .vim allowing you to store editor programs to further accelerate your editing makes stand vim far beyond vi.

Credit Bill Joy for the modal editing paradigm, but vim is so much more than that. Most editors have a vi mode, but they don't compare to vim because they are awkward to script and don't have powerful regular expressions so readily available (both introduced in vim).

We could thank Ken Thompson and Dennis Ritchie for enabling vi, but I thank Bram for keeping vi viable, portable, and well-supported across languages.
I think that's only when you actually cheated/lied/used loopholes to get where you are.

I'm not losing my senior engineer job because I tell some soon-to-be junior engineers how to be good at the job. Neither will say an established artist or maker; they already have their brand.
Dynamic dispatch with heavy reliance on runtime metadata is a huge attack surface in terms of being able to leverage a data bug into full control of execution.

Additionally, the language provides very few runtime or static compile-time guarantees relative to Swift.

This disparity grows even larger if one leverages C directly — which is both common and often necessary when writing ObjC code.
Don’t confuse what you read online or in the news with what is actually happening.
> Any scientist worth their salt is a person of science.

Fun with set theory, tautologies, and rhetoric. Let's hope there are no negative repercussions!
> NixOS is the distro for people that want to give up on the concept of a distro

Indeed! NixOS is for people who are done distrohopping. It's for people who see through the superficial differences between distros and realize that their most essential differentiators are their own tooling (package managers, initial ramdisk management system, init system, etc.), and that the massive landscape of distros actually boils down to a handful of configurations in terms of those key choices, with some defaults lightly sprinkled on top.

Once you reach that point in your Linux journey, you generally don't care very much about those defaults, and what makes a distro interesting or appealing is a solid foundation that suits your preferences. The rest is easy to swap out or modify to your liking.

> If you want to embrace the fragmentation in linux and make it so no dev can ever expect a consistent set of libs, NixOS is for you

Indeed, NixOS is not a platform designed to serve as a ready-made target for proprietary software that wants to just make assumptions about what is present and hope for the best. But it does support Flatpak, Podman, Docker, Steam, etc., for devs that want to distribute software that targets some other such runtime instead of distributing source code.

> If you want to [...] set up a custom environment [...] every time you want to run something

The above is massively exaggerated, but kinda yeah. Years before I took up NixOS, I learned how to package software for a few distros and developed some tooling preferences. I realized that with some basic packaging skills, I could run any system I thought was interesting, stable, or useful and just package what is needed along the way. So when I came to NixOS, occasionally having to package things was not a big problem for me. Such users are a great fit for NixOS, and the NixOS community has a lot of them.
Pastcasting. Technical Blog – Part I
My first thought is how to disable this.
The problem being that scientific dissidents are always attacked with “the science is settled”, “trust the science”, “conspiracy theorist”, etc.

See: ongoing statin controversy. Pretty much every drug related to diabetes. The discovery of the Benadryl-dementia link. Etc.

The science is never settled. That’s the whole point of science: it’s constantly evolving.
I would think that many/most Lisp implementations implement fixnum integers with tags. But many also have automatic overflow into bignums, like in Common Lisp.
It might feel good and noble to chide people about this stuff, but this type of hyperbolic, exaggerated grandstanding is THE reason why our society is so polarized. It is absolutely NOT slippery slope to human rights violations to talk about edge cases or to make tradeoffs. Escalating everything to such high stakes makes discussion and compromise impossible.
I agree that you should always be ready and happy to discard or refactor code as needed. Requirements change, your assumptions may be wrong.

But in practice I've more often seen the opposite problem, where organizations end up stuck on C++11 for a decade for no technical reason. It's good to explore the new stuff and eventually adopt what you can use.
I've seen you post about this before, I think, and I am curious about the details. How did you install Nix and what were the sections of the manual that broke things for you?

> WONTFIX

Link to GitHub issue, please?
A free, ancient laptop off of Craigslist would work better.
https://archive.li/exMo7
You’re a champ and I love you for that, but it’s no excuse for that kind of rudeness. There is literally no easier nor shallower critique in programming than one should’ve commented a little better.

You rock, literally!
Funny, last time I was there (nearly two decades ago), the sewers were overflowing heaps of shit into the street gutters... Memorable. Crazy city, even for Mexico.
I think there is a typo in the first graphic on that page, on the top row the second column is labeled 0011 when it should be 0001.
I don't think so. What people want is a way to create some words, audio, pictures, video, etc and let people see it. The vast majority of people don't care at all about exactly what technological choices are used to make that happen. For a variety of reasons, services that are at least semi-centralized and running on proper servers in datacenters are vastly more effective at this than trying to run a web server on a mobile device being used in its intended role.
Skiena posts recent semesters of lectures on Youtube as playlists, as well.

Going through them at 1.25-1.5x speed, a lecture per night or every few days, is extremely helpful.
I'd really like to try this but every time I try it redirects me to https://www.prettypolly.app/payment-page and asks me to upgrade my subscription. I have yet to actually try it a single time. I've tried on several different days. Does the site actually work to try it for free or is the only way to try it to pay for a month?
Because normal people don’t care about “human cultural output” or “societal value” and think people who use those kinds of terms sound like blowhards. The rest of us just want reasonably cheap, convenient entertainment. Artists and others in the music biz want to get paid. Nothing here that is very hard to understand.
This country is founded on genocide and mass murder

Nothing new here
it's palpable to the rest of us to see how quick the discussion jumps to feigned confusion, a lack of charity to understand what others are saying and to immediate dishonesty when trying to shut down conversation

they're 'confusing' you for the parent poster of the comment chain you directly replied to in the discussion that you inserted yourself into, something understandable from anyone who spends time on sites that have parent/child discussion chains.

the confusion is solely yours alone, but for any other new users to the site you're taking up the role of continuing the discussion by commenting on reply chains inside that discussion, so having a reply to your comment that mistakenly mentions "your" previous post can be immediately understood in this context as the parents post and not as a misdirected attack that needs to be personally identified before continuing casual discussion.

do you need any more context to respond with honest intentions?
I would say you can generally (from my experience >95% of the time) identify a bad hire in roughly a month, mostly in two weeks and then give yourself / them additional two to be very sure.

We just hired for a management position a couple of month ago and I could tell from the very first meeting that it was a bad hire. I made sure with my team that I’m not totally wrong and then communicated my doubts to the C-Level. It took some time because they wanted to give them a real chance but just before the probation ended there was an evaluation meeting and the feedback was, without exception, negative. Took two days and they were gone.

Of course there will be hires that can uphold their charade for six month but I would say that’s an exception.
> Everyone is talking about things like “ActivityPub” and “interoperability” and “personalized algorithms” nowadays but RSS supported many of those features twenty years ago.

RSS is read-only, ActivityPub allows back-and-forth interaction between servers. The two are not comparable.
I think they crossed the limit of sacrifice that is understandable given the endurance of the materials currently used in NAND.

Cell modes are done by charging a cell to a level on write, and measuring the voltage on read. The more bits per cell, the more voltage divisions, and the sooner these voltages divisions turns unreadable, while the material degrades. Technically is on the manufacturer's firmware to decide what cell mode is going to use the NAND, assuming the hardware allows it (ADC/DAC, etc).

But even if the data is not changing very often, the controller of the disk needs to do internal writes for to refresh the cell, or even change the data of cell, in order to avoid data loss.

So IMHO, they are not giving more capacity, due that capacity is going to be consumed for to try to keep alive the data. If one fills the QLC disk of the article for long term storage, bad things will happen, as I understand it.

May be should be the user who decide what bit mode must use the disk.

But what is happening, I think, is along years they are stretching like chewing gum the NAND incrementing the bits by cell, hopping the people adopt the reduced endurance as a normality at prices of data-stored, not of NAND chips-used, at time they limit their chips production.
I suggest you take a second look at that article:

> Last year, according to the new data, the number jumped by more than 1,000, to 49,449 — about a 3% increase vs. the year before. The provisional data comes from U.S. death certificates and is considered almost complete, but it may change slightly as death information is reviewed in the months ahead.

The CDC hasn't calculated an exact final rate yet, but we already know the suicides are approximately 50k and that the US population is approximately 30M, so yes, I have a lot of evidence for my claim.

The data may change "slightly". You're making a mountain out of a molehill with the conceit that the rate may somehow magically become huge when the data is all counted.
I had no idea! Would you be able to shed light on the name of the song?
Society is meant to overcome individual shortcomings via constructive collaboration.

Adding individual strengths, not weaknesses, necessitates adherence to some rules in open communication. Science should know explicitly how to do that.
I built something that sounds very similar at my last company called crosswalk. Open sourced here: https://github.com/danvk/crosswalk

One thing that worked surprisingly well: codegen TypeScript types from your database and use those in your API schema.
Eh, I use them and am quite productive with them. Some of the downsides I don't really buy, for example, the argument regarding allocations. In a typical task engine, you're allocating state per task anyways. Sure you could have custom arenas and such, but you can do that with C++ coroutines also by overriding operator new/delete on the promise object. The lifetime concerns are par for the course when it comes to async stuff (assuming that's how you're using C++ coroutines).
"The paperclip maximizer is a thought experiment described by Swedish philosopher Nick Bostrom in 2003. It illustrates the existential risk that an artificial general intelligence may pose to human beings were it to be successfully designed to pursue even seemingly harmless goals and the necessity of incorporating machine ethics into artificial intelligence design"

https://en.wikipedia.org/wiki/Instrumental_convergence#Paper...
"Meh" is a casual response that means "this does not matter much". I don't know that it's proper English by any means, but it is certainly a common colloquialism. A cursory search suggests that it's imported from yiddish.

[1] https://en.wikipedia.org/wiki/Meh
I've always liked the incorrect lyrics "we're robot Mexican monkeys". Not sure who first came up with that. I remember reading it on reddit back when the short preview clip of Get Lucky was released to great excitement.
Blind indexes are useless when working with limited address spaces like Social Security Numbers, and even US Addresses[1]. It would take under an hour to reverse these on my current home PC.

Your advice isn't simply security theater - It's wrong and dangerous. It leads to companies treating this data, which is still sensitive, as nonsensitive and storing it insecurely, particularly when data teams export it to third-party tools.

[1] https://www.transportation.gov/gis/national-address-database
I think that the learning curve for the nix ecosystem is a lot steeper compared to other distros.
Thanks. As far as I can tell, a "container" is simply a GPT partition and APFS allows logical volumes to be created within. Not unlike LVM, ZFS, BTRFS, etc.
If we're talking about the contents on TikTok, there's probably a very good reason why the ultimate owner of TikTok, the Chinese government, wants that kind of content to be the majority sentiment on the platform.
In PDP-11 terms, the Datapoint 2200 only had these "address modes" ( https://en.wikipedia.org/wiki/PDP-11_architecture#General_re... ):

- register
- register deferred via HL
- autoincrement via PC (immediate operands)

No registers other than HL and PC could be output to the address bus at all. The 8080 was much more flexible, but the instructions it added weren't orthogonal, so I would say it's not at all comparable to the PDP-11 addressing modes.
> If we actually cared about child development we would still be much more serious about controlling the virus. We would still wear masks.

“[Masks] had a significant effect on the children’s emotion recognition accuracy” along with causing a decline in language processing ability.

Try again.

https://www.ncbi.nlm.nih.gov/pmc/articles/PMC9637007/
Sometimes the better solution takes time to reach the masses.

Here we talk about a tiny percent of the tiny 3% of desktop users.
Because it has meaning to me.
You’d need extensions for a lot of things like Apple TV, Roku, Amazon Fire Sticks and all the various apps on those devices. I doubt many of the apps can be scripted in that manner.
> Ted killed himself in prison a few months ago. What benefit could society have gained if someone had heard him out and took some measures to help the environment? Most people won't ask that question, because they have the intellectual and philosophical depth of a puddle.

Well it's not all that interesting question coz he wasn't exactly first or last preaching same thing about the environment, so there is a plenty of other people to listen to that do not happen to be crazy.

But in general I agree that the trend of disregarding someone's entire contribution to everything they contributed based on this or that opinion that is currently regarded as "bad". After all, if you dig far enough (especially in time, kids/teenagers do/think some utterly dumb stuff) you won't find an innocent soul alive...
No chance.

I really cannot wait for this exhausting AI hysteria to die down.
You haven't said what the SaaS business is, maybe start with that?
You can run a static site on github.com for free.
Yes, you can have the reactor offline, with control rods inserted for launch. Then when you reach the requisite altitude, withdraw the control rods and start up the reactor. In the event of a launch accident and potential destruction of the reactor, the enriched uranium fuel would be a chemical hazard (uranium is a heavy metal like lead), but only a mild radiation hazard (since there are no high-gamma fission products, and the uranium has undergone heavy purification prior to fuel fabrication).
You are right. That part seems a little bit vague, I will update it.
As the folk-wisdom goes "Twitter isn't real life". The ones who have that opinion are the terminally online.
Freshpaint (YC S19) Is Hiring Engineers to Build a HIPAA Compliant Data Platform
I'm gonna need a captcha bypasser to access this site that does paywall-bypassing...
The catch there is "separate" - if the object representation is one machine word, you really do not want to have to increase that by a factor of two to store one additional bit of information, and implementors will generally try hard to avoid that if at all possible.
https://m.youtube.com/watch?v=qN1fVkeSUXE

I wonder how many people knew the correct lyrics before this commercial, I certainly did not
Or, in rare cases where someone gets to billion dollars and says "okay it is enough": The opportunity is no longer there and world changed enough for advice to be near-useless.
Mobile BBS!
So am I. Not all terminals actually had cursor keys.
That's not open source, is it?

I feel like we can be more (or less) flexible about the 'impact' and 'single author' criteria, but we _definitely_ need to be able to see the source :)
Show HN: FalkorDB fork from RedisGraph bringing it back to life
The team behind RedisGraph decided to take a stab at bringing this disruptive technology back to market.

We plan to rebrand it and release it as a stand alone product, following the same guidelines we have followed for the last 6 years:

* Working in the open with the community
* Always provide superior performance.
* Easy to adapt
...and the author should have clarified that this Daft Punk song is copied from a 1980's single: https://www.youtube.com/watch?v=5b0jWlPtP5o
Aider's awesome and we're using a few of the ideas from the aider blogs like ctags and the search-and-replace editing prompt. I'm wondering, is anyone experimenting with fine-tuning Llama 2 to get it reply in this search-and-replace format? Excited to see open-source models catch up to GPT-4 on code editing.
If you were right, scientific knowledge would be inexistent and scientific opinion meaningless.

To come to an agreement among experts just like among anyone else one has to adhere to some obvious(?) rules.

Everybody having their own opinion without sound arguments validated by others leads to a useless cacophony.