skysight-inc/HackerNews huggingface dataset:
how are they not making more money off of data? the trip data alone has to be worth millions right? All I see when discussing Ubers profits is the cost of trips and the cost of drivers and how much they spend on marketing and politicians. It seems like theres gaping black hole of all the data they are collecting and it being put to use/sale.
Anyone that claims a fully autonomous car is lying as even the best one Waymo isn’t fully and is very limited to great conditions
You seem to have missed my point slightly. 17 year old me would be very excited about LLMs - they have potential to be very disrupting, and are almost magical compared to what we had just a few years ago (remember when image recognition was a challenge?). Current day me is not. And I have also witnessed several hype cycles - enough to grow tired of pointless changes. Even though I was an early adopter of everything 20 years ago, always ready to try new technologies.

But did the world really change? Are dangerous technology and hype cycles new? Or maybe the world is the same but it is me who have changed? Will current day teenagers recollect 2020s as a golden age of tech?
The tone of the article is way off as far as Wikipedia guidelines go. Reads more like a promo piece.
Also probably need to prestress it for best results :)

If it's stretchy or wavy, the concrete may crack before it starts to produce tension
Dev is not why they are unprofitable. It is mainly due to COGS (payout to drivers and other direct costs) & sales and marketing aka growth at all cost. Their revenue has not gone down
More like "we pretend to be an autonomous driving company".

Plenty of space for companies that can actually deliver, especially in Europe.
I never ended up taking those database electives at uni

In practice though, SQL just seems like a lower-barrier to entry lingua franca than C (for its use)

Unless it’s absolutely essential to your performance -like GIS or data-driven stuff (at which point you might be looking beyond SQL) - I don’t really see it as a highly specialised niche skill

I think most people see it (perhaps rightfully) as a commonly understood but seldom directly used paradigm in isolation

Picking up an ORM is comparatively child’s play but not understanding the basic concepts of SQL is an uphill battle for even the simplest CRUD applications, even if SQL isn’t used

Lingua francas such as C/SQL/HTTP in computing are perhaps even more important as paradigms of thought rather than tools to be used

Especially as we seem to year on year move higher up the tech stack for the foundations to greenfield projects
And of course MS Word for DOS 5.5 is a free (official) download:

http://download.microsoft.com/download/word97win/Wd55_be/97/...
I think at that point I'd have to ask someone to make it for me.
"Does Betteridge's law of headlines still apply in 2024 ?"

no.
I think SQL is due for a renaissance, and I hope htmx is part of that. I know htmx has a reputation as being something only a backend developer could love, but I think that in a few years some of the most effective htmx developers are going to be front end developers who know the web stack (CSS, JS, HTML) well and who have figured out how to use SQL effectively.

If you are smart enough to figure out GraphQL, you are smart enough to figure out SQL, and SQL comes without the security/expressiveness tradeoff[1] inherent in front-end data access technologies. You have hypermedia-oriented tools like hotwire, unpoly & htmx pushing data access back onto the server, and at the same time things like React Server Components doing the same.

I'm very bullish on SQL.

1 - https://intercoolerjs.org/2016/02/17/api-churn-vs-security.h...
Similar thing, but automated with AI based on what you read: https://github.com/m0wer/rssfilter
100% this. I heard a fun saying when I became a professional dev:

“When you’re fed up of keeping up just retire in to SQL, it’s the best pension there is”
IIRC these messages usually have their dimensions equal to primes, to help the aliens a little bit - for example the Arecibo message was 1679 = 73 * 23 bits. We're hoping the aliens have the sense to recognize a product of two primes.
Khan Academy is a 501(c)3 [0] non-profit. "Increase revenue" maybe, or alternatively they may actually believe in their mission. Depends on how cynical you're feeling today I guess.

