skysight-inc/HackerNews huggingface dataset:
It seems like the locking is page-level in "wal" and "wal2" modes:

> Usually, SQLite allows at most one writer to proceed concurrently. The BEGIN CONCURRENT enhancement allows multiple writers to process write transactions simultanously if the database is in "wal" or "wal2" mode, although the system still serializes COMMIT commands.

> When a write-transaction is opened with "BEGIN CONCURRENT", actually locking the database is deferred until a COMMIT is executed. This means that any number of transactions started with BEGIN CONCURRENT may proceed concurrently. The system uses optimistic page-level-locking to prevent conflicting concurrent transactions from being committed.

> When a BEGIN CONCURRENT transaction is committed, the system checks whether or not any of the database pages that the transaction has read have been modified since the BEGIN CONCURRENT was opened. In other words - it asks if the transaction being committed operates on a different set of data than all other concurrently executing transactions. If the answer is "yes, this transaction did not read or modify any data modified by any concurrent transaction", then the transaction is committed as normal. Otherwise, if the transaction does conflict, it cannot be committed and an SQLITE_BUSY_SNAPSHOT error is returned. At this point, all the client can do is ROLLBACK the transaction.

The page also mentions:

> The key to maximizing concurrency using BEGIN CONCURRENT is to ensure that there are a large number of non-conflicting transactions. In SQLite, each table and each index is stored as a separate b-tree, each of which is distributed over a discrete set of database pages. This means that:

> Two transactions that write to different sets of tables never conflict

Source: https://www.sqlite.org/cgi/src/doc/begin-concurrent/doc/begi...
Thank you. What about the rest of the Earth?
Space exploration is unlike anything else. Perfect combination of exploring unknowns + badass robots + science.
The Space Shuttle was reusable (with massive refurbishing after each flight) but given that'd it cost significantly more than a non-reusable rocket per pound I think the point stands. SpaceX managed to make a financially viable reusable rocket.
Probably not. It's patented though. https://patents.google.com/patent/US9720617B2/en
How to connect to Ethereum network using Go
100%

The upfront cost of Django makes people thing it's much more complicated than a micro-framework like Flask.

I like Flask, but not because it's a simple easy to use framework, especially once you chuck SQLAlchemy into the mix. Shit, even now if I don't touch it for a while I end up trying to remember how things work
I thought they were young people in the NASA video. Does that mean people at SpaceX are older ?
The pandemic has, in many ways, accelerated advancement and technological development.
Probably should be merged with https://news.ycombinator.com/item?id=26185404 where there’s more commentary.
> Since the vertical farm does save space in the abstract (just not necessarily once accounting for space needed for electricity generation)

I severely doubt that.

Solar panels are maybe 30% efficient. So 10-acres of glass-roofs need to be replaced by 30-acres of solar panels just to account for this inefficiency (let alone other inefficiencies: such as wiring, inverter, batteries, and LEDs). Maybe 50-acres of solar panels to be anywhere close to comparable against 10-acres of glass roofs once we include other inefficiencies.
Apparently the copter was made with off-the-shelf parts.

I wonder if I can cop a replica somewhere, and how it would fly considering it is built for martian air
Epic is free to publish there game on AltStore. All AltStore requires is that the user runs a local copy of the application on their network and from there they can install anything they want.

Epic likely doesn’t want an ‘alternative’ App Store they want one that they completely control.
“Why should anyone believe..”
Vulnerabilities are found constantly, that’s a feature not a bug.
Apple has earned a decent amount of respect in this area. They have also earned a healthy verification of whatever security claims where are due to some pretty high profile bugs.
A super exciting and well-executed landing with years of practice ahead of time to make it look easy. Things I'm looking forward to:
- Sample collection and caching for pickup by a future sample return mission

- Flying an experimental helicopter on Mars

- Gauging the habitability of its landing region (Jezero Crater, a paleo-lakebed with preserved river delta and sediments) and hunting for ancient microbial biosignatures (with lasers!)

