3 ms·
The evolution of their SQL schema (around ~45:00 on) is pretty cool. For example to implement undo/version control for files, they just added a single `prev_re
by zawerf 8y ago
The evolution of their SQL schema (around ~45:00 on) is pretty cool.
For example to implement undo/version control for files, they just added a single `prev_rev` column. There are some arguably better (but more complicated) ways to do it but it would've been premature optimization since this simple solution clearly worked out for them.
- nodesocket 8y agoIf I am understanding correctly a sort_order column would work as well. Essentially then you can just do select with order by sort_order.