[0] https://projects.propublica.org/nonprofits/organizations/261...
That is reasonable ONLY if the party who owns the lot is willing to trade (possibly with some extra compensation for their trouble). However I see not reason to expect someone to trade their land just because someone else wants to.
The conveyor belt thing has a lot of momentum behind it. There's a push to created automated logistical grid that replaces TEUs with a smaller more manageable and routable standard. Self driving and traditional rail just have extraneous overhead that a basic conveyor with switching simplifies.
Same here but no one hires for a DBA, just keep moving me between projects to put out fires or get them finished one-time or not later then they're already running. Few are actually interested in learning details of designing schema/indexes/queries to be good before there's a problem. I keep telling them to put example SQL queries in PR descriptions with EXPLAIN query plans hoping it will click for them.

My view is that the schema + queries is the essential performance consideration. The code that goes from one persisted state to another is largely plumbing implementation detail. Of course there also lots of precise logic there but it's a healthy alternate view. The first thing I do on any project I join is make a big ERD to know the names, cardinalities, and relations (and wonder how they keep changing that without an up-to-date picture).
For those without money to spare: https://gwern.net/doc/psychology/linguistics/2024-fedorenko....

The authors come from MIT, Harward, and University of California
Holy cow. What happened?
I'm saying that the time the cones come up and the parking is closed to the time it's reopened it takes a weekend... and it takes a year for the approximately same sized parking lot on a government propery.
Hum... Mine personal ones would be:

- teach enough IT at the right time, a teenager MUST know enough to produce nicely formatted docs with graphs, tables etc, LaTeX level, at least with some pre-made templates, how to take notes, do simple computations etc on a desktop, it's the writing ability of today, people MUST know enough or they will suffer for the entire life struggling with bad tech and allowing bad tech to spread;

- teach like universities from the start, I do no know how does primary schools works in the USA, here in EU they teach with regular assignments and continuous checks instead of pushing children to take notes ALONE, study in their own notes and form their own knowledge valuating more their memory and conformism than the knowledge they really have acquired;

- teach without frills, I do not need slides and co, I need lectio magistralis who INTEREST people and makes them feel the passion in any subject, than test the acquired knowledge making your students teach a lesson on what they have learnt, that's the way to prove themselves what they have understood instead of blindly remembered;

- be clear, giving real life examples you audience should have lived sometimes.
GP is not quite correct. It wasn't completely re-recorded, but Dave Mustaine re-recorded many of the guitar solos on the album, and the whole album was remixed.

At any rate, it's not the same (classic, imo) album that was released in 1990.
I suppose the bandwidth is not the bottleneck currently but mainly the "switching capacity" for this kind of application?
> As we come to the end of our first full pilot school year, we’re enthusiastic about Khanmigo’s ability to tutor in math

Are there RCT results (or any results) showing the impact on students?
Rummy circle all jokar follow me
He's a team leader in a company's internal finance department. He doesn't have anything specialised on his computer that he's mentioned, I'm guessing just Word, Excel and whatever he uses to connect to their finance back-office to extract the data he needs for his reports which I guess might even be web-based.

He drives by car, which is admittedly less inconvenient than travelling by public transport, but still requires a walk across a fairly large car park, potentially in the rain.

The heavy laptop is his company-issued laptop that he has to do his work on, and he longer has a desktop PC because (like everyone else in the office) he no longer has a permanent desk. From what I inferred from the conversation, it's heavy because it's old, not because it's anything special and when we're in the pub bitching about work, he frequently complains how slow it is. It's also not compatible for whatever reason with the docks they've put on the hot desks. Maybe he has an old laptop and they since standardised on a different type of laptop since implementing this policy. Maybe he was given a newer computer for some reason, although I got the impression he's had this since at least before COVID. Anyway, I didn't ask further, as I trust that's he's smart enough to have decided for himself that the provided docks don't work and that it's worth the hassle of unplugging everything from the dock at home and bringing the dock in, and then unplugging the work monitors from the work dock and plugging them into the dock he brought from home. If the dock on the desk just worked, I'm sure he'd use it.

