skysight-inc/HackerNews huggingface dataset:
Wow that is a poorly written piece, a shame as actually the subject is interesting.
It’s also a huge call for innovation. When a student learns to code, (s)he doesn’t need to analyse millions of Git repositories to get good at it. Throughout their entire career most developers will probably only see comparatively little code. Perhaps the equivalent of the Linux kernel, if that. And yet, we’re able to learn from the little we see and get reasonably good at coding. It even stands to reason how much better one gets by reading more code (most of which is pretty crappy anyway).
Nature's Gold CBD Gummies
With the body, Nature's Gold CBD Gummies triggers the mitigating reaction to bring down persistent a throbbing painfulness and furthermore upholds joint wellbeing and portability. With the mind, Nature's Gold CBD Gummies Supplement manages temperament examples to decrease nervousness and stress. It likewise prompts rest cycles and goes about as a solution for discouragement. Additionally, with age, Nature's Gold CBD Gummies attempts to invigorate a positive fiery reaction to battle diabetes, coronary illness, disease, and that's just the beginning. You can mend the tissue harm and feel great with a finely tuned ECS framework.

Official Website:- https://doctor4supplement.com/natures-gold-cbd-gummies/

https://www.facebook.com/reviewsforsupplement/posts/879742952612789

https://educatorpages.com/site/naturesgoldcbdgummies1/pages/our-classroom-website?

https://naturesgoldcbd1.tumblr.com/post/656207975635206144/natures-gold-cbd-gummies-reviews-2021-cost

https://www.justgiving.com/crowdfunding/naturesgoldcbd-cbd?utm_term=kr7qGGqp4
Oracle loses to Google and AWS in Israeli government $1.2B cloud tender
Plane, train, or automobile, at the end of the night whichever would get me home first is the one I would pick. It was never the subway.
Right to Repair – Submissions Open to Productivity Commission
It is a toy example. Perhaps imagine a more realistic subquery that is much longer. Are you going to duplicate a 50 line subquery to get the salary when all you want is one more value? No, you'd probably want to restructure the query with a join or CTE instead. To the author's point, a large change relative to the gain.
I did this for the FPS game Valorant, not for cheating, but to see if I could make a 100% computer-controlled opponent.[1]

It involved some weird Logitech mouse hacking for the control side of things and was overall really rough, especially with how much latency was involved.

With a normal USB capture device, the latency is around 50-100ms, so it’s hard to do lightning-fast reaction. Even more so if your view is moving at the same time. Everything that normal aimbots do by directly accessing the game’s memory suddenly becomes much harder when you don’t have memory access.

For anyone interested though, the computer vision models publicly available are both very good and also easy to fine-tune for a specific use case (e.g. a specific game).

[1] https://riveducha.onfabrica.com/valorant-ai-pytorch-opencv-l...
https://www.styvio.com/api/ shows a Django debug page. Launching this way is pretty ridiculous, and persisting after several hours is worse.

I will probably try and take advantage of this API, but I would want a list function of some sort to know what stocks are available. How do I know what's going up / down or sentiment is rising / falling without knowing where to look?
Yeah, some of these subqueries could be fairly easily rewritten.
Absolutely on the nose and a fair assessment.

Fossil fuel executives are criminals, their crimes are global in scope, affecting the entirety of the biosphere.

Unfortunately our legal systems are woefully unprepared for crimes of this magnitude, scale and impact. These people should be tried like the worst war criminals, and even that would be mild. They have done irreversible damage and quite possibly doomed the future of human civilization.
Google search would be hard to replace. In fact, if Google search was turned off over night, the world would probably see a major economic downturn, caused by a sudden drop in productivity.
> VPNs are unnecessary for most "normal people"

Normal people watch porn and get torrents too. So, necessary, at times. Having it always on helps cloak your browsing history, and searches in incognito tabs, which is always good too, these days.

> a provider is good without quite extensive research

No need to be extensive, you’re not hacking banks, do you? And you do research only once.
Groove+Funnels An Opportunity To Make 6-8 figures
There is demand for this sort of work in the League of Legends space. Could be of interest for you!
It would be really cool if databases had an Option<T> type. Then you could remove all the NULLs. Although you can mark a column as NOT NULL, that restriction doesn't "travel": it isn't present for function inputs/outputs, subquery results, etc. Adding it to the type system gives you a lot more mileage. And then joins could be option-aware: an inner join would have outputs matching the input types, but an outer join would have Option outputs (for at least one side).

I'm curious how much work has been done on optimizers for Tutorial D or other D variants. It looks way nicer to use, but I wonder if it is easier to stumble into pathological cases.
An additional subquery and a CTE are both restructuring the query significantly, which is the author's point.
What about GDPR potential violation?
One thing I don't understand in SQL is why creating a tmp table is so verbose, why we can't use type inference.

