skysight-inc/HackerNews huggingface dataset:
Yes, it is possible to connect to the database directly and run an arbitrary query. Example:

$ clickhouse-client --user website --host kvzqttvc2n.eu-west-1.aws.clickhouse-staging.com

clickhouse-cloud :) SELECT t, desc, count() AS c FROM planes_mercator_sample100 GROUP BY ALL ORDER BY c DESC LIMIT 10

┌─t────┬─desc────────────────────────────┬────────c─┐
1. │ B738 │ BOEING 737-800 │ 51530781 │
2. │ A320 │ AIRBUS A-320 │ 37196762 │
3. │ C172 │ CESSNA 172 Skyhawk │ 20049393 │
4. │ A321 │ AIRBUS A-321 │ 19983151 │
5. │ A20N │ AIRBUS A-320neo │ 14938832 │
6. │ B38M │ BOEING 737 MAX 8 │ 14200826 │
7. │ B737 │ BOEING 737-700 │ 13929403 │
8. │ A319 │ AIRBUS A-319 │ 13906164 │
9. │ E75L │ EMBRAER ERJ-170-200 (long wing) │ 12006441 │
10. │ A21N │ AIRBUS A-321neo │ 10965047 │
└──────┴─────────────────────────────────┴──────────┘

Add FORMAT CSV to output in CSV (or any other format).

To obtain an SQL query for a particular region, you can open the browser dev tools (F12), switch to Network, and copy a particular request that is made when you select an area with the rectangle selection tool.
The UK and US only recommend about 60g of protein a day for males which is easy to hit and I specifically mentioned non-althetes.

> You'd pretty much have to eat some kind of fermented soy product every day to get enough protein through semi-normal meals, which is workable I guess though very boring.

Althetes eat pretty weird and repetitively anyway, lots of chicken and protein shakes. TVP, seitan, tofu and tempeh are versatile, and there's plant based protein shakes too.
I purchased a Kobo Libra 2 and it is indeed fantastic. Battery life is incredible, and syncing with the Libby app for books from my library is fantastic. I do wish it could integrate with Raindrop as opposed to Pocket, but the Pocket works okay enough. Can transfer .pdf or .epub from Linux/Mac/Windows easy, and it looks great on the device.
How do you remove the incentive? Don't allow free accounts?
The not entirely legit part might be their GPL violations. AFAIK, they still are out of compliance.
Beeper, who tried to bring iMessage to Android, acquired by Automattic for $125M
Avi Wigderson is 67 years old on got his PhD in 1983. Seriously, how hard is this to understand? Just do the math.
I addressed this earlier: https://news.ycombinator.com/item?id=39991837

When you record transactions in accounting, you're updating various account balances, such as assets, liabilities, and equity. These updated balances contribute to the creation of the balance sheet, which provides a snapshot of a company's financial position at a specific point in time.

The income statement, on the other hand, reflects the changes in these balances over a period of time. There's nothing special about the line items on the income statement (e.g. revenue or expense). Any value on the income statement represents a change in what the company owns (assets) or what it owes (liabilities or equity).
I'd say the primary problem is the attitude that there's nothing you or anyone can do about it.
On a forum that's funded entirely on the premise of small startups eating the lunch of big incumbents, this is a weird take.
I learned that "Nimble" is the new name for "Alpha", discussed in this 2023 report: https://www.cidrdb.org/cidr2023/papers/p77-chattopadhyay.pdf

Here's an excerpt that may save some folks a click or three…

> "While storing analytical and ML tables together in the data lakehouse is beneficial from a management and integration perspective, it also imposes some unique challenges. For example, it is increasingly common for ML tables to outgrow analytical tables by up to an order of magnitude. ML tables are also typically much wider, and tend to have tens of thousands of features usually stored as large maps.

