skysight-inc/HackerNews huggingface dataset:
That looks fantastic. No magic mumbo jumbo mapping, just a simple type safe sql. Both syntax safety (no need to remember which of WHERE and HAVING comes first) and type safety on all fields. It's not advertised in the examples on the front page but i also take for granted sql injections are completely impossible since all data goes into functions and are not string formatted, without the mess of having to remember the order of arguments as with prepared statements.

Anyone got tips on similar frameworks for other languages than java and for other dbs.
Looks a bit like domain story telling:

https://domainstorytelling.org/

I really like the approach of event modeling recently:

https://eventmodeling.org/
Is it so hard to say ORMs are great for 90% of grunt work but sometimes you need to write your own SQL?
Don't miss the best part, in Randy Morris' comment:

Question I the depth this analysis of. Paring rule variability or recursive process, or randomized association efficiency? Arbitrary hierarchy inherent world model categories captures actor, act, actee of. New Guinea highlands reference I languages of number large (day before yesterday), exploit possibilities almost all categorical where.
People don't, in the normal course of things, have a right to charge at and assault each other, with enough force to cause life changing injuries. That's the context of this discussion.

Before it was known that AF seems to consistently lead to these injuries this wasn't a problem, but now the evidence is amassing that it does, if the game doesn't get reformed there is a risk it could get sued and legislated out of existence. With that background, clearly the game doesn't have a legal right to exist, to stop that happening.
I think Americans we are about numb to these headlines as another mass shooting compared that to the reaction of civil society in Germany when a SUV "only" killed 4 people in Berlin.
It also seems they retraced/copied state symbol of Czech repiblic - Lion with two tails as their logo. https://www.mzv.cz/hague/en/general_information_on_the_czech...

Going for that grand traditional authority with corny metals aesthetic.
"necessary contributions to extended kin networks"

There is the root cause. Its simply not mathematically possible for a single salary in a competitive global economy to support more than an immediate family.
There are some animals that don't do anything like a human definition of sleep. Some sharks, for example, who have to keep moving all the time.

Probably any computer-based metaphor we come up with for sleep is going to be crap because brains are not similar to computers, and it is unclear how they work. We don't even know exactly why sleep is necessary.
"deny people you know can’t pay you back"

The banks in Kenya do deny these lenders credit. Which is exactly why they actively approach the higher-credit lenders.
Facebook still has apps? I thought that fad died circa 2012?
> I can't quite take the step into believing that it's probably happening, because that way lies tin foil hats.

I think it was Wired that broke the story about AT&T's secret fiber-splitting rooms several years before they were later confirmed by Snowden's leaks. Given the entities and sheer amount of resources in play (or available to be used for that sort of thing), it's not nearly as tinfoil-hattish as, say, HAARP.
Why would you do this before tackling the climate crisis?
Perhaps UML ceased to be a fad for some, but to this day UML is still the best tool (and practically only tool) that helps describe and document code effectively and efficiently, from requirements to what classes comprised a submodule.

What if your system isn't designed around OO-style classes?
I find the OWASP cheatsheets to be a good start at identifying, understanding and fixing issues like these.

https://cheatsheetseries.owasp.org/cheatsheets/IndexASVS.htm...
It's pretty mind boggling indeed. Back in 2005 I did an internship with one of the two manufacturers of lithography lensing systems, in their R&D. It was very interesting and certainly showed me that my physics studies weren't really teaching me optics at all.

Weird anecdotes: the people working on EUV didn't believe in it at all. It was a big joke to them. But the roadmaps were showing it... not in 2019. The mirrors were being polished by hand. Robotic tools are more accurate, but the inaccuracies they produce are aligned, creating optically meaningful patterns. So instead they had two guys with PhDs in metallurgy polishing mirrors.
The all important simulations of lensing systems were done with classical optics and a ton of FORTRAN. Certainly throwing in some phenomenology around effects that are ultimately quantum effects, but no out there quantum optics or anything of the sort. This was 2005 though. The weight of the lenses itself changed their optical properties enough that we would measure the stresses induced by their weight and the impact on optical properties so we could include that in the system end to end error budget.
It is possible to save money without spending it.

Potatoes are still available, eggs are still available. Buying the cheapest available food, buying devices used, etc, can allow people to live an uncomfortable but low time preference life.
This is the video. I don’t know why you’re dismissive. It’s literally just trigonometry using numbers displayed in the video itself.

https://youtu.be/PLyEO0jNt6M
Adventure Legends
Likely something not backed by a corporation with big bags of money.
Hah, Woods of course. Two years ago a previous colleague of him hosted a talk in Paris. I got a peek of the work it was truly staggering. But the guy told me they were too instable at scale so far. Sounds like a solid hint at the future though.

