skysight-inc/HackerNews huggingface dataset:
A Secret Google Geofence Warrant Helped Catch the Capitol Riot Mob
Coming from the outside, with zero understanding of the internal details, my hunch is the same: lack of support for logical replication is more of a business decision than a technical decision. (But again, this a hunch -- partially based on how good heroku is from a technical perspective)
> I described it as charts and he didn't know what that was. I described it as graphs and he also didn't know what that was. The interviewer had a bit of an accent so maybe it was a language issue but I had never run into someone who hasn't heard of a chart!

It’s at this point that I would end the interview and let them know it doesn’t feel like it would be a good fit.
The rail network appears to be only 20% larger in Austria than Switzerland (5000 vs 6000 km Google tells me). Then the salaries of the people operating those transports are also higher in Switzerland. The GA is a pretty good deal already.
Today, DST Root CA X3 Expiration
What's your goal here? For a lot of people, work isn't their passion and a safe financial bet is the best possible outcome. Some people are passionate about their work, but have family/monetary obligations or goals that require them to make the high salary choice. Others are early enough in their career that it's totally acceptable to take a risk for something that could pan out super well.

The choice you make is impacted by your life goals.
The advantage of DeepMind from more compute resources is cumulative, you can develop better models if you have more compute. So the question really is: If academia and other research institutions had DeepMind's resources, would their output match DeepMind's?
If you're 80 in the USA, you're on Medicare. In the article you link, a Medicare patient paid $186 for treatment.
Yeah, most places I was looking at would be 30-60 minutes outside of large city, and only a short 10 or so minute drive to the local town.

She told me one day that she never wanted to leave the current county (her home county). Now she is also determined to move into her old school district (much more expensive and more developed), even though the school scores aren't much higher than the current one and just with the money that we save in property taxes we could send a kid to a private school. Needless to say, this issue doesn't come down to having a rational discussion to find solutions that fit both of our criteria. I'm wrong, she's right, always.
Treatment costs $10K; he might have felt like he had to take the risk.
From what I've read about similar experiments in various cities, in fact it's not an unmitigated good thing. Most augmentation in public transport usage comes not people switching from driving, but people that used to walk or bike.
> cognitive science, linguistics, and anthropology.

Would love to hear your thoughts on this, esp. the linguistics and anthropology piece.
What happens if they don’t pay the fees?
Exactly. "Maybe" is slower than either "no" or "yes".

If they interview 10 people, and you're ranked second, they don't tell you no until their top choice actually shows up on his/her start date.
Thanks, that's incredibly helpful.

I don't know what it is about the hassio docs but I have a hard time groking them and quite often find myself looking elsewhere for clarification.
As a young developer I stayed away from traditional relational databases because I thought they were boring and restrictive. I quickly fell in love with them. I realized they painlessly provided all the things I was already doing with data and they were doing it much faster and more reliably.

I hope you have the same kind of experience and enjoy Postgres!

As far as actual advice...

1. The key concept of an RDBMS is that each table typically specifies relationships to other tables. So in order to query data you will typically be joining multiple tables. Sometimes new DB programmers get a lot of enlightenment from the simple Venn diagrams that illustrate the basic types of JOINs: https://www.google.com/search?q=inner+join+diagram ...IMHO, once you get this (fairly simple) paradigm the rest is easy.

2. Database constraints are your friends. At a minimum you specify the types of the columns, obviously, but you can go much farther - specifying NOT NULL constraints, foreign keys, and more complex check conditions. Do as much of this as feasible at the database level. Otherwise it is something you need to code and enforce at the application level, where it will generally be less performant and more prone to coder error. Additionally, any constraints not enforced at the application level will need to be implemented across multiple applications if more than one app uses the database.

The second one above is an example of something that sounds boring and restrictive but really frees you up to do other things as a developer. About a decade ago, the "trend" was to treat RDBMSs as "dumb" storage and do all that stuff at the application level, in the name of being database-agnostic. Opinions remain divided, but I think that was an objectively bad trend. For one thing, folks noticed they hardly ever needed to suddenly switch databases, but there are other reasons as well.
This weekend I'll be travelling from Innsbruck to Vienna, a good chunk of the entire length of Austria.

I'm not here enough (and not travelling around enough) to be interested in the Klimaticket, but here's how public transport vs car stacks up:

Innsbruck to Vienna is 476km (~300mi) by road.

It takes about 5 hours to drive, assuming no delays. The way the world is right now, there will certainly be delays.

On the fastest route you exit Austria just after Kufstein and enter Germany at Kiefersfelden, drive through Germany on the A93, then on the A8 towards Salzburg, then cross back into Austria.

Pre-2015 you'd typically have crossed both those international borders at standard motorway speed(!), but since the refugee crisis, and even more since Covid, it's checkpoints (=delays) galore.

