skysight-inc/HackerNews huggingface dataset:
Ask HN: PostgreSQL resources for SQL Server users?
I have 10+ years of experience with MS SQL Server, doing moderately-advanced tasks such as tuning queries and indexes, managing replication and high availability, etc. I'm looking to learn more about PostgreSQL, but if possible I'd love to be able to piggyback on the broader RDBMS knowledge I already have. For example, I understand the broad principles of how indexes work from my experience with MSSQL, but I know that in Postgres the specific implementation will be significantly different.

I'm hoping for some recommendations for learning Postgres that can take my existing knowledge into account, so I'm not starting from scratch. I'm interested in understanding how the engine works, as opposed to differences in syntax. In other words, explanations of PostgreSQL internals, or if such a thing exists, a comparison with SQL Server. Of course, if there are specific reasons why it might be better to start from scratch, I'd be interested to hear those too.
I think I used to work with this guy...a lamp fell like 20' from the ceiling and hit him on the head the first week he was in the office.
The Decentraleyes extension supplies local copies of popular CDN resources but it doesn't support Google Fonts yet unfortunately - this sounds like the obvious way to implement it.
I can agree with this take. While it's true that there is a large financial incentive, I think it is easy for us with our cozy lives in modern developed countries to forget how dangerous, corrupt, and unstable many developing nations are.
Why agrifoodtech VC Tenacious Ventures backed a green ammonia startup
I'm working on bringing async to Django orm: https://github.com/rednaks/django-async-orm
I see a lot of replies about discovery not being a solved problem here, which it isn't, but that also isn't what the OP said.

> Discovery is not a viable product

I'm parsing "viable" as "commercially viable". You may solve the problem (for some definition of "solve" and "problem"), but can you make money doing so?

I don't know, I have no experience in this field, but OP seems convinced that the answer is "no".
Really appreciate this feedback. I actually agree with you on the account requirement (I hate making accounts too, and then I went and created an app that requires one; the irony isn't lost on me!). But I'm a bit paranoid about server costs. Once we're certain that scaling this in AWS is going to be as cost effective as we think (and it's looking pretty good), I'll feel more comfortable removing the friction of having folks make accounts. My real expertise is finance, so I'm outsourcing much of the tech stuff, and I'm leaning heavily on my team for their input in these areas.

As for having to log back in immediately after exiting the app (and not saving assumptions)--that's a real pain. I'll have my guys get that fixed ASAP.
Yeah, and as a result it's the one music service I pay for.

It doesn't give me any control of which attributes I care about, which frustrates me to no end, but it does fairly well at turning up things I haven't heard before and like if I can give it a decent set of seed tracks.
What can happen when you eat your own dog food.

https://en.wikipedia.org/wiki/Eating_your_own_dog_food
Hahaha I'm super happy that someone else takes joy from this dumb thing I made.
In 1979 I got a small VIP tour of Pearl Harbor from the Navy. They made sure we understood that the Japanese attack was effective, but far from perfect. I remember they mentioned three strategic mistakes by the Japanese:

1. They did not hit any submarine facilities, so the US submarines continued to operate normally.

2. They did not hit any of the dry dock facilities, so almost all the damaged ships were repaired in place without having to be towed back to the west coast.

3. They did not hit the fuel depots, so the remaining fleet had plenty of fuel ready to go.

And, of course, the carriers were out on operations, which was a critical miss, as it turned out.
That's what happens when good content is hardwalled.

I wouldn't say the Reuters article is allowed, exactly. At present it contains no information beyond the title, so I've downweighted it. That doesn't mean we're about to ban Reuters.
If You Think the Great Resignation Is Bad, Just Wait Until January
"For some, that means "