- A drill (that can cut intact rock cores, rather than pulverizing them like Curiosity)

- An ISRU experiment that makes oxygen from CO2

- Way more advanced autonomous navigation
I am. Maybe I turned away at the wrong crucial 30 seconds.

(Edit) I checked the JPL clean feed and none of the last two hours of feed is what I saw being sent on NASA live. I got a walk around the robot, and social media about the kids who named it, and talking heads. Bizarre.
What is really egregious is that apple still touts the T2 security benefits on their site and completely ignores the fact that it can be compromised. This in fact does make it harder to take Apple's hardware security claims at face value knowing what they know about T2 vs what they put out in their resources.
Thanks for the paper link! I think your reasoning of hardwiring boilerplate to an expert-vetted (or written) summary is a much more accurate approach. If only we could scrape the clause explanation footnotes from quality sources I would not be forced to write them!
Serious question: Can we design a test for “getthereitis”? Most often, people would pass the test, but then misjudge and, in the case of Christmas, hurry up to “get there” (hence the name) and underestimate a risk. Ability is 10/10 but judgement is 2/10, and it is hard to verify that their mindset is calm.
I think that's correct, but that difference seems to be within the error margins for this calculation, and some other loss (e.g., transmission, storage, etc) could eat any hypothetical advantage that the vertical farming position might've enjoyed.
> never involve wind maxing out in wintertime, because that's not how anything works.

This is provably false by ERCOT's record-setting wind output of 17,541 MW (83% capacity) on February 19, 2018 [0]. ERCOT only had 21,190 MW of wind capacity at that time. Now they have over 25,000 MW, yet wind was producing 3,500 MW (14%) last night, and now that it's warmer is all the way up to 6,629 MW (26% capacity).

It's absolutely true that fossil sources failed when we needed them. It's equally true that wind failed us utterly. If we had no wind generation capacity but instead had 25000 MW more fossil fuel generation capacity, then we'd be in much better shape. Note carefully: I'm not suggesting this as a solution, as there are much better ideas like winterizing our existing capacity. I'm instead emphasizing that our summer capacity needs to be able to meet our needs in extreme cold, and we should either fix or get rid of capacity that can't do this. The biggest culprit by far being our current, un-winterized wind generation systems.

[0] http://www.ercot.com/content/wcm/lists/144926/ERCOT_Quick_Fa...

(I cut off part of the quoted sentence because it made it seem like I was responding to the claim about how ERCOT does projections. As discussed above, I don't care about the projections because wind capacity failing us by design is an even bigger problem than it failing due to unforeseen circumstances.)
What does training here mean -- because if it means a lad sitting down and explaining what the checkbox does then it's certainly the UI to blame.
I'm not a heavy db user, but I touch it once or twice a day. I use mycli as my daily driver. I configured separate profiles for when I connect to prod, and added autocomplete for my db profiles.

I haven't found a gui I'm happy with on Linux, but I've been loving mycli for the last 4 years or so.
The effects can last a lifetime but saying any narcotic will last for at least 72 hours doesn't take into consideration dose, weight, history isn't even closely true.

Did you know eating a poppyseed bagel will cause a positive for heroin for upto 60 hours afterwards while doing a small amount of heroin will not show up on that same test.
Where are you placing these solar panels? Why can't those locations be rooftop hydroponic farms instead?
Guess What? Here’s How AI Is Generating Love Letters Chuckle
Cost of living calculations are silly. Nobody earning 236k in seattle is spending their entire paycheck on cost of living. Tell me, does a share of Tesla cost more in Seattle than Austin?
It's the gas turbines and power plants that failed to come online due to frozen gas pipelines...
They did, you're not wrong at all, but just to add a little bit of clarity the space shuttle was never as reusable as was hoped - it wound up costing a huge amount of time and money to retrofit the shuttle again before each launch. Reusable and Re-usability are different things :P

As far as I know no solid state boosters were ever re-used (how would that work?) - but then again SpaceX doesn't re-use solid state boosters either (because they do not use any)...

Things can be more complex and nuanced than quippy internet back and forth suggest. That's not even touching on the ship-of-theseus problem that is many former NASA engineers working at SpaceX these days.
I helped build ByteDance's censorship machine
Would be better if they just did specialised versions of their datacenter systems geared towards the issue and capitalise upon it for a win win around. However as a stop-gap solution that won't impact many, but some crypto miners - I can see what they are going for.
I think it absolutely makes sense for them to customize their products for the market they want to serve, even if it is artificial, that is their prerogative. But the product is just for gamers that want better games. I think it's funny that is the moral high road here.
It’s good to know there is hope of landing another such gig :)
Correct. I hope that meant that this was more accessible than the average write-up (and not less accurate!) :)
From the article:

