skysight-inc/HackerNews huggingface dataset:
I don't think it's reasonable to expect we can keep China from manufacturing state of the art chips.

What we can do is make sure we are not entirely dependent on China and/or Taiwan for the supply of such chips in our products. That makes sense. Trying to embark on some quixotic quest to stop China from innovating doesn't, and isn't likely to work.
I don't need to be sold on the virtues of applications running on systems like SQLite. The nineties had a lot of servers which were very simple (and performant) compared to LAMP, and I like systems like that.

What I would like is a good primer about the layers on top of SQLite. What does Litestream do for me? How does it compare to competitors? Why not just use SQLite directly? A more in-depth technical discussion would be nice. I'd also like to understand wrappers and ORMs for migration to other systems, should SQLite stop scaling.
>Someone burns a koran

You should look up who gives money to people who do that, and what political movement they represent. You should then look up this book [0] and who also gets money from the same group of people. I'm sure a lot of things would become more clear to you.

[0] https://en.wikipedia.org/wiki/Foundations_of_Geopolitics
Author here. Cool to see the post make it up on HN again. I'm still as excited as ever about the SQLite space. So much great work going on from rqlite, cr-sqlite, & Turso, and we're still plugging away on LiteFS. I'm happy to answer any questions about the post.
And of course, both translations have to do without the "fingidor/finge dor" wordplay.
I remember that. It was a really good store, the first of its kind IIRC. Every so often I think about what happened to the games I owned on there?
Hydra (YC W22) - Pricing Blueprint
OCI registries.

Harbor + Notary + admission controllers - AKA private image repository with image signing.

Sigstore. Another method for signing & verifying artifacts.
It's not iPhones that are the problem, it's everything built with modern technology. Do you honestly imagine that modern antibiotic manufacturing is anything but computer-controlled?
Does it surprise you that despite many working from home, the world in general kept on trucking along? Of course CO2 PPM kept rising. Where people work isn't the only cause of carbon emissions.
Has anyone compared this to YNAB4? (Not the cloud-only subscription-only YNAB, but the good one that was killed off in 2019)

It's by far the best household bookkeeping tool I've ever used, but it won't ever get updates again (running it in a VM just so I can make sure I will always be able to run it), and it would be nice to have something that can track stocks and maybe even foreign currency - but for now, I would be happy with something that can just replace YNAB4.