Exaclty, it varies by person. For some, it is a matter of survival, and can be dramatic with consequences on par with being physically attacked.
I recall a colleague googling Prince Albert in front of his boss whilst discussing a potential project in Monaco. That was before either before safe search was a thing or he had it switched off.
Works for a lot of things, but not Route53... Which is great because that's the only thing I need to do in AWS today :)
Reading “Confidential” Facebook Documents
Exactly the reason why I don’t care about either FastAPI or Flask. In my experience you’ll always need more than what it comes with out of the box and you’ll end up building your own (crappy) Django.
Not to mention, there's no official way to self-host Minecraft servers for Bedrock. I think that's another factor to consider when it comes to the Java edition's survival.
Redrock Holdings Pty Ltd and Hotline Communications Ltd vs. Hinkley
I feel rather confident that public schools in high density America are universally expensive, dilapidated, and crappy. Though to be fair, I only have first hand knowledge of SF, NYC, and Philly.

I also have first had experiences with several small town schools in America and while I agree it is a mixed bag, what I can say is that community expectations make or break the school.

I have lived in areas where the community had no expectation that their kids attend college and to no surprise, the quality of the school was crap. I currently live in a community that expects all children to go to college and thus the quality of the system is great.
Unfortunately, despite now knowing the words, the song will never sound right anymore :)

Great band, though.
I was always resizing images myself and storing separate versions before I heard about Cloudflare Images. The CF implementation looked a bit confusing and expensive though and I ended up using Bunny.net and it's been fantastic. Incredibly easy to use, the API is dead simple, you can pass in different parameters live and it will manipulate the source image and cache it for future requests. It's cheap and support is top notch. Highly recommend people check it out if they're looking for something like this. It's so much easier sending up the original file and being able to change dimensions on the fly.

Update your UI and now thumbnails need to be 400x400 instead of 250x250? Just update the parameters and you're done. No need to manually resize your whole back catalogue as they'll be done on demand.
Thank you! We've got quite a few ideas for additional simulation features, reports, and data exporting services. In due time, we might make these extras part of a premium/paid tier. In the meantime, unless we run into some unforeseeable costs, I'd like to keep the baseline version of the simulator free for folks.
One band absolutely needs to do that.
Obviously your server would be on a DMZ vlan, probably on its own. Set it to automatically take security updates every night and aside from some zero days I'm not sure what security issues you'd have.
> My phone can do "safety-of-ship" alerting?

Yes. Never controlled a drone from your phone?

The fact you've worked defence and can't see how consumer devices do things submarines can't is the issue.

We all know a submarine is worth x billion, a drone much less. We understand about critical failure on each.

You job is to work out how to merge the two, but instead defence hides behind ideas like verifying software. Software verification should be a tool, not a wall for bureaucrats to hide behind.
No, zoning laws are forcing your preferences on other people. They need to be significantly relaxed if not removed entirely.

How about everyone can build the type of house they want on their own land.
xfwm
I'd suggest adding "Show HN: " in the title, it might improve visibility.

Here's a clickable link for everyone: https://app.kolor.social/
(this (very enjoyable) talk is by the author of the linked web site)
Millions of people do exactly that and are not 'amazing' at playing the piano.
I remember that too, FWIW.
Hypergraph Rewriting System in JavaScript
Tim Cook signed $275B deal w Chinese Communist Party
Another acquikill?!
> 1. Invest in a decent router (probably $150-200 at least) and throw openwrt on it. You'll need something with serious CPU beef because openwrt relies more on software than hardware, and most routers use hardware for QoS etc., hence the price tag. You'll also need to actually understand the multitude of settings offered by openwrt if you care at all about security or performance -- this is nontrivial if you aren't already a network engineer.

Why not OPNsense on an old x86 box?

> but that's likely to get you punched by your flatmates when it inevitably reboots incorrectly during a power outage or overheats or whatever and suddenly you need to spend 2 hours debugging problems without a working wireless connection and everyone else is pissed they can't use the internet.

I thought for a couple of years that my OPNsense setup would pass the Family Acceptance Factor, but one day (a few months back!) it spontaneously wiped itself of its settings — requiring me to plug in a monitor, reconfigure it to boot, and restore my settings from a backup.

My (very annoyed) family had to ask why we had to jump through hoops, and not use a simple consumer router like everyone else.

