skysight-inc/HackerNews huggingface dataset:
FunSQL.jl requires Julia to run (obviously as it is a Julia library) but it
produces standard SQL so Julia in this case is just an implementation language.

I have re-implemented parts of FunSQL in Python and OCaml (the one I have ended
up using) and have added a concrete syntax similar to what you have in PRQL.

from employees
define
salary + payroll_tax as gross_salary,
gross_salary + benefits_cost as gross_cost
where gross_cost > 0 and country = 'usa'
group by title, country
select
title,
country,
avg(salary) as average_salary,
sum(salary) as sum_salary,
avg(gross_salary) as average_gross_salary,
sum(gross_salary) as sum_gross_salary,
avg(gross_cost) as average_gross_cost,
sum(gross_cost) as sum_gross_cost,
count() as count
order by sum_gross_cost
where count > 200
limit 20

But, in my mind, the biggest difference between PRQL and FunSQL is the way
FunSQL treats relations with `GROUP BY` - as just another kind of namespaces,
allowing to defer specifying aggregates. A basic example:

from users as u
join (from comments group by user_id) as c on c.user_id = u.id
select
u.username,
c.count() as comment_count,
c.max(created_date) as comment_last_created_date

The `c` subrelation is grouped by `user_id` but it doesn't specify any
aggregates - they are specified in the `select` below so you have all selection
logic co-located in a single place.

I think this approach is very powerful as it allows you to build reusable query
fragments in isolation but then combine them into a single query which fully
specifies what's being selected.
Exactly. This is why it's important not just to have language skills when creating these kinds of datasets, but also cultural knowledge and context.

For example, to pick a bit on the Google Emotions dataset again, it's difficult to label this message...

“Also Republicanism is a belief system. It’s taught and handed down like religion. Conservative talk radio is its evangelism.”

...unless you're familiar with US politics. Hence why it was labeled as APPROVAL by the non-US annotators, even though it's criticizing Republicans.
FYI, this is a different Bolt.

Bolt, US: https://www.bolt.com/
Bolt, EU: https://bolt.eu/
thanks, as someone who just started out doing cuts leave feeling like im in the wrong place
I buy Mtn Dew with real sugar, unfortunately
In case there's any doubt: Could advertising possibly work?
Cash Aid to Poor Mothers Increases Brain Activity in Babies, Study Finds
Something alluded to here is that many of the Languages models use US English. Many terms that are offensive in the US, may not be offensive at all in the UK. e.g. "Fag" in the UK is frequently used to refer to cigarettes. "Can I bum a fag?" literally means "Can I have one of your cigarettes please?".

Similarly something that might be a cat call such as "Get your baps out" (shows us your breasts), could also be used by a baker since a "bap" is a type of bread roll in a slightly cheeky advert as most people are aware of the pun.

How are you going to train an AI to know the context that the person might be talking about bread instead of a woman?

Has anyone realised yet that almost all of this folly? I suppose not when there is money to be made.
> We’ve received and are processing your request to access your personal data.
We will provide your information to you as soon as we can. Usually, this should not take more than a month. In exceptional cases, for example if a request is more complex or if we are processing a high volume of requests, it might take longer, but if so we will notify you that there will be a delay.

I wonder what the formats are.

Also, is there a team of poor souls navigating internal bureaucracy to manually fulfill these requests? Is it a black hole?

A nice policy would be to decree "Every [property] in Amazon must provide an internally registered [endpoint] that speaks [protocol] serving requests consistent with [schema]. Request volume will be limited to at most [limit]." Require it for new stuff, and add it to the backlog for existing stuff.

