On Mon, Mar 7, 2016 at 7:55 AM, Sairam Gaddam <gaddamsairam at gmail.com> wrote: > And the decryption here I mean is to get information from those pages(like > on which table, which column a change is made etc.,) which involves reading > the page to get the changes which are presently made.
Sounds to me you want to implement logical decoding, that is to extract an SQL form from the binary WAL format. I don't believe SQLite provides such a feature, that is something other databases use for bidirectional replication. > I want to make note of those changes and replicate someplace else. And I > found that WAL is the correct place where changes to the database are > present. So my main aim is to get those changes and replicate after further > processing. > Is there any other better way other than WAL? Wal shipping is a good way if you don't need to get bidirectional. Luca
