skysight-inc/HackerNews huggingface dataset:
I built Supr Analyst, a natural language to SQL analytics interface. It combines LLM-powered query generation (OpenAI + Claude) with database schema understanding and user-defined metrics for accurate data exploration.

Technical stack:
- FastAPI backend for API endpoints and query processing
- Next.js + Shadcn/UI for a responsive frontend
- PostgreSQL for storing metadata and user configurations
- Custom prompt engineering to handle complex SQL generation
- Table relationship management through foreign key detection and custom mappings

Key features I implemented:
- AI-generated table and column metadata to improve query context
- User-defined example queries that act as few-shot learning examples
- Custom metric definitions that help generate accurate aggregations
- Query validation layer to prevent unsafe operations
- Support for MySQL, Postgres, and Snowflake connections
- Interactive "Try Chat" with sample dataset to test natural language queries
- SQL Playground for trying complex queries and understanding the query generation

You can try it live here with sample dataset:
Chat: https://supranalyst.com/try-supr-analyst/chat
Playground: https://supranalyst.com/try-supr-analyst/playground

Currently in private beta with people. Would appreciate feedback on the approach and UX.
It’s a joke because most American schools are run by the government.
In my experience, people who use the term "virtue signalling" don't understand the problems that the supposed virtue signalers are trying to solve and simply use the term as a cheap dismissal of their policies. If the policies are bad, explain why they're bad. Don't just say that people putting the 10 Commandments in schools are virtue signalling.
it is not a teardown we are talking about. But rather giving attention. Give certain students more attention and that takes away equal attention from everyone else.

if you gave attention to two kids, one was smart and quick, and the other was slow and stiff, who would you help more?
Imagine you have a program where there are 4 options, W, X, Y, Z. Y and Z can't be set at the same time, and X can't be set unless W is set. If Y is set then X must be set as well.

How do you represent this in a way that makes it impossible, even through programmer error elsewhere in the program, to have the flags in an invalid state?

You can create en enum that looks like:

enum program_state =
(
W_X_Y_NZ,
W_NX_NY_Z,
NW_NX_NY_Z,
... and so on
);
> As in gifted and talented individuals who form a community, or all these folks from this ethnic background you think are talented? Because if it's the former then I'm surprised they've got a community going

"A recent analysis in Nature caused a stir by pointing out that the vast majority of Nobel Prize winners belong to the same academic family. Of 736 researchers who have won the Big Recognition, 702 group together into one huge connected academic lineage (with lineage broadly defined as when one scientist “mentors” another, usually in the form of being their PhD advisor)."

> getting the calipers out and go measure some skulls

Please, just stop.

[0]: Yes, scientific progress depends on like a thousand people https://www.theintrinsicperspective.com/p/yes-scientific-pro...

[1]: How to win a Nobel prize https://www.nature.com/immersive/d41586-024-02897-2/index.ht...
If parts are aligned on a 1024-byte boundary and you know each part's start offset, it should be possible to use the internals of a BLAKE3 tree to get the final hash of all the parts together even as they're uploaded separately. https://github.com/C2SP/C2SP/blob/main/BLAKE3.md#13-tree-has...

Edit: This is actually already implemented in the Bao project which exploits the structure of the BLAKE3 merkle tree structure to offer cool features like streaming verification and verifying slices of a file as I described above: https://github.com/oconnor663/bao#verifying-slices
It's hard not to giggle when the conclusion right after "Smart constructors" says "Do these ideas belong only in functional programming? While they are practiced more there...".

Ah yes, because using constructors to ensure that new objects are in a valid state is virtually unheard of in object-oriented programming.
> 'I am obscenely rich and would like to show off' crowd.

