Hacker News Reader

Comment by alin23 | Hacker News Reader

Yep, having the same problem. I'd love an Ultrawide with comparable pixel density as the 14" Macbook Pro.

I'm sitting on a very large database of monitor data coming from Lunar's diagnostics and error reporting (https://lunar.fyi)

Maybe I should organize it into Postgres and then search for monitors with the PPI I want.

Or is there any easier solution than Postgres for fast ingesting some JSONs and filtering by arbitrarily nested fields?

View on HN

Postgres? Seriously, for one-off playing around? Just use Airtable and you can do all the filtering and nesting you want. Plus then you can share it with us and we can collaboratively contribute.

Could I easily import 30k large and arbitrarily nested JSONs into Airtable?

I'd love to have something with an easy to use UI for filtering that can also be shared.

Yes, the Pro plan allows 50k rows per Airtable base. Arbitrary JSON can't be imported easily though, you'll have to convert it to CSV or use the API to dump data.

Depending on what you mean by large, you can go very far with SQLite. It even has a JSON extension if you want to drop blobs into there.

If you know sqlite there is also a json extension for filtering. Here a link to the example section: https://www.sqlite.org/json1.html#examples_using_json_each_a...

JQ can get you started without any db setup as you explore the data

typical ultrawide - 34" 3440x1440. that's 110ppi, regular density. (owning one, perfect size IMO, filling field of view almost exactly) if you wish retina (220ppi), that'll be 7K - which is alot of pixels. Nothing like this on market though

I’d immediately go with Elasticsearch for stuff like that.

Reply on news.ycombinator.com