ps: do you work in this field ?
Harvesting can be good because it provides space for more trees to grow and store yet more carbon. As long the timber is used for long-term purposes such as housing, then the carbon in the timber kept stored. It's not 100% efficient because when felled the roots and leaves rot and return carbon back to the atmosphere, but AFAIK it's better than not harvesting.
It's especially ironic taking into account how imgur came to be: as a simple image hosting website for reddit without ads/fluff. Now it's the polar opposite.
I use DuckDuckGo, and only fairly rarely fall back to Google. My Gmail account is dormant, I set up my own mail server. But I still have an Android phone…
They consider "apps" websites which just uses the Facebook auth, they probably just disabled thousands of website logins.
It makes zero sense to compare like this. Geekbench is closed source. So, there is no way of knowing what they're even running on ARM v/s x86. But, no way is my MacBook Pro slower than my iPad Pro

This Geekbench comparison, on the other hand, tells me they're on par (both single and multi-core scores)
https://browser.geekbench.com/v5/cpu/compare/140913?baseline...

I'd take this claim with a massive boulder of salt, if you consider it at all that is.
Same for me. I would say an electronic book has the advantage in searchability, but a well curated index might actually beat a naive text search most of the time.
Spreading into the solar system is a long term solution.
Wow this is great! Very well written README.

What just blew me away is the thing with the `JOIN` and the `to_jsonb(authors)`, all with complete typing support for the nested author object. I was actually looking to use a classical, attribute driven query generator (with the sort of chaining API everyone is used to: `tableName.select(...coumns)` etc.) for my next project involving to maybe replace/wrap/rewrite a Rails app and its ORM with Typescript and Node. Maybe I'm trying this instead I'm already half sold. Just worried about forcing colleagues having to learn SQL instead of using a fancy wrapper.
The economy isn't an undifferentiated lump of money, stuff and people. It is a complex structure. If most people have a lot more money, they will be able to afford a lot more of the stuff most people buy most of the time. So the inflation will be concentrated in staples and consumer goods simply due to greater demand versus supply.

If prices stayed as is, it's hard to see why anyone would do a lot of the low paid to medium income jobs many people currently do. But those jobs would still need to be done, which would drive up wages, but where is the money for the increased wages going to come from? Well, businesses would have to charge more. That's inflation again.

These effects would still happen, but might be mitigated by easing in a policy like this over time.

I'm not convinced about taxing it to make it fiscally neutral. A wealth of evidence shows that increasing taxes on the wealthy doesn't significantly increase tax revenue. They just progressively take more and more of their wealth out of the economy off shore, or move off shore themselves, along with their businesses. Many governments across the world have tried this and it just doesn't work.
Do you want to build a database or use one?

Also prolly at Facebook they use some API to access the database.
As some background, the rationale behind creating the C4 model was to create software architecture diagrams that would be easy for anybody on the project team to understand. The example diagram you linked to is fairly typical of what most teams seem to do today unfortunately, and exhibits the following problems: ambiguously named boxes, unclear responsibilities, unexplained symbols, ambiguous relationships between elements, no key/legend, unclear abstractions, etc.

