Hacker News new | ask | show | jobs
by lfmunoz4 612 days ago
"The general idea of streaming changes from SQLite would work, but it's a lot of work"

Seems easy to me, just store/stream all update sql statements. That should have all information needed and don't have to mess with WAL data format etc.

2 comments

The big problem with statement-based replication is that many queries are non-deterministic. e.g. Inserting a row with current_timestamp or random()
Yeah, I wonder why no one thought of that.