There is an internal software where I work where to create a tmp table you just assign the result of the query to a variable. It is so much nicer. So for instance creating a tmp table becomes as simple as the below, no need to declare each columns, to do an insert, to drop the table in the end:

@t = select colA, colB from tbl

select top 10 * from @t order by colB
A better comparison to cheating wouuld be, if one of the runners would have taken a car instead of running.
100% agree, I flagged it since it's in obvious bad faith/disrespect of HN's guidelines: "Please don't use HN primarily for promotion. It's ok to post your own stuff occasionally, but the primary use of the site should be for curiosity."

This person has literally only contributed posts promoting his site, and at this point it's clearly abusive - two submissions of it today (this one and another), once a day ago, and once 3 days ago:

https://news.ycombinator.com/item?id=27790278 - 5 hours ago

https://news.ycombinator.com/item?id=27786752 - 12 hours ago

https://news.ycombinator.com/item?id=27776497 - 1 day ago

https://news.ycombinator.com/item?id=27755511 - 3 days ago
This reminded me about "How can the Bumblebee fly even though it's not aerodynamically capable of doing so? Because no one told it about this limitation". Upon some search, for an accurate quote, I learned that this is a myth, and that Bumblebee flight does not violate the laws of physics [0]

[0] http://www.todayifoundout.com/index.php/2013/08/bumblebee-fl...
> fk_join(foo, 'bar_id', bar, 'quux_id', quux)

This example has same amount of semantic entities as in SQL. Also there is USING. Also why author needs a strict modeling over json when one can model in native types? It's a very strange article.
Do you plan on having some support for hermetic and reproducability? That's the main thing Bazel brings to the table and I'd like to see some solutions that can scale to hundreds of services like that
I'm honestly not sure it really matters for most people. This year I taught a bit of programming with p5.js to design students who are between 18 and 22-23 years old. Over ~50 students, maybe 2/3 were aware that keyboard shortcuts even existed. To them their computer is merely a gateway to Adobe tools.
Bumblebee flight does not violate the laws of physics
Hand-curated marketing/growth newsletter
Additionally there is doping in video games too - a lot of pro gamers in rts and moba take adderall to focuse more and have better reaction times.
Used to happen with black cabs in a London a lot too. A cynic might suggest they wanted you to pay in cash so that there was no paper trail and no need to declare all the income…
I do love SQL and at least where I live (MS SQL Server) it can be made to run amazingly fast if you take some care with your queries and indexes. It's not portable though: as far as I know not a single one of the big sql vendors follows the standards 100% and more importantly, spending some time with one vendor will give you some habits that are sure to not work as well with another (cursor constructs are generally a death blow to performance in tsql but they are the way to do it on oracle for example). So I kind of agree with the author here.

But I also feel that maybe they are asking a bit much from SQL. The complaint that complex subqueries are complex... Well then don't use them? I would use WITH constructs in that situation because I find them easier to read but that's beside the point. I think its perfectly fine to pull out multiple result sets from simple queries and then do the complex stuff in your host language.
I mean interchangeable as in fundamentally the same kind of thing (car that takes you from here to somewhere else), of course not that you can already hop into someone else's ride and expect it to work.

What I'm suggesting is that they could potentially add a feature that enables hopping into any of a set of cars (probably whichever arrives first or is closest) and matches the rider with the driver after the fact.
How to watch Branson’s flight, which Jeff Bezos is still hopping mad about
CREATE TABLE AS can help. As well as CTEs.
You don't have to do all of those things though? Just create table as select (or sometimes select into).
I paid $80 for an $8 cab ride from HCMC airport. I was tired and confused with all the zeros.

Also, I’m pretty sure the meter didn’t display the same number of zeros as the currency. That is, the last 2 zeros were omitted on the meter. But the driver said there were three omitted. Something like that. Oh well.

Otherwise, I had a wonderful stay. Beautiful country, nice people. I can’t wait to go back.
Funny, recently there were threads about anti-cheat rootkits where people argued they're justified because they provide some defense against cheaters who wouldn't be sophisticated enough to exploit the analog hole.

https://news.ycombinator.com/item?id=27640553
> Why can't this be expressed as an INNER JOIN?

`from foo, bar, quux` is an inner join, it's a shorthand syntax. He's lamenting that he has to keep specifying and matching ids, when the database can figure it out on its own from the foreign keys.
Non-competes are terrible for workers and arguably bad for lots of other new companies trying to hire. Don't forget that lawyers decided to exclude themselves from them, when they made the laws in most states.
This was using RAID 5, which in terms of reliability isn't great. It can recover from 1 disk failure, but as the recovery process is so intensive, it's likely another disk may fail during recovery - especially if they are all the same age. Other RAID setups can recover from two disk failures - but that's a trade-off with performance and useable space.