To solve these problems, you do need some sort of common language. Switching to UML potentially solves many of these problems, but teams don't want to do this for various reasons. As noted on the website, the C4 model is an abstraction-first approach (with only 4 levels to learn), although the simple notational tips do aid comprehension.
Not at all, just an interested layperson (I'm in 'normal' IT). My partner studies evolutionary genetics (or something like that), so we talk frequently about biology. There is another DNA computing paper that was very interesting published earlier this year by another group, but I can't find it now. I think it was in Nature.
Jordan Peterson had a really good point when asked about alcohol and drugs, and he said the question should be why aren't we all doing them? His proposed solution to that was that people had to have some specific thing in their lives, that was powerful enough that it was more important to them than alcohol.

It is like societies response to suicide prevention: put up a fence, don't make the people who want to jump not want to jump.
Are there exceptions? If so, what is special about them?
Worth a quick look - it's surprisingly readable!
With the C4 model, you typically treat your database schema as a "container", and save the deployment/infrastructure concerns (e.g. replication) for a separate deployment diagram.
Linus called Geekbench as useless few years ago since it uses hardware implementations of crypto algorithms on some architectures and not on others.

[1] https://www.realworldtech.com/forum/?threadid=136526&curpost...
> there isn't anything that he can't know

If he knew that "something" even exists!

A former civilian nuclear war planner, I think while working for RAND, learned about the existence of the US military plan for the actions involving nuclear weapons: the plan specified the amount of nuclear response to any conflict, which is fundamental for anybody who has the power to resolve conflicts (a president) to know.

But the civilians weren't allowed to know that the plan even existed: the planner also learned that no other civilian, including the people around the president and the president himself, even knew that the said plan existed: it's very existence was being actively hidden from "civilians." They also had a method for delivering them "something else" if the "civilians" asked "about" that topic.

The military managed for years to operate (to be trigger ready) on the plans they kept completely hidden from anybody, including the president.

The president or anybody around him had explicitly no chance to get that by their own initiative.

Everything nicely documented in the book "The Doomsday Machine: Confessions of a Nuclear War Planner." Read it and weep.
Personally I find UML (in its full, standardised form) is still a lot more complicated than is normally necessary too, but it does include versions of several useful ideas.

I have often seen a group of developers discussing something and then someone sketches a simple diagram showing entities and relationships, transitions of a finite state machine, or message-passing similar to what UML would call a sequence or communication diagram.

However, in my entire career, I have never seen anyone actually draw out fully annotated UML diagrams using the official notation, nor any instance of some of the numerous diagram types UML specifies. And that includes working at places where everyone had been given UML training!
Async data loading in React on client and server [video]
An ORM is not a high-level version of SQL though. A more accurate metaphor for an ORM would be like a converter from one high level programming language that is object oriented, to another high level programming language that is functional.
You may find this relevant: https://www.yegor256.com/2014/12/01/orm-offensive-anti-patte...
+1 for DFDs ... UML was designed with OO programming languages in mind, and doesn't really fit well for diagramming functional languages (unless you start creating your own custom UML profile, which I don't see many people doing).
I was writing in terms of what I actually understand and have used—which doesn’t include any Java ORM. In fact if there are Java ORMs that consist solely of POJOs which are populated by raw SQL queries, I would gladly use them!
No one else thought of 2001 and the Tycho Magnetic Anomaly?
At that point you have just placed a limit on spending which is what some other countries do anyway. Personally I think we should move towards banning the use of any paid for media in politics. If candidates want to reach voters they should do it in person or using social media. And voters should be able to ignore some candidates and listen to others based on who they follow. And candidates should need to succeed without the normal public sphere rather than the weaponised media landscape.
This looks really cool. I’ve been building something similar in Crystal to scratch my own itch - https://video.twimg.com/tweet_video/EEQqvAeWkAAx3-3.mp4
>> You need to build your own ASIC

Might be the reason why Intel is putting FPGAs in the latest Xeons: https://www.anandtech.com/show/12773/intel-shows-xeon-scalab...
TypeORM is a step in the right direction for JS ORMs bit it's like 1/8th of the way there IMHO. A nearly fully typed ORM is possible now with Typescript and of course proxy's are out now.. TypeORM was doing too much ADHOC string building under the covers as well. I believe a SQL AST is the way to go. It can be transformed and compiled to database specific SQL allowing for things like predicate push down, optimization, and a sane way to implement db specific optimizations and extensions.
After using the Onyx boox max (all versions up to 3 which was released recently), I am convinced books will die.
The argument of being alone.

We’re millions. We make websites and books and movies and demonstrations. There are also millions who are not willing to engage politically, but who are battered husbands, and not a single battered husband shelter.

But we are heavily censored. Youtube said it’s their #1 goal to censor us. We have no access to freedom of press either.

So apparently you live in a bubble.
Interesting. But core count will probably be barely perceptible by the user. Most real world applications are hard to parallelise, either because the underlying problem is hard, or because the engineering skillset is limited, or because it makes development harder with bugs that are difficult to reproduce and analyse. Either way I don’t think we will be in a world of all algorithms parallelised anytime soon, only some specific widely used applications (video compressing, etc).

And even though some languages that are “natively parallel” like erlang, rust, f# etc are attracting interest, the mass of developers is converging on languages that are designed not to be parallelised (python, javascript). So it’s not even a matter of a younger generation of developers is about to come to show us oldies how it’s done.
In my hardest and most enjoyable job, working on an OS kernel, this was the only way I could make progress. In fact any C code base I basically feel this way.

Empirically I'd wager most of my coworkers had similar habits, although the people I believed had more overall mental capacity than me did seem to have a much quicker ramp up time on just about anything.
I'm curious about this:

"I can grep through the entire set of books for something in particular"

What software do you use for this? I'm guessing you're not literally running grep at a command line on your mobile.

So what software do you use that allows you to search through multiple ebooks? Is there an Android or ios equivalent to DocFetcher?
How does the construction industry work in the US? Do many people DIY? Do many people get hands-on with building homes while still hiring experts where needed? Is it common for city people to own farms/land nearby?

It seems it isn’t really that costly to build a nice 1000 sq. ft. place complete with appliances and modern amenities.

