skysight-inc/HackerNews huggingface dataset:
If you have wal-mode enabled then the automatic locks are table level. So one process can be updating one table and another one can work on a different one. Also, you only need to enable wal mode on the DB once (pragma journal_mode=wal), it "sticks" for each connection.

In my application that uses SQLite (Snebu backup), as data comes in (as a TAR format stream) I have one process extracting the data and metadata, then serializing the metadata to another process that owns the DB connection. This process dumps the metadata to a temp table, then every 10 seconds "flushes" the metadata to the various tables that it needs to go to. This way I can easily have multiple backups going simultaneously, as each process spends a small amount of time (relatively) flushing the data to the permanent tables, and a greater part of the time compressing and writing backup data to the disk vault directory.

I've been working with this for the past 8 years or so, and have picked up a few tricks on keeping as much as possible batched up in transactions, but also keeping the transaction times short relative to other operations. So far seems to work out fairly well.

Note, that in addition to journal_mode=wal, you need to have a busy handler defined that infinitely retries transactions with a 250 ms delay between each retry.

Edit: On further review of the docs, I'm not sure if wal mode enables table-level locking, it may be that when writing to a temp table, that temp tables are part of a separate schema (or are otherwise separate from the main DB) -- which makes sense, as temp tables are only visible to the process that owns them. So a temp table can be locked in a transaction, while the rest of the DB is writable.
hasura does fairly good query optimization using postgres json_agg, that's my preferred way - if more graphql engines did the same that'd be amazing.
"Most <evil grin> players will get the item after buying 26 more boxes"
It is still working. But no, uncurated chronological feed is just too dense for me.
Perhaps, but legislation should be designed carefully so that it can be enforced in a meaningful way
> Because they want him to stop writing. Scott Alexander believes in open debate on any issue and to any participant. The NYT believes that "open" debate should only occur within limits, and that they are entitled to set these limits.

That is basically a conspiracy theory.

