skysight-inc/HackerNews huggingface dataset:
Well that would be very, very cool.
Who’s doing the IDverify startup?
Kind of. dplyr, Pandas, LINQ, Kusto, etc... are big inspirations. The fact that these are so popular and have reinvented the same workflows with slightly different syntaxes to me is a sign that they capture something fundamental about how humans like to think about data transformations.

PRQL is indeed very close to dplyr. In my (biased) opinion, PRQL is actually a bit cleaner than dplyr because it is its own language and doesn't have to work as DSL inside R. The same goes for comparisons with Pandas and Polars having to work as DSLs inside Python.

Compare

from mtcars
filter cyl > 6
select {cyl, mpg}
sort {-mpg}

with

mtcars %>%
filter(cyl > 6) %>%
select(cyl, mpg) %>%
arrange(dplyr::desc(mpg))

Incidentally, I produced the dplyr code from the PRQL with

```R
install.packages("prqlr", repos = "https://eitsupi.r-universe.dev", lib="~/.local/R_libs/")
library(prqlr, lib.loc="~/.local/R_libs/")
library("tidyquery")
"
from mtcars
filter cyl > 6
select {cyl, mpg}
sort {-mpg}
" |> prql_to_sql() |> tidyquery::show_dplyr()
```

(Disclaimer: I'm a PRQL contributor.)
HN is also violently against social events at a company and the idea of social interaction.

Hate to break it to HN, but the most successful engineers I've met in the biz are also very empathetic and enjoyable to be around. This HN stereotype that you have to be an low-EQ, frustrated incel to work on software is incorrect in my reality. Just look at the top coders who are living (Linus, Guido, Hashimoto) and you will notice that they are very teamwork oriented people.
Come to think of it, I think there is a community fork. It’s also used by the Wikimedia Foundation, so I might look at whether they are/could push changes to their own fork upstream.
> if the vast majority of Google's earnings are in dollars

They aren't.
npm and pip is a dumpster fire for IT production environment security. The out-of-band ecosystems evolved to sidestep bureaucratic processes in favor of rapid release versioning.

Anyone who understands the auditing role and provable chain of accountability FOSS OS packagers volunteer for... knows why it was necessary.

Malware will always show up, but it is arguably more important to be able to hold sources accountable. =)
It's easy to close your eyes to politics when you have the capital to cushion you from them.
The punchline is the temperature was originally presumed to be Kelvin.
That may be true, but I think the internal company forums are generally not very junior.
> what a firing offense was: Getting caught having sex on the company campus with a coworker.

If both/all people are consenting, that might be slightly tacky, but surely shouldn't be a fireable offense.
Can you feed in font-start and font-end as tokens so the AI can learn to cluster Comic Sans resumes and white-font skills sections as signals to pay attention to?
`
package foo;

public class Hello {

public static void main(String[] args){

System.out.println("hi world"); } }
`

#As for the build and run,

javac foo/Hello.java

java foo.Hello

---

Structure

You need: a package*, a class*, and a main method*

3

Code

The package needs to match the folder* : 1

The class needs to be public* and match* the file name; Main method needs public* and static* and take an array of String args*; you need to remember the call to output to console* : 6

Build and Run

Have to remember javac* and java* : 2

javac and java have to be available when you call them

0 - 10 [10 if you have corporate IT managed machine] (I'll call this 1)

Remember where to put the package for each call : 2

---

So I only got 15. I could have probably got more if I tried. Just because each of those 15 things is trivial by itself, does not mean you can ignore them.

I got to do 'the algorithm game' with middle-schoolers. I was the "Peanut Butter and Jelly Sandwich Robot". I took their instructions literally. It was a hoot. It's less fun when the computer isn't trying to help you.
Apple Silicon Macs might not have great GPUs but they do have unified memory. I need to try this on mine I have 96GB of RAM on my M2 Max.
I've used Arc probably 90% of the time for the past two months. One thing that I haven't seen mentioned anywhere (even in their literature): it's very lightweight on memory usage.

I've noticed recently that Safari uses 1/3 to 2/3 of a gigabyte for each youtube tab, or gmail, or <many other sites>.

Arc uses roughly 25% of that.

Also, Arc's efficiency as tabs build up seems to grow faster than Safari's although that's harder to quantify. But in concrete terms, Safari puts my M1 Air's memory into the yellow in activity monitor almost immediately. Arc regularly stays green with 20-30 tabs open.

There are other nice things to consider, but that's huge for me.
A friend was doing VSO and got posted to an orphanage in Ulaanbaatar, hence the adventure. I took the trans siberian there and stayed for 3 weeks. Good times.

https://www.vsointernational.org/
The type of websites requiring advanced anti-abuse tactics currently make heavy use of fingerprinting techniques. Google's idea that fingerprinting will cease to exist if this is implemented is a joke.
I agree with you. I, too, as too knee-jerk here. Thanks for spelling it out!
Big keyboard is keeping DVORAK down!
In a fair world we’d all be typing NewQL faster with AI from our flying electric cars in a communist utopia.
Thanks for the kind words. There are many things like grouping listicles you can do to improve search experience, once the incentives are aligned.

Unlimited for $10 is something we are working towards.
Try Palemoon - it is a decent multi-platform hard fork of Firefox with better privacy preserving options.
Also have in mind that there are "Seniors" and "Seniors". 200K is a normal salary for a true Senior in a company that is either tech-focused or very reliant on tech.

Companies outside the tech hubs, or companies where custom tech only provides incremental value to their business, will certainly pay less, and salaries closer to 100K are actually not that uncommon. They often don't even have the ability to accurately evaluate the skill set of a Senior Software Engineer. So what you call Senior and what they call Senior isn't the same thing.

I'm not saying that you should accept 100K, simply that the market is very diverse and we are past the excesses of the past.
Most fat people know they are fat, and know that "fixing" it means eating less and exercising more. Why waste what precious moments you can afford to see your doctor with talk that you both know is unproductive? Until doctors develop better strategies around helping someone manage their problematic relationship with food, which is better handled by therapy, fat people don't benefit from a yearly reminder that they are fat and unhealthy.
It's like fundamental best practice to always wash your hands thoroughly with soap if you handle leaded solder.

You might want to read more in the links I shared about the harmful effects of lead before "whatabouting" to other problems of electronics recycling/waste.

and yes, it's entirely possible this application would get an exemption from usual restrictions on lead. For example in the EU directive, one of the exemptions is:

> Lead in solders for servers, storage and storage array systems, network infrastructure equipment for switching, signalling, transmission, and network management for telecommunications
Not all stock holders will be part of the lawsuit, and some non stock holders (say people who have already sold) can be part of the lawsuit. There can also be people who claim second and third degree damages without actually holding any stock. And there is no rule that compensation has to be in proportion to anyone's holdings. All of this will be up to the court to decide.
The question is who 'pioneered' it, not who 'popularized' it.
You can but what you’ll end up trading precise answers while querying to a chance of hallucinations.
This is a cool pod! Any other security / applied cryptography ones you or folks can recommend?
Nobody is saying these things are binary events. But betting that you're going to more accurately guess the odds of these events than dedicated players with enormous sums of money behind them and who are supported by professional research teams is… maybe not a strategy with positive expected value.
Congrats on the launch!

I have an interesting dissonance with this. On one hand, I understand how huge parameter sets can and do model specific personas well. I've also read some of these cited papers and _know_ intellectually that predicted results can be close to actual survey data. The other part of me is screaming at my laptop that language modeling is about aggregate statistics, revealed preference counts for a lot, and how could a language model actually substitute for market research?

I imagine the biggest hurtle you're going to face are research teams that:

- A. Want to see actual proof behind data

- B. Disbelieve a LLM could generate statistically significant insights about real people that would make individual decisions

- C. Need to justify their own existence / organizational clout with boots on the ground facilitating surveys

A and C might be surmountable, but I'm not sure of a good way of tackling B.
With room temperature superconductivity doesn't it become possible to turn the magnet on and off far more easily? MRIs would be much safer if they were only energized during the actual imaging process.
The American courts really do try to get stuff right, not bully random foreigners for no reason.
Yes, upto 102F ... 38.9C for the rest of the world
his is an old SEO trick (white font, tiny font, font in background color, transparent font, etc.. Worked a while until Google adjusted their algo and this "weird trick" got a penalty.
Some problems are not solvable in software. They are emergent human behavioral issues that are not obvious until larger scales are reached. When you reach scale you have issues with threat actors at different levels. One is the platform operator itself, scale costs money to run and exploiting human weakness is one way to pay for the operation. Others would be scammers/spammers in a system. Then you have the users in the system that can be threats to each other.

There is no easy time for anyone to provide solutions to these problems and it's possible there are not solutions at particular larger scales.
Unmoving copper also neither repels or attracts a magnet.
Eddy currents impede movement of non ferrous metals in a static magnetic field. This looks like slow motion falling or resistance to spinning when the metal is in a fixed field.
This is how auto belays work.

If you move the magnet, the metal will also move since you're inducing a current and the fields from the eddy currents will react against the moving magnet.
Thanks for mentioning this - the instructions that I'd found for making cream cheese had suggested essentially making ricotta, and running it through a food processor until creamy. While this did produce some sort of cheese, it wasn't what I was looking for. I did more research and just as you said, Cream cheese starts with a yogurt, drains the whey off and then is pressed. Some approaches combine yogurt (made with Milk) and sour cream. Anyway, it's obviously a complex and broad topic. You've gotten me pointed in the right(er) direction.
Hopefully they don't cause solar system wide loss of consciousness events.
Probably got demolished and turned into a bank or a Verizon store.
Indeed, f* medium, how did they get to be gatekeepers to so much of everyone's content anyway?

I did register (free), and am now paywalled to upgrade to read almost anything on there - it would be ok if it was just 'paid content' where the authors are getting paid, but it seems to be way beyond that.
unfortunately the reality is that our rights get removed while the big guys get to continue doing as they please
On a single unbounded (CPU + mem) Debezium running on a VM extracting Postgres, I was able to clock in about 7-10m/hr. You could increase the # of tasks, but then it'll hinder your DB perf. Also, this is on your primary DB.

We found it far more efficient and less risky to do CDC streaming and snapshotting w/o read lock in parallel to two different topics. Once snapshot is done and drained, we then move to drain the CDC topic.
Another interesting point about this is that he talks about how it’s mathematically probable that the clinical trial has the power of the larger sample size
Pirsch analytics is a great one https://github.com/pirsch-analytics/pirsch
Oh, I'm a big fan of raw SQL, too. There's very little out there that can bring me same joy as a well-written 30-50 lines-long sql query! Like, I can spend an hour or two on it, but when it runs and produces the results in the desired form, it's sooo rewarding! And realizing that producing similar results in my main language (be it Rust or TypeScript, or whatever) would take me 3-4 days instead (and it would run much longer) makes me appreciate SQL programming more and more. In terms of "usefulness per minute spend" nothing comes close to SQL!

However, the syntax can be a bit clunky from time to time. I'm very fortunate that I use Postgres only in the past 5-7 years, so CTEs, and things like Timescale or JSONB, or PlV8 / PlRust for stored procedures are often on the menu. Yet, simple things still require repeating fragments of code from time to time, and complex grouping or window functions code often looks too convoluted.

And as I wrote in my GP comment: I (and many other developers) already use pipelines for data manipulation in code - beyond databases. Say, we got data from an API endpoint, or we mixing data from several data sources. SQL is familiar because I see it often, PRQL is familiar because I use similar pipelining concepts often in my no-SQL code. Would I use PRQL for super simple queries? Probably not. Would I be upset if one of my coworkers used it for simple queries? No, why would I? Would I try implementing complex reporting query using PRQL? Yeah, I would. Partially because I suspect I would get to my data in desired form quicker with pipelines, and partially because I know: if I get stuck I would convert my intermediary query to SQL and pick up from there.

For me PRQL looks better then most DSLs for ORMs or Query Builders in most languages. Adding a new tool to a project may be annoying, but depending on a project I'd rather pay this price once if it makes my less SQL-savvy team mates more comfortable. "Yet another syntax" is obviously the main point against, but from the application developer perspective ORMs / Query Builders often force one to learn "yet another syntax" anyway. "Don't use ORM / Builder" is an often voiced opinion and yet in practice we work with them all the time, too.

So, I view PRQL not as an alternative to SQL but as a third database communication dialect in addition to SQL and my ORM / Query Builder DSLs.
This sounds awesome to deal with. Thanks for the info.
Isn't there? What would you call a bitmapped interactive display?
Managing Jira and tasking out stories and estimating story points drives me insane and I swear sometimes it's like 75% of my day. Everyone loves to brag about how "agile" we are but we'll spend like an hour discussing how we're going to do a task that will be 2 minutes of work.

And then non-developers are shocked/confused when things don't pan out as exactly how they were written on Jira because we were spending all our time trying to guess our way through how to task things out and how long they'll take instead of just doing the work to figure out what needs to be done. And then we have to go back and fix up the Jira board later, causing even more work. It's insane.
Nobody's stopping you from slapping on a compat layer, and ex. Haiku does that, but it's more work than just being unixy to start with.
Most of the big packages have alpine variants yeah
Mildly-topical Terry Pratchett amusement quote, since it involves a society that has overlooked the power of silicon plus the potential of superconductivity:

> Detritus blinked. There was a tinkle of falling ice. Odd things were happening in his skull. Thoughts that normally ambulated sluggishly around his brain were suddenly springing into vibrant, coruscating life. And there seemed to be more and more of them.

> 'My goodness,' he said, to no-one in particular.

> This was a sufficiently un-troll-like comment that even Cuddy, whose extremities were already going numb, stared at him.

> 'I do believe,' said Detritus, 'that I am genuinely cogitating. How very interesting!'

> 'What do you mean?'

> More ice cascaded off Detritus as he rubbed his head.

> 'Of course!' he said, holding up a giant finger. 'Superconductivity!'

> 'Wha'?'

> 'You see? Brain of impure silicon. Problem of heat dissipation. Daytime temperature too hot, processing speed slows down, weather gets hotter, brain stops completely, trolls turn to stone until nightfall, ie, colder-temperature,however,lowertemperatureenough,brain operatesfasterand—'

> [...] Detritus sat down again. Life was so simple, when you really thought about it. And he was really thinking. He was seventy-six per cent sure he was going to get at least seven degrees colder.

-- Men At Arms by Terry Pratchett
Nice story! Sounds like the more advanced version of the "my 4x-labeled cupholder is broken" story of the nineties.

In fact the nurse gave a quite accurate description of events i might add.
Netflix is paying much closer to 2x on the cash side than 10x, let alone 20x.

https://www.levels.fyi/companies/netflix/salaries/software-e...
Saw that video. Seems like an awesome effort! It's on my list of fun things things to do on a rainy summer day, this summer.
The joke is, the second person heard 127 degrees, assumed that was Kelvin, and dismissed it as unimpressive. Then they realized it was 127 degrees Celsius, which is MUCH more impressive.
Idiot question: if I have access to sentence-by-sentence professionally-translated text of foreign-language-to-English in gigantic quantities, and I fed the originals as prompts and the translations as completions...

... would I be likely to get anything useful if I then fed it new prompts in a similar style? Or would it just generate gibberish?
How did they find you an pitch the project to you?

You mentioned that the project required some rather arcane programming knowledge. Could you elaborate on this? What areas of programming did you have to delve into that might be considered out of the ordinary?

Was there any discussion about privacy when you were implementing it?

Were there any features or functionalities that you wanted to implement but couldn't due to technical limitations at the time?
I used to work on a platform at a large financial services firm; it was essentially complete ignorant of anything Unicode with respect to string handling, strings were null-terminated byte streams. The platform had CSV import capability for tabular data, and it had an integrated pivot table capability based on some widgets that had been grafted onto it.

Some of the users in Hong Kong discovered that you could import CSVs with Unicode text (e.g. index compositions with Chinese company names) and they'd display in the pivot table widgets and even be exportable to reports. But only most names. Some names were truncated or turned into garbage, and I was called upon to help debug this.

My first reaction was frank amazement that this "worked" at all: apparently, the path from the dumb CSV import code through to the Unicode-aware pivot table was sufficiently clean that much of the encoded text made it through OK. I can't remember the precise details now but I think the problem turned out to be embedded nulls from UTF-16 encoding and so was completely insoluble without a gut renovation of the platform.
> I'm not convinced Americans pay less in taxes

They do. It's been quantified. There are many states with no income tax.

A 230k salary and corporate health insurance is going to put you ahead of almost every European software shop.

I love Germany and enjoyed my time there, but I choose to work in the states and have the financial security that can only be gained by saving money from a high salary.

Still, I would love to see some friction added to the layoff process in the US. Perhaps larger mandatory severance periods. Make layoffs possible, but not easy.
I never got the full story, but I wager there's more details to the story which would raise your eyebrows.
There seems to be very little support for these SQL challengers despite many people saying SQL sucks and they want a redo. Why is that?

Some guesses:

- There is some popular non-sql query language that has gained lots of momentum that I just dont know about.

- People are more effective with SQL because they know it so no new and especially existing databases will switch. This is definitely true to some extent, but if this is the whole reason then I guess SQL is pretty good since people rely on it to be effective.

- There is support for it but a few key decision makers are to blame (big data or the MYSQL lobbyists)

- People actually dont dislike SQL that much and/or its not that bad and hackernews is not representative

- These query languages look nice but have technical or performance issues compared to SQL
That's A&M for ya, tho.
OK, but the hard part was the "intelligent" part, right? If you have the "intelligent" thing, and you want to get an "intelligent agent", all you have to do at most is wrap it in a shell script that runs the equivalent of an OODA loop, e.g. AutoGPT.

No, not really.

Neither AutoGPT or any similar actually work. And the only justification for expecting them to work the future is same naively extrapolation more of one kind of quality will automatically give a thing more of a correlated quality.

The humming bird building airplanes: "If we continue to increase the capacity of these flying machines, eventually they will have 'super-bird abilities' and at that point they will naturally steal all of nectar..."
Just use a certificate chain. The manufacturer can provide each camera its own private key, signed by the manufacturer.
The trick predated Google, aiming at older, keyword ranking search engines like Inktomi. The advantage of Google was in fact that this never really worked with introduction of PageRank.
32GB should be fine. I went a little overboard and got a new MBP with M2 MAX and 96GB, but the hardware is really best suited at this point to a 30B model. I can and do play around with 65B models, but at that point you're making a fairly big tradeoff in generation speed for an incremental increase in quality.

As a datapoint, I have a 30B model [0] loaded right now and it's using 23.44GB of RAM. Getting around 9 tokens/sec, which is very usable. I also have the 65B version of the same model [1] and it's good for around 3.6 tokens/second, but it uses 44GB of RAM. Not unusably slow, but more often than not I opt for the 30B because it's good enough and a lot faster.

Haven't tried the llama2 70B yet.

[0] https://huggingface.co/TheBloke/upstage-llama-30b-instruct-2...
[1] https://huggingface.co/TheBloke/Upstage-Llama1-65B-Instruct-...
You are moving the goalposts here. The original claim I am responding to is
"A tool that gives incorrect and inconsistent results shouldn’t have any part of a decision making process."

I agree that there are places where we shouldn't put AI and that checking whether something is an LLM or not is one of them. However I think the sentence above takes it way too far and breast cancer screening is a pretty clear example of somewhere we should accept AI even if it can sometimes make mistakes.
I heard about this years ago, I’m surprised employers don’t already have guards against this, AI or not.