skysight-inc/HackerNews huggingface dataset:
Ask HN: Can you recommend good SQL learning resources?
I am a JavaScript developer and I use Postgres in my projects. My knowledge of SQL (and Postgres) is fairly light and although I do get by, I would like to build a stronger foundation.

Specifically I'd like to get better at;

- SQL fundamentals
- designing DB schemas
- concepts like normalisation, referential integrity
- ongoing DB maintenance tips (e.g. for data migrations)
- any recommended general best practices

All resources or courses are welcome. Thank you!
No, it means what it says - the growth rate is too high for known mechanisms, so they’re looking for explanations. The mass in the universe isn’t the issue, it’s that there are limits on the growth rate of black holes which grow through accreting matter.
And JFK is not even in the actual neighborhood of Jamaica. It’s just an artifact of how the postal codes were assigned - https://en.wikipedia.org/wiki/List_of_Queens_neighborhoods#P...
Access to small business mailboxes is used for a “neat” form of fraud; they intercept invoices and change the account details to theirs. It’s a bit of a long-ish targeted attack, but it makes the news now and then.
It's interesting I just started learning Racket and I can already whole heartedly endorse it.

The language is incredibly well documented and has a lot of image manipulation tools you can get started with right away.
This is great for kids because they really gravitate to the visual aspects of coding.

I've was put off by s-exprs for years, but after 3 days I'm almost in the camp of them being "the better syntax". They're just so darn simple, and I think a kid can get the jist of a lisp very quickly because they haven't been exposed/gotten used to a non-lisp yet.

I think a simplified approach to walking a kid through the first few chapters of How To Design Programs is totally feasible. DrRacket's step through feature would really help a kid see visually what is happening in their program. Ive hears good things about Realm of Racket as well.

Also then you could transisiton them over to https://fennel-lang.org/, a lisp that compiles to Lua, and start doing some love2d programming or some microcontroller coding on Lua supported boards.

Another alternative to the fennel path is going the clojure route and introducing him to the wonderful JVM world. The JVM has a ridiculous amount of libraries that they can integrate with and you could start peppering in a bit of Java learning.

https://racket-lang.org/

http://htdp.org/2020-8-1/Book/part_prologue.html

https://nostarch.com/realmofracket.htm

https://fennel-lang.org/

https://love2d.org/
You can accomplish this with plain old cryptography. No blockchain needed.

There are lots of ways to do it. One of them would be for Fuuture to publish the hash to literally anywhere.

Public + cryptographically verifiable + distributed + append-only still does not equal blockchain, as long as we're defining blockchain as something that was not invented before 2009.
U.S. Debt Rout Ignites Hunt for New Havens That Ends in China
Might be related:

https://github.com/pglombardo/PasswordPusher/

Password Pusher - Open source secure password transfer

Review by Crosstalk Solutions here:

https://www.youtube.com/watch?v=0mpBLRaHtQo
There is not, and will (likely) never be, a need for NFTs. They are a solution looking for a problem.

Some (mostly already very wealthy) people want them. That is not the same as a genuine need.
My tip is to look for slide decks before diving into papers.
While I don't claim to have a comprehensive numbers, I did a quick `rg` on a full clone of nimble package list, and found that macros constitute approximately 0.4% of all definitions (functions, procedures, templates, methods).

proc: 401673
macro: 1869
template: 16255
func: 8746
converter: 3538
iterator: 1833
method: 9025

You would be surprised how much can be accomplished just using simpler language constructs - even for the complex operations. Manual for example advises to use the least powerful construct for the job https://nim-lang.org/docs/manual.html#macros-caseminusof-mac...

> Style note: For code readability, it is the best idea to use the least powerful programming construct that still suffices. So the "check list" is:

> Use an ordinary proc/iterator, if possible.
> Else: Use a generic proc/iterator, if possible.
> Else: Use a template, if possible.
> Else: Use a macro.