Ah, but it wouldn't increase revenue, and everything is existing stuff. Still, I like the idea.
does anybody know the real cause? money alone could not have caused it.
I have never seen a ‘language redirect’ do this. Maybe it is not uncommon to have a language redirect but it doesn’t do this, in this way, very often on the sites I have visited. Unless forced ad sites, I have never seen this. And indeed it makes me doubt the quality of the offered product if this is what they want first impression to be.
For anyone confused thinking this was about the crypto exchange, it's talking about the Gemini web protocol: https://gemini.circumlunar.space
Not GP, but for me it really seemed to affect my sleep quality in addition to keeping me up later. I started by taking 100mg at 8AM and another 100mg at 12PM. Any later and I'd still be awake at 2AM.

The lethargy and brain fog went away if I dosed again, but that only compounds the problems.

I still dose when I need a guaranteed day of focus, but I really try not to use it on consecutive days.

YMMV
Writing complex application in Python or any other dynamic languages is a madness anyway. I often witnessed cases when developers even reused the same variable for different purposes and types just because the language allows it.
For a short delay, you use a small resistor and a small capacitor. For a long delay, you use a large resistor and a large capacitor. The result is that it supports "timing from microseconds through hours." The timing resistors and capacitors are external, so you can select whatever values you want for your application.
Nothing of the sort. But your responses do seem to be consistently evasive, for whatever reason.

If you think the Baltics somehow "belong" to Russia, or that Russia would be justified in taking "action" to prevent Ukraine from joining NATO (which is definitely what you were implying in your posts) -- then just come out and say it.
I don't see anything interesting to choose from in the likes of Amazon knows me better than I know myself — Basically it's just a dump of your profile setup.
Why a new protocol? Because modern browsers are massive, and we need something much, much lighter that doesn't need to support HTML and such.
I find it easier to deploy Docker inages to VPSs than to learn how to use countless AWS services. My go-to combo for a new project is DigitalOcean and Cloudflare.
The Mona Lisa was the most disappointing art work I've ever seen. Size, color, everything. And I was lucky enough to see it up close unlike the arrangement now.
It's getting hard to keep track of which advantages are earned and which ones are only handouts from universities or rich parents.
If you have that study on hand, please please post it. It’s worth its own discussion if that’s real.
This isn't exactly a secret or new information... it was pretty well known when I lived on the peninsula 10+ years ago (thus the username, Poulsbohemian...). There's a state park right near the Hood Canal bridge where it isn't uncommon to watch the submarines come and go in and out of the canal. Always a bit surreal to push your kids on the swings while watching a first strike weapon capable of destroying the world pass by ;-D. I don't recall the name of the street, but there are houses with views across the water to what locals believed to be the dolphin pens...
Requiring a copy of photo ID to be mailed is a joke. The entire point of photo ID is that you're supposed to make sure the picture on the ID matches the person who handed it to you.
What strikes me about that movie now is that it depicts a Napa Valley that doesn’t really exist anymore. It represents the tail end of a time when you could drive around and get tiny, free wine samples at small, uncomplicated places where the restaurant was almost tacked on if it existed at all. Now you go on tightly scheduled bus tours where the samples appear to be $30 each or so. I don’t drink it all and never did (my wife is an aficionado) but there was a lovely air about the less formal version of Napa from that time.
In the true sense that the people are the state, a democracy would hold that the people can push through changes to the system that might not be in the interest of those who currently hold power under the very system the people are trying to change.

And yet... how does a population convince itself that elections are conducted fairly?

Any change proposed in good faith is distorted by anyone who needs things to stay the way they are. Fear, uncertainty, doubt.
Sleep debt. It's very much burning the candle at both ends.
It can also be pretty terrible for your sleep patterns even for a few days after.

As another commenter mentioned, used judiciously, it's amazing.
You need to train models on everyone's own labels. As you've said, "offensive" is context-dependent and each listener is huge part of that context.
If it makes you feel better, it goes both ways; I once signed up for a utility, got service, and discovered months later that they somehow completed the paperwork to give me service but not to actually bill me.
I wish the Arduino IDE actually tried to be educational instead of just being a dumbed down wrapper around avr-gcc with automatic #includes. There are so many things that could be done... stuff like showing side by side disassembly of functions, with register names displayed symbolically. Or even just basic IDE stuff, like built in contextual function documentation.

