3 ms·
> Just the temporal properties alone make it very useful for anything where it matters like billing, finance, inventory. you can easily create datamodel to hav
by riku_iki 4y ago
> Just the temporal properties alone make it very useful for anything where it matters like billing, finance, inventory.
you can easily create datamodel to have this in SQL dbs: create table transaction_history(..., execution_time timestamp);
- tasuki 4y agoThis is not an answer, it's the beginning of a question. Yes sure, we know `create table` and we know it's a good idea to record the execution timestamp. What exactly do you put in the place of the three dots?
- augustl 4y agoFyi, Datomic lets you look at the entire database at any point in time, as an immutable value. Also, you can annotate transactions with metadata, and query for "which tx wrote this specific value for this row/column" and look at custom metadata you added to the tx to reason about your system. Doing all of that in SQL is not trivial, to say the least.