skysight-inc/HackerNews huggingface dataset:
Does not work for me in Firefox: `Uncaught TypeError: c[b[k]] is undefined`. Opens normally in the other major browser.
Years ago I wrote something similar for PostgreSQL. Unlike SQLite, it supports[1] the much richer "information_schema" database schema that's defined by the SQL standard. As long as you can figure out how it represents tables, columns, and primary and foreign keys, it shouldn't be too difficult to adapt this SQL query to fit. After all, reshaping relational data to extract the information you need is what SQL is for.

[1]: https://www.postgresql.org/docs/current/information-schema.h...
Sure, I guess I shouldn't have used the word "theoretically". My point was that with our current knowledge and capabilities, it is completely unrealistic to consider it remotely possible to achieve such a thing. We are orders of magnitudes more likely to disappear as a civilization in the short term than to achieve any kind of meaningful space travel.
You could compute the value of adjacent cells and use it in your formula.
... unless you're playing guitar, in which case tab notation works way better ;)
Weird, I viewed it on firefox with no issue. MacOS, latest version of firefox, mostly just privacy blocking extensions.
Definitely disagree on this one. ORMs are a leaky abstraction, they hide the wall you’re going to bump into anyway, and they bring their own gotchas on top
What we do is CPU bound and we are not just parsing JSON here.

The largest work we do is building an inverted index.
Oversimplified, it is equivalent to this:

inverted_index = defaultdict(list)
for (doc_id, doc_json) in enumerate(doc_jsons):
c = json.loads(payload)
for (field, field_text) in c.items():
for (position, token) in enumerate():
inverted_index[token].push((doc, position))

serialize_in_compressed_way_that_allows_lookup(inverted_index)

You can implement it in a couple of hours in the language of your choice to get a proper baseline.

I am sure we can still improve our indexing throughput...
but I have never seen any search engine indexing as fast as tantivy.

If someone knows a project I should know of, I'd be genuinely keen on learning from it.
yes, and in developed countries outside the US, healthcare is something covered by the state. neither of which has anything to do with the discussion at hand. you're comparing an apple to a kumquat.
Is there a list with responsoble parties, so we can vote the bastards out of the EP during this year's elections?
You can think of it like that.
I think that makes sense.

You can build structures within the GoL rules that implement the GoL rules, so…
As a matter of practicality, what non anonymous wallets exist? It's always just a massive number.
I take notes for two main reasons. First, to improve memory—research shows that handwritten notes aid in memory, learning, and retention. Second, notes serve as a helpful guide for tasks I don’t frequently perform.

I find note taking to be extremely effective for me—perhaps because of that primary goal of memory. My own note taking results in fair amount of longer form writing.

I recently started a blog / digital garden dedicated to note taking. You can read more about my note taking strategy below.

https://notes.joeldare.com/note-taking-strategy
NIST: Personal Identity Verification (PIV) of Federal Employees and Contractors
This is pretty typical. When men express how they feel, they get attacked.

In an inclusive society with room for many perspectives, some things you hear might make you uncomfortable. It stops being inclusive when you "more actively chase their authors away".
We're still working on training the DWA weights on top of a pretained model. We're hopeful that this is feasible. The experiments you're mentioning in the appendix are not changing the learning rate scheduler. E.g., when starting to train the DWA weights after 20k iterations, the learning rate is already quite small. To some extent, this might explain the diminishing returns. Maybe this could work with a completely different learning rate scheduler.
Paracelsus creates diagrams in markdown or dot format for SQLAlchemy defined databases.

https://github.com/tedivm/paracelsus
Friend. Crony Capitalism is not Capitalism. If it was it would be called just Capitalism.

We can move on now.
If you're trying to calculate "how much it would take" for a project that size, it seems silly to try to calculate in dollars. What you want to consider is how many people it would take: what population would you need, with reasonable bootstrapping equipment, to establish a self-sustaining colony on Mars?

