4 ms·
Well, there are a few other massive differences - RDBMS have basically its own version control built in (which is what allows ACID) and by containing the logic
by Illniyar 10y ago
Well, there are a few other massive differences - RDBMS have basically its own version control built in (which is what allows ACID) and by containing the logic for joins it allows performance based on statistics (which can't be done in an upper layer)
- eyelidlessness 10y agoWouldn't it be great if those facilities for version control provided something akin to event logging as a first-class API out of the box?
- Illniyar 10y agoWell oracle has an eventlog (which you use to synchornize databases). I'm guessing that other databases have similar implementations. Though no API to hook into it, as far as I know.
- pritambaral 10y agoPostgres has logical replication. I'd guess MySQL and MariaDB also have something of this sort, because Galera uses that.