• [ ] Python Library for logos blockchain client HTTP API https://github.com/logos-blockchain/logos-blockchain/tree/master/nodes/nomos-node/http-client
• [ ] Writer: Create plugin for sqlite3 python library that traces executed SQL and posts it to blockchain https://www.geeksforgeeks.org/sqlite/how-to-enable-sqlite-query-logging/
  • [ ] Writer keeps track of previous messages and future messages are chained using parent hash (channel message ordering)
• [ ] Reader: Write a follower for the blockchain channel that reads messages, parse them as sql and execute on the local SQL instance
• [x] Reorgs: we rely on channel message ordering for now.

More links:

https://github.com/logos-blockchain/logos-blockchain-block-explorer-template/blob/6fa406f83faa890d82dabb5e2c5a87f553fa3807/src/node/api/http.py

[Grafana guide for testnet.nomos.tech](https://nomos-tech.notion.site/Grafana-guide-for-testnet-nomos-tech-1fd261aa09df81be97d1ff0499363cac)

https://github.com/logos-blockchain/logos-blockchain/tree/8074571bf4b2d72fc62de6bb35de2d50ff7c897e/testnet/l2-sequencer-archival-demo

https://github.com/logos-blockchain/logos-blockchain/tree/master/testnet

https://github.com/logos-blockchain/logos-blockchain/blob/8074571bf4b2d72fc62de6bb35de2d50ff7c897e/services/wallet/src/lib.rs

Sql Zone notes

workshop version (use api for sequencer) vs integrated approach (sequencer uses sqlite directly)