HNHacker News
TopNewBestAskShowJobs

dreyfan

1,508 karma · joined April 18, 2016

submissionscomments
dreyfan··on Spending $5k to learn how database indexes work
Sure, but we're addressing people who are so far on the other end of the spectrum they're using a "serverless" database where they pay for the number of rows scanned per query. I think a managed DB is a better middle-ground for their capability level while still delivering massive cost-savings.

Amazon RDS lowest-tier runs about $13/mo for 10GB storage, 2 vCPUs and 1GB memory with automated backups and push-button restoring. And that would have likely met all of their needs with capacity to spare.

dreyfan··on Spending $5k to learn how database indexes work
Don’t use DB providers that charge for rows/data scanned. Use Amazon RDS or Google Cloud SQL or just install it yourself on a VM. Pay for CPU, memory, and storage instead.
dreyfan··on Ask HN: How were video games from the 90s so efficient?
Sure, but there are <1% of the games being produced that need to tackle those problems. Look at the most of 10,000+ games released on Steam or the endless mobile games released over the past year.

For every Naughty Dog, Riot, Take-Two, CDPR, or Bethesda, there are thousands of garbage studios. Thus my “Broadly speaking” caveat.

dreyfan··on Ask HN: How were video games from the 90s so efficient?
Right. I think it's mostly subconscious. If you crank out CRUD app or some basic FPS in Unity, you're left wanting more and turn to the toolchain to find that complexity. 25 years ago, devs had no unmet craving after optimizing netcode for an 8-player game with 28.8k users or implementing another soundcard API by hand.
dreyfan··on Ask HN: How were video games from the 90s so efficient?
Broadly speaking, modern developers don’t have to deal with resource limitations (neither computing nor financial) so they instead devote that extra energy on completely unnecessary orchestration systems and build toolchains to feel like they’re doing something complex and challenging.
dreyfan··on Why SQLite does not use Git (2018)
> Complexity == popularity == profit

Entire node/js/ts ecosystem resonates strongly here. They reinvent the wheel, assign it a new name, thought-leaders market those inventions to every corner of the tech ecosystem, and then they add another few layers to their build chain.

dreyfan··on Goodbye CSS Modules, Hello TailwindCSS
Bootstrap and numerous other popular CSS frameworks, notably any with grid layout and/or utility classes, have done that for the past decade+. So Tailwind is the modern/popular CSS framework?
dreyfan··on Goodbye CSS Modules, Hello TailwindCSS
> The biggest one being that you have to jump between files when modifying a single UI

Can you expand on why you were doing that in the first place?

Your comment reads like CSS just finally clicked for you (e.g. reusing classes instead of specific IDs, and the entire principle of cascading/inheritance) and are attributing that to Tailwind or something.

dreyfan··on HashiCorp – S1
> Was major Roblox outage Nomad-related

They haven't posted a detailed post-mortem yet but it's more likely consul related that in-turn brought down vault and nomad.

dreyfan··on TimescaleDB vs ClickHouse
That's a really helpful post, thank you
dreyfan··on TimescaleDB vs ClickHouse
I honestly don't know what time-series databases do that's particularly unique. I've worked databases for 20+ years and a date or datetime has always been an integral part of the dataset and thus everything to me is time-series. I always seem them compared against key-value stores or document-oriented databases or NoSQL platforms, which more speaks to people not knowing how to use the correct datastore in the first place than any particular feature of a TSDB.

Even looking at your benchmark queries, I'm confused what value it provides over a standard OLTP or OLAP setup.

dreyfan··on Please Shrink the Trackpad
Alternate opinion: Trackpads are the annoying thing you deal with when an external mouse isn’t viable.
dreyfan··on Zillow to stop flipping homes, loses more than $550M, lays off 25% of staff
With the complete rout today of -11.5% and the additional -11.0% aftermarket on Zillow's stock, it's still up +95% from when Chanos made that comment.

Calling bullshit simply isn't worth the hassle these days (e.g. see Tesla and cryptocurrency fans). Better to figure out how to identify the top and keep opinions to yourself.

dreyfan··on Javascript RORO pattern
You lose the usefulness of IDE argument typehints (now you just get a [Object] requirement) and still need to look somewhere to know which parameters are required and which are optional in your object. And if you mistype the key/tag, nothing tells you about it.

Pass descriptively named variables instead imo.

dreyfan··on Facebook Stole Our Name and Livelihood
That means literally zero.
dreyfan··on An Update on Our Outage
You mean it wasn't an arbitrary edge case in a database the company doesn't even use?
dreyfan··on Roblox has been down for days and it’s not because of Chipotle
Was it because your primary key was an unsigned 32-bit integer and that’s not an “issue”.
dreyfan··on Zillow has listed 93% of the hundreds of Phoenix homes it owns at a loss
I understand that, I'm not suggesting it's a scam or anything (though typically in the US a home seller pays 3% to the buyers agent and 3% to the sellers agent). I'm saying when Bloomberg exclaims "Zillow is selling homes at a loss!" they're missing the point of the strategy. As long as the price they sell for still exceeds the fees they take, it's a profitable move.

Also many of these transactions do not involve traditional brokerages whatsoever. People sell their homes directly to Zillow and other people buy the homes directly from Zillow.

dreyfan··on Zillow has listed 93% of the hundreds of Phoenix homes it owns at a loss
Zillow is the brokerage and they take fees when they buy the home from their users and depending on how they sell it they often take fees on that side of the transaction too. So when you see that Zillow "bought" a home at $500,000, the seller actually gets closer to $450,000 on average. They of course want the $500k price tag to hit the MLS records though, since it supports the endlessly appreciating housing market narrative.

It's not as simple as a buy-low sell-high home flipping strategy.

> "Altogether, Zillow Offers fees can add up to as much as 22% of your home’s sale price — much more than you’d pay while selling on the open market."

[1] https://www.realestatewitch.com/zillow-instant-offers/

dreyfan··on Investors Spent Millions on ‘Evolved Apes’ NFTs. Then They Got Scammed
They weren’t scammed anymore than roulette “scams” many of its players. NFTs are pure speculation and gambling.
dreyfan··on GitHub Copilot available for JetBrains and Neovim
It’s a dream come true for the script kiddies.
dreyfan··on Ivermectin shows that not all science is worth following
Low population density, a largely outdoor existence, and a very low rate of testing and reporting.
dreyfan··on Ask HN: Is the Great Resignation in tech real? If so, why?
Low interest rates -> cheap capital -> lots of tech funding -> lots of jobs.
dreyfan··on What do I need to read to be a CSS dev?
> Don't waste time reading a book

I’m guessing you have little experience with books but the general approach is you read something and then practice what you just learned.

dreyfan··on Kubernetes ingress-nginx controller vulnerability
The people downvoting you did so while waiting on npm install to run.
dreyfan··on Building the Brex API
> Isn't that just fancy phrasing for a username/password?

Not quite. username/password authenticate who or what something is; bearer tokens permit what actions can be taken by the holder of that token, and tend to be short-lived in nature and ideally for very specific actions.

dreyfan··on Comparing ClickHouse to PostgreSQL and TimescaleDB for time-series data
https://blog.cloudflare.com/http-analytics-for-6m-requests-p...

has some good thoughts. The main thing you'll likely need is some sort of a buffer layer so you can do bulk inserts. Do not write a high-volume of single-row inserts into Clickhouse.

dreyfan··on Gov Parson pushes to prosecute reporter who found security flaw in state site
The US is so completely and utterly fucked I think it's beyond redemption at this point.
dreyfan··on The reports of Perl’s death have been greatly exaggerated
There’s far more venture capital than innovative ideas and the business problems are rarely hard to solve. Engineers get bored so we have a constant flow of new languages, frameworks, and lately, an overwhelming focus on tooling and infrastructure.

At the end of the day, most companies are just generating dynamic HTML after performing some rudimentary CRUD database operations. It’s disappointing so much time and money is spent only to arrive at the same place that /cgi-bin/ and a perl script solved over two decades ago.

dreyfan··on Why I Hate Frameworks (2005)
tldr: OOP sucks.
← PreviousPage 3 of 8Next →