skysight-inc/HackerNews huggingface dataset:
Is there a way to remove the overlays? By that I mean the crap above the videos? I really can't use it with those, I'm autistic and it's just too much.
I wouldn't call someone "well read" just for reading lots of books. I'd call them a "book worm". "Book worm" still has more positive connotations than "binge watcher" or "couch potato", but "well read" indicates that they read the classics and can talk about them intelligently.
Elon Musk Says He’s Thinking About Creating a Social Media Platform
Right join is just left join with the clauses switched, so it makes sense to use left join consistently. Inner join is just a left join with a 'not null' condition. I prefer inner join for conciseness, but it makes sense to always chose left join for consistency. Full outer joins are rarely needed in my experience.

In any case, all the joins are just syntactic sugar over cross product. AFAIK SQL did not have the join syntax initially, you just did SELECT foo, bar WHERE foo.id = bar.foo_id
Nearly all of the stuff that makes the Arduino interesting comes from places other than the Arduino company itself, though - even the IDE and the user-friendly Arduino libraries that ship with it were basically just copied from the Wiring project. Their ports to microcontroller architectures other than the one Wiring was based on have also been kind of poor compared to community-developed and third party ports.
First class languages for the Windows Platform.
> Jared if you’re reading this, I’m sorry for using Jared as the fake name. Your real name fits much better.

Could we speculate as to what his real name might be? Lefty? Joinathon?
Would be nice to have a link to an example.
All you need is to read "How to win friends and influence people" book and then go and practice the techniques. Start with introducing yourself to people and just asking questions about them as everyone loves talking about themselves. That is all, really.
On another side, I was in a company building custom ETL solution, they are building 5th attempt where previous three are still in production, it is total mess.

It takes top talent to build an ETL solution from scratch.
> When you think about it, all joins are just a left join

Not really; using left joins enforces a specific table order in the query plan.

It's possible to optimally use left joins because one can either guess the optimal order (which is a bad habit, though), or can observe the query plan and emulate it.

My guess that this developer didn't trust the optimizer to do a good job at ordering, and he wanted to enforce it, but that is generally not the case with modern engines (of course, there will always be exceptions).
That's still really high though. nRF51 sleep current is around 2 microamps. You can run it off a coin cell for years (depending on what you're doing). Sounds like an RP2040 would last maybe a week.
This actually has happened to me on Gnome several times ;-)
not at all, pattern recognition has to do with raw data, correlation/causation about highly conceptual interpretation of the data
A famous case of this is the Danish man Victor Cornelins that was born in St. Croix but at the age of seven was brought to Denmark to become part of a human exhibition as a "negro kid" to attract visitors. His birth name was Cornelius which is not unusual in Danish so Cornelins must have been a simple writing mistake. However, this lapse is negligible compared to the racism he was subjected to.

https://en.wikipedia.org/wiki/Victor_Cornelins
I sometimes use left join to protect me against errors somewhere else.

Let’s say you do an inner join in insert into … select statement to find some other entity which 100% should be there. If something else is screwed up you might silently filtering out rows. With left join you keep everything, but not null constraint on the table protects you and turns it into an explicit error.
Ok no scientific basis for this at all but I often wonder if some future inventions are so potent that their "gravity" for lack of a better word, manifests itself into being.
No , there are many surnames with multiple spellings in their native language. See e.g Danish Skov Skou Skog etc etc
We use Kotlin JS in production and like it quite well. It enabled us to easily share code with the Kotlin backend and Typescript frontend. Kotlin also generates Typescript type definitions which enables us to easily call those Kotlin methods from typescript. The multiplatform vision allows us to compile/share natively code for mobile platforms too.