Mixing drives from different manufacturers may help, but really you shouldn't rely on RAID alone. For commercial use you could duplicate the data on multiple NAS systems, but at home you probably aren't going to do that. Simplest is to understand RAID is not a backup, and to store the data somewhere else as well :-)
> (Also please do not slack me when you're sitting right next to me, it's like, more disruptive and annoying than just talking to me. But mostly just use Email, please.)

I was about to say the same. Slack disruptions are often worse than in person interruptions. Email isn't.
Erik Prince's Plan to Make Weapons and Create a Private Army in Ukraine
Not really, because if they cheated, they didn't actually accomplish it.

They cheat to gain the prestige of having accomplished it.
I disagree. If my manager tells me (as you wrote) “your performance is not meeting expectations”, that’s plenty signal that either we are not on the same page (and we need to fix that), or that I need to get my performance up to the bar.

If your manager gives you that feedback, they’ll then tell you specifics and come up with a plan. I don’t think this is “corporate speak” as you put it.

We can formally give this process any name, but it doesn’t change anything.
That isn't what "lingua franca" means, which is a poor start to your "it's better to only know one language" argument.
Should the filesystem matter? I'd assume a database would just allocate a large chunk of disk space and memory and do what it will with that on a layer closer to the metal than files.
> The only way I can assign an internal monologue of human emotions to you is (i) pattern match your external behavior with my own behavior in an emotional state (ii) take you on your word when you describe that your feelings, (iii) assume that all humans are roughly going to be the same.

Aha... With animals, I think (i) is a misleading option. Our own emotions are laden with self-reflection, with an internal monologue, with thinking about why we're feeling something and how we might be able to change it. This is how we get the idea of "emotions" at all. If we take away the ability to self-reflect, to even have a conceptual understanding of "emotions", that doesn't mean the emotional behavior necessarily goes away, but the conscious experience of the emotion may be quite different, perhaps even completely non-existent. (Again, not consciousness itself, just consciousness of the emotion.)
Exactly... I mean tourism is a big part of the economy in some places. As a tourist I don't mind paying a reasonable amount more than locals, but charging $40 for a 2km ride is clearly just taking the p***. Our ride was 45 minutes maybe 20km, so $10 felt like a good deal to me :-)
> One thing I don't understand in SQL is why creating a tmp table is so verbose, why we can't use type inference.

> There is an internal software where I work where to create a tmp table you just assign the result of the query to a variable. It is so much nicer. So for instance creating a tmp table becomes as simple as the below, no need to declare each columns, to do an insert, to drop the table in the end:

> @t = select colA, colB from tbl

> select top 10 * from @t order by colB

Unless I am misunderstanding what you are looking for, 'SELECT INTO' works the way you want: https://www.postgresql.org/docs/9.1/sql-selectinto.html

It's on every RDBMS I've used, IIRC.
On certain minecraft server anti cheats, this used to be a thing. People used to use a hack called "Kill aura" which automatically attacked anyone with a certain distance of you. Minecraft server anti cheats implemented a system which inserted an invisible fake player circling around the player, and if the play consistently hit the fake player they got banned. This system worked pretty well for a while until cheat developers realized they could pretty easily determine the real from the fake anti cheat inserted players.
> We have seen others in this forum refer to Amazon's work as fixing broken code that's hardly maintainable.

Reminds me of someone that worked at a vendor of Semiconductor ATE equipment. The codebase was a total hopeless trash fire. Watching him flail and fail gave me the impression that working for a place like that, actually caring about anything is a liability.

You should only care about three things. Your mental health. The money you are making. What your boss wants. You should treat anything you are working on as a booger to get rid of as quickly as possible.

'As you are closing the ticket you may feel a sting. That's pride fucking with you'
I think increasingly more browsers (except Chrome and Edge) come with strong privacy centred defaults nowadays so it doesn’t require a tech savvy person to stay private or anonymous.

I wish Google Analytics had an option to run a small proxy in a Docker container so I could run it on my server and collect all traffic without being blocked.
One of the elephants in the room with SQL is that it is one of a small number of popular languages that doesn't use

function(arg, arg, arg)

It is strange that "SELECT a, b, c FROM schema.table" keeps any aura of respectability. That is legitimately outdated syntax, people don't write languages that way any more. It was a 70s era experiment and what was learned from that experiment is that the style has no upside and comes with downsides. It should be 2 or 3 functions, with brackets.

With full knowledge of SQL, the successful languages that followed it were C/Python/Java/Javascript that use lots of functions and a smattering of special syntax for control structures.
>The usual response to complaints about the lack of union types in sql is that you should use an id column that joins against multiple tables, one for each possible type.

