SQLite database file:Extract records from binary file RRS feed

  • Question

  • Hi,

     I am working on SQLite file format.SQLite records are stored in the data pages.There is concept of varint .

    Each Sqlite table record is stored in one cell.

    cell has the following format:

    1. A varint representing the total number of bytes of payload, including any overflow.
    2. A varint which is the integer key, or row id.
    3. The first portion of the payload that does not spill to overflow pages.
    4. A 4-byte big-endian integer representing the page number of the first overflow page. This
    value is only present if payload is spilled to overflow pages.

    Mostly varint varies from 1 to 9 bytes.

    Is anybody know the concept of varint.


    Monday, July 9, 2012 9:36 AM