I'm currently working on parsing a SQLite file for my C program, and I need to extract three columns, url, username, and password. I want to parse it without using the sqlite3.h header file. I could use some pre-installed libraries on Windows, but right now trying to make the parsing manual.
The passwords start all with a prefix "v10", so I can locate all the passwords, and then go back until I find "http" to get the url, but can't figure out how to parse the username from the middle.
Here is a example of a row:
http://example.com/index.phphttp://example.com/index.phppostcode343434passwordv10XXXXXXXXX
In this case "v10XXXXXXXXX" is the password, and the username is "343434". How do I determine the length of the username?
Links to documentation about how they are formatted would be appreciated. I have tried reading the SQLite Database File Format, but can't seem to understand. The idea is to make the file as small as possible, so can't use anything big.
Thanks in advance!