I'll hand-wave away whether Mars has the necessary resources (I suspect it actually doesn't, but that's just a guess) so if we assume that Mars has the raw materials we need, and is just lacking an atmosphere, then it seems likely (just spit-balling here) that a million people could get the job done, or to be conservative, ten million. For comparison, North Korea has something like 25 million -- they're not as isolated as a Mars colony would be, but they're also not organized well.

If we really want to translate that back into dollars, it seems unlikely that we should budget over a billion dollars per person, but maybe?
So the whole internet will become like LinkedIn. Let the horror begin.
This is amazing, more detail about how it works: http://b3s23life.blogspot.com/2006_09_01_archive.html?m=1
Sure, but it assumes technology we don't remotely have. Maybe I should not have used the word "theoretically" here. It's just ridiculous to seriously consider it at this point.

It is nice to think about it, of course. But I just don't get how people support wasting so many resources into sending people to Mars where it's basically useless (though exciting, I get it!) and we have much bigger problems to solve on Earth (e.g. the survival of our species in acceptable conditions).
As an aspect of that, the perception we get of a face is very much a "cooked" or processed representation of and not an exact picture of the face as it is. The thatcher effect and other similar effects are evidence of that.
Same, does not work for me on Android Firefox
The more I read about the race the more it sounds like calvinball.
At least, this has the same impact on GPU prices.
You may like PRQL, which gives a more composable-atoms based approach. I find it far easier than SQL.
I hope I will grow old enough for one to see a proper confirmation of life out there
Does work on FF, MacOS 14.3.1 (Sonoma :-/)

(Some extensions conflict with some webpages, too...)

One day we will get it together so every computer program works on every computer, if we don't collapse our ecosystem first.
It is nice, albeit the old windows (listed building which means I can't replace them) let out a lot of heat. The fireplace generally heats the whole place effectively when it's on though. It's worth it for the character of the house.
SQL seems to be the QWERTY of the data query world. It's far too entrenched.
> Yeah that make sense, but still very much earthlike biology perspective.

What does that mean? The parent’s point was that this isn’t just a matter of looking for what is already familiar, but a matter of through the lens of what affordances the elements have and therefore what, in principle, is likely or even possible, to the best of our physical/chemical knowledge.

There’s a rational middle ground between parochialism and anything goes.
Life every million parsecs means less than one life form per galaxy, so hardly teeming.
Show HN: AI powered data analysis for research
You speak in absolutes. What works for me, works for me :)
There is a deeper lesson here: Someone was thinking of lines of code as an asset, not a cost. It's a an error you also see in junior programmers writing reams and reams of code. The lesson is a harsh one for us code lovers, at least it was for me:

Code is a means to an end, and an expensive one at that. The best code is the code never written. Our job is to solve problems, not to write code.

You can use LOC as a crude measure of progress, in the same way as tons of concrete used is a crude measure of progress when building a skyscraper.
I'm guessing a sloppy equivalence due to the idea of "existence is outside of the world and outside of space and time" showing up in descriptions (e.g. "a platonist might assert that the number pi exists outside of space and time" from https://iep.utm.edu/mathplat/).
The headline is wrong. The case is not for prions, but for prion-like behaviour in amyloid beta plaques. They found that this could have been a cause of transmission in rare cases where people received hGH sourced from contaminated cadavers and 5 out of 1800 developed early onset Alzheimer's. But they also had 200+ other people develop Creutzfeldt-Jakob, which is actually known to be caused by prions. So there might be some similarity that enables transmission in a related way. Or there might just be related symptoms. Either way, it is completely irrelevant for normal people, unless you eat squirrel brains or ground up beef imported from Britain in the 90s.
"Disaster" may be an exaggeration, but I think the syntax could be better, proper layout or not. In particular, I find that complex SQL queries often need to be read in a "spiral" order due to SQL's attempt to resemble natural language. I find PRQL's consistent left-to-right/top-to-bottom reading order a clear improvement.
I tried to study C. J. Date's books to understand relational theory... suffice it to say that I got nothing from his books, except a deep irritation partly due to his absolute pedantry...

