3 ms·
with the returning clause it should be trivial to do cdc now, no?
by gigatexal 6y ago
with the returning clause it should be trivial to do cdc now, no?
- paulryanrogers 6y agoCDC?
- nalgeon 6y agoIsn't it done with triggers? SQLite supports them since long ago
- gunnarmorling 6y agoInteresting thought; with the client/server database model, RETURNING isn't relevant for CDC, which rather extracts changes from the transaction log, not scoped to any particular client session. But in the case of SQLite and its embedded way of running, one could indeed envision to use it for implementing some basic CDC functionality at the application level. It'd still lack metadata though like transaction ids, log file offset, etc.
- gigatexal 6y agoTrue that’s right. I was just highlighting the spin that SQLite puts on the returning idea. What a really cool feature and db