> > 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. >
Yeah I read the source file wal.c and based on what I read, SQLite syncs the frames which have page data in WAL with the main database to update it. But I couldn't find a way to get those changes because they deal with frames and pages. So if I get those WAL frames where page data is stored and read them will I be able to get the changes which are made? 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. > 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. > 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?
