skysight-inc/HackerNews huggingface dataset:
Why not both. If kibana supported sql that would be
cool in addition to it’s 2 (or more) distinct syntaxes.

The issue is with non relational dbs like redshift that do support sql it is
very easy to write an innocent query that takes hours to run if you don’t use specific keys in the query (ones used for sharding). But then some kind of warning or query plan indication would help there.
Yeap, simply supporting FROM … SELECT … WHERE … would make sql much more autocompleteable?
people who intentionally choose sql databases often make every effort to avoid writing any of the stuff by hand, which should say something about how much of the value proposition lies in the language itself

> SQL has a solid standards committee that maintains and improves it.

so does c++. so does javascript. so does cobol
Work count as work ?!? Soooo, anacdote time. I had this boss who walked into my office and saw me sitting in front of my computer, reading the screen and not typing. He asked me: "what are you doing?" I said: "thinking about how to solve problem X." he said: "okay, but why aren't you typing?!?!" For him it was working as a software engineer is only when you type.....
The actual uneditorialised title is "The Guardian’s approach to generative AI", and the reality is far less sensational than the invented title "The Guardian will now use generative AI" implies.
The work was already done for them, as LINQ is just do-notation from Haskell.
Ugh I hate those. I’ve been using Jira for nearly a decade and have written numerous filters for dashboards, etc and I always have to look up the bespoke nuances of JQL.

Recently I was burned by a bad query in Google Log Explorer. There was no feedback my query was wrong, just no data.
When I see people argue about government intervention, I always think that if the intervention is going against the wishes of people, there will be a private sector attempt to undo or reverse the government intervention but equilibrium isn't guaranteed.

Too long copyright durations and too stringent distribution restrictions are undone by open source projects. This does not result in an equilibrium because there is a vast space of projects that need to be proprietary in some dimension and open source in another. The equilibrium solution has to be a hybrid of the two approaches.

Side none: An equilibrium is like a limit of a converging series. You don't have to reach it, just get close enough until you are happy aka |x_i - x|< epsilon
That doesn't invalidate their existence.
If you're not using proprietary software but common programming languages and OSS tooling there should be no difference.
I think the argument is clearly trite, .docx seems like a joke, and very more likely within the hundreds to thousands of years, people probably won’t even speak Finnish there anymore.
Lovely stuff. Now someone please use this in a Bioshock-like adventure based in London's semi-apocalyptic west end.
Also, gravitational* waves. Gravity waves are something else: https://en.wikipedia.org/wiki/Gravity_wave
Isn't your comment judging a fish by its ability to climb a tree?
> Feature phones weren't a substitute for personal computers. They weren't as necessary of an accessory as it is today. On the other hand, standards governing how those phones worked weren't changing as fast, so, given good care, you could use your phone for 10+ years.

I am quite sure that many people across the African continent and Asian see it differently.

Specially those that were using Symbian devices.
There's no way I believe this is the real reason. The whole history of MS/apple/facebook and successful businesses in general is allowing others to experiment to create add-ons / apps then creating your own integrated version to capture the value. i.e. let them pay the cost of experiementation and then copy it. See MS office, MS internet explorer, MS games, MS teams, Apple sherlock/watson, Facebook UI,......
This is a strength, not a weakness. It forces you to only select what you actually need, and state where it comes from afterwards, to only limit your query to exactly what you need.

This is paramount for performance.

If autocompletion is your issue, just get a better client, it's perfectly possible to autocomplete field names even before specifying database or table name.
I wonder how the people who live in the residential house feel about suddenly being a fan destination. The people who bought the breaking bad house have had a rough time.
The joy of SQL is that it's so high-level.

Other responses note some (to me) esoteric enterprise use-cases for which SQL may not sufficiently describe exotic data vistas. Sure.