I'd imagine that OpenWrt would be the same, or worse.
maybe open a twitch account and stream when you're creating your artworks? You have a vast, vast experience in doing what you do. Then maybe add a patron profile where people can subscribe to have a voice in what you'll draw next, etc.

I'd watch you drawing!
But once you know that you need a NAT loopback, you can quickly follow instructions on internet to create that rule.
Thank you! We've got some premium features in the works. In the meantime, I'd like to keep the site clean (I hade the way advertisements muddy up the UI)and just let folks use the baseline simulator for free.
I dont think the concern for what our neighbors are doing has gone up so much as our ability to make noise about it. Dealing with conflicts between neighbors is ancient.
LG also has the 24UD58 for $300
Varda Space Industries | Flight Software Engineer, Embedded Systems Engineer | Full-time | Onsite | Los Angeles

Factories… in-space! Reusable rockets have lowered the cost of access to space and opened up a range of in-space activities. From more powerful fiber optic cables to new, life-saving pharmaceuticals, there is a world of products used on Earth today that can be manufactured better in microgravity. We’re accelerating innovation in the space industry and creating products that will benefit life on Earth. Our mission is to expand the economic bounds of humankind.

We’ve completed a Series A and received venture funding from investors including Founders Fund, Khosla Ventures, Lux Capital, Caffeinated Capital, General Catalyst, and Also Capital. Founded less than a year ago, we’re still in the early stages with plenty of room for growth and the ability to help form the engineering culture.

We’re looking to fill two positions: (1) Flight Software Engineer and (2) Embedded Systems Engineer.

Learn more and apply at https://varda.com/.
Looking at the numbers, they should be renting. Secondly, children are expensive. Thirdly, it’s cheaper to have kids if there is a stay at home mom. But likely not going happen as that bra is already burnt down to ashes.

Having said that, the article is trying too hard. Why live in SF? 300k is plenty in the rest of Bay Area.

+ humble brags like this is why everyone hates tech bros and America. It’s just silly. But annoying as fuck.

In the real world, who talks about how much they spend? No one with any real money will ever talk about how much they spend? What kind of bizarro culture is Bay Area water breeding? It’s tasteless and so rude. Some kind of sponsored ‘creative accounting’ shenanigans to promote some agenda. These are not real people. At times like this, I feel obligated to apologize to the rest of the world on behalf of California. Sometimes it looks like the entire state has been raised by a family of traveling clowns who got lost near the Nevada border and decided to adopt the feral citizenry of CA. Leadership in Sacramento doesn’t help.
How does imgur stay alive, out of curiosity.
I am, and that's the thing - if it's my property, and I go to the council meetings and what not, then you're kinda stuck.

> Also, it's much more costly to build infrastructure for low-density development, so you're complaining about a problem which your advocacy directly causes

My real complaint here is this--and I'll use a recent event as an example. In a town (not city) I used to live in, adjacent to a major city, somehow some developer got approval to build these really narrow row-home style town houses - 3 deep from the street and about 20 units wide. About 12 of these things. About a year has passed and this housing is up and ready for service. The additional roads that support that population increase will probably take at least 5 times as long. Until infrastructure improvement is strictly tied to additional housing supply and one doesn't move without the other, it doesn't benefit me to have more people in a place I live clogging up the roads.

> Oh, and lack of public transportation directly increases traffic

Goes back into antagonistic culture. How can we keep public transportation safe and without criminal elements? We need to really solve a bunch of problems first - some of which are economic (homelessness), and some of which are culture (people using these facilities for drugs and as bathrooms, etc.) before it's something I really want.
Wow, the story is literally that government officials have been briefing reporters and may have an angle to sell.
Wow, this looks so awesome! Really simple UI too — gonna have to give this a try. I was just struggling with some client-side image upload stuff last week, and I love the idea of doing the full service integration from client to backend as a product.