By train the journey is scheduled at ~4h15m. The train also enters Germany but doesn't stop there, so no border checks.

A standard ("2nd class"/economy) walk-up train fare is €74 ($85), but if you buy an annual railcard for €66 ($76) that's halved, so €37 ($43). This is a completely flexible ticket valid on any service that day, so if you are late (or early) you just get on the next train, and there's basically one every hour pretty much throughout the day. The railcard pays for itself in the first return trip.

Maybe it's just me, but €37 for a 300mi journey, with a completely flexible ticket, just seems like amazing value.
It should really be "A quantum computing strategy suffers..."
I ducking hate mobile auto-correct too, so I turned it off. I've become a better thumb typer and now own what I type.
And I do use "ducking" since I don't like to swear ;)
Yeah, sorry, I misunderstood.

Do you think it's impossible that the virus actually did infect you the second time, just asymptomatically?
It would be tempting at a lower price but I'm inclined to save my money for a machine that runs Win 11 and can take a current generation GFX card.
>>something more valuable?

yes? I am not aware of any fast food chain paying minimum wage (at least not the federal min wage in the US)

In my area most are about 2x Minimum Wage being advertised, with interview and signon bonuses
Probably not. It's not clear how to scale other methods to make use of so much compute. They top out sooner, with fewer parameters and less compute.

One way to look at why deep learning is having the impact it does is that unlike other ML methods, it's actually capable of making use of so much compute. It gives us modular ways to add more and more parameters and still fit them effectively.
I was just yesterday talking to someone about this; they mentioned that Patroni leverages some way for setting up replication slots on replicas [1]. Haven't tried my self yet, but seems worth exploring.

Something I'd like to dive into within Debezium is usage of the pg_tm_aux extension, which supposedly allows to set up replication slots "in the past", so you could use this to have seamless failover to replicas without missing any events. In any case, this entire area is of high importance for us and we're keeping an eye on any improvements closely, so I hope it will be sorted out sooner or later.

[1] https://twitter.com/cyberdemn/status/1443130986116624388
[2] https://github.com/x4m/pg_tm_aux
The article unfortunately is behind a hard paywall...
You put forth the idea in your parent comment that there is a simple bright-line test -- apparently textual -- for deciding whether a remark is an innocuous opinion or a credible threat.

So -- bearing in mind that the speaker's henchmen said they interpreted it as a command -- which side of the line does "Will no one rid me of this troublesome priest?" fall on?
The other way around I hope ;)
I understand that rabies treatment promptly after the bite ( "post-exposure prophylaxis" ) has a very good track record. (1)

But if you leave it until symptoms start, it's pretty much a death sentence. A terrible, agonising death, too. (2)

There are also vaccines, that can be taken pre-exposure. What I did not know is that they date back to 1885 (3)

1:

> Existing vaccine regimens for rabies PEP are close to 100% effective and WHO-prequalified vaccines are highly effective. The expected number of rabies deaths in patients receiving PEP after a confirmed rabies exposure is fortunately extremely low.

https://www.sciencedirect.com/science/article/pii/S0264410X1...

2:

> As of 2016, only fourteen people had survived a rabies infection after showing symptoms. Rabies causes about 56,000 deaths worldwide per year

https://en.wikipedia.org/wiki/Rabies

3: https://en.wikipedia.org/wiki/Rabies_vaccine
Where did Robert Haas say this? Quick search didn't surface much, except for a blog post from July by Hans-Jürgen Schönig: https://www.cybertec-postgresql.com/en/postgresql-zheap-curr... Doesn't sound like they discontinued the project.
Are you sure? I’ve literally never seen any video of Fripp playing standing up?
I'm sorry for your experience in France. French people are not really friendly to strangers (not in a racist way, more in a "i don't even know what language this stranger is talking"). I'm 50% sure the locker staff didn't even understand what you wanted from them and just reacted with stress.

But Paris have the reputation to be pretty hostile, even to the rest of french population. Our other cities are much more open and friendly. Our countryside is also pretty friendly but don't expect anyone there to understand you but at least they'll friendly try to fake that they can.
Catastrophic floods on the Earth carved some impressive valleys. The North American Mississippi Valley varies from a mile wide between bluffs in the north to many miles wide downstream. It was apparently carved after the last glacial melt, when the remaining ice in Canada gave way. The ice was still a mile or two thick, and melted in pockets (i.e. enormous fresh-water lakes thousands of feet deep and many miles wide). When the ice dams holding these lakes broke one summer, it released a burst of water a half-mile high. That ground everything in it's path into powder and scoured the earth down to the bedrock, as it spent the summer surging through the US midwest and down to the sea.