But most of the "shaming" one encounters seems to be about advertising some sort of magic wand product more than pointing out a substantial woe in a system that has been prominent for a half century.
`3w` is a command all its own. There’s an implicit move command baked in. Moving gets pretty clunky if you don’t have first order movement (adding a specifier or something to clear selection). You can mimic this by mapping a single button to <C-v> and disabling all movement commands in normal mode. It’s rough, but may be learnable.

I think something that might work better is adding a “commit” signal to operations. So you type `d3w` and the editor highlights the next three words with a strike through or red or whatnot. Then you can hit enter to commit the delete or escape to cancel it (cursor resets to start position, highlight goes away).
I read this paper as commenting on the second-order derivative of benchmark progress with respect to DL techniques. The trends presented start with 2012-era models with 2012 data, and end with 2020 results for 2020-era models. Thus the extrapolation on training costs accounts for the current pace+style of progress and innovation in all relevant subareas of ML. To me it seems that it’s saying “if research continues in the same trends as it has from 2012 to 2020, here is where we will end up in 2035.”

In other words, in order for us to buckle the trend we would need to start innovating in ways that are unlike the ways that got us from AlexNet to here.
That's valid DuckDB syntax
I felt the same way when Malloy[0] launched. It has some interesting features, but I couldn't see myself ever using it. Nothing makes a big enough difference to spend the time to learn it.

Would love to hear from anybody that's using it regularly

0 - https://www.malloydata.dev/
This is no longer true in database that have JSON support (which is most of them these days). You can aggregate the result of a subselect into a single column (the underling data doesn’t have to be stored as JSON, you can convert as part of the query)
Doesn't change the fact of the "clever" Webassembly marketing.
Malicious compliance at its finest.
K should be easy to get when the next station is Kingsbury, and Q is available at the following stop, Queensbury. F from Finchley Road.

U might show as "London Underground" at some point.

Does V show in "Change for the Victoria Line"? I can't remember if these trains show that.
Although it reads as though it's $1 ea for your first 100 homes you sell, then $995 after that.

And actually, probably need to make it $1/home for the first 1000 or so just to get the site to critical mass. Not going to get many buyers for 2 listings...
Throw in a code review.
Well, if there's one game worth your time, PS:T is probably it. Arguably one of the best cRPGs of all time.
Blinken Says His China Trip Aims to Lower Risk of Conflict
https://archive.is/2F8Mq
I wouldn’t mythologize the elites of the past too much. FDR’s grandfather made his fortune selling opium in China.
The biggest advantage of SQL is that it's so common that if you deal with data a lot you tend to know it well enough. Sure, there are small differences between databases but joins/grouping/window functions tend to work similarly enough.

On the other hand, when I have to do a somewhat complex query in Elasticsearch, or MongoDB, or gorm, or Django ORM, I have to check each time in the docs how it's done.
The Rise and Fall of Fake Meat in America
I'm on 18, but will upgrade to 21 when it drops. Not really felt the need to upgrade to 19 or 20 as they haven't provided any features I'm interested in.
Those categories cannot be “wrong” as they are based on the types of molecules.

I think what you mean is they are not meaningful to guide health decisions as they are too broad and can be further subdivided into more specific categories.
If the task is to climb a tree, it's reasonable to not hire a fish.
That's a clickbait headline that isn't appropriate for the article, the original is "The Guardian’s approach to generative AI".

They seem to be only using it in the background - "helping journalists interrogate large data sets, assisting colleagues through corrections or suggestions, creating ideas for marketing campaigns, or reducing the bureaucracy of time-consuming business processes"

If and when they use editorially, the seem to be checking and moderating with human oversight and "will be open with readers" when they do so
Perhaps I’m lucky, but I’ve never experienced SQL shaming. What I have experienced is referencing shaming, where I’m allowed to write SQL, but all table references in that SQL need to come from the model instead of being hard-coded in the SQL. I suppose it’s nice to have all the join tables’ models being included in the file. It makes it easy for a search to find all the usages in case there is a big refactor. It also makes the SQL look a lot more complicated then it really is and a lot less clean then these examples- at least in the code.
If the fee structure was something like 1% list price + 50% (list - final), I could understand it as an 'I'm not used to negotiating, pay someone to do it for me' service.

