diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2018-03-22 21:31:05 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2018-03-22 21:31:05 -0700 |
| commit | 4ce751f000285bc97adef27bab0873ae2690859e (patch) | |
| tree | 2b0650d49294b0bedaf20978045df01c1e97b567 /next_thoughts.txt | |
| parent | daf21f0b80e1783ed1eb777a7b6a9c5618c069d7 (diff) | |
| download | fatcat-4ce751f000285bc97adef27bab0873ae2690859e.tar.gz fatcat-4ce751f000285bc97adef27bab0873ae2690859e.zip | |
bunch of unstructured notes
Diffstat (limited to 'next_thoughts.txt')
| -rw-r--r-- | next_thoughts.txt | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/next_thoughts.txt b/next_thoughts.txt new file mode 100644 index 00000000..0e89249a --- /dev/null +++ b/next_thoughts.txt @@ -0,0 +1,19 @@ +Should probably just UUID all the (public) ids. + +Instead of having a separate id pointer table, could have an extra "mutable" +public ID column (unique, indexed) on entity rows. Backend would ensure the +right thing happens. Changelog tables (or special redirect/deletion tables) +would record changes and be "fallen through" to. + +Instead of having merge redirects, could just point all identifiers to the same +revision (and update them all in the future). Don't need to recurse! Need to +keep this forever though, could scale badly if "aggregations" get merged. + +Redirections of redirections should probably simply be disallowed. + +"Deletion" is really just pointing to a special or null entity. + +Trade-off: easy querying for common case (wanting "active" rows) vs. robust +handling of redirects (likely to be pretty common). Also, having UUID handling +across more than one table. + |