I finally learned SQL with a gentle introduction by Alan Beaulieu. I stumbled upon another book that's about the theory: Applied Mathematics for Database Professionals, by Lex deHaan, and Toon Koppelaars. Maybe these authors will benevolently teach me relational theory.

But please avoid C. J. Date's books. And don't be him when writing a book or trying to explain something to another human being.
> so if we assume that Mars has the raw materials we need, and is just lacking an atmosphere, then it seems likely (just spit-balling here) that a million people could get the job done

Hmm... I don't get how it seems likely that a million people could get the job done. I mean really, we are destroying the conditions necessary for our survival on Earth. It's not like we know how to survive in a place (Earth) that just requires us to change nothing. Why would we be able to survive in a place (Mars) that requires us to create from scratch the very conditions we can't seem to maintain on Earth?
Yes - seem a much better, more general, approach.

There was an interesting interview of Lee Cronin on Lex Fridman's podcast a while ago.

For anyone unfamiliar, Assembly Theory is based on the idea that the more structurally complex something is, such as a molecule, the less likely it was created by chance, and the more likely it was created by an assembly factory of sorts, one type of which is life in it's potentially diverse forms.
I don't see that particular statement "leading" to the second statement. You quoted very selectively and didn't quote the part that is the reason why I believe carbon-based to be much more likely, i.e. the fact that silicon is such a bad candidate and that no other molecule allows complex chemistry. Maybe that helps with your fascination. Obviously I skipped all the actual arguments, but they are easy to find by the interested reader in standard literature.
People have built explicit turing machines in GoL, so it certainly is Turing-complete.
I think review and approval would be faster than the coding, but certainly would need testing. Just adding tests would be valuable too.
I’ve theorized in my book _Fat Gas_ that vasopressin levels are tied to elevated indoor CO2 levels.

Would not be at all surprised if these novel social conditions stem from not going outside enough and from poorly ventilated buildings (especially gyms and conference rooms) and transport (planes trains and automobiles each routinely exceed 1000 ppm from everybody’s lungs).
If anyone is interested in reading about this idea, I recommend Stephen Wolfram's "A New Kind of Science" [0] and Max Tegmarks's "Our Mathematical Universe" [1].

[0] https://www.wolframscience.com/nks/

[1] https://space.mit.edu/home/tegmark/mathematical.html
Problem is they never topped Win7 UI
Monero seems to be well on its way to being banned by governments:

https://www.binance.com/en/feed/post/3817825785186
I’d much rather deal with the peculiarities of SQL than any of the attempted replacements (ones I’ve seen in my minted experience). Elastic for instance, other json based languages, are absolutely terrible. We lost something we when stopped writing ANSI standards.

We’ve even stayed on InfluxDB og versions _because of _ the SQL like syntax, and also their improved languages are a nuclear disaster area.

SQL, despite its flaws (null != null) is pretty good enough!
One thing that's worked for me is jotting down stray thoughts in a tiny pocket notebook or in a note app. I just finished writing a full post about that process.

https://notes.joeldare.com/stray-thoughts-notebook
See C.J. Date's "An Introduction to Database Systems," https://www.amazon.com/Introduction-Database-Systems-8th/dp/... This is not news.
Seems most likely, but why is there anything at all to begin with?

.. a feeling deep in the pit of my stomach.

Does anyone else sometimes get these "intuitive flashes of insight" - like your brain configures itself in a pattern that "lifts the veil".

I've been thinking of starting meditating to stabilise or cultivate this state if possible because i've feel like i've been losing this slightly psychedelic ability since i was a kid.

Most often i get it in the hypno/hypopompic phases, sudden flashes of eureka that disappears just as fast, like a loud echo of "wow this is existance", "time is unbelievably deep", "demensions and perspective are bizarre in essence", "is this just a fraction of a shared dream" etc.
Apple supports the last 3 named OS versions - anything older won't be getting security updates