I don't believe he has any fancy pens. He does, however, frequently need to make handwritten notes during meetings and so he brings in his pens and notebook to work and takes them home at the end of the day. Again, this is because he longer has a permanent desk, so nowhere else he could store stuff. I'm sure they have a stationary department he can get new pens and a notebook from, but he'd still have to take them home each day if he wanted to keep the notes, and I can't imagine he'd get away with asking for a new pen and pad every day. I also imagine that he wouldn't want to leave his pen behind and then when he's a different hot desk the next day, just pick up someone's half-chewed pen and work with that. I'm just speculating though, I only know for sure that he told me about having to take his laptop, dock and pen and paper into work each day. Maybe he just decided that it's easier to shove the pad and pen into his rucksack along with everything else each day and traipse over to wherever the stationary is kept every morning.

TBH I wasn't expecting there to be to follow-up questions, so rather than asking about the full specifications of his computer, the quality of the stationary and whether he preferred 2B or HB pencils, I just said "yeah man, that sucks".
Make sure to also include a link tag in all the website headers, so the feed is discoverable by readers:

<link type="application/atom+xml" rel="alternate" href="/feed.xml" title="olano.dev"/>
No, the number of tools JS developers have made to avoid learning SQL if it was going to die out it would have done by now.

All that collective effort to avoid learning one language and thinking about your data structures first is staggering.
Why the Taylor Swift economy isn't real
What level of optimizations do you normally need in those cases? Just adding an index, removing subqueries or something more complex?
At least they are using it to teach math and not to tell us we don't need to study math anymore!
Coincidentially, SQL is having a "revival" in the streaming world... feldera, materialize, arroyo and many others are all betting on SQL as the language to express computation on moving data.
Where do you find insane salaries for DBAs?
> Having to do it via huge price hikes and screwing drivers makes me dubious about their ability to do so more than a few times.

So here's my dumb question:

What's with all the people that talk or even brag about how much money they make doing ridesharing, food delivery, etc?

Are they just lying?

Are they misinformed, bad at math, etc?

Do 10% of the drivers actually make money, while the rest break even or lose money?
If you created it, then you're not colonizing it in any meaningful sense of the word (you are using the word to invoke implications of historical atrocities, etc.)
How do you do

SELECT AVG(price) FROM cars
WHERE brand='BMW'
GROUP BY year
ORDER BY year

without SQL?

So far, every alternative syntax I have encountered was less human readable and/or less concise.

I think SQL will never be replaced because it is not really something that was invented but rather the simple consequence of wanting to store and retreive data.

You could replace "SELECT" with "GET" or "FETCH". But in the end you need to define what action you want to perform. You could replace "WHERE" with "FILTER" or "CONDITION". But in the end you need to define what you want to retreive. Etc. So by just stating the neccessary information, you always end up with SQL. And every real alternative has the problem of being less concise, less easy to read and less easy to write.
https://www.nycgovparks.org/planning-and-building/capital-pr...

Why this box costs $4 million? Can someone explain?
> It has absolutely nothing to do with...

Christian abuse has nothing to do with rising Christian Nationalism?

I think we're just going to have to agree to disagree. You have a nice day.
I like this a lot. A habit I picked up in grad school for math was to, if I thought I understood something, really check my understanding of it by re-explaining it to myself. Serializing thoughts into language is a pretty great way of catching holes and errors in reasoning.

I suspect this is also why rubber duck debugging works.
Yes and:

I take magnesium (Mg) at bed time. I believe it helps reduce muscle cramping, improving my sleep.

TIL There are many compounds avail OTC. The most common Mg-citrate upsets my tummy. After trying a few variataions, I settled on Mg-glycinate, which is also reasonably priced (vs say Mg-orotate).

YMMV. Please consult your doc. Adverse effects, drug interactions, etc.

Best, of course, is a nice hot bath with epsom salt. But that's not always practical.
Huh - TIL :-) It does sound pretty neat though...
>> Until the database and your queries need to be optimized for higher load, then suddenly everyone wants a DBA.