> The worst case scenario: Demand for power overwhelms the supply of power generation available on the grid, causing equipment to catch fire, substations to blow and power lines to go down.
Same, bought a GTX1660 Super, and the price doubled since. It's madness what's happening on the GPU market.
Yeah, I tend to place a lot more stock in the vast legions of musicians who can't agree on anything but are almost unanimous in "Look, just don't do heroin. Any drug but that."
Same here.

This article is way out on facts.
This guy should better read some science based books like the of Gabor Mate, 'in the realm of hungry ghosts'. Inside this books it is well explained in detail, if drugs create addictions, why humans take drugs, what happens to the brain on drugs, what happens in long term usage and what somehow all users share in common, from their emotional journey. Its about getting love, feeling seen, feeling rewarded, ..from friends, next one's and society itself or more often, in the search for rest from trauma and depression....

Damn nautilus this article was reputation hurting.
If you're talking about the iPhone, yes. But they lost a bunch with their desktop computers with this unaddressed, apparently very real problem. Unless there is some news and it turned out to be a hoax? But it seems real.
This is the typical distraction of "Don't worry about how bad things are, think of how lucky you are that they weren't worse."

Us Texans really need to focus on getting the people in charge out of office. I will vote for anybody that will work towards strengthening our infrastructure.

Hell I'd run on an infrastructure platform if I had any idea how. (And of course the means to run.)
Demand > supply means stuff is operating outside of how it’s designed which can cause a lot of rather uninteresting problems relating to impedance mismatch etc. IMO, the reverse is more interesting.

Let’s suppose your adding 200GW to an electric grid, lose 10GW to transmission losses and consume 190GW. Everything is nice and balanced.

Now suppose someone adds another 50GW to the grid, where does that energy go? It ends up as waste heat, but while a few KW here and there is meaningless at that scale 50GW will melt or burn some important stuff. That’s a rather extreme example, but generators are only designed to spin so fast etc.
It's not just assets. Commodities are up 40% from 1-year ago verse the dollar.
South Carolina governor signs abortion ban
Nothing Republicans ever do is in the interest of common good. Nothing. They should be laughed right out of the House for even thinking about proposing this BS.
Looking at it now, it appears names have been removed from the article.
People just choosing not to work in a thread about about ever-increasing numbers of workers with multiple jobs. Really??
A year ago I bought a RTX 3070 when I rebuilt my entertainment rig. I replaced a GTX1080 and got rid of it. I should have kept it and resold it. It's crazy and I wish there were two categories of cards. Mining cards and Gaming cards. Looks like NVidia feels the same and is making dedicated cards for the basement farmers.
Grow lights are quite good at only emitting light in certain parts of the spectrum, and have been for some time now.
Tangentially related: Has anyone else been shocked by the amount of widespread schadenfreude resulting from this disaster? I get that people dislike Texas for many reasons, but it seems like every avenue of "you deserve it" is being explored on social media towards the people there.
"For certain sensitive information, Apple uses end-to-end encryption" - there's a lot of important user generated data from Apple apps that is not end-to-end encrypted.

Frankly, I'd like to see them go even further and put in place a policy that all user-created-and-consumable content can only leave the device in end-to-end encrypted format and have those keys managed by my AppleID so not even Apple can decrypt.