(And I'm sure you could find someone to do that here if you wanted, especially for very high value properties, or by bespoke arrangement with some other real estate agent or salesman who's used to negotiating, but it's just not commonly done. I suppose for one thing you often end up paying more than the list price - and they might have to negotiate hard to get it for that, other times not at all. You'd need to somehow incentivise listing at a 'real' asking price (or penalise difference from it) I suppose.)

But the house-finding (and related apparent refusal to arrange viewing except through buying agent sometimes) and inversely aligned incentives seem strange to me.
It's not binary: bosses and investors want to know who will obey the rules as you see them for a variety of reasons. They'll fund / promote based on the needs of the projects you will likely face.
Decentralization can be about delegating decision making. Hopefully to the people closest to the problem. The trick is to pair accountability with responsibility.

Sometimes also called "empowerment".

The job of central powers (that be) then changes from obsessing over outcomes to upholding the structures and processes. Basically making sure everyone plays nice.

--

It's been ages since I binged on Peter Drucker. Someday (hopefully) I'll reread.

Like Marshal McLuhan, Neil Postman, Clay Shirky, Everett Rogers, Deming...

Drucker remains highly relevant.

I'm in awe of how certain people were so clear-eyed about changes (upheavals), even at the very beginnings of those changes.
What, you mean like Firefox?
Since moving to Apple Silicon, I've been wanting more ARM options in the cloud. Although it is possible to host x86_64 VMs, having fewer differences is obviously better.

I've been using Oracle's free tier for a while, and it's been OK. Performance-wise, my Objective-S and libµhttpd based web-server appears to be doing around 1800 requests per second, and held up fine to a HN hug of death.

Hetzner was far, far easier to set up, both from their console and via the API. Performance was comparable.
I don’t really find the examples convincing. Like, I get that sql could maybe be written in a slightly less horrid way but I would prefer something a lot less horrid.

I think I’m much more motivated by analytics queries than the kinds of thing in this example though. I find sql is poorly suited in this case because it is verbose and written backwards, and often requires many layers of subqueries. That said, one can usually still express queries in SQL that other systems do not allow.

For these kinds of queries I think there are just better ways to express them. Another issue with sql is that has some quite strange semantics.[1]

An example query I wrote yesterday is:

select group, min, max, (max-min)/1e9 range
from
(select group, min(size) min, max(size) max
from
(select time, instance, sum(size) size, regexp_replace(name,…) group
from X
group by regexp_replace(name,…), time, instance)
group by group)
order by range desc
limit 10

Which is neither pleasant to write nor iterate on interactively.

With something like dplyr instead:

X %>% mutate(group=regexp_replace(name,…))
%>% group_by(group,time,instance)
%>% summarize(size=sum(size))
%>% group_by(group)
%>% summarize(min=min(size),max=max(size),range=(min-max)/1e9)
%>% arrange(-range)
%>% head(n=10)

And that can be built up interactively pretty easily by adding onto the end of the pipeline.

I would also note that, due to sql being painful, the query is not exactly the one I wanted and instead I would have wanted something better capturing the change over time, but the thought of doing that in SQL seemed too unpleasant.

An example of an actual query language that tries to be better for analytics: https://prql-lang.org/

[1] from someone who spent a lot of time working on databases and sql: https://www.scattered-thoughts.net/writing/against-sql and just on semantics: https://www.scattered-thoughts.net/writing/select-wat-from-s...
It's easy to cherry pick. I guarantee you there are a lot more queries that are easier to write in SQL than in your favorite FancySQL (or even worse, NoSQL) variation.
Those are intended as shortcuts for creative apps where you typically need the entire screen real estate. There was precedent for that going back to pre-X macOS, but spaces and full screen windows are a consistent approach at switching contexts in creative apps.
Yup, this right here. This aspect of SQL is overwhelmingly why I insist on ORMs, too. Any efficiency gains you get by having a senior dev write raw SQL for a complex query are immediately negated by a junior turning what an ORM would write as a single query into three DB calls. All because SQL insists on a flat result set you have to turn into a nested collection yourself, without an ORM doing it for you with eager loading.
At least they're putting forward some sort of "policy".