Also - notable portion of the commonly used macros is for embedded DSLs that in other languages would require you to use a separate build step with some external tool, or give way to horrible clutches like operator overloading-based DSL.

Note that I did the full clone several months back, and it is missing around two hundred packages that were added in this time, but I doubt it changes numbers greatly.
In case you find it useful, I'll mention that I use Bitcoin as a store of value: it lets me store a portion of the output of my production (i.e., my salary) that I don't need to consume right away. Occasionally, I convert a portion back to other currencies and consume it. I never have and don't intend to ever trade in black markets. I expect that thousands of other users like me will continue to be willing to buy/sell, needing to "consume" it (convert to other assets) at different times.

In a very real sense, I've used Bitcoin to buy real things — and I really don't care at all about the fact that I had to convert to Euros first; it still was just as useful for me to store value I've produced until the time, months later, I'm ready to consume it.

There are other technologies to store wealth and we can compare them, Bitcoin is certainly not the only one. But I think failing to acknowledge this would be just as foolish as pretending it is the only means to do this.
Doesn't really answer my question.
Good question. There's a few reasons I use that phrase and I agree with you that, from a statistical perspective, it isn't the correct usage of the term:

- There was a lot of misinformation spread (on both sides of the debate). So people were voting for issues that didn't apply.

- There were a lot of protest votes from people who assumed "Remain" would win and who also did want to remain but wanted to voice disagreement with the government and/or concern about unconditional relationships with the EU.

- There options were too vague. "Remain" largely meant keeping the status quo but some read it to mean including countries like Turkey (who were extremely unlikely to ever join the EU anyways). Likewise "Exit" meant different things to different people. Some people wanted a "hard exit" (no EU trade deal). Some people wanted to stay connected to the EU but to have a revised deal. People were voting for the same options but expecting different outcomes.

And as a result of this there had been a high number of people voice regrets about the vote they had cast in post-referendum opinion polls.

Sadly we will never know just how accurately the results reflected peoples true opinions because all calls for a follow up vote had been literally laughed at. However subsequent general elections have demonstrated just how far from settled the debate was.
The electricity there isnt just cheap, it's virtually free. They just dont shut you off it you don't pay.
Trustworthy digital bookie, I guess?
If there are artists making money that previously weren't then that proportion is irrelevant. It's a completely voluntary system, no one is forced to use it or care about it.
I have been using Syncthing for a few months now and I love it!
Completely agree that the decline in food quality and the economic structures is tied to a decline in food culture. Seems the rest of the comments do not get the point that if people who can demanded quality food, the race to the bottom could be avoided.

For example, I see how dairy went from the milkman delivering high quality milk to the mass produced stuff that barely resembles the original item. The interesting part is that now the high quality milk can only be had at ever increasing prices as the demand for it has decreased. If people who can afford it don't buy it, less people will afford it in the future furthering the decline in food quality.

Truth is the poor don't even come into the picture. The decline in food culture is driven by the upper class and the pretense that things are the same. "It is still milk!" No it is not the same item. See also, impossible meat, etc...

