skysight-inc/HackerNews huggingface dataset:
Do you think SQL stopped at SQL-92?

Arrays, JSON, CTEs, window functions, booleans, MERGE, temporal tables, regular expressions, foreign tables (aka SQL/MED), etc.

SQL hasn't been sitting still, (though ORMs seem to lead folks to believe it is).

Do you currently write K&R C or modern C (C11 or C17)?

Don't get me wrong, I don't think SQL is perfect. Far from it. But PRQL isn't fixing the defects in SQL I care about. For example in DDL, NOT NULL should be the default rather than nullable. When I declare a column as a foreign key, I shouldn't have to specify the type again when the system already knows what the referenced type is. Then again, PRQL is for querying, not data definition, so it doesn't actually solve my biggest issue at all.

SQL could perhaps be more terse. I agree with a lot of folks that FROM should have been first and SELECT near last. That's pretty uselessly subjective. The argument that it's not composable falls flat for me though. Views, CTEs, foreign tables, set-returning functions, etc. are all forms of composability within SQL. When you think in terms of sets, they all fit quite well together. If you're not thinking in sets, it doesn't belong in the database in my opinion.

The underlying engines themselves have been innovating like gangbusters. Using the same wire protocol, folks can connect to a standard Postgres database, a massive CockroachDB cluster, Supabase, and all points in between without changing a client library. The same is true for MySQL, MariaDB, and PlanetScale.

Time series DB? Just use SQL. Analytics? SQL. Document-oriented data? There's even standard JSON query syntax within SQL.

It works. It doesn't generate huge amounts of CVEs like C has. (DB libraries have the SQL injection attacks, not SQL itself.) And it scales fairly seamlessly from Google Spanner all the way down to embedded SQLite.

But folks assert it's irreparably broken and needs urgent replacement. Having trouble buying it. Perhaps I just haven't seen the right replacement yet. That may indeed be the case. I just don't see PRQL being that replacement. It feels a lot more like a lateral move to me at best, and that's just too disruptive compared to potential benefit.
I don’t think you understand what you’re saying. “A linear combination of non-linear features” is not what people mean when they talk about linear regression. And even if they were, a neural network will do a much better job of generating the non-linear features than you will be hand. So again, it’s logically obvious that a neural network will be capable of performing better than simple linear regression.
110%

'Show HN' comments are always fascinating, and I do like that being negative (without some positivity) usually results in gentle and respectful HN pushback.

No need to pump everyone up all the time, but it's refreshing to see people supporting each other.

And support should be more contingent on effort than excellence. :)
Ha, now I see why I suddenly got it in my youtube recommendations.
This is already done. There are many labs currently looking for "synergistic" combinations of treatments.
Probably not. But some great songs take quite a few listens to gel (this might just be me) and I find if I'm listening to streaming music I am skipping songs and missing out to a certain extent.

Certainly a lot of artists put out albums with a lot of "filler" material, but if I was a new listener trying to pick up (say) David Bowie or Steely Dan or Sufjan Stevens I might miss out on a richer experience by not listening to the whole albums and just skipping to the hits and familiar songs.
Czkawka 7.0 – Krokiet, a new GUI in Slint
Does that mean that you don't get stuff done? Or does it mean that you just decide what to do moment by moment? If it's the latter, then why does having it written out add any more stess?

For me, NOT having stuff planned out is what's stressful and the difference in productivity is noticeable when I have some sort of to-do list/schedule vs. when I just wing it.
Do I have this right?

1. Google is overrun by low quality product reviews and comparisons

2. Google starts to weight highly sites with manual testing

3. All those sites shamelessly lie and say they have manual testing -> back to 1

