rust-sqlite logseq

database schema

• block table
  • integer primary key
  • nullable foreign key to parent block references block table - null indicates a root-level block
  • sequence number represents order amongst sibling blocks
  • block text content - markdown like logseq
• page table
  • integer primary key
  • foreign key to root block of page
  • page metadata columns
• cache table
  • blobs with binary representation of the application's internal representation of a page, parsed from a selection of block table/page table rows