> "As we executed on our codec convergence strategy for ORC, it gradually exposed significant weaknesses in the ORC format itself, especially for ML use cases. The most pressing issue with the DWRF format was metadata overhead; our ML use cases needed a very large number of features (typically stored as giant maps), and the DWRF map format, albeit optimized, had too much metadata overhead. Apart from this, DWRF had several other limitations related to encodings and stripe structure, which were very difficult to fix in a backward-compatible way. Therefore, we decided to build a new columnar file format that addresses the needs of the next generation data stack; specifically, one that is targeted from the onset towards ML use cases, but without sacrificing any of the
analytical needs.

> "The result was a new format we call Alpha. Alpha has several notable characteristics that make it particularly suitable for mixed Analytical nd ML training use cases. It has a custom serialization format for metadata that is significantly faster to decode, especially for very wide tables and deep maps, in addition to more modern compression algorithms. It also provides a richer set of encodings and an adaptive encoding algorithm that can smartly pick the best encoding based on historical data patterns, through an encoding history loopback database. Alpha requires fewer streams per column for many common data types, making read coalescing much easier and saving I/Os, especially for HDDs. Alpha was written in modern C++ from scratch in a way that allows it to be extended easily in the future.

> "Alpha is being deployed in production today for several important ML training applications and showing 2-3x better performance than ORC on decoding, with comparable encoding performance and file size."
The main difference from Funkwhale to the "streaming" services is that you need to "build" your music catalog, either by uploading your own music collection and/or following other people's libraries. So, "out of the box" you are not going to get any music available unless you join some instance which has an extensive catalog of copyright-free music or gives public access to songs they own copyrights.

For your use cases:

> I'm driving and want to listen to (...) mixture of music

Yes, Funkwhale can create "radios" which generates playlists like what you describe. You can choose to generate the playlist according to how often you listen to it or whether it is your "favorites" list or not.

> I want a random assortment of chill classical music to lull me to sleep or get into a relaxed mood.

If you have already access to this music, the radios can be set according to a specific genre.

> A song comes up in conversation and I want to quickly pull it up

That will depend on whether this song is available to you on the instance.
Thank you. I really appreciate that.

It still feels exactly the opposite of what I thought a credit and debit were. Surely when you add sheep, you credit the sheep account and debit the cash.

I get it. It's just a shift.
A mix of cowardice and bravery in a human way.

A hero doesn't slink away to a dictatorship to save his skin. A normal person would do this. Most of us, maybe.

But should we be celebrating that?

And it should also make us question who benefitted from what they were doing, and maybe realize that these people were geopolitical players batting for a particular not-so-nice team rather than independent heroes for freedom.
And since when are removable batteries worse for the environment?
If what you mean by “am I missing anything?” is “am I missing out [if I haven’t/won’t read it]?”, then possibly, yes. The concepts are timeless, and depending on what you already know, you may learn something useful, or at the very least something stimulating.

I read the first edition way back when, and thoroughly enjoyed it.
agilend.tv - TV channel for business-centered video with embeds from Cloudflare serverless and YouTube.
Always needs two entries to keep assets equaling liabilities plus equity. If you do anything it effects both sides of the equation, thus “double entry” is required to keep this relationship. It’s the accounting equation.

https://www.investopedia.com/terms/a/accounting-equation.asp
The person you're replying to is confused, but that's because accounting can be confusing.

An account is fundamentally either an asset or a liability. When you buy something with a credit card, you've incurred a liability, and gained an asset, no matter what you've purchased. If you use a debit card or cash, you're trading one asset for another.

One of the basic asset categories is expenses. That's the confusing part! When you acquire an asset, which is consumed or otherwise has no book value, that's an expense.

So when you buy groceries with a debit card for a hundred bucks, that's a +100 in Expenses:Groceries, and a -100 in Assets:Checking. If you buy the same groceries with a credit card, it's +100 in Expenses:Groceries, and -100 in Liabilities:CreditCard. When you pay off the credit card, that's -100 Assets:Checking, and +100 in Liabilities:CreditCard.

Asset is overloaded here, because Expenses are not included in calculating net assets. It's confusing! I find it even more confusing that Income is a liability, which always gets lower. That's because whoever paid you had a liability to do so, which they met out of assets.