Catering to the lowest common denominator is only enabled by betters not knowing and choosing better. The health consequences are already apparent and the difference between people's diet and outcomes will only grow starker
MacBook Air costs 3x the price of a Dell Inspiron. The Mac laptops seem to be great (I've never owned one, have ordered one though), but they're not entry level. It might be Apple's entry level, but it's not the markets entry level.
I guess that makes Batman a hell of a writer.
the SOP with C++ is you overload the new and delete operators and implement your own heap.

It can be very handy especially when you add tags to your allocation so you can track the number of allocations from a specific piece of code, great for finding memory leaks.
> They are also an ebooks monopoly and control more than half of US book sales in general.

They have more than half of US book sales, but I wouldn't say they control half of US book sales. There are other large retail stores, such as Walmart and Target, that have large collections of books for sale that include the books that make up the vast majority of what the public buys. Oh, and Barnes and Noble is still around and they have a huge selection, too.

Walmart's in-store selection is pretty limited, but they have a big online selection, and it is not just the popular books. They go pretty far into books of very limited general appeal. For example, Walmart's "Gravity Science Books" section [1] is just full of things I can't imagine more than a handful of people worldwide wanting, even if you filter it down to just books sold by Walmart and covered by Walmart+ free shipping, rather than sold by third-party resellers through Walmart's marketplace.

[1] https://www.walmart.com/browse/science-books/gravity-science...
That's exactly the purpose of std::vector's “reserve“ method, btw.
I feel mostly angry when I read the comment I'm replying to. There's simply too many people not able to spare $1000 who are not in a position to change that, for reasons outside their control. Although people posting such comments are likely not listening to reason anyway, I feel something needs to be said.

I'm now curious where your question comes from, though. Note that I'm aware of the "virtue signalling" narrative. But better that than blaming people for their poverty.
You are very right and very wrong at the same time. Yes shaming is an extremely poor substitute to such tax but I don't see such tax happening any time soon. So what is the alternative? And shaming has a function: It creates awareness and more importantly momentum to establish such tax.

I expect that the counterpoint to this would be that shaming doesn't convince people. Well, I'm not so sure about that. It's not like there's a happier substitute. These things are not fun. We are spending our planet. We need to tighten our extravagances. It isn't fun.
Show HN: Hypernotes – GDPR conform Roam alternative with mobile apps
False equivalency. We prevent children buying alcohol and firearms because they might harm themselves and other people not because other people might use those things to harm them.
World Day Against Cyber Censorship
Wow that’s crazy. How did you solve it?
I wonder what the age distribution of porn discovery looks like. Back in my day, I had to put-up with one of my neighbor friend's dad's Danish spank mags where you couldn't see anything due to follicular foliage in the way.
As someone who’s spent a lot of time in and around farms. I even bought a farm last week!

This is an accurate depiction for the vast majority of farms. It’s an industry where you have a high over head cost (want to start raising cattle - $300k land, $50k equipment, $30k housing / barn, $20k fencing, $10k to start a herd - profit in 2-3 years). This scales well. Get some more land, you can keep the equipment running longer, concentrate cows, etc

I do think this creates overall a less healthy and productive nation. The reason I bought a farm was for my families nutrition. Food from the store has far less nutrition. Working on a farm teaches you hard work (as the article describes) and family bonds. We personally don’t plan on making much profit, if any.

All that being said, focusing on the niche is important. In Tennessee they produce grass fed cattle. Many farmers make profits with relatively small herds. I’m planning on planting a walnut or pawpaw grove, and raising elk.

Unique goods provide a way to make a profit without scale. This is like every industry.
Wow, I swear I went looking way back and didn't find either of glauth or go389 - thanks a bunch!
Not excuses. I'm pointing out that to achieve the streamlined real-world-tech-spec, you need that kind of person.

My wish is not only for my organization but for everybody. The world might be a better place if things are cheaper to maintain.
> Maybe boring, but maybe not.

A lot of this is about audience perception, and considerations of what makes a good spectator sport in different cultures.

More than perhaps anywhere else, sport in North America often tends to be about the spectators. Think NASCAR where you can generally see the whole track and there is a lot of overtaking, and a lot of crashes, or basketball which is a high speed, high scoring game played on a smallish court that, again, maximises action. There's a noticeable emphasis on creating the most exciting and intense spectacle for the audience. I think the same is true of contemporary ice hockey, which is like a ludicrously amped up version of regular hockey: the high scores are all part of that.

I'm not an avid follower of any of these sports but, as a casual viewer, I find I'm much happier to sit down and watch them than some of the original sports on which they're based because they're very accessible and high on action and entertainment value.

The one sport where this really comes unstuck for me is American football: the stop/start structure built into the game just drives me up the wall, and I find myself significantly preferring the (by comparison) rarely interrupted action and flow of rugby. That's not a critique of American Football at all - it's obviously a deeply tactical and nuanced sport: this is just my personal preference for a longer arc of play, on average. And, by the way, I'm talking specifically about rugby union: I've never followed rugby league.
Ethereum has something like 100,000 validator nodes up right now with a plan to switch completely this year, summer I believe. Polkadot, while not nearly as popular/big, is already running as a pure PoS blockchain.
The UK got a several-week headstart on the EU, announcing various partnerships, particularly with Oxford/AZ, before the EU even began their process. (Yes, I am aware that purchase orders were signed at different times, but the UK secured funding and supplies back in May last year, when the EU didn't begin its process until June)

Talking about "queue jumping" or "corruption" really seems to be rooted in bitterness or just anti-UK sentiment.
No way. At least there people willing to pay me 1000$/hour.
GitHub release: https://github.com/wasm3/wasm3/releases/tag/v0.4.9
Using Redis to build a large scale realtime back end
For an overview of how Zig does this and at the same time a nice overview on different types of allocators:

What's a Memory Allocator Anyway? by Benjamin Feng

https://www.youtube.com/watch?v=vHWiDx_l4V0
This claims to be end to end encrypted. One hard requirement for effective end to end encryption is that a user has a method to confirm that they are actually exchanging data with who they think they are exchanging data with (e.g. Signal's safety numbers).

I don't see anything like this here. So unless I have missed something, the E2EE claim is bogus and Bitwarden ends up being a trusted third party in this system. The identity management seems to work on the basis of an email address verification entirely under the control of Bitwarden.
How do you politically get the world to agree on a power consumption tax? I like the idea but it seems unlikely at a global level.
I don't think we're arguing the same thing.

Here's the context for my argument: believe it or not, there are people that will use language to impress or intimidate or to even mask their ignorance, even people who also purport to communicate ideas. Sometimes those people will also purposely use jargon with the aim to do both: direct their message to their in-group and purposely exclude individuals not from their in-group (I can list some examples of groups that do that, but I prefer not to go down that rabbit hole. I'm sure you can come up with some examples as well).

On the other hand, people who genuinely care about communicating ideas as broadly as possible will tailor their speech in such a way as to make it most accessible to as much of the audience as possible, because to them the idea is the important part not the medium. I leave it up to you to define 'accessible speech', but to pg it means communicating with simpler language - I think he makes a reasonable argument. Especially in context of a multicultural society with a sizable (recent) immigrant base and a global audience with various levels of English vocabulary knowledge.

It is also the hallmark of a good teacher when they can tailor the idea to a student who is smart enough to understand it but struggles with overcoming some kind of barrier (from vocabulary, to culture)
Show HN: Anagramathon: Multi-player online word game
Hi all!
First time posting anything here. This is just a simple game I made while learning crystal. You might like it if you're into word games:)
https://f-droid.org/packages/hans.b.skewy1_0/ for the eavesdropping microphones :)
Yeah I had that but this was just a bit more than a year later I think
The i3-530 is a 10-year old desktop CPU, so of course it uses more power. The M1 can go up to 39w, which is comparable to the Ryzen you mentioned. I didn’t know either, and looked it up before commenting to make sure I didn’t make any wildly incorrect claims.

The M1 is an incredible achievement, but let’s try to remain honest about the numbers.

https://support.apple.com/en-gb/HT201897
Perhaps - I'm not American so I've not been following it that closely.

My point was that the first side which started claiming faulty elections wasn't Trump.
A Model of the Cosmos in the Ancient Greek Antikythera Mechanism
Not an NFT fan but point taken. We need to go at this from all directions, but picking energy use cases one by one will make a mess of it. We need incentives at the base layers (energy production, fuels etc.)
I'll second this.

Affinity Photo and Designer are great tools, they are cross-platform (although you have to purchase them separately), and regularly go on sale (I bought both for 70$ total).

I have yet to find a task I used to use Photoshop or Illustrator for that I can't do with these. I am not a hardcore or super advanced user, but that's why it works for me.
Good time to reconsider if you really should continue subscribing, I'd say. Money to them means money to the copyright holders, and they are destroying our equipment with their DRM. Perhaps better to do something else with that money and time and do something productive instead of being passively fed content for consumption.
> but at a certain level, companies will hire people that execs know/have worked with

This happens more frequently than people realise. Execs depend on, to state the obvious, a loyal next line leaders to get work done. And more often than not newly hired execs are under pressure to begin showing results in about 8 months or so. Hiring their loyalists gives them a very good chance of showing positive impact. Otherwise they need to wrangle with existing reports and peers to win their trust and loyalty which is a time consuming process.

I've seen this happen almost at all the places I've worked in
It was almost 30 years ago... my how time flies.
Hey World makes what’s old new again with blogging
Hello HN!

Hypernotes is a knowledge-management tool similar to the likes of Roam Research, Obsidian and Notion. It provides all the features that have become the gold-standard for personal and organizational knowledge management in recent years:

1) Bi-directional linking between related notes & automated connection suggestions,

2) Outlining of large topics into smaller sub-topics,