And then it should have an "export self-contained project" feature that gives you a directory containing a Makefile and all the dependencies to build your .ino, as source code form (and none of the ones you don't use), so you can easily see exactly what is getting built under the hood and can use that as a bridge to working outside the ecosystem. At the scale of 8-bit micros there's no reason not to work with copies of your dependencies, and it's very educational seeing everything in one place (and being able to hack on it) instead of having it scattered in a bunch of global package paths.

The frameworks and libraries are useful (if opaque and quirky and underdocumented), but the IDE is just so underwhelming... heck, it doesn't even manage to be a decent text editor.

Getting started with Arduino makes total sense, nobody's expecting newcomers to start off with the IC datasheet... but they should be able to eventually read the parts they need and work with it directly, instead of relying only on software abstractions. That's the beauty of these systems.
If your grandma can install a web browser, she could install lagrange. If she knows how to navigate to 'facebook.com,' she can navigate to a gemini URL. If gemini got enough user share, lagrange or something similar would come installed on a computer by default. Gemini is not all that hard to use. From the user perspective, it is just like using Chrome, but the websites are more basic.
It actually took place in the Santa Ynez valley, not the Napa valley.
>It leads to lots of really interesting and fun sci-fi that somehow hasn't really been dug into sufficiently yet along the same lines as the Twin Paradox

It's been done.

I mean, time dilation in general, and a fast ship catching up with a slow ship in particular.

I would guess 50 years ago-ish practically every variation had been done. Tau Zero was a notable example.

I don't know when the genre started, but it's easy to forget or not be aware than Einstein came out with special relativity almost the exact same time as the Wright brothers were getting their plane going.

Technology has taken a long time to catch up to physics.
Watch out that electricity costs went up significantly in Europe in the past months. I am a happy hetzner customer since 2012 I think. Their server monthly costs were just a bit higher than my electricity bill would've been if I were to keep a machine up 24/7 at home, so I rented a machine from them having the hardware basically for free.

Last week I got an email from them saying my server cost would increase from 30eur/month to 48eur/month. I can take afford the increase, but I wonder how many companies with infra bills of tens or hundreds of thousands will be able to afford a 60% increase in hosting costs.
The GOP was opposed to the motor voter law in the 90s because they didn’t want to have to nerf the DMVs?
OpenBSD is much more strict than FreeBSD with regards to release cycles. You get N-1 releases, period, which ends up being any version gets you about a year of support.
My understanding was that making it difficult to connect to, in order to keep out people who wouldn’t/couldn’t meet the bar, was an intended benefit and not an accident (whether that’s a good idea or not is an exercise for the reader, but the premise of this article seems to assume that it wasn’t the intent.)
> I said curious not dismissive.

I was curious. I went to the site. I saw literally nothing about the purported "exploration of legal intersection with smart contracts".

> When people don't communicate like you it doesn't mean their ideas are bad.

They have to communicate those ideas first
It may look sick but it's eating battery like there is no tomorrow. It's pegging 2 of my CPU cores at 100% constantly.
I believe this is only for accounts with sharing on. Otherwise, there is no infringement
Aah trying to bitbang with a Sleep? I agree, it's a case of "get off my lawn and go back to node.js" :)

Or, more accordingly, don't think the computer is magical.

Edit: it's a bit funny seeing someone trying to discover things by themselves but saying "it's difficult to measure pulse width with an oscilloscope" just triggered me - pun intended
Worse, the ping changes a lot. From 3 minutes to theoretical 22, but if Mars and Earth are separated by the Sun, you would have to communicate through a relay, adding possibly other 10 minutes.

Mars will be a digital frontier forever, or until someone discovers communication faster than light, which is impossible in our current model of physics.
Right, most people search in inclusive terms: “I want this with that trait”. It’s unnatural, at least in English, to search for something based on what it isn’t.
Chiming in to say you are dearly mistaken, you turkey-squid uncle buntler.

I, on the other hand, am a fucking amazing shit OG bitch.

But yeah this stuff is absolutely dangerous, opinions like these are destroying culture. It won't be long until the threads these automatic tools are moderating, WONT BE WORTH HAVING.

'Nuff said.
Wine is very much a social status. You gift it. You keep a "good" bottle around for company. Stupid, but how the world works.

My wife and I, we just like and prefer the sweet $8 pink sweet barefoot wine. Despite having no guests, we don't touch the 'good stuff.' For no other reason than we don't like it.
> It could say - Google is bad in that and that BUT it has Go. Or it could say - Google designed Go and is interested in its adoption BUT its own managers don't think that Google developers want to learn Go.

It's implied. In fact, Go is an "officially" supported language, meaning there is a dedicated team to maintain tooling around the Go ecosystem, sweep for security issues,
keep "runtimes" (in this case the compiler and binaries) up to date.

> But instead it says that Google documentation "does not teach you how to fish" and "you're not sure how to proceed" and at the same time Go somehow gets away with it - "At least with the Go libraries it's feasible to read the entire source code and flesh out things on the edge of documentation".

If documentation is going to be equally bad either ways ( that's something I've resigned with), then all else being equal the library implementation which is easier to read would be preferred.

That said, Go being idiomatic also means generated documentation is more standardized. Java has JavaDoc, but that's not enforced or culturally as consistent as Go.
A massive improvement that would redeem one of the dumbest characters in the series, to the point where you just have to believe it is true?
Definitely don’t have to. It’s an anecdote from a single person, it’s not normal behavior.

Don’t read too much into individual HN comments, especially those describing outlier behavior.
Try learning Rust, then you reach this point

https://stackoverflow.com/questions/39558633/higher-rank-lif...

I still don't understand what higher rank lifetime bound means and this affects whether I can write code that actually compiles
Excellent execution in the payments space and expanding beyond that to support business infrastructure and development through things like Treasury and Atlas etc.

Not sure that qualifies as a monopoly, but in general Stripe is an example of one (so far).
I'm reluctant to get too into it as it's a downvote magnet. This reply already should be legitimately downvoted just for being OT. Yes, they offer a magnificent service. Best of class or nearly so, for all their offerings and a decent free tier to get the mindshare. But: they want to dip their beak into all internet traffic. The power that comes with such concentration is impossible not to corrupt.

What efforts against censorship? Like how they (actively) cancelled 8chan and Daily Stormer?

I won't go into anti-surveillance much because it's too contentious. Very few recognize or want to acknowledge the downsides of 1.1.1.1.

I honestly don't want to get into it more than that in part because I've forgotten more than I used to know about their various business practices. (I used to work near to this space.) I have a vague idea that they have made centralized (power concentrating) choices in some cases, where they could have made decentralized choices, but I can't recall specific products ATM and, well, I'm only willing to invest so much time in this post. By their literal mission "to build a better internet", we can see from those choices that better is in the eye of the beholder. Just as evil has always been as defined by Google.

I don't mean that Cloudflare is willfully evil. At the time that I was intensely interested in them and formed this opinion I could find no evidence of willfulness, and their products and their operations have all the good protections. But they do get to define 'better' in their own image and in favor of their own interests.

I'm sorry to be so vague.
A friend of mine managed to get 350Mbs symmetric fiber for $40/month. It seems to be actually delivering those speeds. He's going to wait a while before fulling committing to it, and canceling Comcast, of course.
> Usually, this should not take more than a month.

This tells me that there are people involved in manually packaging it up somehow.
Reminds me of the dogs the Russians trained to deliver bombs to the Germans. However, in the chaos of war, the dogs would get scared and run back to the owners with the bomb, killing the Russians.
The way I see it: in both cases, people with decision-making power made decisions, in keeping with established precedent and aiming for a desired outcome. Also in both cases, a minority of those not involved in the decision-making process have raised bad-faith arguments and managed to convince the rest of the world that there is a controversy in how the decisions were made and carried out, and that the decision-making power should never have been delegated in the first place.
I guess this is a better place than any to mention the King Crimson song "The Night Watch", which remarks on the painting and its imagined context.

https://www.youtube.com/watch?v=-qCXHghedxw
https://github.com/sublimelsp/LSP with https://github.com/sublimelsp/LSP-typescript works pretty well for me. They are also both being actively maintained. It'd be nice if it was built-in, but it works well enough that I still have not found a compelling reason to switch to VSCode.

I really love sublime and it doesn't seem to be dead just yet. Sublime Text 4 was also a pretty great release.
It depends on what you are doing. Legal research and writing can be anywhere from kind of dull to fascinating. That's also true for pretty much any job, so I'm not sure what your point is.
I can’t speak for TASM, but I learned 6502 ASM for my senior project. It can be daunting, and for me the trickiest part was reducing down to what I wanted to do. I suspect it’s more complicated for larger addresses and more features, but still it’s ANDing, ORing, and simple math. You’ll get it.
717 Gigapicels?

They should have titled this installation Rambrandt

I'll, erm, show myself out.
God of War Performance on Linux
> The OP's Stripe commentary might be over the top, but YC has yet to produce a mature response to any of these friction points.

How could they produce the mature response you’re looking for when the accusations are full of holes. Lyft isn’t a YC company and didn’t use Stripe initially as he claims.
The only “Proof” (his words) posted is incorrect: Stripe posted their blog post before he posted his.

He has produced no real evidence for his claims. The evidence he has tried to produce is trivial to check and works against his claims.

How should YC respond to this?
I created something very similar. It is a PNG and bootable x86 MBR polyglot. When executed, it rewrites the PNG's image data, to convey the program's output.

https://twitter.com/OverTheWireCTF/status/146574242275182182...

Someone who solved the challenge did a writeup:

https://joe.lothan.net/ctfs/2021-advent-otw/00-warmup/
Then they are quite bad developers, because that is exactly what a team of ours did in a two day hackacton.

Some learned C++ on the Arduino, some went with TypeScript and Angular, others with JavaScript and AWS Lambdas, together we got a robot arm to pick and drop pieces with a Web dashboard and remote control, talking with each other via the "cloud".

Naturally all of them had several years of coding experience, but in other languages.
Very effective, but quickly diminishing returns for me. If I do one pill a week, that day is awesome. But as soon as I step it up to 2 I'm overwhelmed and might even take a nap I wouldn't have otherwise. This is only 100mg.

But the reason I stopped taking it is that I'm just a salaried employee. It doesn't matter if I'm super focused or not. I'm still getting paid the same amount. There's no point in artificially elevating myself.
I'm always a bit put off by the "experts can't tell the difference between these two things!", in this case red and white wine. On closer inspection one usually finds an element of deception, here the white wine is coloured red and then experts describe it as a red on tasting.

This makes sense from a Bayesian point if view... What are the experts priors? What's more likely? That their nose is off today or someone is trying to decieve them by dying white wine red? I would guess it's the former. There must be a large publication bias is well, "experts can differentiate white from red wine" is hardly going to get much attention.

To make this a fair trial I think you need to blindfold them rather than "trick" them.
I do not know how this book is, but if you are looking to learn Probability by yourself, a great resource is- Introduction to Probability by Dimitri Bertsekas and John TTsitsiklis.

I highly recommend it.
Reminds me of this poem I came across in a computer magazine a long while ago.

https://spot.colorado.edu/~sniderc/poetry/wakawaka.html
I learned F# before ever touching Nix. And it's not the functional nature that's the issue, rather the terse syntax, sparse documentation of plenty of special functions you need, and so on that make it an issue.

It's hard to find out how to do things, and often you find two examples with a partial solution that each use a very different incompatible way to get there.

I think the core idea of Nix is good, but we need a decent programming language designer to have a go at a new language for packaging.