This is also why, when you pull a CSV of a checking account, purchases are positive numbers, and income is negative. A CSV of a credit card will have purchases as negative, and payments as positive. It's the difference between an asset account and a liability account. Again, not to be confused with net liabilities: Income is a liability, but not one you owe anyone, rather the contrary, Income just gets smaller and smaller (ideally! If it isn't getting smaller then your net assets will be shrinking, most of us can't afford that for long).

The main thing is that an account which fluctuates from zero to positive, or accumulates, is an asset account. One which fluctuates from zero to negative, or accumulates negatively, is a liability account. There are times when this matters, notably when you can take a tax deduction for expenses, that's a good example of why they're on the asset side of the books.
Republicans in power -> rural voter base dying off -> democrats get voted in -> expand Medicare and tax unhealthy habits -> rural voter base stops dying -> republicans get voted in because “big government”

Rinse and repeat
And with a dead flat black bezel too. Likely the promo pic is not how it would look to your eyes in real life.
OK, I stand corrected ... but lezginka or zikr, what about the tempos? both seem "too fast".

(and do you have any opinions on what opinions Kadyrov might hold on Nasruddin?)
Show HN: I Made Chai - AI in your CLI
It's AI in your CLI to help you with shell commands every time you get stuck.
This was my thought. Floppy emulators are a dime a dozen thanks to the retrocomputing community. Emulators for the custom boards full of discrete logic, opaque ROM chips, PLAs, and so on from long dead companies are going to be a much bigger challenge.

If they had good schematics for all of the parts it might be possible to keep the the system running for a long time with a couple of smart EEs who are comfortable with the scope and soldering iron, but eventually they're going to run out of some obscure part and be up a creek.

Or maybe they could replace entire boards with home designed versions condense all of the old logic down to one chip and a handful of support components and start in-place upgrading without a total system revamp. Still an expensive process, and one that requires some hard to find engineers on staff, but theoretically spreads out the upgrade process over many years. It also loses out on functional improvement opportunities while your system is made up of a hodgepodge of old and new hardware.
or you could just write the code in the first place in a language that doesn't have maintainers that intentionally break old code. that's what you would do if you aspire to write code that constitutes part of the intellectual heritage of humanity, as opposed to being an expedient way to resolve a problem you have this week, to be thrown away in a month or two. you can still compile c code that uses gets(), you know. a couple of years ago i fixed a perl cgi script i'd written in 01998 to work with current perl; it took me half an hour. and euclid's proofs are still valid 2500 years after he wrote them down
> When I deposit money, it modifies two accounts at the bank.

Yeah, I get that. I don't see what that has to do with the labels used to describe the transaction.

Actual physical cash is weird because it's an asset to its owner and a liability to the rest of society. But when you deposit cash in a bank, the bank doesn't become the owner of the cash. It has borrowed that cash from you. So that cash is both an asset (because having borrowed it from you it can turn around and loan it to someone else) and a liability (because the bank is in debt to you for the amount of the deposit).

A simpler example is depositing a check. In that case, money just gets transferred from the payor to the payee. It's a debit from the payer's account and a credit to the payee's account. Or at least that's how it should be.
Whose music did you use to train this thing?
Ask HN: What are your favorite puzzles?
who owns the washington post?
And the people involved walk away whistling without consequences. It doesn't matter if the fine is 0.1%, 10%, or 50% of yearly revenue if you're not the one paying it.
> Who gets promoted when they juke the stats to say there isn't a problem?

Who says there isn't a problem? IME many people says there is a major one, that the US needs to revamp its healthcare system, and rural voters vote against it.
I used LANs half a decade before connecting to the wider net. SBCs and VMs are much greater resources than I learned on. Routers are cheap, I just set up a dynalink with openwrt for $75.

No one is asking teens to set up a production kube cluster. There’s so much to learn—they’ll be fine.
Zikr is a style of prayer. Not music.

For most lezginka they're 100% ignore it.