They can introduce it at an API level without having to dictate storage providers. If a web-version of an app needs show my photos they can let the end-user browser decrypt it. This works for private data, 1:1 and 1:Many shared data.

I should have a choice with who hosts my encrypted data, who manages my keys/identity and who provides a service that uses that data. Let's get back to providing value through services and away from leaching value through hoarding data and controlling protocols.

Yes - this will force companies to change their business models if they rely on access to my data. Will it make for better software - Yes hands down. More companies can compete and we'll start to see more creative solutions.
In fact that's exactly what they're doing: the Mars Reconnaissance Orbiter is serving as a communications relay, as it did for previous landers.

It's just that since there have never been more than a handful of spacecraft active on Mars at any given time, there's currently no point in spending huge amounts of money to launch a whole constellation of satellites for continuous coverage.
No flame sit. It is either safe or not. Safer doesn't qualify as safe.

Your query searches for type unsafeties.
A third query would be for concurrency unsafety: deadlock. All three unsafeties are builtin by design. There's no way to deny it.
But they still do repeat the same lies again and again.

Stack overflows being memory safe you can tell your grandma or upper management. Problem was rust was once memory safe, but they ripped out the GC. Now it's just better than C++, but not better than Java or really safe languages. Overhype rarely reflects well on a community.
A bus driver plans to be seconds from driving over a cliff, as that is the optimal way to drive in some cases.

Not so, here. There was no need to be this close to the cliff.
The SPAC Bubble Is About to Burst
Do you have any links where I could read up on the work being done for type sharing? Sounds awesome to me.
If we accept that there's nothing but physics, then there are no boiling pots or humans. There's only a complex multi-particle wave function.
You’ll Never Build a Sustainable Business with Execution Alone
I read that the design life of the helicopter is five flights. Does anyone know what the limiting factors are? The brutal cold and abrasive dust both seem like they could contribute but I am curious what the real answer is.
Amazon GameLift hits the ground running in the new year with new feature updates
I can see where you are going with this, and I am aware of the problems with drug tests and largely agree they are over-applied. But I don't know of an alternative to these imprecise tests in many cases.
Electricity doesn't work like that. You don't "add energy" to wires. It's the loads that draw the current.
The difference between what? The question was whether majors in the US mean the same thing as those things listed for the UK. I'm saying yes they do. The claim was never that other aspects of programs are identical in both countries.
It's a risk any user of the major platforms takes when they participate in a walled garden ecosystem.
I don't see how nuclear can win over the long term.

Solar and wind are simple and very amenable to mass production. Many parts of them are usable for other purposes -- we need generators for things other than windmills, inverters for things other than solar powerplants, etc. This means we're not making things as a one off, but doing mass manufacturing, and the different users all reap benefits.

They're easy to produce, which means there's lots and lots of competition, which pushes down price.

They're easy to install, scale and maintain.

They're easy to iterate, because it doesn't take billions to test a new design on a small scale.

They don't need most of the parts nuclear has -- if you think of it a windmill contains parts a nuclear plant needs too, but unlike nuclear doesn't have all the nuclear stuff along with it, which isn't cheap.

The way I see it, nuclear could have been successful but is going the way of the mainframe -- today mass computing is done on huge amounts of commodity hardware, and in the same way large, purpose built plants are already being overtaken by mass production of panel after panel being churned out of a factory, and that's not going to get any better for nuclear.
No worries friend. Point of debate for me is learning about and refining a viewpoint through rigorous defense. Doesn't all have to be topic at hand so long as we're working toward this goal in good faith.
> But, it's important to also point out how bizzare this exception is, how did this even get included as the one and only exception?

It's not really 'an exception'. The article most likely written by a non business person confuses a mistake (money sent to the wrong account) with money sent to the right account. The law almost certainly doesn't allow a wire transfer sent to be recovered for that reason and type of mistake. It does (by design) allow a transfer sent to a mistake (like a typo) to be recovered. This actually makes sense and here is why:

A wire transfer is payment for 'goods or services' let's say. Often that 'goods or services' is released (or relied upon) when money is received.

Wire transfers are by design 'final'. ACH is not. An ACH can be reverse (for a number of reasons).

If you could claw back wire transfers all sorts of things (that depend on them being final) would break down and you'd have all sorts of problems down the transaction line.

It's like giving someone money in a sense. You give someone money they give you something in return.
Or, even easier, raise prices...
> I think the point stands

No it doesn't. The person was trying to say SpaceX > NASA. Many people here are trying to shit on the other side as if they have a real point.

They're both doing cool and useful things and they're both really really good at what they do.
Trust and async work are key.
GnuDB
Is there a separate Law enforcement guide?
When you see a chart* with a non zero-based Y-axis you can be sure that the article that includes the chart either has an agenda or tries to sensationalize things.

* Note: there are few exceptions where the absolute value is not important, only the fluctuations are, e.g. stock charts.
If they are putting other people's lives at risk, maybe!
Once macys.com gets a page with all the tech they open-sourced that is actually used at a ton of places outside of the company, similar to that of Airbnb[0], then we can talk.

Out of the ones I personally worked with, Enzyme[1] is pretty much the de-facto industry standard for writing React unit tests. Airflow[2] is used very commonly (our team at a big known non-tech company I used to work at used it about 5 years ago), and so is Lottie[3]. And these are just the ones off the top of my head, given that I actually got to use those. They have many many more that seem to have a pretty high usage. And their tech blog is very insightful, I learned quite a bit from it myself when it comes to my development skills.

And no, I neither was nor currently am employed by Airbnb, not a big user of theirs, not paid to say any of this, and I have no particular liking towards them at all.

0. https://airbnb.io/projects/

1. https://airbnb.io/projects/enzyme/

2. https://airbnb.io/projects/airflow/

3. https://airbnb.io/projects/lottie-android/
No different than anything else. Californians should not live near forest fires, New Orleans shouldn’t have been built in the gulf...
Read a little closer...

>“The operators who took those actions to prevent a catastrophic blackout and much worse damage to our system, that was, I would say, the most difficult decision that had to be made throughout this whole event," Magness said.

>"At the end of the day, our operators are highly trained and have the authority to make decisions that protect the reliability of the electric system,"

strongly implies ERCOT had absolutely no working plan to deal with this issue and instead relied on observance and skill of operators to save them from complete and total blackout.

CAISO is an example of how this should work. it has detailed and thorough plans for high winds, inclement weather, earthquake, fires tsunami and flood. If there is an ISO flex alert for customers to save energy or a blackout is planned, its generally forecast with days to spare. Operators and plants are shut down and restarted in a coordinated, orderly fashion with excellent communication and transparency. CAISO even takes into account climate change and will mail out free coupons for bagged ice for users in a shut-down area along with maps to cooling centers or warming centers if need be.
http://www.caiso.com/
Hmm, online stores can do this ("here's the product you're about to buy, the quantity and its price, shipping, total sum, here's the address it'll be shipped to, hit 'Purchase' to confirm."), but I guess no one at the bank wanted to pay for that feature on their ancient app.
> I always wondered why the ATL tech scene was 'underdeveloped' compared to comparable sized cities like Seattle and Austin

No insight on Atlanta or Seattle, but Austin has had tech longer than people like to think (IBM/Freescale, UT Austin+TI Partnerships, etc), and also got on the 'hype train' early by rebranding SXSW from pure music/entertainment into 'SXSW Interactive' quite a while back (early 2000s if I'm not mistaken), so you have lots of west coast tech/media/vc 'influencers' heading there on a yearly basis getting schmoozed heavy
Thinking aloud here; perhaps we could somehow use optical fibers to bend the light from rooftop to vertical farm?
I hate to suggest toxic social platforms but I've had good results with LinkedIn.

I pretty much never have to reach out to potential clients/employers - they reach out to me which gives me leverage and the ability to set terms such as no take-home tests or tricky algorithmic questions.

Maybe give it a try?