carstonh

Joined 3 years ago

Karma
17
Submissions
10
Member since
May 8
data + maps
View on Hacker News

Recent submissions

Comment · 12 days ago
155T tokens/day per cluster? OpenRouter reports that last week total usage on their platform was 164T tokens. Surely all that demand couldn't be satisfied with one cluster? Are these different units of token, or maybe something got lost in translation?
Comment · 1 month ago
agreed… why can an ID token for a separate client application be used to read and write to GitHub? that’s the story here.
Comment · 1 year ago
Comment · 1 year ago
Based on my reading of the GeoParquet spec, the main difference is that geometries are stored as WKB using Parquet's byte array type. Byte arrays can be delta-encoded. There is also some additional metadata stored like CRS and a bounding box.

When using EPSG:4326 lat/lons, I don't think GeoParquet would give you any benefits over just having separate columns (this is what I typically do, and it's plenty fast).

If you are using range requests to fetch only parts of parquet files at a time, you could potentially sort your data using a hilbert curve, which could limit the number of row groups that need to be fetched to execute a query.

Comment · 1 year ago

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton