On 7 Mar 2016, at 5:52am, Sairam Gaddam <gaddamsairam at gmail.com> wrote:

> How is data stored in WAL?

You can learn about the data format for the WAL file in section 4.0 of this 
page:

<https://www.sqlite.org/fileformat2.html>

> If the data is stored in pages inside WAL then how to see the changes which
> are presently made to the database?

This requires detailed knowledge of how SQLite works.  If the file format page 
I referred you to does not help you may have to study the SQLite source code to 
find out what you need.

What are you trying to do ?  Are you trying to monitor a program which is 
running  or recover a corrupt database with some data in the WAL file ?  There 
are good ways to do these things but they do not involve reading raw data from 
the WAL file.

> Any information on WAL decryption would be appreciated.

The WAL file is not encrypted unless the database file is encrypted, which is 
unusual.

Simon.

Reply via email to