Isn't this a problem that Pagerank is supposed to solve? Auditing content for quality is basically an intractable problem to scale
From that period I would vote for Jaguar E-type
https://cdn.i-scmp.com/sites/default/files/styles/768x768/pu...
I would argue that the native word size is still 32 bits on x86-64, though. With many instructions, using 64-bit registers needs a segment prefix override. Some RISC architectures do not even have 32-bit zero-extending integer instructions, so for them, 64-bit as the native word size makes sense. On the other hand, I'm not sure if <stdint.h> and uint16_t were invented at the time, and “short short int“ is not valid syntax (even today), so there wasn't an obvious way to denote a 16-bit integer type.
Statistical optimization is a known process; one where we understand every step, and can therefore instruct machines on how to perform it. Cognitive reasoning is still today not understood (in the Von Neumann sense) by anyone.
If I could make a suggestion, try dividing your list into two: a to-do list and a "someday, maybe" list. That's a concept from GTD that helps a lot with peace of mind.
I don't think you understand how invitation trees work, or how Merkel trees work for that matter, if that's what you drew from my comment, which essentially said nearly the opposite. The graph is the shape of a tree due to the patterns of invitation fanning out, but there is no such thing as a branch that has more priority over others in a structural or modeling sense.

The other commenters remark that you ban the entire space below the spammer, is a subjective judgment call they would make if they're the one paying the operate the servers and not wishing to use their time and energy to subsidize someone's desire to abuse the internet. Acting like this is some sort of petty fascist power move is not arguing in good faith, it is actually an attempt to escape an argument that you are failing to understand, by changing the subject from how to deal with a certain kind of common social network pathology, to a completely different name calling argument about someone's imaginary nepotistic motivations. It's probably best that you do excuse yourself from such discussions, even if you feel you need to disguise your exit with a juvenile parting shot.

Anyway you already advocated for, as you say, a "nepotic" system, by presuming to kick out people - spammers- whose behavior you feel disrupts the environment you're trying to curate for the benefit of people who are there to support it. There's absolutely no pretending you're above the enforcement of value system boundaries, it's only a question of how focused you want them to be, what stable values you want to optimize for in order to create a consistently attractive experience for your users.

I use this site far more than reddit, in large part due to the fact that it does encourage its users to identify and punish behavior (through flagging, disliking) that is out of step with the objectives of the site, as outlined in the usage guidelines which everyone implicitly agrees to (try to) follow when posting here. And yet in the public scope reddit is the clear 'winner' if raw traffic metrics are the score.

After being on the internet for 20 something years and Usenet for 10 before that, I've had quite enough experience with free for all dumpster fire communities to know that they are not the bastions of high-minded openness that people naively or foolishly believe them to be.
Opening /proc/self/fd/1 is not the same as dup(1)
Oh no! ...anyways...
how sweet it is
> I'm totally fine with failure

You shouldn't.

> it's more a feeling of as another commentator said "worthlessness" and that I do not have any knowledge and as such anything I've made has been only possible through external means (googling, following tutorial, whatever excuse my mind makes up about me making up my experience).

Well, maybe it's not "debilitating fear of failure". Maybe it's indeed a "feeling of worthlessness". Maybe it's something else with an official name that you can wave around to justify your failures. One thing is sure: it's not impostor syndrome. At all.

> Like say seeing some influencer brag about how they manage to create a game engine in 24 hours while for me making a "deployable webapp" takes months, will make me feel worthless and then start to question anything I've done is actually learnt or if it's just "luck" or "cheating" that made me able to write this simple webapp.

Never, _ever_, compare yourself to anyone else.
The trick is that you don't actually have to do all the tasks you write down. It is still nice to have a record of what you've planned so if you ever decide to jump back on any task you have a history of what you have done and any context associated with it on hand.

A lot of my todos are something like "I found this article interesting but I don't have the current skills to really understand everything in it" or "I want to add this feature to X but I think I will wait until the new version comes out because it will be easier then" or "I want to remember this when I finally decide to do Y".
2x faster than Cloudflare Worker cold starts.
> statistical optimization problem where the goal is maximum acceptance by the user