I also love to see the quickly evolving Jetpack Compose which would enable to write natively executed UI code on most major platforms. (iOS is not there yet and likely depends on new memory model which is currently being developed.)
The article explores the use-case of 10GB ephemeral storage for AWS lambda.
Just my experience at work (I don't intend to change your mind or invalidate your opinions) I can see from reading code what IDE the developer used, this is because I investigate bugs and I see trivial JS bugs that Intellij highlights but the author used VS Code and an avoidable bug was put in. Intellij is slower because it actually parses your project and dependencies and even with a dynamic language as JS it can infer many types and show you the error.
I don't understand where you're going with your "region / culture" thing. The rest of your comment makes it sound like your standards are just lower than mine. You describe your work as mostly tedium and say you don't have a problem with that. This is a state of affairs I will never ever accept for myself.

And I'm approaching 40 myself and have been a part of this industry since the late 90s, so I'm not speaking out of youthful naiveté either, but rather from the vantage point of a conscious set of choices I've made on personal values and introspection into my own psychological needs.

The set of people who share such values/needs may or may not be a majority, but I never claimed they were. This discussion was originally on the broken state of open source, and my contention is that a lot of people who do open source probably do it because they're a little bit like me, frustrated with their day jobs, and looking for a way to contribute to the world in line with personal values that are similar to mine, and an outlet for unmet psychological needs similar to mine.
NOT going way out of my comfort zone and forcing myself to socialize. Fuck that.

For me, it was finding the right gang, with a shared passion. Still very close friends with ... 6 of them? 20 years later. We completely forgot about the shared hobby, btw - I have different relationships with each of them.

Recently I got into the same context that used to make me feel awkward and surprise - still awkward and unpleasant. Better at dealing with it, of course, but mostly better at getting out fast.

Ah, and you're allowed to dislike certain kinds of extroverts. It's not envy, and you should definitely not emulate them. You just don't click.
I'd call it a more poetic name: the shaming demon. This is an unconcscious virtual creature that lives in our brains, like a botnet lives on PCs, and it watches restlessly for non-conforming behavior. The key feature of this demon is that it can be activated by a special whistle, and its wrath can be easily directed at your enemies. The weakness of this demon is inability to focus on many things at a time: if your enemies are many or they change frequently, the demon's wrath won't do much.
An inner (standard) join returns a row in the result, when the join finds a match between two tables, and no results when there is not match.

A left join always returns at least a row; when there is no match, the part of the result (if selected) that corresponds to the right table, has NULLs.

There are many important consequences of this, one of which is that left joins enforce table ordering; inner joins can be reordered by the optimizer if iterating them in a reordered way gives faster access (imagine two nested for loops, and swap the inner loop with the outer one).
Quicktime is the basis of the MP4 file format, so it's still in use pretty much everywhere.

>MPEG-4 Part 14 is an instance of the more general ISO/IEC 14496-12:2004 (MPEG-4 Part 12: ISO base media file format) which is directly based upon the QuickTime File Format which was published in 2001.

https://en.wikipedia.org/wiki/MPEG-4_Part_14
Try to see some org-mode Emacs videos on YT and co, you'll discover the real meaning of "notes" and "computer usage" :-)

For instance https://youtu.be/B6jfrrwR10k but also, https://youtu.be/5ViUBaarsbw a bit exaggerated but nice. Notes are just personal documents, text means information, and automation on information means IT. Actually a notes-based computer system/environment is a desktop, is what we need and miss today.

Crappy compartmentalization of modern "apps" is the opposite, is the need for business against the user need and interest. Personally I have in "notes" essentially anything thank to the Emacs ecosystem:

- my files are org-attached, accessed via search&narrow thanks to org-roam

- links in notes point to pretty anything, mails threads, specific messages or mail search queries (all local, locally indexed maildir by notmuch, something better than GMail and under my total control), feeds (posts I decide to keep), bank transactions (any kind, from transfer to stocks passing through grocery expenses)

- notes form my agenda with SCHEDULED, DEADLINE, TODOs meta-information adding to a heading, org-agenda scan all notes to form a view, a single page or more than one, letting me selecting what I want to see (look for) or not

- queries on notes (org-ql) and transclusion means the ability to form/see my web of information "putting on the desk" (screen) just what I want in a semi-automated manner

- notes are also literate programming environments, spreadsheets, slides, all integrated with all meta-information I might want to add, I can place, link-to-execute, pass data from a code block to another, with code blocks of various languages, like pipes in the shell, but in a 2D environment instead of the CLI, I can create a table with all "formulae" I want like a spreadsheet but without the need to open separate tools and with the ability to use any language for them (included the built-in "calc" CAS)

Peoples these days use Google search and the modern web just because they are unable to make their own, collaboration included, notes with desktop computer environments are the tools need to substitute the centralized web of the giants to a web of personal information network shared as we want.
Drugs, clubs, sex
Just see https://youtu.be/B6jfrrwR10k and https://youtu.be/5ViUBaarsbw you'll understand why all modern software and unix CLI are actually limited and limiting crap :D
Tiktok claims to have a billion monthly active users now. That puts them #4 in the social/public-user-generated-content category, behind Facebook (2.9B), Youtube (2.2B), Instagram (1.4B), and well ahead of the likes like twitter or reddit. I wouldn't call that a "relatively minor platform".
When did Quora start requiring logins to view content?
Pipy is a programmable network proxy for the cloud, edge and IoT.
Written in C++, Pipy is extremely lightweight and fast. It's also programmable by using PipyJS, a tailored version of the standard JavaScript language.

More details on https://flomesh.io/
What I learned a while ago is that it's pronounced like gwen, but with the tongue deeper in the mouth for the g.
I don't think that rebuild would happen more frequently with PCB based windings though, the main failure mode of stators from insulated copper wire is that over time the vibration eats through the lacquer, especially near the places where the wire has been bent sharply, which then shorts out the stator. But if your whole winding is fixed in place in the PCB with space enough to prevent arcing then I don't see how short of gross mechanical damage or frying a winding you'd ever have to replace them.
As a European, when I think of stereotypical 'American' surnames, it's often the European ones that are not common near me that I think of, particularly Polish names ending in -ski and Italian names ending in -i.

I wonder if other areas in Europe do the same in reverse. (Though typing this out I realise that I grew up knowing a few people with a Polish and Italian surname that fits these patterns, so possibly that's why they stick out for me personally).
Same goes for using software from other countries, no?
Still doesn’t make it fast in any meaning of the word, which was my original criticism.
> If it wasn't for Google giving wind to their sails, the Kotlin ship wouldn't have gone anywhere.

I disagree. While the Google announcement to officially support Kotlin surely gave it a big boost, Kotlin was already in widespread use for Android development well before Google announced their support for it in May 2017. Additionally, it was also gaining traction for server side development since before the Google announcement. I had been evaluating Kotlin closely during this time, and made the decision to start using Kotlin in our (primarily Java and entirely server-side) company codebase in late 2016 because I was already convinced Kotlin had a bright future. We weren't the only ones who thought this, I was tracking multiple other companies in our space (financial tech) that were evaluating and/or already moving to it too.
Age has also brought a deeper understanding for me.

I was shy because I was very sensitive to loud noises and bright lights - they overwhelm me. Not in a psychological sense but in a raw sensory overload type way.

The gain on my brain is set quite high and the hustle and bustle of school completely overwhelmed me everyday, year after year.

That led me to believe I was socially completely incapable - which led to social anxiety. Once I was able to understand and not shame myself for needing quiet everything started to change.

I now know that I fear parties and pubs not because of the people so much as because of the overstimulation. The social anxiety is an extra layer over that - and that falls away with age and acceptance of my biological nature.

Do you lose the ability to think and speak in social settings? Like everything becomes utterly confusing? Does it not happen in more intimate gatherings - low light, small room only a few people even though they are strangers? Then you might be dealing not with social anxiety, but with overstimulation.

Overstimulation cannot be beaten, it is a raw innate characteristic of your mind, great for some things bad for others.
> In the real world, your past uniquely determines your future. If a physicist knows how the universe starts out, she can calculate its future for all time and all space.

[Layman here] Is this ignoring quantum mechanics? Or is the claim that you can reconstruct the original wavefunction a collapse? I thought randomness was pretty intrinsic to quantum mechanics.
I wouldn't count on that: many things that seem straightforward, especially to an adult tech-savvy person if those things are tech-related, are far from that for others. And even tech-savvy people can be (and often are) careless, distracted/preoccupied/unfocused, making mistakes; I think pressing a "start" button automatically upon closing the door is something that can happen easily. Also as a rule, extra guards, safety measures, and/or warnings are good, especially when irreversible damage can happen.

Edit: actually there's an example of an unexpected mistake in this thread already, in the comment by hanoz. As mentioned before, listing unplugging as the first step would be useful.
Hmm amazon cards, nice tip. I was thinking about PayPal but the problem is that PayPal might find it scammy or spammy paying out random people from my personal account
No idea. I think the demo schedule drove him to find something that he could get working.

To be fair, I think he was fighting not just Kotlin JS but using React within it and his own lack of web technology experience being predominantly an Android dev.
I found the opposite. I took a look at TikTok, but the videos are too short to get into anything interesting. There's lot of interesting stuff on YouTube, however. Some of them could be shortened somewhat, but not down to a few minutes.
I video call my parents.

I'm not convinced by "natural, therefore better". The "can see everyone" is the one thing that's better with video than in person. But yes in person as a whole is better.
Hap video frames are stored in a MOV container, but you could use .MKV too. What exactly do you need from Quicktime ? I work with the Hap codec too, so Im interested :)
Apparently you know the feeling when a competitor comes up and do 80% of what you're doing for half the cost (in dev time, memory weight, etc.). Hell, it still feels unfair even when it's a coworker who gets tasked with redoing (usually using some trendy new stuff) the system you've been maintaining for so long and know by heart, and that you've dreamed to rewrite for an equally long time.

You comfort yourself by saying they will run into the same problems that just wait their time in a dark corners of software or hardware. But they generally are in a much better position, with their smaller and simpler software, to deal with it than with old software.
And if you want a webapp, use SpringBoot.
There is a quote by Kafka on the front of my keyboard:

> Beyond a certain point there is no return. This point has to be reached.

Most of the exiting, good and spectacular things in life happen when you make yourself cross some boundaries, when you leave your comfort zone or put yourself into certain positions where you either have to give up and feel bad or pull through and end up in a new place.

Doing sports will also help. An actress gave me this advice once as well: She asked which one comes first, the confident/sad/aggeessive posture or the in er feeling that leads to that posture. She said you can also simply turn it around: Put your body in a confident pose, and you will automatically act more confident.
Show HN: KeepAlive.Finance – Keep your credit cards alive
keepalive.finance is a stupid simple project I made in one night to keep my credit cards alive and I figured I’d share it. It’s just a Stripe subscription that bills you $1 every 6 months so that your account doesn’t get closed
> family guy

Holy crap literally this happened to me few days ago
Hell, you don’t even have to compile it anymore — java HelloWorld.java just does the thing you wrote.

Also note that `java HelloWorld` looks for classes, so if you are in the same directory as the classfile, .class is not required.
You have poor reading comprehension (in addition to a real hatred for one particular language, which seems unhealthy). I never stated that it was among the most popular languages, just that it was gaining momentum.

In 2019, 41% of Kotlin devs claimed to work on web back-ends. In 2020 it was 47%. In 2021 the survey changed wording but "server-side development" had increased to 52% of Kotlin devs.

https://www.jetbrains.com/lp/devecosystem-2021/kotlin/
The DEC Alpha running OSF was by far my favorite Unix system at the time.
I'm afraid I don't agree. MicroPython is neat, but if there's one thing Python is not suited for, it's microcontrollers. Coupling one of the slowest scripting languages with low latency near-realtime requirements is not a recipe for success. It might be useful for teaching basic concepts, but it is not going to be useful for real applications. And Arduino already has the teaching of basic concepts nailed very effectively.

I certainly think that MicroPython serves a niche, primarily very simple hobbyist/educational roles. However, I do not regard it as suitable for anything beyond this. It's the wrong tool for the job, and if you want a scripting language for low-latency low-overhead use, there are smaller and more efficient languages which fit better into an embedded role.
Yes, but at a higher refresh rate - 525 horizontal scan lines @ 60hz vs 625 @50hz.

Refresh rate is linked to mains frequency.
Comparing things like vine or TikTok or Instagram reels to a 1 or 2-hour long video makes no sense at all. Those are wildly different things and both have their time and place.

I haven’t used TikTok but I do use Instagram reels and the feed is what you make of it. I follow a lot of musicians so I get interesting snippets of songs or things people are working on, or theory/exercise tips etc.
You can also buy mini nuc boxes with amd chips which will run circuses around the Mac mini for gaming.
I’m not a big fan of kotlin, but gradle does have a kotlin dsl as well which is in my opinion much more readable and explicit.
I'm missing, which settings have been chosen for rocksdb, and why.

I dearly hope, not just the defaults.
This would be so much easier in Lisp.
> So, paying more than other buyers is in a way stealing? Do you hear yourself?

When it comes to housing, and your intention is to use it as an investment vehicle, yes, absolutely.

I have no problem with individual buyers who are intending to use the property as their primary housing competing on price. I do have a problem with institutional or investor buyers competing against those would-be-homeowners on price.

Homes aren't just any other assets, they're not just some good. They're a thing you and your family need to survive. They _must_ be treated different. And if that means considering institutional or investment purchases in homes be considered stealing, so be it. There must be controls on such properties to ensure a more equitable (read: regardless of wealth) distribution of this specific asset type.

> You are opposed to the very idea of price signals?

For housing? Yes, 100% against it. Housing availability and access should _never_ depend on an individuals wealth.
Linkfinder – A Python script that finds endpoints in JavaScript files
Well that's not enough information to give to an engineer. You just listed several huge features by simply naming them. That isn't a spec. If you said "... like Twitter" then that would require some form of reverse engineering on the developer's part.
Emacs buffers are just buffers, not canvas, so dynamic information display is limited, but much can be done and it's already there (see Nicolas Rougier's Nano Emacs as a showcase).

You can substitute for instance

(push '("#+BEGIN_SRC" . "↦" ) prettify-symbols-alist)
(push '("#+results:" . "") prettify-symbols-alist)
(push '(":PROPERTIES:" . "") prettify-symbols-alist)
(push '(":END:" . "") prettify-symbols-alist)

you can avoid tags using in-property-drawer kev/value tagging, that's also easy to query with org-ql. A code block is run by a function as pretty anything and a function in Emacs can be called in countless way, like:

- hitting a key

- on file save with a hook

- when certain conditions happens with a hook

And that's in a global or file/buffer-local approach
You have to grab their attention via other means. Think about what other points of interest your users have as individuals. Cater to that interest and once you have enough people then you introduce the dating app service. Else you can visit your target audience where they gather and tell them about the service and give them an incentive that will keep them interested until there enough people to make the service useful. Such as a 2 year free membership for the first 5000 users. You can also partner with another service that has the users and would want dating as a new service.

Think about what new communities are appearing on the net and create a dating service for them. What new interest have you seen growing lately?