Gannett's use is more troublesome in terms of impact:
https://finance.yahoo.com/news/gannett-tiptoes-generative-ai...
SQL selection works perfectly on tables in poor normal forms. If you have the columns you need to query pre-joined into the table you’re querying, you just skip the joins. Updates are what gets fun if you don’t have normal form.
You are absolutely right for the moment, but the question is whether this will always remain the case. I am honestly doubtful and fairly certain this will be more a question of when than if. Seeing as both Nvidia and Apple continue making consumer hardware that does well in inferencing, I fail to see why training sufficiently capable models locally may not become more common place, especially as there are already murmurs in the field that overly large models (100B+) may not be necessary for many use cases.

Add to that the fact that institutions (including research institutes[0][1] or universities outside US or EU jurisdictions) are likely to continue undertaking the task of training larger in size models, making the fruits of their labor freely accessible, I just do not see a way for centralized enforcement of specific LLM training rules.

[0] https://huggingface.co/tiiuae/falcon-40b-instruct

[1] https://www.databricks.com/blog/2023/04/12/dolly-first-open-...
I'll respectfully disagree here. English is one of the worst choices for a latin alphabet based lingua franca, as a mix of germanic and romanic languages, with inconsistent to non-existent rules, differences between sound vs written character. It got its current status by piggybacking on 2 empires, with a bonus of hollywood for planetary indoctrination.

I've seen a few languages lose lingua franca status in their subdomains in my liftime: French as the ex-language of political power in Belgium, and German as the ex-technical documentation language. In fact, seeing more and more Chinese appear in electronic spec cheats, I've wondered if such a change isn't already happening for English. As always, the cultural core of the power in vogue will be the last to notice the disappearance of status.

There was a document regularly appearing here on HN: The fate of empires, linked below. If you follow it's rules, you'd expect a new power appear out of nowhere. So for a new lingua franca, we just can't predict what will be the choice, but the existing big languages might be the worst candidates.

I believe English will be lingua franca until a new empire will rule the world. If the USA disappears and balkanization follows, English will have a long life. But if a global invasion from a new culture comes, English is done for.

http://people.uncw.edu/kozloffm/glubb.pdf
Passwords for games where you have items - which can e worth a lot. Like those hats, or skins, or items.
Whole accounts can be sold too for legacy skins, or game collection.

A big list what bills have to be paid, to whom, by when, with estimated amounts, adrrsses, telephone numbers, bank account numbers.

Your social security number.

Information if some of your personal belongings (e.g. books, toys) are worth something to collectors.

Wifi password

Actual list of people who you want invited to the funeral. If you get a phone with 500 contacts it is hard to say.

Information what type of grave you want, what religion.

Someone technically savy needs access to phone (including being able to pay the bills in thr future) + main email account to unlock things.
Bad HN title for quite a reasonable article saying that they won't use it where there is risk of unreliable facts creeping it but will leverage it for things like interrogating large datasets.