A brain could also be described like this, if you focus only on the text output.
What exactly makes you think those two are different in nature, not just in scale and training data? It seems like a lot of these discussions are walking in circles trying to compare ill-defined things (human cognition) with well-defined ones (prediction).
I’m well aware, as I said in my comment, I need to add filters and am working on it!
No I'm sorry. I don't mean "growth" as in infinite and unsustainable growth like VC-founded startups. I mean "growth" as in adopting a bigger market share.
Oddly as a Kagi user, it does have a fault.

It actually sucks at finding the low cost product.

Want the cheapest esp32 c3... google is a better place to start. I can quickly find the "price to beat" and go deeper elsewhere.
It's explained in the post:

> Have you ever done a dense grid search over neural network hyperparameters? Like a really dense grid search? It looks like this (!!). Blueish colors correspond to hyperparameters for which training converges, redish colors to hyperparameters for which training diverges.
NVIDIA's new GPUs have horribly confusing names.

Are higher numbers better or lower numbers better? A6000? A100? A800?

And H > A > V > K, I think? And there's no T100 for Tesla and J100 for Jetson? But there's a Tesla V100 (Tesla Volta 100) and a Jetson Xavier which is neither Jetson nor Xavier architecture but Volta architecture?

Can we please just have monotonically increasing product names in terms of compute capacity and stop jumping around the alphabet?

I know they name architectures after scientists, that's cool, but at least they could do what Ubuntu does with release names and go in alphabetical order.
I tried doing it this way. While it sounds nice, and apparently works for some people, my biggest problem was stuff getting buried hundreds of lines into the file. I couldn't trust it to remind me of anything beyond the few items at the top of the file. Another problem was having everything as a big blob of text mixed together, unless you take on some overhead when entering things (put them in the right place) or during the day (moving things around).

If this appeals to you, I'd recommend using a big html file with Javascript to query the things you want to see, using class names as tags. A good text editor will have snippet support, and you can just dump any new items at the top of the file as they come in. If you want to get fancy, you can write in markdown and convert to html on the fly.
You mean “ Beijing Benz” which is owned 51% by china and makes their own cars too using the tech taken from Mercedes?
Dutch because of the tax regime. Other famous ‘Dutch’ companies:

- https://en.wikipedia.org/wiki/Inter_IKEA_Holding: “Inter IKEA Holding B.V. (also known as Inter IKEA Group) is a holding company registered in the Netherlands”

- https://en.wikipedia.org/wiki/Airbus: “Airbus' headquarters are registered in Leiden, Netherlands, but daily management is conducted from the company's main office, located in Blagnac, near Toulouse, France.”

- https://en.wikipedia.org/wiki/Lipton_Teas_and_Infusions: “Lipton Teas and Infusions is an American-British private company based in Rotterdam, Netherlands, that produces tea and other herbal drinks.”
>The reason for that is that C does not offer a generic function pointer type, and standard C disallows casts between function pointer types and object pointer types.

I've wondered why this hasn't been relaxed a bit when void* is used. Say you have these functions (modified from the link)

int compare (const char *a, const char *b) {
return strcmp(a, b);
}

int compare (const void *a1, const void *b1) {
const char *a = a1;
const char *b = b1;
return strcmp (a, b);
}

And then you have some FP of type int(*compare)(const void *a1, const void *b1) somewhere...