It's far more likely that the journalists in question don't care one way or another if Scott Alexander continues writing or not, they just wanted to do their work according to their usual standards (e.g. use people's real names, not write a with the goal of making the subject and his fans happy).
I do miss keyboards on devices. This is something I'd really buy.
> I have always promised myself that if I become a billionare, I will simply stop providing services to municipalities or countries that create arbitrary laws that make it hard or difficult to do business in.

Do you believe that a society should ONLY maximise metrics towards "ease of business"?
pass is great. I use the dmenu script to get passwords into my clipboard without leaving the keyboard or being locked into browsers with a supported extension.

As others have mentioned, the Android app has slight issues, but they're not dealbreakers for me.

There's some interesting pass plugins, e.g. pass-otp. You can get 2FA passcodes from the commandline rather than being locked into Google's Authenticator.
As clear as can be yes.

Now you know which websites are willing to absolutely ruin your experience just to abuse you. The implications can be seen pretty much everywhere in society, it is a momentous step in the right direction.
These buses are operating at gigahertz speeds with nanosecond timings. You would need cutting edge chips to do that. The note is correct. They could of course be manufactured, but it would very hard and very noticeable.
Porting Unix to Windows NT (1997) [pdf]
Why? OP's idea wasn't so bad. A badly wrapped/packaged sandwich can create a bigger mess than a Big Mac.
Galaxy S21 Ultra–$200 cheaper but still not competitive
Reminds me of the recent Lisperati1000: https://www.hackster.io/news/the-lisperati1000-is-a-cyberdec...

I think these personal terminals are really cool, and might foster some interesting innovation in the near future.
> And they’re rolling out slowly without a ton of stories of cars going haywire and flying off the road.

Automakers and Comma are operating at completely different scales. Orders of magnitude apart. You’re going to hear about more autopilot issues from major manufacturers because there are far, far more of them on the road. Comma only has a small group of loyal customers who make the leap to buy and modify their car.

Comma also incentivizes customers to keep quiet if the autopilot fails. The drivers can’t blame a multinational automaker if something goes wrong. They have to admit that they modified their car with an aftermarket device that hasn’t been safety tested. Comma even provides disclaimers that their product isn’t production ready. If it fails, the customer doesn’t have much incentive to broadcast to the world that they bought, installed, and used a product on public roads that was advertised as being not ready for prime time.

It’s false to equate Comma’s software strategy with that of major automakers. At minimum, automakers are working with safety regulators. Comma has gone to great lengths to specifically avoid dealing with anything safety related.
A year from now:

"I do not understand why the only companies that exist are Google, Apple and Microsoft? Where is the competition?"
“You+Reap+What+You+Sow”:+Meaning+&+Origin+|+Good+News+Of+GOD
And is it going to be anything similar in Python? From the looks of it, Python's pattern matching is nothing like OCaml's or Erlang's, but perhaps I am wrong.
Similar experience. In my case, they wanted a video course on a library that wasn't finalized or published, and was still in an obvious beta with frequent breaking changes. On top of that, I was in a 12hr timezone difference, and only wanted to communicate with me regularly at 11/12 at night on week days, which didn't work well. Oh, and they only wanted to use skype, an app I never use normally. I was promised promo codes and release on multiple websites, and I got a single weekend promo code, and only published on two websites. And the icing on the cake is now 100% of the people I worked with don't work at Packt any more, so I don't even have a person I can contact any more to work on promotions or updates.
I love Ruby. Have used it for 15 years, but I can't stand Rails. It's just massive overkill for most things.

I prefer to start with Sinatra + Sequel for web projects. Sometimes Padrino + Sequel. As your project grows, sure, you'll pull in many things similar to Rails, and probably pull in some projects that started out with Rails too, but it allows you to be much explicit about which dependencies you pull in, why, and to limited where it gets pulled in.
It looks like the patent was approved in between the CAFC decision of State St. (subject matter is patentable if it produces a "useful, concrete, and tangible result") and SCOTUS's Bilski decision (State St. is on crack and not good case law). Bilski and later Alice have made it rather clear that these kinds of abstract patents aren't going to fly, not that it stops patent attorneys from pretending otherwise.

So this patent very likely wouldn't hold up in court. It was approved in a time when the USPTO more or less gave up on adjudicating patentability (thanks to the State St. decision).
Who tried to keep mask whole transatlantic flight ? It is almost impossible.
Convertible car, let in the fresh smog.
How about Keepass? I use on all devices.
The job of the news is to inform people (or more cynically, keep them watching to show ads). Sports are a major topic that a huge number of people want to be informed about. Why wouldn't they be in the news?

There are lots of things in the news that some people don't care about - they report on traffic (or at least they used to) even though many people don't commute. They report on the stock market even though many people aren't invested. These days they sometimes report on Bitcoin and other crypto, even though the vast majority of the world has no interest. Speaking of the world, they report on world news that most people don't care about, because they're only interested in their own country.

The news reports on things that people care about. A lot of people care greatly about sports. Just because you're not one of them doesn't mean it's strange to report on them.
Note that Dr. Friedman has explicitly said that the NYTimes article includes fabricated "quotes" that he never actually said. IIRC, Scott Aaronson's Shtetl-Optimized blog talks about this.
I am a long-time reader of Slate Star Codex and was a self-described Rationalist in my teenage years. I am still active in effective altruism circles.

I consider the article entirely fair. In fact, you will see that pretty much all I am doing in this thread is telling people to read the original article. Its treatment of SSC is evenhanded and, at times, downright glowing. It says everything I want to say more eloquently than I am able.

The only problem I have with it is the title.
Ask HN: What is your high-pressure job?
What kind of high pressure jobs do you guys do?
Is your job very stressful?
Do you enjoy what you do (some people enjoy high pressure jobs!)?
Are you looking for a new job or do you want to stay where you are?

Thanks!
Fun but a toy
If people start using more electricity, politicians will have to choose between improvements or dealing with mobs with pitchforks.

Worst case scenario there are some brown outs as they get their shit together. But it’s relatively easy to solve this with pricing or by subsidizing local solar or a lot of other things. And people will absolutely not tolerate their power going out, so those things will happen.
Keep in mind this is a meta-analysis using data published in papers that are up to 30 years old and from overseas including China, then applying it to California's carcinogen list (prop 65) and California commute times.

I am sure a followup study will be done to see if this is actually a problem in the USA in 2021.

The article is published here (Open access) : https://www.sciencedirect.com/science/article/pii/S016041202...

Edit: I found this news article from 2003 discussing the issue of carcinogenic new car smells and how manufacturers were trying to eliminate the the dangerous smells while simulating what consumers expect a new car should smell like:

https://www.caranddriver.com/features/a15133792/new-car-smel...
Is spacetime real? Does mass & energy "curve" spacetime? Is gravity an actual force or is it a virtual force emerging from "curved" spacetime? Like all forces gravity can be modeled by geometry. Where gravity is different from the other forces is it applies to everything - regardless of charge, regardless of mass, regardless of energy. Therefore the geometry, and gravity's metric, applies to everything in the universe. Does spacetime exist? Is it curved? We simply can't tell - spacetime is indistinguishable from gravity's metric.

I think a more interesting question then is whether spacetime arises as a result of the presence mass & energy?
The precision achievable with FPGAs is well beyond 10s of nanoseconds.

The high rate transceivers are used with capacitative dividers or internal signal propagation delays defining the reference intervals for time to digital conversion in extreme accuracy applications, these and similar approaches yield precision to picosecond scale and beyond.
Several Moves Ahead: Learning to Think Like a Chess Master
Does that makes sense if you want to be a Billionaire? Just leave Europe / money on the table and let some competitor take that space?

Some of these laws are ineffective, wonky, and probably annoying, but they're existential threats to doing business.
I normally avoid Twitter et al, but I like their Twitter account.
> Just buy some motherboards and analyze the chips to find where the backdoor is

If you were bugging motherboards, you would surely anticipate this. Some possible mitigations include only bugging a subset of the motherboards, and bugging them in ways that make them physically indistinguishable from a normal unit. Modified silicon or firmware would be very hard to detect.

> The fact that in over two years that still hasn't been done is just very suspicious. If someone is making a large claim but not providing information that can be found using public, verifiable sources, then it's very reasonable to doubt it.

If the bugged hardware is rare (it would be if the attackers were smart), then the public would not have access to it and the government agencies looking into this may still well be investigating this or keeping it quiet for whatever reason.

I'm not convinced either way on this situation, but it's far from impossible that the allegations are true and it is seems worth discussing.
> Honestly Google should have just boycotted Europe for a week and seen how well everyone handles not having gmail, google, or anything.

So we'd all be using outlook.com, bing and other alternatives now. Would've been a really bad move to just forfeit a market like that.

The cookie banners do actually help a lot, as they bring awareness about privacy issues to the broader public and allow to choose which sites to use based on how hard they make it to opt-out.

Laws like this are important because they make companies design for the benefit of the consumer as opposed to just for their own. And I'm gald the EU is pushing for this with the power they have while no other legal entity of similar size seems to bother.
In theory nothing, in reality a head start counts for a lot. I’m sure companies like Apple and Sony would love to stop paying Immersion exorbitant license fees for the privilege of making things vibrate, but they’re still doing it.
As an outsider, it definitely wasn't obvious at the time. Red Hat is still around.

If you look at their wikipedia article and see the photo of the rack mount servers they sold[1], that doesn't seem that ludicrous even today.

[1] https://en.m.wikipedia.org/wiki/Geeknet#/media/File%3AServer...
And if a mod does see this, maybe they'll consider also Dispensing With The Title Case - since it reduces the information in the original article title ('Building Rich terminal dashboards') by obscuring that Rich is the name of the Python package behind it, and it doesn't (just) mean adjectivally rich (other than I'm sure that's the reason for the framework's name).

(Bit of a bee in my bonnet because I never like Title Case In Submissions Even If The Article Itself Uses It anyway, but it's especially unfortunate here.)
The typical approach to direct contact is to look for the signs of the people making the journey (genetic, linguistic, and cultural transmission). If you don't have these, they're often practically indistinguishable because the archaeological record inherently tends to be spotty, without continuous data points for uncommon trade goods. Moreover, the Asian northeast is vast and only lightly surveyed.
LastPass is killing its free plan starting next month
Bitwarden, Zoho Vault, KeePass - are some good alternatives. Thoughts?
I disagree. Pop-up fatigue causes people to just click the button that will get them to their content the fastest. While some people might dive into trying to opt out, when you get these pop-ups on every other site, many people are going to click the easiest button to make it go away. This is a poor law because it has to be done on every website.

I think it may be better to have this as a decision the user chooses once within their browser, and the browser can then pass along the intention to the website. There can maybe also be a third option where the user could then choose on each site, and the browser would show the choices, rather than the website itself. This would standardize the UX around the issue.
The parent was referring to the perceived physicality of atoms which you cannot touch or understand except in terms of the forces between your instrument and the bundle of quanta we call an atom.
It's remarkable to think that Kodak invented the digital camera yet could not turn it into a business. Their failure to do so eventually killed their film camera business, and then their entire film business as well.
I system administrator at Air traffic control system. So any downtime cause risk of lost planes with people. Most stressful is update software.
Legislation is problematic too. I can't be bothered to make a decision to make a decision about storing cookies every time I visit a website, so I click yes every time without reading.
I'm patiently waiting for a commercially available cyberdeck (or kit). This website doesn't have pricing or order information, just a neat render. Not sure about the buttons though, they look spongy.
I'm sure it's pure coincidence it's at an all time high when he decided to "get rid of it".
He wrote a book on it https://lethain.com//staff-engineer/
Wow, hour per day driving on average. The spurious co2 emissions really boggle the mind.
> Noise canceling headphone make my ears feel like they want to bleed if I wear them too long.

Maybe you don't have good ones. I can wear mine 24/7 with ANC on.
ActiveRecord and the scenic gem for database views is a very powerful combination. For the vast majority of queries, you don't need to write optimized SQL by hand.

When you do, you can push that work to a version controlled database view, and wrap it in a ActiveRecord class interface and still get all of the ORM niceties.
Reality has a left-wing bias. It's not surprising that people who research things drift away from right-wing rhetoric.
Here's what I think I would like ...

A unix command named 'topify' which allows you to create a pipeline of stdio into a top-like, updating, single screen output.

So, let's say you have a command with multiple lines of output - like netstat or certain airport commands - but instead of doing silly things like I do now:

while true ; do airport -s ; sleep 10 ; tput clear ; done

... I could `topify airport -s` and I would just get a nice, single page, constantly refreshing output summary.

There are a LOT of commands I wish I could 'topify' from time to time ...
Can we buy this already?
Thank you :)

This is my plan for the future actually, to filter your feed to genres/people/books you subscribe to. But until today, only 2 people have been actively using it (as you might have seen), and we happen to read a lot of business books. But I'll integrate this feature when there's a greater diversity of posts (which you can contribute to ;))
Slate Star Codex and the Gray Lady’s Decay
Cool project. Hard to tell if it actually exists or is just a rendering.

> it runs a full Linux system with an ARM SOC.

So is it a dumb terminal or not?
> Also artificial limits, especially when companies limit existing features like this piss me off (cough google photos cough).

On the one hand, I tend to agree that changning existing features to paid is not-great (disclaimer, I was paying for Google Photos/One/Whatever even before they announced the changes), I wouldn't call space limits "artificial"
Fake reviews and fake products.

I wanted to buy turkish cotton bath towels the other day, and it's basically impossible to find (really, try it). Nearly every listing has misleading discriptions in spite of 5 star reviews.

I feel like unless I know the specific brand or product, I'm using Amazon less and less. I guess there's a niche for competitors - better search and a high quality filter.
How does TikTok moderate their content anyway? Do they just have a massive amount of people scrolling through user reported videos looking for violations?

Being primarily video based and having the lowest barrier to upload seems like it would be a recipe for disaster.
lol you're about to get a giant offer from Amazon. Tell them you want 10x whatever they first offer and they'll say yes.
Those aren't explanations, they are analogies to help the human mind picture the effect.
Not really. For instance, with TiddlyWiki you can run a local server and save everything on disk in a single html file. Jumping from localStorage to a DB means you go straight from "only in one browser" to having to deal with the overhead of a DB. A single text file has the advantage that you can drop it in a repo and have it version controlled or keep it in a Dropbox folder and use it on multiple computers/share it with others.
This anti-NIMBY astroturfing on HN is fascinating. There is a repetitive hammering of a short list of talking points.

I am from the East Coast which is very built up. We largely don't have this weird NIMBY anger. In a lot of places here there are tons of tall buildings being built. The whole angry discourse is alien to me.

No one moving to New York is angrily ranting about "NIMBYS" undermining their supposed right to cheap housing. Or not when I moved to NYC.
Which models? The only thing I can find to support your claim is random people tweeting that they think it will be worth 1M. I guess when enough people say something it becomes a "fact"
Here's some links by way of an answer for you...

Stripe, including webhooks support, actively developed: https://github.com/code-corps/stripity_stripe

Global pay solution that supports everything: they are all a bit crap you're right, the best I've found is https://github.com/aviabird/gringotts and ex_money really is amazing that integrates with it (I would suggest it's better than the equivalent ruby gem). To be fair I'm not sure I'd want to use the pay gem with anything complex as you need to be able to use the specific quirks of each API properly (for example it can't pause subscriptions on stripe right now even though stripe supports this: https://github.com/pay-rails/pay/blob/master/lib/pay/stripe/...).

You're also right about noticed, after looking into it more it would be worth building for elixir for sure. Ravenx represents a start but it's unmaintained and doesn't have a huge number of strategies. It depends on how much I needed to do notifications like this. For the apps that I've built we've just needed database and grouped emails sent once per day, no need for texts or slack etc. There's no reason these couldn't be added fairly simply but I agree noticed is very neat. It's definitely a few weeks work to roll your own from scratch so to be honest I'd probably just integrate with Twilio and just pay for someone else to handle this for me.
I know that noone will believe me, but today as I was on the toilet, trying to wake up -- still groggy --- I just imagined something like this. I thought I wish I had a 19th century typewriter, hook it up to a Raspberry Pi and make a dumb terminal (writing stdout to paper on ink!). Seeing that I probably don't have enough EE skills to do that, I hoped for something like a calculator that can't connect to internet but is programmable and has a keyboard.

Next thing I know, I come to HN and see this post. I guess it's refreshing to know that I'm not the only software engineer who wants to reject modernity. I love programming, I love CS, I love mathematics; but I hate modern computers, internet and software. They're distracting, addictive, bloated, annoying, slow, broken... I just wish I could make a mechanical computer from woods and program that over the weekends.
I think that pattern matching is actually more intuitive than say, decorators for example (beginners I came across usually have a hard time with those).
250k is about median, I wouldn't consider it well paid.
Senior: we need to give them a promotion, but with no new responsibilities.
Well… if GitHub could fix their cookies so that they do not need to show any more modals, some of those 10,000 could too.

https://github.blog/2020-12-17-no-cookie-for-you/
Peer-to-Peer Machine Learning