Makes sense to me, generating queries using natural language seems to be one of the less tricky areas to get right.
Oh man, thanks for providing those wikiteam tools, they’ve been a huge help in a large fork off of fandom!
I just checked out the career page of the company you are working for. First of all, judging from the site, you are not looking for front-end devs at all. You have exactly one programming role (https://www.gipmbh.de/karriere/java-software-entwickler-in), which reads like a pure back end role.

And although I check virtually all the boxes of your backend tech stack and education requirements plus a lot of JS/TS and Angular experience, I would not consider applying. The job ad explicitly mentions a location. So this reeks of a position with no real "home office". I once interviewed with a company which advertised as full-remote and then when it came to the offering was only granting flexibility nominally, but was legally a when push-come-to-shove-your-butt-is-in-our-office-seat contract. Also, it is in my eyes not sensible to exclude the developers with a vocational education (Fachinformatiker Anwendungsentwicklung or MATSE) with your degree requirements.
The extinction of OS 7 (platinum) roll-up windows is something many people miss.
It's still working for diamonds.
If they're on MLS, they'll be on Zillow.

Buyers these days do a lot of their own searching. If a buyer finds the listing on Zillow via MLS, it won't stop them from viewing the house even if they have an agent.

Once they view the house, the owner could convince them to ditch the agent. I mean honestly, what does the average agent do for a client? Not very much.
Spelling errors? In The Grauniad?[0] Forswear!

[0] https://www.theguardian.com/media/2021/may/12/guardian-200-t...
> Gas Station Jim Proposes To Pam: This iconic and one of the best Office scenes takes places at the real gas station at 2909 Los Feliz Boulevard in Atwater Village.

This one is incorrect. The commentary on the DVD talks about how they built a set just for this scene so that it could be raining during the proposal. They built a track so cars would go in circles as they filmed. They couldn’t reasonably time filming at an actual location to match the weather and they couldn’t just spray water on a real highway.

Here’s an article that explains it: https://www.insider.com/the-office-jim-and-pam-gas-station-p...
Is there a recent render of the "earth as neutron star" picture?
Sounds awful. I like that everyone can get in on the discussion topics of the day. Whenever something odd or unique shows up, there’s usually some kind of expert in the field chiming in. That isn’t something I’d get with the subreddits model.
It's funny how some devs are negative towards SQL but fiercely protective of other much more obscure tools from the 1970s, like unix utilities.
Even 2 trillion tonnes sounds like a very small amount of water compared to what must be getting redistributed by climate change? The Antarctic ice sheet alone weighs around 25,000 trillion tonnes. So even just melting 0.1% (25 trillion tonnes) of it would move far more water into the oceans than we've ever pumped from groundwater!
Then you've missed the entire point of "migrating".
Also important: The behaviour of SQL is well understood, a new query language always introduces the risk of defects in the query language itself or developers making mistakes in an unfamiliar language.
Looks like we are in the next hype cycle again where people push what they want to see.
Facial identification is not what's preventing them from catching your package thief. If that were the obstacle it would be about two court cases before all thieves are wearing a bandanna in front of your ring camera.

You've chosen to constantly surveil yourself and, without their consent, your visitors, sending all of that to Amazon. Now you want to force a similar apparatus to constantly watch all of us everywhere, so you can buy things more conveniently. No thanks.
As someone who is generally against testosterone supplementation… hell no that’s a terrible comparison. How extrogenous testosterone affects the HPTA axis and the returns/dependence, is nowhere near what opiates do to your mu/delta opioid neuroreceptors.

Opiate neuroreceptors autodownregulate, for one, so that means tolerance/dependency gets worse over time. That doesn’t happen with testosterone at all. Also, TRT would not have diminishing returns, after you get past the first few weeks. Some of that is tuning E2 levels, etc; most of it is psychological result of expectations (think placebo effect).

You risk issues at common doses, like cardiovascular damage (which tend to be higher doses than TRT), but these issues don’t compare with opiates.
Are they also restoring content from deleted accounts?
> I realize that there is no way someone can maintain this after my death so I added a "how to dumb down the house" section that describes what can be removed.

As someone running a lot of custom automations on Home Assistant, thank you for this tip.
They haven't misrepresented anything. The GPL license can be used for open source projects by companies (e.g. for commercial purposes). There is no need to include a more specific category if you already covered the broader category.
In the Loopy: the story of Casio's crazy 90s console (2018)
I agree with many points, however, it depends on the abstraction that you need and the abstraction depends on the architecture you are adopting.

For example, if you are doing DDD and your repository implementation is about SQL, adding another layer of abstraction is not worth. But if your design is less sophisticated, or you are in an early stage of the project, you may find appealing to use that abstraction.