And then the table structure, relations, indexes, and keys all get changed because it wasn't carefully designed the first time. Then changes propagate into a bunch of queries and code and it's a much bigger deal than doing it better the first time ;-)
While not global, that was essentially what Hulu was originally for the US. A single streaming platform co-owned by many of the big networks. You could watch FOX, NBC, ABC, and other shows all on a single streaming platform.

Notably absent at the time though were many of the big cable networks and movie studios.
Use QUEL?

range of c is cars
retrieve (avg(c.price) where c.brand = 'BMW' by c.year)
That only applies if it was addressed to you though. If the mail was addressed to your neighbor and delivered to you then you don't get to keep it.
Ha, SQL is one of only a handful of computer languages that is both older than most of us and probably will outlive most of us.
Gemini 2M context window, code execution are available today
Ok, That makes sense. Now that I think of it if they switched to JS they probably would have rewritten it by hand instead of using a tool like J2CL.
Love the thought that went into this.

I subscribe to the broken window theory of policing. Letting officers get away with small violations opens the door to bringing their ego to the job, and an "us vs them" mentality.
AWS and DriveHQ are literally mentioned in the first paragraph.
Not trying to be 'that guy' but the first line calls out AWS and DriveHQ:

Cybersecurity threats are increasingly leveraging cloud services to store, distribute, and establish command and control (C2) servers, such as VCRUMS stored on AWS or SYK Crypter distributed via DriveHQ.
I found the official Ministry documents page in Japanese[0]. Looks like it's more like dedicated closed freeway system for fixed-programmed autonomous semi trucks, than actual 500km-long belt. Whether it's going to be rubber tired or metal wheeled is at least officially left TBD for now.

Funny detail: Asahi Beer is asking in a slightly roundabout way to make it able to handle heavy objects and beverage-specific pallets, with a picture of a metal beer tank for illustration. They haven't decided if it's ever built or where depots will be - but it must carry beer IF they're going to do it!

0: https://www.mlit.go.jp/road/ir/ir-council/buturyu_douro/inde...
Communism doesn't imply anarchy as it is primarily an economic system rather than a form of government.
Yeah it's called crony capitalism. It seems from my observations that as long as the money machine is focused on making business and political leaders more money, "the economy is great!!1!" and when the pendulum swings the other way (well, the one time or two in my adult life), "it's awful everything is terrible" despite other economic indicators to the contrary. Since media companies such as news orgs are part of the 4th estate, they also share some culpability by not sufficiently investigating and reporting. And maybe I'm wrong (probably so, in fact); these are just some observations from my perspective.
> If I said a microcontroller felt pretty army, that's different to saying it feels arm-y, since army is already a word.

I'm assuming that you don't mean that the microcontroller reminds you of an upper body appendage, and are instead referring to a well-known instruction set architecture. If that's the case, I'd recommend 'ARMy'. But you're correct about the ambiguity where the word form you want to use collides with another pre-existing word. In that situation, you'll naturally need a different solution.

> Language is meant to convey meaning, and you understood the meaning I was trying to convey, so what's the issue?

That's precisely it. Language is meant to convey meaning: and the more complex and abstract the meaning we mean to convey, the more precise we need to be in our use of language. Deviating too much from well-established conventions makes ambiguity or miscommunication more likely. Conversely, to your point, blindly adhering to conventions where that would increase ambiguity also impedes communication.

In this case, the erroneous hyphen didn't completely erase your intended meeting, but it did make the sentence slower to parse.
SQL is the opposite of teenage sex - everybody does it, nobody talks about it.
This is just a map/filter/reduce/sort, you can do that in pretty much any language you want
That's absolutely insane. I know that no system is perfect, but how can someone get 10 years for a single threat over the phone?
> This is a failure at the city contracting level. Incompetence or corruption or both.

Solely? Editing out the contractor's actions seems to leave an incomplete picture.

edit: I suggest there is a fault with society, when society gives a pass to a business operating unethically - simply because it leveraged (or purchased, fed/state) loopholes that allow it to do so.
>So yes, no one really cares.