I imagine some poor tribe looking up and seeing what looked like an enormous storm front from the north. Only to discover it was a large brown bow wave thousands of feet high, roiling with the destroyed forests and prairies it had uprooted, churning toward them at 30-40MPH. Inescapable and inevitably fatal, I wonder if they ever understood what hit them.
Maybe we just disagree about what constitutes best practices. I can't speak much about Java land, but I wouldn't describe rebasing in general as a best practice without further context. If you're working on a team that always rebases feature branches then your preference for not rebasing doesn't seem valid to me.
> I'm not convinced it's useful to make a distinction between the spirit and the law anyway. The concept of government and law is just as abstract.

My use of "abstract" refers to the fact that the first amendment applies only to the US government, and consequently it's more concrete or restricted than the broader "spirit". Any particular "free speech" law is just one concrete instance of the more abstract concept of "free speech". The utility of the distinction is proved by the fact that we can talk about "free speech" laws across countries, but also in that we are currently having a debate about whether large social media networks should adhere to a free speech ethos.

> I think it's more accurate to say the first amendment specifically limits _how_ the US government is allowed to censor speech i.e. they can't use their extraordinary powers to do it. It doesn't say they can't use the same tools and tactics everyone else legally uses to minimize the visibility and impact of certain speech.

I'm not sure what distinction you're making. Specifically I'm not sure what "tactics everyone else legally uses to minimize the visibility and impact of certain speech"--most people don't minimize the visibility and impact of speech. The few who do are generally private platforms, and the US government specifically can't use these same tools. For example, the government can't legally give a platform to a Muslim group but deny that platform to a Jewish group. Additionally, it can't use its extraordinary powers to e.g. order a takedown of an offensive website, but it can't use "ordinary" powers to denying platforms to certain groups either (e.g., Neo-nazis/Antifa can protest in the streets as well as moderate liberals).
"Yeah, there's something you can do to help. Stop asking me for updates. Stop wasting my time, and let me get stuff done."
Monero itself is not KYC, sorry if I worded that poorly above.

The transactions to and from Kraken can definitely be tracked since they would have a record of the actual wallet address you sent your funds to. As for things that happen after that money hits your wallet - you’re right they wouldn’t be able to track it.

I checked the Monero subreddit just to see if my understanding of it tracked with what people who actually own it say and it looks like they agree that transferring from a KYC exchange does allow tracking for transactions coming out or into the exchange.

https://reddit.com/r/Monero/comments/ppcusq/moving_funds_bet...
The root is still the root, but everything else is just flipped: https://leetcode.com/problems/invert-binary-tree/

It is also extremely simple:

TreeNode* invertTree(TreeNode* root) {
if (root) {
invertTree(root->left);
invertTree(root->right);
std::swap(root->left, root->right);
}
return root;
}
I’ve never in my 10+ year career needed to invert a binary tree.
Calling yourself an "engineer" involves licensing fees, continuing education, and the most fun of all - a university degree.

Some jobs require you to be a member, but most of these jobs aren't in software.

So most software people I know just use adjacent titles like "developer" or "designer". It's essentially the same job - just without all the extra responsibility.

The word "engineer" has a certain social clout to it, though. Hard for your mom to brag to her friends if your title is "developer".
Phenomenal idea! Really great approach to forum UX. I sincerely hope you keep working on this, I'd love to see how it evolves.
Between "Amazon Web Services" and "Plumbing" he lists "Backflow Prevention and Cross Connection Control Inspector/Tester" and... I'm not quite sure if that's a cloud architecture skill or a plumbing skill!
A couple of more ideas:

* Some way to go to the top of the page without refreshing the page.

* Some way to load new posts asynchronously without refreshing the page.
Ahhh the reputable businessinsider.com, breaking the hard news stories. *sarcasm&
Luxembourg resident here. Free public transport is a game-changer. You don't have to think about it, you just step on the bus, or tram.

This also means the bus driver doesn't have to worry about checking tickets. There aren't guards to check if people are jumping over turnstiles, etc. Moving to 'totally free' eliminates all kinds of overhead.

There is no reason it couldn't scale.

And the question of scaling hides an interesting assumption: what is the purpose of charging fares?