The construction industry in India is shitty - carpenters, painters, plumbers, masons, general contractors have little to no professional training and eff up projects often, the tools aren’t modern and renovation work is infrequent because of the poor quality of construction services (and non-existent DIY culture and ecosystem). Also, it’s probably looked down upon in the Indian society if a house owner goes DIY with any construction work (gardening is an exception).
I use Entity Framework for C# and I have grown to appreciate it. I get libraries for in-memory databases which makes it easy to write thorough unit tests, the `Include` function uses join to include foreign key objects in an optimal manner, and scaffolding tools make it easy to map from SQL to C# classes. The resulting SQL from the Linq expressions is logged which makes it easy to see what is going on, if you already know SQL. The only problem is that I think the writeback to the database of manipulated or new objects is not clear but that might just be because I haven't read the documentation for that thoroughly.
> Voting over the internet? Oh dear... But it theoretically could be a use case for blockchain.

Upon deployment of such scheme, it will be quickly discovered - or claimed - that some of the voters had their voting software MITMed, or their computers hacked, or whatever.

With electronic voting, you have to secure the whole chain, starting from a person interacting with their device. It's not like finance, where you can paper over malware or direct attacks on people's devices through police investigations, reimbursements and insurance payouts. Mere accusation of a e-voting's equivalent to Zeus being deployed would call an election into question.
> Of course, but the margins are much better on cutting-edge nodes.

No, not anymore for at least a decade, and this is the very reason GloFo bailed out on the "Arms Race." Extreme capex with uncertain payback times looked very scary to their investors.

TSMC 7FF will only break even next year.
Don't just learn SQL. An ORM like SQLAlchemy will allow you to save time and write cleaner, more comprehensible code.

But do learn SQL. Do not use an ORM before you have learnt SQL.
So you do all your analytics by running a series of service calls and then writing a script to collate them into the needed results? Seriously?
I’ve tried and used uml for 20 years. It’s hard to learn and a different way of thinking for many staff. I see a pattern of the business analyst / product owner /non-tech lead hiring someone to make uml for ver. That abstraction costs money and time and creates confusion.

So I think it’s not a worthwhile investment. The non-techs can’t create or edit and typically can’t read. The techs don’t use it for what they are creating.

I’d rather spend time on docs in the actual system components or teaching non-techs enough to read autogenerated docs or walk through code that actually is the system. Then couple that with block diagrams written on whiteboards or powerpoints or whatever. If you get to the point you need notations it’s too complicated and point them to the appropriate source.

This isn’t easy. But I think it’s easier than pretending that both sides learning an artificial middle language (uml, etc).

Because construction analogies are stereotypical if you are building a building. A big, expensive skyscraper. If your construction workers speak English and your financiers and architects speak French. I think you’re better off investing in hiring some people who speak both languages than in making them both speak German to work on blueprints.
TL;DW: This is my recent talk at React Edinburgh about the problem of loading data asynchronously (especially on the server) in React applications when React itself is synchronous.

I first talk about the problem, then one way to solve it: a library called react-frontload[0]

[0] https://github.com/davnicwil/react-frontload
My dude, do a search, there's help out there. Text only therapists all the way to video chat. It only take 5 minutes to get started, but please look into it.
I've seen a number of organisations where everybody has been given UML training, and mandated to use a specific UML tool. In reality though, everybody is just abusing UML class diagrams as a way to draw ad hoc "boxes and lines" diagrams instead! :-)
How about an offer of 15 with a 3 pound non-transferable (therefore worthless) store credit?
What are the advantages of a yurt over a pole barn or mobile/manufactured home?
Yes you do. Among other things. Its one of the things that counts toward your 'demerit' score. Or at least it certainly appears to. Theres people who haven't done anything but ask a couple 'stupid questions' that were answered before that were modded. Of course their moderation policy is so opaque only the admin could tell you exactly what happened.Or maybe not since they seen keen to adapt the 'Google approach' of having their bots take over sight unseen.
EPMA, Elysium Planitia Magnetic Anomaly
After numerous natural disasters, wars, etc, the one long-term constant for prosperity seems to be human capital.

If you have society that attracts the smartest individuals for the most productive professions (which is right now anything involving information technology), your society wins.

Your society will develop new concepts first, will be the first to sell it, and the first to reap revenues from it.

Besides, it is very easy to tax the megacorps.

Tariffs on intellectual property. Or reduce tax deductions on licensing fees. Bermuda is the center of intellectual property ownership.
Hence why I called it "endemic".
Why? Why couldn't they work the same way in any browser, like websites do?
I would say more vivid but not necessarily nightmares
Well, memory aside (the iPad Pro having less) and perhaps SSD performance, how is the iPad Pro slower? What have you tried? It can run at least some code (the Geekbench) equally well. So what other programs could it run equally well?
Right, so let’s suppose you already segmented the data to two different backing datastores, and your monolith is now connecting to both of them instead of just the one. Now you can do the service migration, at which point you still run into the situation I’m discussing.
Handle an ungraceful service in Kubernetes by bash
Three Mile Island closes for good