This is how I feel, I own all the Half-Life and Portal games on Steam, but since the 64 bit ARM transition they're just useless bits. And it feels like it shouldn't that big a problem to port them, but nobody seems to care enough.
Same here... Am also bilingual, and I seem to think in language only when I think _about_ language, e.g. when I plan what I could say or write. Otherwise, it is concepts or images.
To all junior SWEs: read a SQL book over the weekend. You'll end up being the respected DB expert on most calls after literally a few weeks. Most everyone never progresses above a SELECT with a couple JOINs and then complain the DB is slow and need to push work into the backend service where usually the opposite is true.
I think in words. There is always an internal dialogue. Even when doing music, or painting, I'm always anticipating what's next by some words; here comes the bridge, goes to Am now, gonna paint leaves in this shape, or maybe this other. I can visualize things and sounds, but words are always involved. That's probably why I'm not very talented at music or painting.
Doesn't the MTA pay $2.95 billion per mile of new track?
I've abandoned the idea of all humans use language the same way a long time ago. However I hope everybody does not use language as a tool to drive a car and looking at the work of Srinivasa Ramanujan I'm pretty sure no language was involved before it sparked.

"Language is a virus", Laurie Anderson ♫
Among software engineers it’s possible SQL is becoming a niche skill. I’m a data scientist and probably write SQL at least 4 hours a day, lately that’s been more like 10. SQL is an incredible language and I strongly prefer it to python for data processing.
Is there a term for predicates that are checked by static analysis when possible, but relegated to runtime checks when not?
The Government Created the Most Profitable Company in America - Verisign
Show HN: Open-source and privacy focused offline translation in the browser
I'm launching Linguist Translate, an open-source, full-featured translation solution with an embedded offline translator based on the Bergamot Project created by Mozilla.

Site: https://linguister.io

GitHub: https://github.com/translate-tools/linguist

Today, Linguist is launched on ProductHunt. Check it out: https://www.producthunt.com/posts/linguist-translate

Linguist is not just a wrapper over Google Translator like many other extensions. You can use any translation service with Linguist, thanks to custom translators! You may even deploy any machine translation (like LibreTranslate) on your localhost and then add this service to Linguist.

All features are included: text translation, full-page translation, selected text translation, Text-To-Speech, dictionary, history, and even more.
Author here. Mongodb offers primitives around filtering, group bys and orders, but calls them 'pipelines'. I'm not an expert on that, but it's quite possible. It's just a series of set and list operations after all.
But your comment is not a headline. You gotta at least write a blog post.
LOL...

And then there is Golang. SQLC ( https://sqlc.dev ) becomes a source of truth not a sink... mix in some yaml and you have your json tags and validation mixed in.

Candidly good engineers are still using SQL...
Tactics for going beyond 0-1 with LLMs?
I’ve spent my career as a founder / designer / PM. Getting past 0-1 to product-market fit is really rare with any product. When you introduce LLMs, you’re adding non-deterministic elements to your experiments. Sharing some of our process in the link.

Once you have demand, there are clear ways to scientifically optimize results. But in the early days, how are teams with features (in production, with customers) validating their ideas quickly?
This is what Sciter, Lexbor or litehtml are aiming for.
Why do you think so? The videos looked very impressive for the most part IMO.
It is of military strategic concern though, oftentimes electricity is easier to source than a logistics chain of fuel.
Not completely. The Postmodernists do use language to shape people's thought by redefining words and eliminating wrongthink words. And they have been successful.

But they mainly influence people who are not thinking to begin with. Or, to put it more mildly, do not have time to think about every issue and therefore adopt the current mainstream propaganda.

So in the sense "Can we conjure up a fake reality that many people will believe?" they are right". In the sense that "language is reality or even thought they are of course wrong.
It seems either the group or the order is missing?
France gives an allowance and health insurance! If you're seeking asylum there. https://domasile.info/en/what-social-rights-do-i-have-as-an-...

I'm willing to bet that this is still the situation in a decade, because there really aren't any other approaches that aren't horrific. There's no sign that Labour understand this or have any plan for improving it.