Basically it's an excuse to crack down on non-Chechen language music and culture.
meta has billions. Other startups can't just donate their IP to the world and then raise money to do multimillion training runs
Maybe they need a new slogan to help folks with the transition. Something like: "Don't tweet, Xcrete!"
I'm curious how the newer consumer Ryzens might fare. With LPDDR5X they have >100 GB/s memory bandwidth and the GPUs have been improved quite a bit (16 TFLOPS FP16 nominal in the 780M). There are likely all kinds of software problems but setting that aside the perf/$ and perf/watt might be decent.
I disagree on that point, I think it’s totally possible to live healthily without eating anything that comes from an animal.
> The above and I don't ever have to run security updates or patch an OS.

Have you been involved in the xz project in the last 2 years? Curious.
The first time has some informative content, or at least some ironic clip-art to copy to your next presentation. The 3rd time and on it's just repetitive. Makes me jealous of the Microsoft employees from the other story about training videos.
That’s the McGregor effect. Both the fighters and the org realized that they get a lot more sponsorships and audience with the WWE drama. Most fighters have a short and injury prone career so I don’t blame them for trying to make some money. There are still plenty of fighters who don’t take part in the nonsense
Yes, pretty well all of the big firms have one big product they're selling: cover for questionable behaviour.

They usually don't just break the law or cheat out of simple desire to. They're for hire and openly compete with their willingness to "transform", "cut red tape", "do things differently™" which are euphemisms for questionable behaviour, usually at the public's expense but their customer's gain.
From the YC Startup Directory for W24 [0]:

USA: 195
UK: 6
Canada: 4
France: 4
Germany: 2
India: 2
Nigeria: 2
Brazil: 1
Kenya: 1
Sweden: 1

0 - https://www.ycombinator.com/companies?batch=W24
Even better, I want to pick components from a tool window, move them around and resize them with the mouse and have the code automatically generated for me, if possible well hidden so I don't even have to look at it.

Somehow this was standard twentyfive years ago, how could we have regressed so much?
I would vote this down if I could for the following reasons:

- I prefer state-based TDD as opposed to interaction-based (see https://martinfowler.com/articles/mocksArentStubs.html).

- I've used both testcontainers and dockertest, and from my experience dockertest is more robust.

- The capital T for the outer argument comes across as being hypercorrect. Why would one consider the shadowing of this argument bad?
The point is that it also beats the baseline on every other size (1B and 3B). So it wouldn't be surprising to see it beat a 7B transformer model like the 6B model. Note 2 on page 5 probably explains why the sizes are different.
I don't think the article is a reflection on efficacy of the public agency. If their budget for new software is $0, how exactly are they supposed to upgrade it? It's certainly possible that the agency has been utter shit for 25 years, but this article doesn't give the information to conclude that.

> Perhaps they should earn those resources competitively instead of being given them?

How? They're a public agency. There is no profit motive - if the public wants nicer stuff, they need to pay for it. That includes both the software costs and the higher salary costs to hire people capable of those types of projects.

Again, you come off as someone running their mouth with no actual experience interacting with public agencies. It's very frustrating to know how to fix a problem without being given the resources or permission to do so, which is often the case in transit. Add to that most transit agencies have a tiny budget for IT, and I'm not sure how you expect this to get solved without a big public push.
Transit employees are not the same people as, nor have the same motivations as the politicians who manage transport agencies.

Of course the employees work hard. It’s the vocation they’ve chosen. I’m always amazed by the diligence of TFL and rail employees in the U.K., for instance.

No, the guiding principle for the folks at the top is “so, how can I make money for myself out of this before I fail upwards?”.

I’d wager the SF situation is just the same old looting by the Very Important People who run the show, leaving employees and actual managers with a shoestring and two peanuts to make it all work, while the head honchos bathe in gravy.
Zee

Zeh

Zay

Chee

Cheh

Chay

Hee

Heh

Hay

Ecks-uh

Ecks-Eee (really strange that this is the "real" one considering it doesn't resemble an acronym)

Ecks-ay
If we are talking about basic reasoning, you know that doesn't mean there is not a major problem of discrimination at this end of the pipeline.
I broke my big toe sparing once when it hit my partner's kneecap. That was my worst injury to date.

She said last time that happened with someone during sparing it broke her kneecap instead, so I guess I was 50/50 on that one.

People are shocked when I tell them that a sport where you try to hit other people in the head has a shockingly low rate of injury.

> Some places require head protection too, but I'm not sure if that actually protects you vs just giving your opponent a false sense of "it's okay to hit you harder".

Plenty of studies have come out showing that head gear increases the rate of injury, to the extent that head gear and padded gloves should just be banned in every gym.

The safest way to spare is bare knuckle with a mouth guard. No one in their right mind punches full force when bare knuckle, at least not more than once.

(Also, bare knuckle, still wrap up, and hit with the first two knuckles. Boxers in thick gloves learn to hit with the bottom two knuckles, which will shatter the shit out of any hand that tries to do that without gloves on...)
Drones are at their best right now. Few random NSFW clips:

2 days ago https://www.reddit.com/r/UkraineWarVideoReport/comments/1byq...

4 days ago, big armor assault stopped with at least over $10mil destroyed by DJI/fpv drones and arty https://www.reddit.com/r/UkraineWarVideoReport/comments/1bxg...

4 days ago https://www.reddit.com/r/UkraineWarVideoReport/comments/1bx1...

6 days ago $1mil tank erased by two $500 drones https://www.reddit.com/r/UkraineWarVideoReport/comments/1bv9...

This article is about "Drones from American startups". That is Skydio and AeroVironment (Switchblade). DJI are cheap, readily available from your corner importer, reliable and offer world leading performance. There is visible gap between quality of picture from DJI and "military grade" Skydio, second one is worse despite being much more expensive. Switchblade 300 cost almost as much per one small anti personnel unit as whole Stugna launcher system, Ukrainians developed their own loitering munition now:

https://twitter.com/Osinttechnical/status/177806496555700666...

Lack of cruise missile deliveries from the west forced Ukrainians to develop bigger kamikaze drones based on ultralight planes manufactured in Ukraine, range over 800 miles https://www.theguardian.com/world/video/2024/apr/02/ukraine-...
Ask HN: Who's planning to move soon to Porto, Portugal?
Curious for demographic purposes :)
Came here for this comment. I’ve always kept an eye open for anyone who has applied this insight to something. There is something also satisfying about how accessible accounting is vs any other domain you encounter invariants (like noethers theorem, group theory, or equivariant neural networks)
Doesn't Cerebras already have a trillion ?
They're a little off when looking for 32bit overflows: unsigned 32bit integers top out at ~4gb, that kind of bug would've shown up much smaller than 32gb.
These Russian intelligence smears seem unsubstantiated but also irrelevant. Let's say they are both explicitly Russian agents. Why does it matter? Do you have any thoughts on what they revealed? Does that offend you as a citizen of this world? Do you think the secretive mass surveillance programs or activities in diplomatic cables were acceptable? Unless you think the revealed information is factually false, I don't think the source matters. But clearly the aggressive reaction from the US government, news media, and others suggests that everything revealed was real and accurate.

As for the "creep" comment - this is a vague labeling that isn't possible to debate. You either agree with it based off a subjective assessment or you don't. But if you're referring to the rape accusations made against Assange, those charges were ultimately dropped, because "the evidence has weakened considerably" (https://www.bbc.com/news/world-europe-50473792). The entire saga of those accusations seems suspicious and feels like a tactic to extradite him.

Regardless, all of this is a distraction. The things revealed by Wikileaks and Snowden are far more important and significant to society than this minutia. Somehow detractors always want to point at lesser issues around Assange or Snowden instead of addressing the many elephants in the room.
Ironically, Æ is the most useful part of this child's name. Ash short for Ashley or Ashleigh is common for girls and boys in Britain. Wikipedia suggests the name is mostly for girls in the USA.
I very delexically read that as bogroll and was quite confused