makoz (u/makoz) - Readit News

makoz commented on Neon Serverless Postgres is generally available neon.tech/blog/neon-ga... · Posted by u/refset

> Postgres continues to hold its position as one of the most popular developer databases ever created.

Not bashing Postgres, however that statement is an overstatement. Postgres was a "it exists" database back in the early 2000's.

All the scripts my scripts kiddie paws could get on were always orientated towards MySQL.

Uploading .php3 files on 56k were my teenagers eyes of fun.

makoz · 2 years ago

Disclaimer work at AWS.

> Postgres was a "it exists" database back in the early 2000's.

If we're really nitpicking it's not saying Postgres is the most popular database since the early 2000's. If you base it of off install counts as the metric, I would assume the statement is true since I'd think it's either Postgres or MySQL today.

makoz commented on Nile: Serverless Postgres for modern SaaS thenile.dev/blog/introduc... · Posted by u/yarapavan

infra_dev · 2 years ago

Nile CEO here. Nile abstracts away compute machines and provides an experience where you can easily scale up or down based on the load you push.

Specifically, Nile lets you do the following - Create a database and start querying it. Nile takes care of adding capacity to tenants as workload increases. - Pay for what you use. You will only pay for what you use. We have plans for pricing where you can pay based on usage per tenant. This will ensure your business value is aligned with the cost of your database. For example, a customer on your free tier may not be an active user and you would not pay for them in Nile. - We have built multitenancy into Postgres and a gateway layer that routes. This helps us to scale to zero with instant availability when you want to scale back up.

- You can create even a million tenants if you have that many customers. - We have built connection pooling into Nile. This helps to provide limitless connections as you grow

makoz · 2 years ago

Disclaimer work at AWS.

I'm still trying to understand the scaling story better. When we say serverless it mentions automatically scaling when it detects some sense of resource pressure. If I have a "hot tenant-database", does that mean this shard will be scaled automatically without impact to existing queries? Or would there be some "blip". I suppose it's unavoidable in edge cases but curious about the regular ones as well.

It's an incredibly cool CX you have here with the automated query routing/tenancy story though, looking forward to what happens in this space.

makoz commented on Fly.io Postgres cluster down for 3 days, no word from them about it webcache.googleuserconten... · Posted by u/burnerbob

Jupe · 3 years ago

Ouch?

The bad news is that I'd be out of a job if I chose your service in this instance. 47 hours is two full days. For an entire cluster to be down for that long is just unacceptable. Rebuilding a cluster from the last-known-good backup should not take that long, unless there are PBs of data involved; dividing such large data stores into separate clusters/instances seems warranted. Solution archs should steer customers to multiple, smaller clusters (sharding) whenever possible. It is far better to have some customers impacted (or just some of your customer's customers) than have all impacted, in my not so humble opinion.

And, if the data size is smaller, you may want to trigger a full rebuild earlier in your DR workflows just as an insurance policy.

The good news is that only a single cluster was impacted. When the "big boys" go down, everything is impacted... but customers don't really care about that.

Not sure if this impacted customer had other instances that were working for them?

makoz · 3 years ago

Disclaimer work in AWS.

> Rebuilding a cluster from the last-known-good backup should not take that long

It's not even clear if that's the right thing to do as a service provider.

Let's say you host a database on some database service, and the entire host is lost. I don't think you want the service provider to restore automatically from the last backup because it makes assumptions about what data loss you're tolerant to. If it just works from the last backup, suddenly you're potentially missing a day of transactions that you thought were there that magically disappears as opposed to knowing they disappeared from a hard break.

makoz commented on Fly.io Postgres cluster down for 3 days, no word from them about it webcache.googleuserconten... · Posted by u/burnerbob

remram · 3 years ago

Single-AZ i not single-host though, and while a single AZ can go down for major events, it doesn't break because a single piece of hardware failed.

makoz · 3 years ago

Sure, but isn't this more about risk tolerance at this point and how much your customers care about? Where the responsibility should be on customer's end. Running on EBS/RDS doesn't guarantee you won't lose data. If you care about it, you enable backups and test recovery.

Just because some customers are less fault tolerant than others, doesn't mean we shouldn't offer those options where people don't have the same requirements or are willing to work around it.

makoz commented on The tug-of-war over server-side WebAssembly digest.browsertech.com/ar... · Posted by u/paulgb

samsquire · 3 years ago

This is a timely article for me since I've been trying to learn more about webassembly lately, thank you for it.