3) Embedding of text blocks to reduce duplicate content,

4) Knowledge graphs for better discovery,

5) Extensive collaboration on the task, note, and notebook level,

6) Support of text formatting like markdown, code, LaTex, etc.

In addition to Roam, Hypernotes offers features listed here:

1) Hosting on EU servers (GDPR etc.)

2) Mobile apps & offline access

3) Enterprise-grade admin and user management (SSO, SCIM, Groups, Roles)

4) Visual ways to interact with your graph (drag&drop)

5) MS Teams integration (next week)

6) Advanced task managmement (assigments etc.)

7) Chat functions (via Zenchat)

We would love it if you'd try it out and give us some feedback! Also, if you have any questions about Hypernotes please don't hesitate to post it in the comments.

Thanks!
I have not thought about dark castle in years, but just reading the name I can hear all the sound effects
Also, no logins, just a single string of numbers as your account number. So no one can go to mullvad and say "gimme the deets for criminal@gmail.com", which is nice.
The Buffalo natives on this forum are all too aware of this.
The i7 (and Intel) has always had mediocre graphics performance, mostly just for 2D, office/productivity and media encoding/decoding.

What'll be interesting is how the M1 will compare upcoming 4th gen Ryzen laptop parts with RDNA2.
I'm not sure if this is referring to the privacy laws or the internet itself, but the internet connectivity in Germany is dreadful in my experience. Capacity is at its limits, to the point that some flats don't have access to the internet.
Strong agree, for me the idea of showing something to a colleague immediately makes me able to view it from a different lens. Regular design critiques are really valuable, even if the person you are showing it too isn't an expert, because it gets you into a different mode of thinking, you can't do mental shortcuts when you are actually explaining things so it forces you to be concrete.
The worst thing, in my opinion, is that there has been no communication from OVH directly to their customers. I am impacted and I have not received a single e-mail about the situation even now.
Which just has a bigger storage, but the performance is the same as in the cheapest one. There’s no point taking the most expensive option and try to invalidate the results because of it.

And yes, for development sub $1000 laptops are entry level.
There wasn't anywhere for the matter to be yet. The big bang didn't just create matter and energy, it created spacetime as well. That's just a footnote though, gbrown's is the right answer.
A single developer who put in 7000 hours before he made a cent. It was a hobby project he was passionate about.

He thankfully now makes a comfortable living from it.

It's one of my favourite indie-hacker-style stories, as the hacker was motivated by his intrinsic joy of making something.

https://www.reddit.com/r/IAmA/comments/9urjmg/i_made_a_free_...
i use a small Dell netbook with Linux to rdp into my dev system when working remote. works a treat. small ight and heaps of battery life. GO for it.