BTW - I’m part of the dev advocate team at Cloudflare, would you want to chat sometime about your experience with Images? Definitely would love to hear your perspective as a dev on what could be better!
This is astrology-tier. Look into the Illuminati card game for some baffling predictions.
Just watched two episodes of Better Call Saul on Netflix Germany without issues (while not being able to run my Terraform plan against my eu-central-1 infrastructure…).
Notepad is core OS functionality? I think not.
I don't really see the selling point of upgrading to Windows 11 - what does it get me, a moderate power user who is moderately set in his ways
Biden Vaccine Mandate for Federal Contractors Is Blocked Nationwide
Looks interesting. It appears to be missing bear bags for food. Are customers taught how to survive in the woods or is it expected they already have camping/hiking experience? Will there be a version for cold weather and high altitudes, maybe with a thicker or different material? Have you also thought about accessories like thermal water bags that could be suspended above the Jupe to provide a shower or drinking water with some pass-through interface? It looks easier to set up than a Yurt but more heavy duty than a WWII style military tent. Is there a time lapse video of people setting one up from start to finish without video cuts/edits?
At my org it was deployed in the middle, around the fourth wave iirc
I view twitch and youtube as two completely different types of content. Twitch is livestreaming and youtube is prepared, scripted content. Sorta like 24/7 cable news channels vs a documentary or drama series. A lot of people have a preference for one or the other and I definitely prefer the latter. Especially since the "news" that happens on twitch often seems to be twitch-specific drama.
With Postgres, you can do log-shipping replication using whatever mechanism you like to deliver the WAL files, with no direct network connection between the primary and standby servers.

It's still kind of roll-your-own, because you need to provide shell scripts to handle archiving, fetching and cleaning up the log files on either end, but it can be done.
In my opinion there is a lack of talent in these industries for building out there own resilient systems. IT people and engineers get lazy.
> According to the post, the rover was located 80 meters away (about 262 feet) and is expected to reach the site in another two to three months of trekking.

That is unbelievably slow. Assuming it's heading in a straight line, if it travels 80m in 90 days, that's 3.7 centimetres per hour, which is slower than bamboo grows.

Fortunately the rover doesn't have to be right next to the object to dispel some of its mysteriousness, and maybe after a month the image will be clear and mundane enough that the object won't be newsworthy any more.
According to the Axios article, the lawsuits are about antitrust, not alleged fraud. As I detailed, the reason newspapers are in a precarious financial position is because they previously held a geographic monopoly on classifieds advertising in their cities, but now the Internet (starting with Craigslist) destroyed their monopoly & greatly lowered classified rates by its sheer size. This would have happened, and indeed already did, without Google or Facebook existing
> Microsoft has not added any functionality to their operating system or applications since 1998

This is simply absolute nonsense. Are you really contending that no real functionality has been added to Windows since Windows NT? I know HN loves to hate Microsoft but are we really upvoting this crap?
For the record I wouldn't argue "blockchain" is the only possible means of decentralization/distribution for offloading graphics compute.

With that said, an example would be a solo artist making CGI in C4D for a client/hobby (this is a small subset of potential use cases, but most relatable today).

Typical workflow costs would look like:
- Local Workstation ($4K w/ 2 high end nvda gpus)
- Render 2000 frames at 4K resolution for final render (need a better figure here but let's call it $500)
- Time spent on workflow rendering - 5 hours
- Time spent on final rendering - 10 hours

In a decentralized render situation:
- Local computer ($500 - in theory no discrete graphics necessary)
- Render 2000 frames at 4K resolution ($100)
- Time spent on workflow rendering - 1 hour
- Time spent on final rendering - 2 hours

I'm not trying to handwave at the data here btw, I just have a day job and want to answer promptly. RNDR is far and away cheaper at the moment than local or render farm compute: https://twitter.com/rsquires/status/1466599124451487744

Here are the main reasons why it's cheaper:
- Most decentralized GPU operators are "running at a loss" -- people who own GPUs don't expect a return so any dollars earned while they're idle is good with them.
- No "datacenter tax". Server GPUs are objectively more expensive than the network's GPU's which bias towards consumer.
- In terms of time, rendering is one of the most parallelizable workloads. 2000 frames rendered sequentially on a cloud instance is just slower than 2000 frames rendered in parallel on 50 cloud instances.

For QoS, because it's so much cheaper, redundancy is much more justifiable to add to the system.

On compatibility, an SDK would allow people to build their own products that leverage the compute of the network. That's not something there is a high incentive for centralized render farms to offer.

If you want to go deep I highly recommend recent podcast with CEO of OTOY and the two hosts of the Mograph podcast: https://www.youtube.com/watch?v=SRtOMF4JKd4
A whopping 64 words. That's a pretty weak "article".
Sorry may bad - I do see how it comes across that way but I'm not saying Microsoft's platform is perfect either or in any way hawking.
You mean Napster? It did take off...
Why hate?
I don't hate, Microsoft or Office, or anything like that. Those are choices, things. You can't hate things.
I agree with this OP that office had all the functionality almost everyone needed twenty years ago. Most of the changes to office have been cosmetic and frustrating to established users. Perhaps their could have been add ons - like in browsers, for more functionality that certain users need, without
messing with established work flows and ease of use, which are also important.
out of curiosity, how often do you do this? And once you discover something, how do you get it into your music app / playlist?
Come on, we all know managers don’t want to claim an outage till the last minute.
It was down as of 7:45am (we posted in our engineering channel), so that's a good 40 minutes of public errors before the root cause was figured out.
Don’t we have an advantage in studying RNA (or “junk” DNA) over proteins in that sequencing of nucleic acids is far easier than sequencing of proteins? Seems fortuitous for our research efforts that these nucleic acids play a bigger role in biology than we initially thought.
sway for coding and gnome when need to talk via zoom
But that still begs the question.

What's the launch platform? How do you program the drones to find its target?

Its not too hard to imagine the drone as a slow-moving missile, with maybe a similar launch platform where drones can be easily programmed with GPS-coordinates and go off on their mission.

But the minute we think about logistics of storing, programming, and deploying this hypothetical weapon... we realize that we're just building a really crappy version of the MLRS (multiple-launch rocket system).
Credit Score
Credit scores mean nothing. They are a scam designed by banks to make people pay high interest rates and penalize them for payment in cash.
I would report my credit score as “these nuts.” I can give a s less what my credit score is lol.
I use https://everynoise.com/ and randomly spam clicks until I hear a category worth exploring.
My interpretation is people just care about local news far less than they used to? I’m in a semi-major city and the local news is only a small part of my news consumption.
Worth a look, certainly. Also very possible that this John is upfront about honest postmortems and like a good leader takes the blame, whereas Sally and Mike are out all day playing politics looking for how to shift blame so nothing has their name attached. Most larger companies that's how it goes.
> Don't confuse "official" with "true".

I’m not.

The claim in the article which provided the story is that it is the “official Chinese story”. The article carefully avoids claiming that the story is true, though it obviously wants people to conclude that.

> Beijing is happy, officially, to accept Washington's story that they clumsily crashed into a rock.

Right. So the simplest claim in the article about the story—that it is China’s official story—is simply false.

> The "true" story is really only relevant to the military planners on both sides. And presently it doesn't serve either of their interests to broadcast it publicly.

Or, maybe the true story is what is officially broadcast, and the one with the obvious lie about the nature of the story is false beyond just that obvious lie?
> ~~I got two 9 problems cuz of us-east-1~~

I left my two nines problems in us-east-1
https://www.thelifedoctor.org/the-narcissist-s-prayer
Building an OpenTable Bot
Or problems just persisting, because the fix is easy, but explaining it to others who do not work on the system are hard. Esp. justifying why it won't cause an issue, and being told that the fixes need to be done via scripts that will only ever be used once, but nevertheless needs to be code reviewed and tested...

I wanted to be proactive and fix things before they became an issue, but such things just drained life out of me, to the point I just left.
The Unfunny War Between Comedians and Spotify