• in sql dbs (sqlite), you write to primary server and replicated to secondary guys
  • read requests distributed to secondary replicas, write goes to master
  • read more common than write
  • in Logos, writing goes to sequencers. sequencer will write binlog to Bedrock.
  • replicators “indexer nodes” will replicate state locally by applying logs posted to Bedrock, people can send read reqs to them
  • all validation must be done within sql pessimistic
    • baby step: trust the sequencer
  • use python with sqlite
  • extract transactions from callback
  • wait for not full finality but replicate with some delay
    • or maybe deal with forks? create db copy for each new block & apply changes, then prune any blocks not included after finality
    • we can rely on channel immediate ordering
  • for demo, use open source tools that use sqlite & plug it into logos