undefined | Better HN

0 pointshutzlibu4y ago0 comments

Most people won't, they will just get annoyed, if they accidently open a video and the editor hangs up for some time, trying to process it.

And I regulary work with JSON files the size of some MB, which already puts some editors into a real struggle.

Out of curiosity, why do you have so big files? (A whole DB as a json file?) And what editor do you use for them?

0 comments

1 comments · 1 top-level

nicoburns4y ago

> A whole DB as a json file

More like a whole database table as a JSON file - I split the whole database export into tables using `jq` (an export from Firebase Realtime Database). I generally use sublime text to open them, it's quite happy with anything that will fit in RAM. For very large file it just shows a load bar while it loads it.

It was vital for exploring the shape of our data during a data migration to Postgres as our data was not very regular in shape and firebase's querying capabilities are pretty limited.

j / k navigate · click thread line to collapse