Be able to write a setup like this
BEGIN READ WRITE WITH (system_time = DATE '2024-01-01');
INSERT INTO docs RECORDS {_id: 1, value: 'blue', _valid_from: DATE '2024-01-01'};
COMMIT;
BEGIN READ WRITE WITH (system_time = DATE '2024-01-02');
INSERT INTO docs RECORDS {_id: 1, value: 'red', _valid_from: DATE '2024-01-02', _valid_to: DATE '2024-01-03'};
COMMIT;
SELECT *, _valid_time, _system_time
FROM docs FOR ALL VALID_TIME FOR ALL SYSTEM_TIME;And have some method of rendering the rectangles that we've output.
Not sure if this is useful for literally just me though 😅
Be able to write a setup like this
And have some method of rendering the rectangles that we've output.
Not sure if this is useful for literally just me though 😅