>create table json_value(id integer);

>create table json_bool(id integer, value bool)

>create table json_number(id integer, value double);

No, the usual response is "Don't do that!"

99% of the time you either know the data types (so each JSON object becomes a row in a table where the column names are keys) or you don't know the data types and store the whole object as a BLOB

I'd be on board with adding unions to SQL, but I doubt I'd use that feature very often.
A beetle? In my aquarium I have snails walking upside down under the water surface!
Audacity has not done very well. It has been in a dire need for a usability and a feature update for a very long time.
(Disclaimer: My knowledge of Rust very limited, but I have quite a bit of experience with getting Qt/KDE classes to work with other languages.)

You are absolutely right. The effort to be acceptable bindings for Qt would be a tiny fraction of the cost compared to building a whole new Rust native GUI library.

Qt is huge set of libraries with an equally huge API. But there are a lot of shortcuts and smart ways of approaching the problem to get what you want out of Qt for minimum effort.

Bindings like PyQt and even PySide go for the nuclear option of generating bindings for the whole Qt API and trying to match the C++ API in style too. This is an absolutely massive huge task. Also, getting people to contribute to an open source bindings project is hard. Getting people to contribute to a bindings generator is even harder.

NodeGui https://github.com/nodegui/nodegui, Qt bindings for Nodejs, on the other hand takes a very different approach which in one way is low-tech but I think is actually very smart. I'll summerise the differences:

* It focuses on Qt Widgets first. This greatly reduces the amount of work to the parts that people actually need. (BTW, if you just want QML and Rust back-end then Jos van den Oever's work at https://invent.kde.org/sdk/rust-qt-binding-generator has probably got you covered already.)

* Mostly hand written, no generation techniques being used. This makes the bindings code repetitive yes, but also easy to understand, easy to debug, and easy to extend. That greatly lowers the barrier for casual contributors.

* Doesn't try to copy the C++ API 1:1. For example, to extend a widget in C++ you are expected to subclass it directly and override methods etc. NodeGui chooses a more composition approach where method you might override are instead exposed as events. Another example, the Qt API is encrusted with convenience methods and overloads. Most of these can be skipped or implemented purely on the JS side.

* Intercepts most events via `QObject::event()` instead of trying to do this method by method (i.e. in QWidget's collection of event handling methods). Smart move.

* Qt has a lot of tiny value classes which can be replaced in the API by JS native objects holding the same data.
Ask HN: How do you promote your service online?
I made a product in the crypto field, a service I know people need and does not exists on the market right now so I know people want to know that service now exists. And they hopefully want to pay for it.

But most social platforms prohibit self promotion to cold audience. Eg. Reddit, most discord servers.
Cold emailing is prohibited by law.

How do you promote for a new product when you don't have network?
NHS Covid app settings changing to send fewer alerts
While some of their complaints are legit I think most of the SQL in this article are straw men. Most of it can be made more readable and more performant.
Sort of. A regular person on steroids could never compete with a skilled athlete who isn't, certainly. But in virtually all sports a skilled natural athlete also can't realistically compete with a skilled "enhanced" athlete.

It's not really cheating anymore, since everyone does it now, but the point I'm trying to make is that it's not nothing either.
Valve is actually doing that. Sometimes when they update VAC, they intentionally do not ban anyone for a while to catch as many as possible. Not unlike the police is handling drug dealers.
Thanks. I didn't know this syntax. You still have to drop it in the end but somehow I never ran into this syntax.
Interesting read. Contrary to what the author states, I’m think Pitfall was available in arcades. I’m pretty sure I spent a small fortune playing it.

Before now, I never realized that it was (sort of) the first platformer/side scroller.
Just read this on the Steam page for SpriteStack regarding the upcoming release.

Do not worry to get current version of SpriteStack - it's the one that will get updated with all the new features you can read about there https://spritestack.io/upcoming. After the update the price will go up so it's the best moment to get it - also it helps me to focus on SpriteStack instead of looking for funds.
Advice on the privacy and personal data protection aspects of a digital euro [pdf]
You can take SF Muni anywhere you want to go... as long as you want to go to the financial district/Market St. corridor. Seemingly more than other cities, the transit system is built around that particular commute which makes it frustrating if you're an out-of-towner trying to get to shopping/nightlife areas or to a friend's apartment. (And then there's BART which although it has the look and feel of a metro, has a network map more akin to commuter rail.)
<message has been deleted>
The main experience I have with gulls is one by one eating up all the ducklings in the canal here in Amsterdam, to the horror of everyone on the terraces.
It's good bait. The vague, unassuming titles turn up gems as often as they do crud. Compare with the other cat-related title on the front page right now.
Yeah and you're still going to have to do all the work and be a talented athlete to be at the top, unlike with hacks or cheats.