The usual joke is "for dentists who want to take some family snapshots" (which is a slur at dentists, not at Leica. I've used two of their cameras, the Q and the SL2, and both are very pleasant experiences).
Functionally talented and gifted students autodidact to their interests which is a much better outcome than institutionalized bullshit schooling. I deeply disagree with your assessment that institutional learning is some universal booster for smart people and shows your own personal bias. So in balance of your position: I think it grinds down a students willpower and spirit to be placed on a pedestal to be given more resources than other kids. I’m willing to meet in the middle and say either system is equally depressive of students for learning in a way that leads to benefits for society.
Just a fun aside: Islam is responsible for the foundations of algebra and the al in algorithm is of the same Arabic root.

I'm not an Imam but I feel like if someone wanted to justify using a Western created algorithm they could just say "well technically this is just built on our initial work"
how long ago you were a junior engineer?

I suspect it was possible because availability/performance requirements were different.

also-I think your defined problem is partially caused by developers themselves: if you give them simple (even if it is challenging) project, they get bored and start creating problems themselves to make project "worthy" of their time
Uh no. Pretty much every single backup camera on every single vehicle is the exact same little module that produces analog video and literally just runs a component cable to the head unit which has a standardized analog video input.

Zero software required.
I think that's not the issue, the issue it's the mandatory karma based sorting.

In Usenet you had threads as in Slashdot/Reddit, but on scoring you were on your own tastes.
From what I could grasp of the official text, there seems to be more conditions.

Apple must make the decision made by Cade public in their website, and also inform all iOS developers affected.

The law which was used (L12529) also allows more aggressive fines (let's say 43.000 per day per iOS developer), or even suspension of services. But these were not mentioned in the decision.
It's always been ironic that a book about not caring what other people think needs to censor the word "fuck" in its very title.
I just kinda doubt they ran a banking startup without ever consulting a lawyer or an accountant.

Why do you find this hard to believe? I find it hilariously easy to believe.
Is it possible to generate an SQLite DB from the site data and statically serve it, so sql.js can use it as a DB to provide something like search?
Gifted and talented communities are all the persons who meet a criteria to join said community. In children this is often scoring beyond grade-level in tests.
> Taking resources away from those who move society forward and spending them on those who are unlikely to "pay it back" is a way your culture dies.

What does this even mean?

To me, the measure of a healthy society is how that society treats those that are "unlikely to pay it back". The most unhealthy societies treat unwanted humans as disposable refuse. For example, I don't think we'd call the culture/society of the 1900s US particularly healthy. Yet that was probably the peak of the US keeping resources in the hands of "those who move society forward" the robber barons and monopolists. We didn't think anything of working to death unwanted 5 year olds that were unlikely to make a positive impact on society.

As for "dying culture" that to me is a very different thing from society. Societies can have multiple cultures present and healthy societies tolerate multiple cultures.

> Conquerers in the past used this strategy to win massive empires for themselves.

Which conquerers? I can think of no historical example where a conquerer somehow convinced a target to take care of their needy so they could conquer.

> This is perhaps the sole political topic I will die on a hill for.

I'm really interested in the foundation of these beliefs. What are the specific historical examples you are thinking of when you make these statements? Or is it mostly current events that you consider?
You're unfortunately right. Every Scala codebase I have seen recently is essentially legacy. New services are not built with it anymore. Other than blaming SBT and the Haskel fans I'm not aware of a technical justification. But the industry/community has shifted since 2015-2018.

The only rare exceptions I heard of were strict FP shops who share nothing with common JVM-based development. You could have a few years of full-time Scala experience with Akka and Spark and they won't even screen you.

In the year of our Lord 2024 the question is if you want to bet on Java21+ catching up with Kotlin or go with Kotlin from day one. The choice is less obvious nowadays. I'd go with a modern language, actual job market sides with Java still. At least on the backend in the Bay Area.

As a side note, I cannot imagine a competent JVM-based developer not familiar with either Kotlin or Scala by now. In a typical Java shop half of the team is dying to switch to one of them in my experience.
I don't agree. It's an interesting historical story, and historical material has always been welcome on HN. There's much to be intellectually curious about there, and no need to be provoked onto an ideological track.

For those who do feel provoked, the appropriate response is (1) not to comment, and (2) to look elsewhere for things that do gratify your intellectual curiosity. There are 29 other threads on the front page, and hundreds more within one click.
Why now? These concerns have been being raised for decades.
This is me being a 100% armchair physicist, but I'd theorize it'd be something like trying to iluminate a room with a flashlight vs pointing it to a white (diffusive?) surface, counter intutively you achieve better* ilumination with the aditional diffusive surface

* Better for say, photography
Absolutely WILD response. Its easy to was the dirt off a fruit or vegetable. Drinking raw milk is like eating fruit or vegetable with feces on it still.
it was never alive to begin with. certainly not in the real world.
There's a counterpoint to consider: my son refused to do the work necessary to get above a B+ or A-. Every now and then he'd screw up and get a solid A. His reasoning? The extra bit of work needed to get the A was effort he could put elsewhere, and it doesn't change your college prospects much anyway.

Now, he lettered in sports, had multiple hobbies and all that good stuff. He now has a Ph.D. and works for the Department of Energy. He is a master of time management.

The big thing is to understand your kids' goals, discuss how realistic their goals are, and how what they're doing is in alignment with their achieving those goals. You can have those discussions as early as middle school. The other thing to realize is your kid will be much better off if you start discussing work/life balance now. Straight A's aren't everything.
In Java you have to set max heap somehow - either ergonomics or just -Xmx command line option. Max heap is given (many a reason, and it sets before running the main method), so if you pick under the 32GB it'd auto use compressed pointers (optimize for size - optimize for speed). That option (compressed pointers) can be switched off, of course, via a command line option as well.
Based on my general experience with S3, they jettisoned A years ago (or maybe never had it).
At 5000 companies this is a little like saying that investors should avoid the S&P 500 because it includes both Coke and Pepsi.
If you’re building something front scratch, the architecture/modeling/abstraction work is done first. This sounds like a scaling issue, and a simpler one at that. As for harder problems, we’ve had to rearchitect parts of our software several times as it scaled.

So yea, I can understand why you’d find this kind of work annoying, but in my experience it’s mixed in with more traditional harder problems.
Not all that counts can be counted.
Not all that can be counted counts.

I hate Agile and I'm not going to try and sugar coat that. "We're drowning under the weight of clueless product leads, managers, and owners who've never written a line of code" That's why this still exists though not performant, because it some peoples entire entire careers now.
I got this one when it was on sale for about $135:

https://a.co/d/7XSrYmL

Looking back, the SSD was garbage so I ended up using my own nvme. But it’s a little solid piece. It came with some windows but I just put Debian on it.

The price is not that much higher than pi with all the accessories and give you multiples of performance
The only reason he wants physical assets is to achieve his objective. Russia is one of the richest nations on earth in terms of natural resources, and Ukrainian land can't add much to that. It's only worth is to show the West that they can't stop him and destroy the belief in the USA/EU/NATO/Democracy.

Ukraine was a zero threat to him, but the ideals of the West were his destruction.
We just ejected from Seattle Public Schools for this reason. My daughter, as a gifted student, was basically ignored by her teachers for the last 3 years because she was smart, and therefore they didn't have to worry about her. But, by ignoring her, she atrophied. Her standardized testing scores dropped every year. She no longer cared about learning. It truly is a regression to the mean.
Why?

It costs a lot more to build a new school or maintain an existing one in The Bay than in Fresno.

It also costs more for teachers since the cost of living is so much higher.
The relevant comparison is the energy needed to turn asteroids into food vs. the energy needed to turn exhaled CO2 and poop back into food. Astronauts live in closed ecosystems, so you don't need to bring in additional mass. Just close the cycle.
If you do merit based acceptance into programs then obviously it will have a different demographic makeup than population at large. We can discuss the causes of this elsewhere, but obviously test/school performance varies significantly by ethnicity today in the US.
It isn't that unreasonable to ask for an education system that pushes kids as fast as the kid keeps up with and eases them back if they regress

Surely you can see the damage this would do to the majority of children currently being told they are "gifted"?

Being "gifted" until the 6th, 7th, or 8th grade would psychologically cripple a lot of these kids through high school. It's better to not allow that "advanced but not gifted" demographic in from the outset, than it is to unceremoniously boot them at some arbitrary time in the future if they fail to keep up with those at the extremes.

The better ideas are the remediation, normal, advanced and then gifted classifications. And you don't get the gifted label unless you are on the extreme of exceptional.
Beautiful, nice work, I bet that was fun!
In many (but not all) scenarios "Make illegal states unrepresentable" is way too expensive to implement.

Especially when dealing with a fast changing domain, having to support different versions of data shapes across long time periods: dynamic data definitions are more economic and will still provide sufficient runtime protection.

"Errors as values" - what is an error? I see this pattern misused often, because not enough thought was put into the definition of an error.

"Disk is Full" vs. "data input violates some business rule" are two very - very - different things and should be treated differently. Exceptions are the right abstraction in the first case. It's not in the second case.

"Functional core, imperative shell" - 100% agreement here.
I happen to fall into the same group as the previous poster who is a voice actor.

I know you did this as a challenge for fun but in fairness you should keep those challenges to yourself and not publicize them when the technologies involved are a pandora's box or ethically dubious.

I find it really hard to think of a single plausible use for this type of technology that is beneficial.

Nearly all uses directly or indirectly cause harm except maybe as voice restoration (for someone mimicking their own voice, whose vocal cords were damaged), and that would only help a limited number of people in these situations.

Used in lieu of voice actors, the demand for jobs in that sector go to zero collapsing the economic cycle/market eventually (non-market socialism->failure).

Same thing for any type of acting really, where it may violate their publicity or other rights.

Then there's the extreme where people use this technology to ransom victims in faux kidnappings.

If you created a public facing website for this, I hope you ran it by a lawyer and have an ironclad liability waiver (which I'm not sure any waiver's actually exist in this area of law that would be sufficiently defensible). Inevitably at some point there is always the question of negligence that comes up after harms have been done.

You don't want to be named in criminal lawsuits as a co-conspirator or otherwise, when your service/application is used by criminals to commit crimes.

The juice isn't worth the squeeze imo.
It's not that the teacher were racist. It's that the tests or indicators used to identify individuals as gifted were not evaluated well enough for bias. It's not overt racism. It's stuff like rich parents hiring tutors and the rich parents being more likely to be white (I would argue that implicit racism isn’t racism as it lacks intent, but is still a harmful bias to be eliminated). This goes back to their comment on high achievers getting into the program vs the inherently gifted. Another example is IQ tests administered in English to students who have English as a second language. Even stuff like parents training their kids for the format of the IQ test questions provides and advantage.

The problem I have with a lot of the stuff related to gifted learning is how it's structured and gate kept. In a public school, there should not be a limited number of seats for an academic program. Any student who can perform in that program should be allowed to participate, not just the top 10% or whatever. I think it should be measured on their current academic performance, not some IQ test or teacher recommendations. If you're consistently getting As in the regular course, you should be eligible to try the accelerated program. You may get more out of the accelerated program even if your grade drops from As to Bs. It also seems that many programs are all or nothing - either you're in the gifted program for all subjects or none at all. Being advanced in one or two subjects and in the regular classes for the others should be fine. It seems this is at least picking up more popularity in the past decade or two.
> Simplified: the central bank decide on an interest rate that they want to see.

This is incorrect.

Using the US central bank example, the Fed has a target for inflation. It uses interest rates to try and hit that target. If inflation is higher than 3% the Fed will raise rates to cool the economy.

The Fed sets interest rates directly because lending money to the Fed is viewed as "risk-free" (as the US government has never defaulted on a debt). So if the Fed offers a risk-free 4%, banks will need to offer more because they are not risk-free. So banks no longer really lend savings out for loans. They borrow money and lend it out at a higher rate (eg mortgage-backed securities).

So when you could get a mortgage at 2.5%, it was because the Fed was offering 0%. When the Fed offers 5%, mortgage rates will go up to 7-8%.

There is another mechanism that the government could use to control inflation: fiscal policy, specifically taxation. A criticism of monetary policy to control inflation is that it's indiscriminate. People will go out of business and lose their houses. Taxes only target profits.

So in 2021-2022, we should've just passed a windfall profits tax of 80%. That would've cooled off inflation real quick and given the governments funds to distribute to those most adversely affected. But that will never happen because the corporations and wealthy who own both parties will never stand for wealth redistribution to the poor.

They will however demand wealth be transferred from the government to the rich.
I remember seeing this terminal emulator, deciding to give it a shot to see what the deal is, and being asked to sign in. I have never uninstalled a program faster in my life.

I think I'll just stick to iTerm.
It makes sense, though. Google doesn't want to send business to a competitor - that's giving them a leg up on you.

While the EU may punish Google, it shouldn't expect them to like it.
The fact that they even required a login in the first place is crazy for a terminal. I doubt this is going to convert users that previously didn't use Warp because it required a login.
Denmark does not have to stand alone thanks to the EU.
bind keys please!
I think thats the major issue I have with Gradle in large orgs: it doesn't lend itself to reuse, but I don't blame it either: it's not really meant to do that.

I'm dating myself, but 20 years ago, we had Ant. It was very much a blunt hammer like CMake. Maven came along and was like "how about we choose a definitive way to organize projects, make that repeatable". You lose flexibility but gain speed/reuse.

I see Gradle more of a replacement for Ant than Maven in this regard. Infinite flexibility, at the cost of speed/reuse.
A better way to search across Gitlab projects
With x32 the limit would be 4GB which is on the low side of things. Having 8byte alignment (i.e. last 3 bits zero), allows for 32GB - which is better.
I am assuming that in OP's case, they want their go process to "see" the machine as it is though, to surface more accurate/better stats?

Interesting link nonetheless, thanks!
Spoiler alert: it's "easy" when you narrow down to applications who come from wealth and/or went to a prestigious university.
The translation software isn't a person. It will necessarily take liberty with the source material, possibly even in a non-deterministic fashion, to translate it. Why would it be any different from a LLM as a tool in our definition of plagiarism?

If I used a Markov Chain (arguably a very early predecessor to today's models) trained on relevant data to write the passage, would that be any different? What about a RNN? What would you qualify as the threshold we need to cross for the tool to not be to be plagiarism?
For Firefox I have my own little extension that just loads a HTML page with more or less the same as what you're describing. I presume you can also do that with Chrome, but I don't use it so idk.

I don't really get why this isn't just a setting, but ah well. There are some extensions that do this out there, but I found all behaved wonky. I'm not sure if they're "doing it wrong" or because I have it easier as I don't need any settings and can just load a static HTML file. I'm not an expert on any of this.

For those interested, in manifest.json I have:

{
"manifest_version": 2,
"name": "newtab",
"description": "newtab",
"version": "0.5",
"browser_specific_settings": {"gecko": {"id": "XXX@XXX.XXX"}},

"chrome_url_overrides": {"newtab": "newtab.html"},
"permissions": ["clipboardRead"]
}

And then in newtab.html you can just put anything. It has the clipboardRead permission for some JS code I have to add a "go" button if the clipboard contains an URL