The lack of Quicken OFX Import is a bummer :( But if the CSV import is good, it would still work. (As much of a pain as OFX is to implement for developers, especially since there's at least two major versions, it is pretty widely supported by US banks to download my transaction history)

Will probably give it a spin on the weekend, since the demo actually looks promising!
I hear ya. Here I'm hoping that with Apple Silicon and GPT, maybe some devs will take it upon themselves to port games even if Apple and Valve don't.

Gaming on Mac is definitely not my first choice, but I don't have the time, energy, or budget to deal with separate computers these days (or the fan noise and summer heat of a desktop GPU). Limited to whatever comes out on Mac or GeForce Now :/

And unfortunately it's hard to use Linux on desktop for frontend work. Adobe Suite is a must for me, and Linux font rendering is different enough to Macs and Windows that it's hard to get an apple to apple comparison of how a web page would look on mainstream computers.

I'm sure it's come a long way though! When I first tried desktop Linux in the 2000s, it didn't have the right fan drivers and melted my laptop, cracking the glass table underneath lol.

In the meantime... off to play BG3!
They declared bankruptcy in 2021....you sure you really wanna own that stock?

(they emerged from it successfully though)
USB 4 uses the same port so it will be around for another 10 years most likely.
from their announcement was "Unity Personal and Unity Plus: Those that have made $200,000 USD or more in the last 12 months AND have at least 200,000 lifetime game installs." but looks like they are backpaddling after some "leaked document" saying that they would use similar rule as Unreal, but ask for 4% instead of 5% as Unreal does.. Unreal is the only real solution against Unity.
Why not? They pollute more because of this decision (assuming we're talking about a desk job of course)
Bone-marrow transplant from the mother followed by kidney transplant from same, without organ donor rejection, and thus no need to take immunosuppressants forever.
I recently saw the launch post of Electric SQL which syncs to SQlite, I like the pattern on how keeping the data close to the frontend can solve many problems, if synced with the main DB. I hate to run another docker or manage service to manage this layer but if somehow a part of data from the database like Postgres can be synced using something simple like litestream and can be placed either on edge or client can be a solution to many of the problems.
Nitpick: the author is female
> Why isn’t this practice that workers clearly love, and are willing to leave companies to keep, seen as a great step in the progress of labor?

It's better to think of people as individuals, and not as "labor" or "not-labor". I think remote working is great for this, much better than top-down mandates on cars and congestion zones, although those swell the tax coffers nicely, but I don't think it's a great victory. Lots of people (particularly those who do actual physical labour, such as builders and shopkeepers) have to go to a workplace. It's not a victory for them, because lumping people into tribes means category errors abound.
Yes, and when he got there he put his feet up and closed his eyes.

https://youtu.be/0JQbeCAlF6s?t=61
Thanks, I did not know about Scrypted!
They're there for the storefront alone and it shows. Valve's vision was to become the _platform_ for the PC and then add a store.

GOG at least tries to do things right with far less resources. The rest are simply abysmal.
Anyone who thought streaming and cutting the cord was a solution to the cable tv was ignorant of businesses desire to make money and reduce cost.
Good perspective. Unfortunately (1) is unavoidable when you're trying to automate GH itself (role assignments, tagging, etc.). But at this point, I would rather handle a lot of that manually than deal with GHA's awful debug loop.

FWIW, there's nektos/act[^1], which aims to duplicate GHA behavior locally, but I haven't tried it yet.

[^1]: https://github.com/nektos/act
As much as I like half life games, there are a handful of studios capable of creating interesting sci-fi shooters but no other company can really have things like Steam Deck, Proton, etc. as some of their core products
nope, its not PCA :)

but yeah you can archive similar results with a PCA if you want.
Cool! Didn't know about this. Thanks.
They pay them by paying their employees, who pay for transport.
> 7 degrees F

Typo? Pipes freeze and burst at that temperature.
How to Protect Against Insider Threats: 5 Trending Approaches for 2024
> When you put your data right next to your application, you can see per-query latency drop to 10-20 microseconds. That’s micro, with a μ. A 50-100x improvement over an intra-region Postgres query.

Why compare the latency of a remote Postgres database with a local SQLite database? If your app is so simple and self-contained that it runs on a single EC2 instance using local files, nothing prevents you from installing Postgres on the same machine, whether inside a container or not.

I have some simple apps on EC2 with MariaDB on localhost, and well-tuned queries rarely take more than 100-200 microseconds. That's total query execution time, not just communication latency. RDS just sucks for this kind of use case. It's not a useful comparison.

> As much as I love tuning SQL queries, it’s becoming a dying art for most application developers. Even poorly tuned queries can execute in under a second for ordinary databases.

Didn't you just say that milliseconds matter?
You could read the article that you had to scroll past to look at the chart.

Can we see a change in the CO2 record because of COVID-19?: https://gml.noaa.gov/ccgg/covid2.html
Natural monopoly in the formal macroeconomic meaning of very high fixed cost with virtually zero marginal cost (ex. it costs ~nothing to transmit an extra watt of power, fly one more passenger, insure one more person, etc). In these cases basic econometric theory shows that production cost is lowest with a single provider, adding two or more competitors increases total cost of production without changing the total output. Obviously nothing obtains these conditions precisely in the real world, but in general the principal holds for big infra stuff. I think your example of a bus system faces the obvious fact that the US dumped a ton of resources into private auto travel which makes it challenging for any public/shared transit to succeed.

The power grid is another classic example of a natural monopoly, it costs a lot to make a power plant and hang a bunch of wires, but once it's running it's basically free to send a small unit of additional power to a person. For this reason the US was going to nationalize the grid back in the 20s but at the last minute decided to lease to a "regulated monopoly" private corp (IIRC it was some dude in Chicago who convinced them to give him the lease). Texas tried to roll this back in the like the 90s and their power costs shot through the roof and still remain nationally high.
Apple forgot to make a new iPhone this year [video]
What software have you used that does this?

So far every time I've relied on automatic categorization for this sort of thing it fails horribly. I don't think I've used anything that's GPT based though.
Thanks for the reply.
Is the code available by any chance?
Coming 2025.
Most banks (at least in the US) allow a data export, usually in Quicken/OFX or CSV format. I download the transactions from my accounts once a week or so and import it into the tool. (PayPal gets charged to my credit card, so it shows up on the credit card import, no need to track PayPal separately)

I currently use YNAB4, and I've assigned categories to Payees, so when it sees a transaction to e.g., my local Pub, it knows to categorize it as Food. For stuff like Amazon or eBay, I need to manually categorize each transaction, but that takes a minute or two.
> am so confused why HN is so tolerant of startup grifting, but dismisses cryptocurrency as an absolute evil

I mean.. it’s a site associated with a notable VC organization.
You've never met anyone who's used Slack, WhatsApp or Airbnb?
Living in So Cal, I was fortunate to get to see Oingo Boingo several times, all at small venues, including once as their “fan club name”, the “Clowns of Death”.

They never really made it big nationally, or chose not to, in terms of touring. I even saw the then new “Red Hot Chili Peppers” open for them, who far eclipsed them is n popularity.

But at the same time, they were very local, and really accessible to local fans.

They did a few large venues, but I never saw them at any of those. Elfman is said to have stopped touring due to the risk to his hearing because of how loud concerts were becoming, and him and Steve Bartek (Boingo guitarist and collaborator) transitioned quite successfully to movie soundtracks.

I have to assume the advancements in things like in ear monitors make live performances much less damaging for performers. I’ve worn ear plugs at concerts for years.
I've been to company all hands meetings I would describe as that.
> You can’t control your taste.

Author might not be able to, but it's hasty to generalize this to everyone. I, for example, can. It's simply a matter of knowing one's self enough to know where taste originates and what principles and beliefs it's founded on.

I had to stop reading at this point as I couldn't take the rest of the piece seriously.
Yes you’re right for new movies. People are bored of the formulaic crap. Alamo replays a lot of popular movies, and those have been much busier. Kubrick and Christopher Nolan movies. The recent Dune. Rerelease of The Exorcist. Etc.
Why is it not a victory for them? Less congestion on the roads, higher prices for their labor since WFH work is more attractive.
And how long did it take to build those 6GW? from project start to finish?

And no, solar power is equal to nuclear power. Where is my solar power night time?
> Fundamentally, the problem is that the worker should be given incentives to bring their income to an area

This can be done naturally, if local government intervention is low, so there's more money for local businesses to spend, or unnaturally, if local government intervention is high, so local businesses have less decision power, and the local government spends that money on infrastructure for companies coming in who pay less tax.
Is there any good non-web non-plaintext (which is unsuitable for rich data despite its initial allure) alternative?
First of all, no. Stop using this reasoning. Police only work _AFTER_ the car has been stolen. "Greater Police Presence" (that's one hell of a euphemism) only ever prevents crimes of opportunity.
i.e. The Drunk Guy throwing a beer bottle at a window.

Police do not prevent crime, they apprehend people that they then accuse of doing the crime.

When you have somebody actively looking to steal $THING, they will find it and steal it.

You do not see these massive Kia/Hyundai thefts in countries that mandated immobilizers in all new vehicles.

So it is a failure of policy, not policing.

Adding some sources.
https://www.ojp.gov/ncjrs/virtual-library/abstracts/role-pol...

https://www.washingtonpost.com/politics/2020/06/07/over-past...

https://prismreports.org/2022/02/23/police-dont-stop-crime-b...
The Verge isn't paywalled though?
Use Postgres. Or if you insist on this type of architecture use CouchDB. I shudder thinking about a SQLite schema migration across clients with potentially unknown versions.

Seems like a disaster waiting to happen unless you have a bunch of logic centralized somewhere to keep track of last know schemas per user client database. And if you’re going to do all that, unless you desperately need low latency (in which case you could use a multi region database like cockroach), why not just centralize?
That’s a real possibility. The more money you pay to avoid ads, the more valuable you are to advertises.

I hope that it’s not inevitable though because there are so many streaming services, and because piracy and VPNs are an option.

If I had my way I’d create regulation that forces companies to offer ad free versions for some multiple above the ad supported price.
> each of your webheads has its own clock. Use the database clock!

Yes, for consistency you should use the database clock by embedding the calls to `now()` or similar in the query instead of generating it on the client.

But it's not sufficient to use these timestamps for synchronization. The problem is that these timestamps are generated at the start of the transaction, not the end of the transaction when it commits. So if you poll a table and filter for recent timestamps, you'll miss some from transactions that are committing out of order. You can add a fudge factor like querying back an extra few minutes and removing the duplicates, but some transactions will take longer than a few minutes. There's no upper bound to how long a transaction can take in postgresql, and there's a lot of waste in querying too far back. This approach doesn't work if you care about correctness or efficiency.
Do you use https://www.sqlite.org/cgi/src/doc/begin-concurrent/doc/begi... ?
I think a lot of people are less productive when they work from home. It's easier to switch into "work mode" when there's a specific physical location where you only work.

A separate room as a home office probably has the same benefit though.
If you have a modern heat pump system, it's often more energy efficient to keep it at a steady temp. They become more efficient the less they have to work. This means if you're changing the temp while at work, there's a spike when you return where it has to work harder. The efficiency loss there is often worse than what was saved by changing the temps while you were away.
One thing that actually makes this slightly less horrible is the Gh tool. You can use gh run watch to tail your logs in the terminal and at least don't have to click through a million things just to see output.
1. He's the chair of the board, so he has an outsized amount of control. He could easily fire the CEO or any other C-Suite members if he wanted to.

2. He owns a bit more than a minority stake, he owns (I've found several estimates, so I'm putting in a range here) between 9% and 12.5%. That's hardly a minority stake for a company worth nearly $1.5 trillion. He's the single largest shareholder.

3. Maybe not a full on monopoly, but AWS has the same market share in the cloud space as the next two providers combined. (MSFT + Google). That's as close to a monopoly as I can think in of a competitive industry without getting trust busted.

4. Most people I know would prefer to keep things the way they are - they pay for a premium service on top of already paying for Prime. If Amazon offered Prime Video for free but it was ad-supported, I'd be fine with that. I don't think I'm alone when I say that if I'm paying for a premium service (Video) on top of already paying for a service (Prime), Amazon shouldn't be allowed to triple-dip by selling ads.

Streaming platforms usually have ad-supported tiers, yes, but most of those are either free or very cheap.
Neural networks are Turing machines. You can make them perform any computation by carefully setting up their weights. It would be nice to have compilers for them that were not based on approximation, though.
In the code example for virtual threads, I have no idea what will happen in parallel.

How do I reason about the order in which the calls change the state of the world?
Mine is Doogee, first saw it in 2017. They were truly ahead of their time (maybe still are?)
The difference is that nobody is harmed in the scenario where someone makes a closed source product with permissively licensed code. The original project is still there and still just as usable. Everyone still has the same freedoms as they did previously.
I have personally rejected a candidate that claims to know professional security tools but maintains that it is not his job to filter out false positives ("because they don't exist") before presenting the results to the developer team. The same candidate would also say "you need a firewall" but would not be able, in an interview setting, to explain how to protect the database server using a firewall - i.e., what exactly to allow.
At least make your own argument, don't ask ChatGPT to do it for you. ChatGPT is really stretching to make your point though, as you can see from the laughable use of the phrase "Another striking resemblance between browsers and operating systems" after just listing a bunch of web APIs that no one cares about. (WebVR? Get out of here...)
If you're viewing that website on a desktop, I strongly suggest removing max-width: 90ch from the body css. Instead of 50% white space, it goes full width and makes the table substantially more readable (particularly the code samples).
The point is that "diversity statements" can be used as a smokescreen to obscure gender and racial discrimination. What makes one diversity statement better than another? Are they graded anonymously, with any racially or gender identifying info stripped out ("as a ________ I bring...")? Only vague answers are given.
And other race cars get the best of both worlds.

Le Mans cars and other touring cars are famous for holding up 24hrs under very high loads, even with the engine strung out beyond its street legal spec, but I think the most impressive feat is the Baja 1000.

Modern trophy trucks make ~1000 horspower, and the load is insane. The engines are running a pretty high average throttle, at high RPM, pushing a giant, heavy truck through sand, in a blazing hot desert. The fine dust can clog the filter, radiators, and get in all sorts of crevices. The whole drivetrain is constantly being shocked as the wheels leave the ground then jolt back to the correct RPM when the truck lands. And the whole truck is constantly being G-shocked, crashing into terrain you wouldn't even want to hike over at highway speeds, over and over again, for 1000 miles.

This was impressive back when the trucks were making a mere 300-600 horsepower, but honestly I have no idea how the modern turbocharged monsters even hold up.
Valve's 2 hour refund option came in direct response to a 2014 lawsuit from the Australian Competition and Consumer Commission[1].

Rod Sims, head of ACCC at the time, asserted that Valve's original no-refund stance broke Australian law.

> Under Australian Consumer Law, everybody who buys a product or a service has a right to a refund if the product doesn’t work. They have a right to a refund, or a repair. Those rights are enshrined in Australian Law, and our allegation is that Valve sought to remove those consumer rights which is a breach of Australian Consumer Law

[1] https://gizmodo.com.au/2014/08/accc-commissioner-heres-why-w...
@ananthakumaran, can this be installed via Docker and ran in the browser like your demo[1]?

[1]: https://demo.paisa.fyi/
If only competitors could do better...

https://gitlab.com/gitlab-org/gitlab-runner/-/issues/2797
I live in Mexico and talk to people here about the clowns that are running for president in the US. It's genuinely embarrassing.
Edit to address actual reasons it would be bad:
1) Mexicans (in Mexico) distrust the US and its military. The US should not damage the remaining trust it has with an enormous trade ally. That would push Mexico towards China.

2) Could the US significantly damage the cartel(s) on their own turf?

3) What are the cartels? Are they the literal president-level politicians who are affiliated? Should the US "take them out" too?

I could go on but really the short answer is that the US would end up causing a mess, ruining the lives of normal people, and damaging its relationship with a major world economy and major trade ally.
UK Consumer Rights Act gives you two weeks for no fuss return of items bought remotely. IME, Steam do not adhere to the law here.
It's been a little while since I've looked into the Open Banking API stuff - how easy is it to use this API as a consumer? Or do I have to create a business and apply for a license in order to use it?
Making a Micro Linux Distro