If it is to reduce usage (to thus ensure that the system isn't used past capacity), then why do you want to limit the usage of public transport? If people don't take public, they will take private transport (cars, etc) which have much higher social cost (you can move many more people by bus than by car).

If it is to 'raise revenue to pay for the system', does the same argument apply to use of roads? What is a fair road tax, given that this method of transport has such high social costs?
Multiple Slack Workspaces
is this still a frustration having to go into workspaces one by one or is there a solution for it?
Good article.

Just wanted to point out https://jmmv.dev/2021/08/useless-use-of-gnu.html, which also covers the portability problems that GNU has widely introduced and describes alternatives to the common issues.
> My experience from living in Paris is that "non, c'est pas possible" isn't "no, that's against the rules", it's more of a "that sounds like it requires effort on my part, please go away".

This captures my experience as well.
Live Coverage Facebook’s Efforts to Attract Young Users Under Senate Scrutiny
It's approximately what we aspire to in most democracies, no? Policy and law representing the will of the public. The fact that it's imperfectly achieved in reality doesn't seem a compelling reason to abandon that as a value altogether.
Explaining explaining: a quick guide on explanatory writing
I stick to standard SQL syntax/features whenever possible as well, but...

Honest question: how often do you switch databases?

I've never really found myself wanting or needing to do this.

Only time I could really see myself wanting to do this is if I was writing some kind of commercial software (eg, a database IDE like DataGrip) that needed to simultaneously support various multiple databases.

> MySQL

It feels particularly limiting to stick to "standard" SQL for MySQL's sake, since they frequently lag behind on huge chunks of "standard" SQL functionality anyway. For example, window functions (SQL2003 standard) took them about a decade and a half to implement.
Interesting, what was it from that podcast that made you reconsider? Always eager to learn about opportunities for improving the experience of using Debezium.

Disclaimer: I work on Debezium
Minecraft to add telemetry
I like this, but let's make it 50 days instead of 50 years. Or maybe weeks. I could see 52 weeks.
The original idea by our green party was a "1-2-3 Ticket" which means 365€ for one state, double for two states, and triple for all states (per year for all public transport).

They just renamed the "3" ticket to climate ticket when they introduced it, meanwhile work on "1" and "2" is still ongoing in some places afaik.
Thank you, that actually sounds kinda interesting. Very much not sold on the look of it though.
In the Klimaticket, all public transport is included. Cities as well as inter cities
> So it's maddening to me that in most office contexts, my schedule fills up with meetings and I'm expected to get my work done around them. And that nobody sees that as a problem, because that's just office culture.

Block out portions of your calendar with recurring work time, and let them schedule their meetings around that.
Thank you for your work on it! I used Sequel Pro for a long time for MySQL databases and occasionally use its successor Sequel Ace as well, but I'm moving my workflow to Beekeeper Studio as much as I can.
Partnership applies genome search engine to 7k grapevines
You don't have to make the alias `tv`. Feel free to make your alias tidy='tidy-viewer'.
So are we using google as an example of what to do or what not to do?
Not sure, but I've found almost all Beaver condiments (not just their mustards I've tried) to be worth the trouble to find, especially their Tartar Sauce.
https://img.webmd.com/dtmcms/live/webmd/consumer_assets/site...

"The treatment regimen for rabies was first developed in the late 1800s, and it hasn’t changed much over the last 100 years.

"But the price of survival has gone up rather dramatically -- nearly 400% over the last decade for those shots.

"That rise is part of the reason why people who have insurance coverage may be stuck with hundreds of dollars in out-of-pocket costs, while the uninsured and underinsured often face thousands of dollars in medical bills.

"In 2007, for example, vaccine maker Sanofi Pasteur charged an average wholesale cost of $740 per 10 milliliters for its Imogam immunoglobulin, a purified blood product that is the most expensive part of the rabies treatment. Ten milliliters is the standard dose for an adult who weighs between 134 and 166 pounds.

"By 2017, the company charged $3,612 for the same dose, an increase of 388% over the last decade, according to First Databank, a company that tracks pharmaceutical costs.

"HyperRAB, the other brand of immunoglobulin on the market, has seen price increases of 370% over the last decade."

https://www.webmd.com/a-to-z-guides/news/20180220/the-high-c...
A long while ago I wrote up a little processor to determine field lengths in a given file - I forgot the original reason. ( https://github.com/sullivant/csvinfo )

However, I feel I really should have taken the time to learn Awk better as it could probably be done there, and simply! (It was a good excuse to tinker with rust, but that's an aside.)
Our Institutions Keep Undermining Themselves
How could foreclosures not be good? If you buy too large a property in too nice of a location, making it too unaffordable for you, then you don’t deserve it. In fact not only do you not deserve it, you should be punished for not considering you could not afford it. You are stealing from others people’s livelihoods. To equate this to oxycodone shows ignorance to the fact that 75% of housing is owned by individual investors like you and I, or your mom and pop, while oxycodone is owned by a monopoly backed by big government.
I second this, upgraded 100 odd instances using pg_upgrade. And it's lightning fast, takes less than a min whether the db cluster is a couple GB or a few TB.
Just make sure that you always run the check mode to catch incompatibilities between versions.
That's what Luxembourg did. Works great!
Hard paywall, doesn't work with archive or outline.

Text available on Google cache:

http://webcache.googleusercontent.com/search?q=cache:VhqweeF...
Congrats to the team. I cannot wait to work on v14.