# I am the Watcher. I am your guide through this vast new twtiverse.
#
# Usage:
# https://watcher.sour.is/api/plain/users View list of users and latest twt date.
# https://watcher.sour.is/api/plain/twt View all twts.
# https://watcher.sour.is/api/plain/mentions?uri=:uri View all mentions for uri.
# https://watcher.sour.is/api/plain/conv/:hash View all twts for a conversation subject.
#
# Options:
# uri Filter to show a specific users twts.
# offset Start index for quey.
# limit Count of items to return (going back in time).
#
# twt range = 1 1
# self = https://watcher.sour.is/conv/3lw3jba
Patterns for modeling data with absolutely no NULLs?**
Sup friends. I am curious about patterns for modeling data of various types where you just straight up do not persist null values, ever. All fields NOT NULL constrained. But in a way that disambiguates unasked and unanswered questions. Where invalid states can’t be represented, like “none of the above” being stored alongside one of the above. And where there is minimal dependency on app layer logic, db triggers, or complex constraints.
Examples that come t ... ⌘ Read more