cldellow

Google Sheets has an extensibility system: you write a React app that renders as a sidebar inside the sheets UI. This exposes a few additional API endpoints vs the vanilla sheets API. For example, you can determine the selected range, when a user has edited a value, changed sheets, etc. We use this in our add-on to help people select a range. Sounds like it might help for you, too!

The extensibility system also lets you show a modal dialog, which we use for previewing API calls to third party HTTP servers -- sounds like a similar thing could work well for you, too.

You could also look at supporting named ranges if you don't already, so people can refer to a range as `FinanceData` instead of `Sheet 1!A3:F90`

Some more colour is that the OSM Buildings project didn't even ask permission to use the OSM mark. If they were a community project, this was permissible. If they were a commercial project, they ought to have sought permission from the OSMF.

Given that, it seems pretty reasonable to me that the OSMF's stance was basically: your name is your problem, if you think someone is infringing on it, it's up to you to enforce it.

The OSMF runs on a shoestring budget - something like $400,000/year, vs Wikimedia Foundation, which runs on $170,000,000/year. It would be a real shame if a potential donor thought this particular instance was a reason not to donate to the OSMF.

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 approaches.

I'm assuming the requirement is not really to build a single .mbtiles file, but to have some way for a process to serve the correct tile when given a z/x/y tuple.

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 file size.

The blog post is very light on details. My intuition is that this is primarily focused on powering the map on osm.org in service of people who edit OSM getting to see faster updates. This would be in keeping with their current raster tiles, which are not meant for use in "real" applications.

There are enough technical challenges in rolling out vector tiles with minutely updates for editors on OSM -- in my opinion, they should solve it for OSM first before thinking about committing to a specific schema for public use by other apps.

Still, anything that incentivizes innovation on vector tiles is pretty exciting. One option that could be interesting: provide "fat" builds of tiles that have every feature, and create tooling to do something akin to treeshaking so people can simplify the resulting tiles to only contain the features they need for their use case.

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 service. The OSMF was OK with this. It seems the OSMF is OK with a lot of things -- including permitting Cesium to use the OSM mark in their own commercial project.

Live and let live, may a thousand flowers bloom, etc.

Rather than reflect on the fact that their name was not really theirs, but relied on the goodwill of the OSM mark, the OSM Buildings folks decided to ragequit and shut down their project, dramatically claiming that their name was "seized by a multimillion dollar company"?

The whole thing is bizarre to me.

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]: https://wiki.openstreetmap.org/wiki/Tag:amenity%3Dbicycle_pa...

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 people absolutely drag recruiters who do this - it's because it's slimy. At least with a recruiter, the company has a degree of insulation.

If the CEO is going to send emails claiming they've pre-screened you, are excited about talking to you and that they will get back to you if you submit an application, then it's reasonable for people to call them out when they don't do this.

The graveyard that is Google's issue tracker has an abandoned ticket about this: https://issuetracker.google.com/issues/261579123

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 adds a `comment` field on table B. Ruh roh.

I'll use them in short-lived personal projects, but not on something where I'm collaborating with other people on software that evolves over several years.

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 thereof except in accordance with the principles of fundamental justice.

has been found to provide similar protections. You can be required to identify yourself, and, in drunk driving cases, you can be required to do roadside sobriety tests, but in general, you aren't obliged to answer questions from the police.

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.

(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 info in that endpoint is based on the stock Shopify catalog fields, and can be misleading depending on the specific theme customizations that the merchant uses.

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, Google suspended a Google Certified Publishing Partner's GAM account for several hours with no notice. The partner had several years of history with Google, did $100M/year of revenue with them, and had an assigned Google rep who did weekly calls with them.

Google reactivated the account, but only after significant disruption to the partner.

I agree that it's good to be a critical consumer of news, but eh, if it walks like a duck and quacks like a duck, it's probably Google being blissfully ignorant of the impact they have on their users.

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 that low". They're used to big numbers.

I work at a much smaller company. We are not a trillion dollar company. Even we, when offering an unlimited service, ask ourselves: "What happens if someone takes us up on this offer?"

It's not a loophole, it's what he paid for.

It's fine to stop offering an unlimited service. We did! My only beef with Google's conduct here is the 7 days of notice prior to deletion.

I've followed Mike Masnick's reporting in other cases. He seems like an even-handed, fair journalist. I trust that he's not hiding the ball, nor letting the other journalist mislead him about the situation.

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: Derp. I was reading the note he wrote to OpenAI staff. The tweet itself says "After learning today's news" -- still ambiguous as to when and where he learned the news.

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. :)

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 security or integrity of computing systems or networks of Vercel, its partners, or any other person, and must not attempt to gain unauthorized access.

