cldellow

7 ms·

31.
by cldellow 3y ago
The SQLite limitations might also be solvable by sharding the databases (so each sees 1/N of the write volume), tiering them (so tiles that are written most recently are in file A, then file B, then file C), or a combination of these a
32.
by cldellow 3y ago
You often want to build your own tiles for specialized applications. Any map schema is a tradeoff -- if you include every feature in every tile at every zoom level so that the renderer can pick and choose what to show, you bloat the tile fi
33.
by cldellow 3y ago
It seems unlikely to me that the OSMF did something shady in exchange for the promise of 6,000 Euros from Cesium. The OSM Buildings folks called themselves "OSM Buildings", using the OSM trademark. They offered a commercial servic
34.
by cldellow 3y ago
The site loads https://storage.googleapis.com/bikebucket123/BikeRacksWithAd... , which looks like a dump of OpenStreetMap data. I'm guessing they're just rendering the amenity=bicycle_parking entries. [1]: ht
35.
by cldellow 3y ago
A previous discussion (flagged, for some reason): https://news.ycombinator.com/item?id=38517333 I tend to agree with the OP. The potential employer is starting the relationship on a deceitful basis. There's a reason pe
36.
by cldellow 3y ago
The graveyard that is Google's issue tracker has an abandoned ticket about this: https://issuetracker.google.com/issues/261579123
37.
by cldellow 3y ago
Natural joins also automatically break your queries when two columns happen to share a name but not the same meaning. Step 1: use natural join. Life is great. Step 2: someone adds a `comment` field on table A. Life is great. Step 3: someone
38.
by cldellow 3y ago
If you invoked the fifth, you'd be made fun of, since that's a US thing. But section 7 of the Charter of Rights and Freedoms: > Everyone has the right to life, liberty and security of the person and the right not to be deprived
39.
by cldellow 3y ago
A quick Google suggests that early cars were also lighter--probably easier to hoick about a 1,200 lb Model T than a 3,000 lb Camry.
40.
by cldellow 3y ago
(not the OP, but I have some experience with Shopify) Shopify stores publish their product catalog at /products.json. From personal experience, you can hammer it pretty hard without being rate limited. A challenge is that the pricing i
41.
by cldellow 3y ago
Yes, why wouldn't I think that? As I said, I trust Mike Masnick. I also have past professional experience that leads me to believe Google does what's easiest for Google, not what's best for their customers. In one case, Googl
42.
by cldellow 3y ago
You talk about loopholes three times in this comment. > Because they are using 237 Tb in an unlimited service from Google Google's a trillion dollar company. A popular saying amongst Googlers is "I don't know how to count
43.
by cldellow 3y ago
You've put "learned the news" in quote, but what Greg Brockman wrote was "based on today's news". That could simply mean that he disagreed with the outcome and is expressing that disagreement by quitting. EDIT:
44.
by cldellow 3y ago
Looking at archive.org, I think this was only added in their most recent May 1, 2023 TOS update. He might be the reason it now exists in the TOS. :)
45.
by cldellow 3y ago
Vercel's terms are at https://vercel.com/legal/terms . A handful of possible violations from section 6, Acceptable Use: - The Services may only be used for lawful purposes. - You shall not attempt to undermine the
46.
by cldellow 3y ago
I used to be a personal support worker for adults with cognitive and physical disabilities. In some sense, I was a non-AI solution that enabled them to do their activities of daily living. I'm pretty sure they'd have preferred not
47.
by cldellow 3y ago
R2 is significantly cheaper for egress, but not for API calls. It's still cheaper for API calls, but only by 10%: - 1M GETs $0.36 (R2) vs $0.40 (S3) - 1M PUTs $4.50 (R2) vs $5.00 (S3)
48.
by cldellow 3y ago
Stripe isn't removing your posts. It's us, the readers of HN, who are removing them, because you refuse to follow the rules of this site.
49.
by cldellow 3y ago
Where do you get that from? According to https://zerowater.com/pages/frequently-asked-questions , > Does the ZeroWater® 5-stage filter reduce bacteria? > The current system is meant to be used with municipally tre
50.
by cldellow 3y ago
Brita/ZeroWater filters make potable water cleaner such that it tastes better. This filter makes non-potable water cleaner such that it won't kill you/make you seriously ill.
51.
by cldellow 3y ago
Sorta related: when I was 22 or so, a friend and I sold some software to a school district. We were young, poor engineers with no idea how sales worked. When they asked what the price was, we picked a nice round number that sounded appealin
52.
by cldellow 3y ago
I would believe that scraping is why they now require users to be authenticated. But given that they now require users to be logged in, it should be computationally cheap to drop unauthenticated requests at the front door before they incur
53.
by cldellow 3y ago
Maybe. It's really hard for me to believe that a uniform 600 tweets read per _day_ limit for almost _all_ accounts is the best tool they have to mitigate a scraping attack. They likely have great insight into the risk profiles of each
54.
by cldellow 3y ago
I worked for several years in the ad tech space. Display ads on the open web are...something else. IMO, second price auctions don't work well in the online ad world. In the real world, you know: (1) all bids are submitted before being
55.
by cldellow 3y ago
I'm not the person you replied to, but it's janky for me, too. Console logs: device: undefined, fps: 60, gpu: amd renoir, isMobile: false, tier: 3 FWIW, my laptop is a relatively beefy 2021 model (granted, with integrated GPU). Fo
56.
by cldellow 3y ago
As a meta point, it's interesting that 4 lawyers signed this letter: - Timothy Parlatore, a criminal defense lawyer - John Rowley, a former federal prosecutor, and now a criminal defense lawyer - Jim Trusty, a former federal prosecutor
57.
by cldellow 3y ago
The argument is that he didn't (a) disclose what he was doing, nor (b) disclose that he owned the company where the money went. I work at a very, very small startup. Even our very small startup has by-laws that cover this: > An offi
58.
by cldellow 3y ago
I think the spirit of the Stable Diffusion moment comment is that there is a ton of work blossoming around LLMs, largely because there's a good base model that is now available. And that's undeniable, IMO -- llama.cpp, vicuna are
59.
by cldellow 3y ago
Canada has some national parks that do something like this. Lake O'Hara's booking system this year is a random queue: > In lieu of a random draw, Parks Canada will be employing a queuing system to help manage the expected high
60.
by cldellow 3y ago
For anyone else who runs into this: this is configurable via the cog icon in the upper left corner - you can disable the typewriter effect altogether, or speed it up.

More ›