Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
user:kluong:generic_schema_round_2 [2022/02/16 00:04] kluong created |
user:kluong:generic_schema_round_2 [2022/02/16 00:07] (current) kluong |
||
|---|---|---|---|
| Line 12: | Line 12: | ||
| pressure_hpa double PRECISION NULL, | pressure_hpa double PRECISION NULL, | ||
| humidity_percent double PRECISION NULL, | humidity_percent double PRECISION NULL, | ||
| - | ... | + | ... # fill in the other fields here |
| ); | ); | ||
| </code> | </code> | ||
| Each type of data we're collecting should be present as a field. Just like in my previous post, if a field is unimplemented, it doesn't waste too much space if it's empty. | Each type of data we're collecting should be present as a field. Just like in my previous post, if a field is unimplemented, it doesn't waste too much space if it's empty. | ||
| + | |||
| + | Building it this way has the benefit of making the database pretty readable - it's easy to understand what data we're storing by just looking at the column names. | ||
| | | ||