- You may not use the services or Vercel's infrastructure for proxying, scraping, to create virtual private networks, or to create virtual private servers.

Reasonable people might disagree whether 12ft.io is being unlawful, undermining the integrity of a computing system, gaining unauthorized access, or proxying/scraping. So the TOS also says:

- The final decision of whether an account is in violation of any of these acceptable use terms is at the sole discretion of Vercel.

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 to be dependent on me, though. I imagine that's true here, too--no more need to edit your behaviour/filter your thinking/navigate interpersonal stuff just to do something minor.

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)

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.

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 treated, potable water as the current filter will not remove microbiological contaminants.

> Does the ZeroWater® 5-stage filter reduce cryptosporidium?

> At this point ZeroWater® 5-stage filters have not been tested for the removal of cryptosporidium(microbiological cysts).

Both ZeroWater and Brita are explicit that their filters are meant to be used with water that the government has already deemed safe to drink.

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.

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 appealing to us.

"$100,000."

Our counterparty may have actually laughed at us. "I can't just write two twenty-somethings a cheque for $100,000."

Oh, shit. They're on to us. They're gonna bargain hard, and we're going to have to lop off tens of thousands of dollars.

"But what I can do is write you a $10,000 cheque for a 1-day training session, a $15,000 cheque for installation support, a $10,000 cheque for 1 year of maintenance and a $65,000 cheque for a perpetual 5,000 seat license. Does that work for you?"

It did. To do this day, I'm pretty sure we sold the government $100,000 of services because two high-up administrators were incapable of working out their interpersonal issues. Instead, they used our software as a go-between. Absurd.

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 real expense.

It'd also be cheap to just blackhole datacentre IP space.

The sort of attack that would require this level of limits is malware on tens of thousands of residential machines that can use a user's existing Twitter session cookies. I'm really skeptical that's the case.

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 account based on age, size, past engagement. This is an incredibly coarse banhammer -- very close to just turning off the servers, IMO. Reasonable if it lasted for an hour, debatable if it lasts for a day, idiotic if it lasts longer.

Would love to see the inside story, hopefully it gets leaked/reported at some point.

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 reviewed

(2) the highest bidder is actually going to pay the second price, and there's some friction in the form of a buyer's premium that makes it cost inefficient to immediately resell the item

Neither of these hold in the ad space.

Re (1), if you're trafficking ads through GAM, Google gets a chance to see the highest bid before deciding to commit to a bid.

Re (2), a publisher can insert fake line items that dynamically activate on a per-impression level. The goal of the fake line item is to be a stalking horse to artificially inflate the second-highest bid so that the second-price auction is effectively a first-price auction. If the publisher accidentally bids too high and wins the auction, they can just run the auction again.

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). For a business that's not about 3D rendering, spending an innovation token on making sure your landing page can have a smooth background animation seems like it's playing on hard mode.

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, and now a criminal defense lawyer

- Lindsey Halligan, an insurance claims litigator

All except Lindsey have since resigned from Trump's legal team.

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 officer who is a party to, or who is a director or officer of or has a material interest in any person who is a party to, a material contract or transaction or proposed material contract or transaction with the Corporation shall disclose in writing to the Corporation, or request to have entered in the minutes of the meeting of Directors, the nature and extent of such person’s interest at the time and in the manner provided by the Act. Such a person may participate in any discussion related thereto but shall not vote on any resolution to approve the same except as provided by the Act.

I suspect this is pretty boiler plate stuff. The family corporation that my wife and I own doesn't have this text in its by-laws...but that's because it's a closely-held company. I'd certainly hope that a "real" VC-funded company would have this text.

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 some really prominent examples. People are running language models on Raspberry Pis and smartphones. Anyone who wants to tinker can.

Now, all the stuff that's built on top of LLaMa is currently encumbered, yes.

But all of that work can likely be transferred to an unencumbered base model pretty easily. The existence of the ecosystem around LLaMa makes it much more likely that someone will create an unencumbered base model. And it seems like that is already happening, for example, the Red Pajama folks are working on this.