Which strangely means if you have an Intel Mac that Apple dropped support for, you could run Windows 10 and still be supported until next year
Having traveled to Japan quite a bit, I can definitely see that. Though I'm also at the stage of my life where I do not want anything else to enter my house. :-) (And I have quite a bit of stuff from Japan my dad brought back from when he was traveling there a lot.)
the article didn't mention the “static initialization order ‘fiasco’"

https://isocpp.org/wiki/faq/ctors#static-init-order

If you have two static objects in two different files then good luck if one depends on the other, as the initialization order is not well defined.

If both files are in the same executable then you can get around that by linking the object files in the desired order - well mostly, kind of.

i have hit this problem at some point...
How would I extract the payload of a LinkedIn notification?
LinkedIn seems to provide email notifications for a variety of notification types, so I was going to extract it via email. However, the notification type that I want, is not sent to the email. Is there a way to get a notification from LinkedIn into my application?
This is mind blowing; I'm lucky that I've seen hashlife and life in life before, that these additional layers by themselves don't leave me stunned for days.
Impossible to happening. You cannot force people to have device and internet to make transaction. How would you give money to homeless or pay if you out of signal?
This is from 2011 or possibly earlier. Since that was around the same time ThreadSanitizer came out, I wonder how similar the two approaches are? I know lots of people use TSan nowadays but I haven’t heard of anyone using Relacy
First time seeing https://paste.mozilla.org, very cool
Broadly speaking: IP Transit is the relaying of bandwidth towards the rest of the world.
Dark fiber is a fiber optic connection where you shine light in and get it out on the other end, no other party on the physical fiber strand.

(Both are generatalizations)
Works on Edge but doesn't appear to be working on Firefox
Regarding your first point:
I think you are correct. What we are seeing is something akin to a US elephant curve[1] but the chasm is widening to upper middle class professionals, while the trunk is pointing up more sharply.

When the US deindustrialized, the global poor got richer (manufacturing earns more than subsistence farming) and the rich got richer (it's cheaper to make things overseas), but the lower middle class got poorer. In aggregate it looks like the world got richer, so the Steven Pinkers of the world scold the complainers for not getting that we are living in the best time in human history.

I think the economy is turning against the kind of worker who gets a four year degree and might have a job title like, "data scientist", and everyone is going to tell them they should have known better.

1. https://en.m.wikipedia.org/wiki/The_Elephant_Curve
“Not much of an achievement, but” here refers to the commenter’s action, not the one in the article
There was literally a PowerPoint slide in the released docs implying they had backdoored Google's internal servers.
Makes you wonder how many fantasy creations from fiction originated not from the author’s imagination but from their actual sensory experiences.
DynamoDB – the most common access patterns with real examples
When we talk about serverless, we often think about AWS Lambda, API Gateway, and DynamoDB. DynamoDB has a special place in the serverless but might be a bit tricky to model the data.
With this blog, learn the most common access patterns and how to model the data in DynamoDB with real examples.
EU AI Act Compliance Checker
That sounds like hard mode, the easy solution is to just initialize them the first time they are used. GetInstance(){ if (!instance)instance = new Foo; return instance;}, add a lock if you need thread safety and done.
> The US style of 2 party system of presidential democracy and the role of electroral college are a bit problematic but the average US citizen isn't less political aware than the average Indian.

I don't think I will agree with you there again. But then we all have viewpoints and you can agree to disagree. I could similarly opine that you believe in a simpler, universal model of how political demagoguery works. Different populations respond to different degrees.

Looking at the voting bloc supporting DJT which is strongly pro-GOP/MAGA despite the dozens of legal challenges, the attempt to insurrection and felonies - that is unprecedented in any other place. My previous neighbors in NC still believe every one of the legal case is schadenfreude, and cannot understand why J6 actions were illegal and why "elections were not stolen". This is not a single person anecdote. A lot of educated people - working as nurse, technicians, delivery people just don't understand. I don't think this is just about loyalties. There is more at play. They are oblivious to many technicalities of governance and take the campaign email's/sms bulletpoints at face value. These are the target audience for TikTok based political influencing.

If the poor in India scrounging for two meals don't understand political big picture, I can excuse that. How can the recent right-wing tribalism among educated, well to do people in US explainable? I know social awareness cannot be quantified, but this perception is not just mine. The way conservative faction is getting away with its shenanigans despite so many challenges makes people everywhere else wonder why US voter factions for e.g. in Midwest and South are so so gullible & what could be done for awareness
Interesting and well done!

I have an extension that adds a div to the page, Grammalecte, its breaks this website a bit. A div:first-child, or an id would fix it.

A reminder that extensions can affect HTML content and you need to target your elements in CSS in a robust way.
> Abraham is in that list,

Yes, and one of the things Abraham did was take his kid out for a human sacrifice--because he saw god in a dream.

Its one thing if you and I were talking with God, while a bunch of guys in lab coats were doing experiments trying to verify whether it was God or just some kind of magic trick.

But there's no sense of the word "evidence" in which a dream is evidence that God wants you to kill your kids.

> things unseen

i.e. things we do not gain knowledge about through our sensory organs, i.e. not empirical evidence. Hebrews is rather poetic, at least in my favorite English translations, but I don't think it could be any clearer that faith doesn't come from sensory experience in the way empirical evidence does.

> but that's not the faith being promoted in Hebrews.

People wonder why I care so much about what Hebrews says about faith, given that I'm an atheist. The reason is this: if you think faith is the same thing as evidence, then sooner or later, when you really need a good reason to ignore all the evidence which makes you feel like you are doomed, you will need the kind of faith which gives you things to hope for, even though the answers are as yet unseen. When (not if, this eventually happens to everybody) that happens, I hope you find you have the right kind of faith too see you through.
Well, I've read an article about some people getting flushed down the drain because the company that was supposed to keep them frozen kinda went out of business.
works fine for me on ff/w10
If you recently sold your home, you might get part of your realtor fee back
Using production metrics as a whole is very stupid and a good way to get devs to optimize for the metrics rather than quality work. A contemporary example would be a company that promotes for "impact" (i.e. launching new products) which is a great way to have a bunch of failed products that nobody maintains!
My understanding is that one of the changes we made is we stopped feeding cow brains to other cows, which was the root cause of the problem.
And by the author of this version: https://blog.oimo.io/2023/04/10/life-universe-en/
for some reason, HN only shows the base URL. The full URL to the blog post is this - https://blog.scaletozeroaws.com/aws-dynamodb-data-modeling
My thought is that ‘things just exist’ and the problem is the dimension we experience things in.

Does that make any sense?
That analogy doesn't really fit. To make it fit the setup needs to be you are in a city with only a few restaurants that offer deep dish pizza, and are advising someone who wants to have deep dish pizza three meals a day every day but is having trouble with that because the price for deep dish pizza is high and the restaurants are often full.

Telling them they should go to Chicago [1] and that they will be shocked by the difference in price and ease of getting into deep dish pizza restaurants there is not going to be offensive to deep dish pizza chefs elsewhere.

[1] I've never been to Chicago. I'm just assuming that its reputation as the deep dish pizza capitol is at least partly due to having a lot of deep dish pizza places.
Wait until you add support for encryption.
To that end I recently wrote about several modern ways to convert handwritten notes to searchable notes. I primarily write handwritten notes because of the mental benefits of doing so.

https://notes.joeldare.com/handwritten-text-recognition
I’m assuming this is only achieved by “cheating” in some way? That is, I don’t see how giant pixels can come and go, at a zoomed in level, without breaking the rules of Conway’s game of life?

Still cool, but more curious to understand how this works, and if it’s actually able to pull it off “legitimately”.
And it's not just the size of the distance we can see, it's the size of the slice of time when we are looking. We've had the tools to sorta-kinda detect life signatures for what, 10-20 years? Maybe we can keep that up for another (at best) 100-1000 years until we destroy ourselves? The universe is on the order of 10^10 years old. Star formation will end ~10^14 years from now The last black holes will evaporate ~10^100 years from now. So our temporal search window is astronomically small, too.