I think the system interface is probably extremely important and significant part of webassembly and history. It's history making. It's the definition of a foundational interface that all users of webassembly shall inherit and need to target if it takes off. Which I hope it does. A standardised bytecode format is awesome!

Why do I say this? The binary interface for C programming such as the amd64 SysV calling convention is established and is important for C FFI interoperability. Likewise, the syscall interface for Linux is established and so is Win32 API or POSIX.

If people are trying to compile existing code so it doesn't need to be changed to support webassembly, then that's one constraint. Another constraint is performant Javascript interop. Another constraint which I personally find most interesting is the capability of defining a new API that is fit for purpose for application development. So that incorporates threading, garbage collection and sockets.

makoz · 3 years ago

OOC how are you going about learning more about webassembly?

makoz commented on Amazon employees push CEO Andy Jassy to drop return-to-office mandate cnbc.com/2023/02/21/amazo... · Posted by u/mmurph211

jonas21 · 3 years ago

> just to sit in a stuffy room and zoom

Presumably, that's what the return to office plan is trying to fix. Right now, if you go into the office, you're spending a lot of time in zoom calls because half the people in every meeting aren't there. If everyone's in the office, you can just meet in person.

makoz · 3 years ago

Disclaimer work in Amazon.

That at least doesn't work at all in my situation. I'm based in Seattle and I collaborate regularly with folks in probably 3-4 other geographic locations, ironically no one actually in Seattle.

If anything getting the video conferencing to work in a meeting room is more of a hassle/friction and a poorer experience when you still have to accommodate someone remote.

makoz commented on Amazon will require employees return to the office 3 days a week seattletimes.com/business... · Posted by u/twiddling

alright_scowl · 3 years ago

Some talking points are repeated ad exhaustion as if they were absolute truths, when they are largely relative:

- People collaborate better in person: Bullshit, a lot of developers collaborate better through text. Code Reviews, code snippets on Slack, quick screen shares, diagrams. In fact, verbal communication is very inefficient, prone to inaccuracy and misunderstandings.

- Junior developers don't get mentoring: Bullshit. Most developers are self learners (that's how most people learn to code anyway). Plenty of great material online, from tutorials, to stack overflow, to Indian dudes doing videos on YouTube. Mentoring is largely overblown, and can still happen through text,

- Humans are social beings and need human interaction: Bullshit. Many developers are introverts. And if you are not, find ways to socialize outside of work. Find a hobby with a community or a meetup close to whwre you live. Anything, from tabletop games, running, playing soccer, magic the gathering. Do a language class on your free time, go to a music concert, anything. When you are remote, the world is your oyster.

makoz · 3 years ago

Disclaimer: work at AWS

For the record I'd prefer a work environment that's closer to maybe 1-2 times a month in the office.

> Most developers are self learners (that's how most people learn to code anyway)

I don't think that's true. If you poll the vast majority of people in intro to CS class, most people never coded before. I recall it being a small minority at least back when I was in school (> 10 years ago).

There's also stats comparing before WFH and after of how long long it takes someone to onboard properly/be productive (forget the exact stat/KPI, mix of survey/commit stats?) and it's extended by a few months. Now that might be due to bad on-boarding since it wasn't a remote-first, but if that still exists years later it is interesting

> People collaborate better in person: Bullshit, a lot of developers collaborate better through text

Agree with that. I really wish we would write better docs and have more of an async setup

I do genuinely think there's aspect/learning that is lost/slower in the last few years, but that might be because we haven't really thought about accepting "remote-first" and trying to shoehorn what we already had into WFH model.

makoz commented on Chess.com Says Hans Niemann’s $100M Lawsuit Is a ‘Public Relations Stunt’ vice.com/en/article/k7b9e... · Posted by u/isaacfrond

whaaswijk · 3 years ago

So there can be no redemption? I can’t, off the top of my head, think of any endeavors where someone can never participate again once they’ve cheated. Certainly not in sports.

makoz · 3 years ago

Really? Doping and Lance Armstrong is the first thing that comes to mind. Although I guess we could argue he wasn't competing anymore

makoz commented on Amazon confirms corporate staff cuts that could hit 10k employees wsj.com/articles/amazon-t... · Posted by u/mfiguiere

malfist · 3 years ago

That's why I had a disclaimer about being hired this year.

If you weren't hired this year your base is likely still around the 160k

makoz · 3 years ago

Data point of one and all that, but I got a decent bump in base and have been with the company for more than a few years. I assume that's true for almost everyone else based off the Blind posts.