Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
benjiro
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
16 ms
·
121.
▲
by
benjiro
1y ago
YugabyteDB / CockroachDB like from that description. Curios to see how it competes with multigres.
122.
▲
by
benjiro
1y ago
Never mind ... clearly i am the issue.
123.
▲
by
benjiro
1y ago
> There's nothing special about it Wait when you need to manage a bunch of servers yourself. Unfortunately, the solutions available are complex, and not something where you can simply points something to a server, or VPS, and have a
124.
▲
by
benjiro
1y ago
OrioleDB looks interesting but the with the storage changes, the issue will be the compatability with other extensions. pg_search (paradedb), timescale come to mind. We have seen this issue with YugabyteDB, and their integration off RocksDB
125.
▲
by
benjiro
1y ago
Its not a "Europe" issue alone but even more locally. Saying this as a IT guy, we had way too many talks with banks about IT projects that in the US will have been way easier. But in specific EU countries was constantly met with &
126.
▲
by
benjiro
1y ago
> The reason is that they were using them as financial instruments and now they have less confidence on the West. So they are moving to other things. Only partially correct. The reason why so many Chinese invested into the West is becau
127.
▲
by
benjiro
1y ago
DuckDB is a columnar database, and columnar DBs are way better for analytics, statistics... That is its main reason for its popularity, the ability to run specific workloads that row based databases will struggle/be slower at. Nothing
128.
▲
by
benjiro
1y ago
Just want to point out that your 50 req/sec cached means nothing in case of dealing with scrapers. What is the entire topic ... he issue is that scrapers hit so many pages, that you can never cache everything. If you website is a 5 pag
129.
▲
by
benjiro
1y ago
I need to agree with the author, with a caveat. He is a well developed developer. For somebody like him, churning out good quality code is probably easy. Where i expect to see a lot of those metrics of feeling fast come from, is from people
130.
▲
by
benjiro
1y ago
> Is that WP Core or a result of plugins? Combination of all ... Take in account, its been 8 years when i last worked in PHP and wordpress, so maybe things have improved but i doubt it as some issues are structural. * PHP is a fire and f
131.
▲
by
benjiro
1y ago
Ironic part ... LLM are very good as solving CAPTCHA's. So the only people bothered by those same CAPTCHA's are the actual site visitors. What sites need to do is temp block repeat request from the same IPs. Sure, some agents use
132.
▲
by
benjiro
1y ago
> one of those was definitely not "traffic quintuples." O, it was... People warned about the mass usage of WordPress because of its performance issues. The internet usage kept growing, even without LLM scraping in mass. Everyb
133.
▲
by
benjiro
1y ago
Its been a few years when i last worked with WP. But the performance issue is because they store a ton of the data in a key value store, instead of table with fixed columns. This can result in a ton of individual row hits on your database,
134.
▲
by
benjiro
1y ago
Why do you need to buy more expensive hardware? The thing is, if you run a old Xeon server, and compare that performance vs modern consumer level hardware. Unless you are bought a 50~64 core server (and the power bill to match), your often
135.
▲
by
benjiro
1y ago
> For storage, Hetzner does offer Volumes, which you can attach to your VM The argument was about dedicated hardware. But it still holds for VPS. Have you seen the price of Cloud Storage? ARM VPS 40GB is 4.51 (inc tax), for 40GB storage,
136.
▲
by
benjiro
1y ago
Trust me, even with 35 cent/kwh (Germany), its easy to make it work. Just do not buy enterprise hardware. People are obsessed with running racks full of often obsolete hardware, that is not designed around energy efficiency. Here is a
137.
▲
by
benjiro
1y ago
> I will definitely buy my own hardware and collocate. Even colocation is often fraud with issues. I shall not mentioned the plectra of dead hardware from datacenter electricity failures. Ironically, my home has more stable electricity
138.
▲
by
benjiro
1y ago
> I don't believe they do the same for VPS / Cloud servers. Because its backed into the price. If you run a VPS for a month, you get the listed monthly price. But if you run a VPS for a shorter time, the hourly billing price i
139.
▲
by
benjiro
1y ago
> At Hetzner, you can rent a machine with 48 cores and 128GB of RAM for the same money. The problem that Hetzner and a lot of hardware providing hosts have, is the lack of affordable flexibility. Hetzner their design is based upon a base
140.
▲
by
benjiro
1y ago
A ton of stuff in PHP is mostly templating + DB calls for a lot of websites. If you combine Go + Templ for instance, your "if err" are mostly on the DB calls. What you needed to check in PHP anyway. Yes, the if err != nil is extre
141.
▲
by
benjiro
1y ago
And that is the core of the problem. Your buying a storage media that is a lot slower in sequential read/write, and also on random's. But your paying the price of the superior m.2 NVME's. SSDs need to sit more between HDD
142.
▲
by
benjiro
1y ago
The problem as pointed out by the author in the link, is that there simply is no storage solution that sits between a SATA HDD (cheapest 0.15 Euro/TB) > NVME (0.45 Euro/TB). Technically, SATA SSD's need to fill this spot a
143.
▲
by
benjiro
1y ago
The problem your overlooking is not just the upgrade vs new cost, but also the parts issue. Buying a brand new Framework tend to be more expensive then a ~ Chinese Laptop. *New vs Upgrade* In general, you can sell a second hand laptop at ar
144.
▲
by
benjiro
1y ago
Lithium-ion: produces its own oxygen, the reason why you get thermal runaways. LiFePO4: Does not produce its own oxygen, any fire (can happen) is limited to the surrounding air. A trend in home batteries, that we see now (because of killer
145.
▲
by
benjiro
1y ago
Also need to add, that a large part of the 80% that got kicked, was moderator staff. So it makes sense that after they removed too many developers, they ended up rehiring them. Take in account, Twitter their front end, the stuff that people
146.
▲
by
benjiro
1y ago
Annual revenue is not profit. This is the money earned without all the costs of running the business. For instance, the total revenue was 171m in 2024. But the cost of revenue was 86m. Then you need to remove the operation expenses, that ar
147.
▲
by
benjiro
1y ago
What amazes me more then the jet, is the amount of light pollution from the cities.
148.
▲
by
benjiro
1y ago
Point 6 grow a lot, with the recent UK chances requiring people to hand over their Identity to see xxx rated content. Privacy was a issue before but its getting worse and worse. Point 7 ... see the recent EU law about chat services needing
149.
▲
by
benjiro
1y ago
> With $1k you can build a pretty good system 1. The hardware you buy for these activities, has still residual value after 1, 2, 3 year. Unlike the streaming service you pay for. 2. Its cheap to upgrade / expand over time (if its no
150.
▲
by
benjiro
1y ago
Here is another offender "VanceAI" ... Try deleting your account with the delete button. Nothing happens. Everything on the site perfect, just that Delete button is broken (and the request times out). But wait, you can send a tick
More ›