HNHacker News
TopNewBestAskShowJobs

andrenotgiant

2,185 karma · joined September 27, 2010

submissionscomments
andrenotgiant··on Layoffs Don't Work
> After the early-2000s dotcom bust, Bain researchers found that stock prices for S&P 500 companies that had no layoffs or laid off less than 3% of their workforce increased an average of 9% in the next year. Meanwhile, stock prices were flat in companies that laid off between 3%-10% of their workers, and prices plummeted 38% for companies that laid off more than 10%.

Failing companies go through layoffs. Companies like Sun Microsystems, Kodak, Sears, Circuit City, Kmart all went through lots of layoffs. But everyone knows that's not what killed them.

andrenotgiant··on Siren Call of SQLite on the Server
Something I've always wondered... How do downstream DB integrations like Fivetran or other ELT services play with SQLite? It seems like that's another consideration for running it in production at a real company.
andrenotgiant··on They see your photos
This is a good example of the F in FUD marketing. I hope to never work for a company that has to scare people into using a worse product.
andrenotgiant··on Why does everyone run ancient Postgres versions?
(Neon employee) We auto-upgrade minor versions as long as they can be done autonomously. For major versions, you're right it's still manual but we're working on improving that. Here is our version policy: https://neon.tech/docs/postgresql/postgres-version-policy
andrenotgiant··on How does David Geffen Hall sound?
https://archive.is/nfpe9
andrenotgiant··on Marketing to Engineers (2001)
I think it goes even further.

I'm not sure if it's unique to developers, but many have tools and vendors that they HATE or LOVE with an irrational passion.

HATE - Seems often about tools or vendors that they had no choice in, but had to spend a great deal of time working with.

LOVE - Seems often about tools or vendors that they associate with advancements in their career.

These feelings of LOVE and HATE lead to emotional decisions.

andrenotgiant··on Vector database per tenant: new architecture for AI apps using Postgres
Would love to see how database-per-tenant compares on cost to putting everything in a single DB
andrenotgiant··on Neon Postgres vs. Supabase
(I work for Neon.) The author does not work for Neon. He did some one-time consulting work for us earlier this year. We didn't review or have input on this article. I'm sure he'll be happy to update it with the Supabase corrections he is a great guy who is trying to be genuinely helpful.
andrenotgiant··on Comparing different "SQL over HTTP" APIs
> Transactions over HTTP are complicated. The PlanetScale Serverless Driver (which is HTTP powered) supports transactions

How are they able to support transactions over HTTP?

andrenotgiant··on Comparing different "SQL over HTTP" APIs
Dumb questions:

1. I'm assuming all these HTTP API's use HTTP/2? 2. What is the real-world difference between using websockets and http for the Neon API?

andrenotgiant··on CFPB Takes Action Against Coding Boot Camp BloomTech and CEO Austen Allred
https://news.ycombinator.com/item?id=40071539
andrenotgiant··on Why is Postgres growing so fast?
For all the reasons shared here already, plus a compounding effect on top:

For every percentage point of marketshare that Postgres takes, the risk in choosing Postgres decreases, and the risk of choosing an alternative increases.

Risk is:

- Will it continue to develop, get bugs fixed, security holes patched?

- Will it work with all future tech my company adopts?

- Will it remain Open Source? - etc...

andrenotgiant··on PlanetScale performs layoff and prioritizes profitability
Don't you work for Planetscale? Why are you saying "they"? Were you affected by the layoffs?
andrenotgiant··on Writing a Postgres logical replication system in Golang
> not sure if it is worth the effort.

Exactly. Teams that are mature enough to use data branching in development likely already have a schema migration tool that handles the merge safely with all the necessary controls.

andrenotgiant··on PGlite – Postgres in WASM
How is this different than the one done by CrunchyData here https://www.crunchydata.com/blog/crazy-idea-to-postgres-in-t...
andrenotgiant··on Nextdoor's Heisensubscribe (and Other Dark Patterns)
That's not even the darkest dark pattern on NextDoor

When you try and switch your newsfeed to "recent posts only" they show a toast notification "Your selection expires in 60 days" https://imgur.com/1fZpleg

Presumably because they've found they can drive more engagement by recycling old controversial posts.

They are true innovators in dark patterns.

andrenotgiant··on Ask HN: Cost Effective Managed Postgres for Next.js App
What blockers did you run into on Vercel Postgres and Neon?

