FRESH

Hacker News

6NF File Format

75 points by sergeyprokhoren

by nikolayasdf123

1 subcomments

> habr.com
interesting to see this forum show-up again.
remember 15 years ago there were posts about DYI drone from some random guy with lots of theoretical physics about stable conditions derivations. it got a lot of criticism. now looking back and following what DJI is doing with sensors, his approach was totally wrong and that community nailed it with feedback. the forum got some extravagant ideas and some worthy criticism. at least back then.

by deepsun

2 subcomments

Improvement idea -- in my experience "valid_from" is always a date (no time, no timezone). That's how it's reported in documents (e.g. contract validity period).
Rows that need seconds (e.g. bank transactions) are events, they aren't "valid" from a particular point in time forward, they just happen.

by rixed

1 subcomments

> country_code 01K3Y07Z94DGJWVMB0JG4YSDBV
A 7th normal form should mandate that no identifiers should ever be assigned to identifiers.

by mhalle

1 subcomments

This format requires temporal validity with `valid_from`, but doesn't include `valid_to`. I don't understand how `valid_from` and the also required `recorded_at` interact.

by spennant

0 subcomment

Odd seeing this right now for me. I recently implemented a 6NF schema for parsed XBRL files from EDGAR. The architecture was the right call... too bad the data is not useful for analytics.

by unquietwiki

2 subcomments

Looks interesting, but few comments on the forum & even a negative vote count ATM. Format kinda looks "old school" in terms of defining records, but I guess that can be a positive in some circumstances?

0 subcomment