If you have correct pointer const-ness, why isn't the first method the PREFERRED way of doing this? It's shorter, more clear, safer (calling compare directly and not through a FP still gets you proper type checking (you wouldn't call either of these example functions directly, but for others you might)), and IDE suggestions can better explain what the function is. I've thought several times about suggesting to compiler writers/the C committee to bless the first method. Is there some obscure hardware that the first would be incorrectly compiled or something (i.e. the calling convention for void* and foo* is different)?
Yes, that was obviously an extreme example. But we know that it is possible in reality to implement a physical system that does what we call thinking. There is, I think, no particular reason to suppose that it's physically impossible re-implement the functionality with much less meat. Supposing that you've done this, you then just need to more clearly define "thinking" and "LLM" to determine whether changing that re-implementation to be closer to an LLM results in it losing the ability to think before it gets there.
Building your first computer vision model just got easier
I just setup this awesome way to easily deploy computer vision models using natural language, check it out: https://code.groundlight.ai/python-sdk/blog/getting-started
That's my point. How can you compare the two if one is not even well-defined, let alone understood?
Reused for food? Is it dishwasher safe?
VSCode and Markdown go a long way for me because it allows for index linking and some other nifty tricks. The main challenge is making sure the md files are organized.
Safari has a side bar where tabs are in fact vertical. Tab groups will also let you, um, group tabs, and they're presented as a tree in the sidebar.
I use Bing, too. People are suprised when I recommend it, but for most general searches, it's quite a bit better.
Sorry, what recent events? I was under the impression that ASUS was one of the better board / gpu manufacturers?
"some people have more money than you", still, 15k USD is a lot, even without this perspective.
I enter my to-do items into Google Calendar. If I can't finish them today I move them to tomorrow or another future date. Once they are done they stop moving.
I’m not sure how, but I got the zoom messed up on iOS and I can no longer see the submit button. Refreshing doesn’t fix it.
I'll never understand how in this day and age we still allow people to die suffering this way.

How come we are ok with euthanasia for pets but not people?
Again, it’s not Mercedes selling cars in China. It’s some joint venture that’s majority owned by the Chinese that has forcibly taken Mercedes tech and has made millions of cars using it. You can’t compare a Mercedes in the USA and China and say they are equivalent
LLMs don't talk like children, and they don't seem to be taking that development path. They are trained on adult language. They don't make the kinds of mistakes children make and it doesn't look like we could use children as a model for improvement.

It's entirely possible that LLMs will one day emulate adult speech without ever passing through the child development stages. The stages it takes to get there will be distinct.
A dash cam is totally different because of how insurance for cars works. The thief burglaring your home does not carry liability insurance for crime. Your property insurance should already cover the theft, there’s no point in determining fault and what company should pay out like in a car accident.
These "apologies" are something that deeply irritates me.
Caffeine is in many anti-headache drugs because it literally is a vasoconstrictor that helps reduce headache.
Animating graphics while loading were invented as a way to reassure the user that nothing was stalled, halted or crashed. Therefore, any loading graphic whose animation is not directly tied to the thing which is waited on (i.e. the loading of assets, the reticulating of splines, etc.) is fundamentally dishonest, and teaches users to distrust loading animations; that is, the reason they exist in the first place.
I would love to see Wasmer Edge in the next comparison!

A summary for the lazy readers:

* Cloudflare workers outperforms the rest by a big margin (~80ms avg)
* Fly.io cold starts are not great for the Hono use case (~1.5s avg)
* Koyeb wraps the requests behind Cloudflare to optimize latency (150ms best case)
* Railway localized the app in one region (80ms best case, ~400ms rest)
* Render has some challenges scaling from cold (~600ms avg)

In my opinion, this shows that all platform providers that uses Docker containers under the hood (Fly, Koyeb, Railway, Render) only achieve good cold starts by never shutting down the app. The ones that they do, can only achieve ~600ms startup times at best.
I think the author is trying highlight that one doesn't necessarily fancy tools. The productivity space has so many options that it's easy for one to get overwhelmed with settling on the "best" option.

My partner relies on a Leuchtturm weekly planner; my father bought into the whole Stephen Covey system; a coworker has a stack of Post-its, and I use a hodgepodge of Google Calendar (far off single events), Apple Notes (weekly tasks for work) + Reminders (medium-term todos).

The whole point is not to rely on one's (aging) memory to keep track of stuff. As long as tasks aren't falling between the cracks, keep doing what you're doing.
I'd probably be similar if I lived in Boston/Cambridge these days without a need to commute. I wouldn't use a car day to day. But I'd use one to go to outdoor activities or to visit people outside the city. Even if the economics didn't quite work out, I'd want one customized for my liking just so I didn't need to think about it.
The Klingon one was awesome. This one has Q though.

It is truly wild how much quality content the franchise was able to produce in the 90’s.
That's because your search query isn't specific enough. Google doesn't read your mind to figure out what about "indoor light" you seek. So it defaults to commerce.
Germany got a bit off-rails during the last months. Any critique towards Israel’s actions it is called antisemitism.

As an example, this event organised by jewish people to talk about peace have been marked as antisemite by the government and lead to funding cancellation of a cultural center.

https://oyoun.de/en/news/offener-brief-oyoun-muss-bleiben/
My sister is far far richer and more successful than I am. She once told me that every night the last thing she'd do was to make a mental list of things to do tomorrow. That was it. Nothing written down.
You will be able to resell that 192G Mac Studio for 3-4k after a few years easily, which you've bought for 6k. There's nothing competing with Apple Silicon right now for local LLMs when you look at TCO.
Yes, a lot of commercially grown cannabis is, unfortunately, irradiated. Different countries (abd different US states) have different laws about the amount of mould and yeast that are permitted on sold cannabis flowers (as well as other things, such as moisture content). The target is quite hard to meet got some markets, including the UK and EU.

To get to the required levels, irradiation isn't necessary... but it's cheap and easy. I get the sense that it's often used because of poor growing practises, more than anything else.

I can't speak for other countries, but in the UK most cannabis has until recently been gamma irradiated - which often led to practically terpless flower that smelt of damp hay. More recently, e-beam (electron-beam) irradiation has largely taken over - and it seems to be much, much kinder on terpenes! Honestly, most is now impossible to tell apart from non-irradiated flower.

I don't have actual data, I'm afraid. There's a single paper talking about cannabinoid and terpene content of cannabis after gamma irradiation, which was paid for by Bedrocan - but I haven't found anything about how it compares to e-beam.
Basically any group of organisms that have sex with each other...
This is a collection of a ton of super useful tools I came across and had to share!

On mobile there's kind of a full page banner ad for their desktop tool. All the generators are right after that.

(Much better experience on desktop in general)
Small tech companies tend to be design or engineering led. Organizations grow and evolve, and as they become large they become marketing or finance led.
I find it helpful to give myself permission decide NOT to do something. The to-do list is a bunch of things that I thought were important when I wrote them down. If the next day I only do half of them, but feel those were the important ones, then I have success. If I decide that half of them aren't worth doing, the doing those would be failure.

The goal of the list isn't to beat you up, but just a tool to make sure that at the end of the day you did the things that were important to you and YOU get to decide what that means.
But monitoring fly.io from fly.io is a bit biased
The reason that we had to wait for large language model in order to have computer systems that seemed produce something like effective natural (human) language processing (NLP) is that human language doesn't follow strict and logically definable rules but is instead something like a complex overlapping mesh of multiple kinds of rules-following processes. So what constitutes "offensive content" or a "straightforward question" or etc is itself not straightforward (yes irony but bear with me...).

The main thing is that LLMs are an end-run around the dilemma of corporations not wanting to spend the money required to produce a codified model of language struggle (a task that would require training many, many linguists). So instead LLM take massive training data and use massive processing power to create contextual prediction system but by that token such systems aren't understood or fully controllable - they contextually reproduce what the training data tends to do, which is what humans on the Internet tend to do. And this contextual reproduction means there's always the potential for user into change the "meaning" (more accurately the context) that the system's original gave. "And to me, the most offensive content is that which censors itself..." (there millions of better example you can find for "prompt exploits"...)
In a brain the user to some extent is itself. LLMs do not have anything like this. They're once-through, static, and are not in any way embodied or self-referential (beyond context or what you feed back into them).
https://archive.ph/YkgOw
Yeah if they have no negative reviews, that's a bad sign. A particularly scrupled YouTuber I follow typically won't do a paid video if the product isn't good and instead does an unpaid tear down video. That probably limits his opportunities to brave marketing teams with high quality products, but it also makes his reviews quite valuable.