What do you expect to spend?

andrenotgiant··on New cancer drug kinder than chemotherapy
Chemo has tons of well-known long term negative effects. The idea with replacing Chemo with Blina is that it has a measurable similar short term effect (get rid of the bad cells) with less (so far) long term effects.
andrenotgiant··on New cancer drug kinder than chemotherapy
This has been my experience firsthand in the system too.

Childhood cancer (mostly Leukemia) treatment in the USA is a well-organized country-wide clinical study aimed, at this point, at carefully reducing the amount of high-intensity chemo via replacing it with drugs like the one in the article, Blina.

They have gotten so good at treating Leukemia that they are now optimizing for reducing the long-term negative health impacts that come as a result of the treatment.

There are still tragic cases where the patients systems don't respond well, or there are complications as a result of compromised immune systems, but everything I have experienced points to major advancements and continued progress towards improving outcomes.

andrenotgiant··on I'm sorry but I cannot fulfill this request it goes against OpenAI use policy
Everything on Amazon is shady knock-off garbage.

I made the mistake of buying bandaids from there, they looked like a brand name but slightly off, they gave my kids rashes.

I made the mistake of buying LED light bulbs from there, the brand name was reputable but who knows if what I actually got was the same brand or a copy, they started flickering and randomly going out within a year.

I made the mistake of buying an LED monitor from there. It turned out to be some third party seller with a ridiculous return policy, so even though I had been conditioned to think Amazon had good return policy, now that they let third party sellers set their own policies I had to eat 30% of cost to return it.

No more Amazon for me.

andrenotgiant··on We removed advertising cookies, here's what happened
Yeah I would actually believe that for sentry.io visitors, but for the internet at large, that seems high.
andrenotgiant··on AWS cancels serverless Postgres service that scales to zero
Do they auto-wake when you query them? How long does auto-wake take?
andrenotgiant··on Pg_rman: Backup/Restore Tool for PostgreSQL
Even more basic question, why either of these over pg_dump or pg_backrest?
andrenotgiant··on Can a pill prevent deaths from venomous snakebites?
betteridges law of headlines says no
andrenotgiant··on A Deep Dive into Neon and PolyScale
So polyscale is an edge-based cache for your DB. I immediately scrolled to the "Cache Invalidation" section, since that's the hard bit.

TL;DR - They also have you route your writes through Polyscale, and they watch the data being written to decide what needs to be invalidated, then it sounds like there's a fallback for complex queries that just looks at last time a table was hit.

I wonder how things like views and prepared statements work?

andrenotgiant··on Fast custom JSON.parse that preserves large/precise numbers in JavaScript
The interactive performance testing widgets in the blog post are really useful - is there a separate repo that has the code used to create those?
andrenotgiant··on Why cloud bandwidth is so obscenely expensive and what you can do about that
Great question. "Free Bandwidth" is almost worse than cheap bandwidth because in reality it means: "Secret bandwidth pricing/limiting"
andrenotgiant··on Why cloud bandwidth is so obscenely expensive and what you can do about that
Yeah I think the list is only highlighting the worst offenders. It would be more useful to also include the cheap VPS providers mentioned later, that would be:

- Scaleway: $0

- Hetzner: ~$490 _(article says bandwidth is free but I think above 20TB it's charged at 1 Euro/TB)_

- DigitalOcean/Vultr: ~$5k depending on compute usage _(you get a free bandwidth allowance based on compute)_

andrenotgiant··on ChDB: Embedded OLAP SQL Engine Powered by ClickHouse
I don't have an opinion, but this article gives a fairly unbiased comparison of DuckDB vs Clickhouse-local, which I imagine exhibits similar performance characteristics as ChDB, just without the embedded part: https://www.vantage.sh/blog/clickhouse-local-vs-duckdb
andrenotgiant··on Ask HN: Why are there no open source NVMe-native key value stores in 2023?
I think the original question came up after the recent Rails keynote where they mention that, with NVMe speeds, disk is cheaper and almost as fast as memory, so Redis is not as vital. https://youtu.be/iqXjGiQ_D-A?t=2836

So Solid Cache and Solid Queue just use the database (MySQL), which uses NVMe.

So now, in addition to: "You don't need a queue, just use Postgres/MySQL", we have "You don't need a cache, just use Postgres/MySQL"

← PreviousPage 2 of 13Next →