Bitcoin full node and query server

Apr 24, 2024

View in context in the libbitcoin Slack #general mirror.

David Chocholatý13:24

Hi everyone👋, nice to be here. I'm David, and I'm joining via the Summer of Bitcoin. Just introduce myself briefly. I'm a student in the master's degree programme at FIT Brno University of Technology. I have experience contributing to open-source Tone Mapping Studio project for about three years and Mixxx organization through the Google Summer of Code in 2022. I'm interested in the project SQLite Database for libbitcoin. I like the idea of the performance improvement for the less equipped computers (probably the same as mine 😄). @SoB mentors: Please, can I ask you a small question? I have done the first two parts of the Competency Test in the project idea published on the Summer of Bitcoin website. I have a single-page document with the problems and ideas I got during the libbitcoin database installation and running a node. Should I post the document here or send it only to mentors? Thank you for your answer in advance.

👋 2🙌 1👋🏻 1

evoskuil14:33

The document that I posted is the only work done on it so far. I would start by building a schema that maps to the existing database and then writing the archive queries in SQL against that schema. Note that tables are designed for efficient access during validation and confirmation stages, so any deviation should be considered carefully. Also, the store is fully read/write concurrent and tables are all append-only. The two height indexes (candidate/confirmed) can however be popped (become smaller).

(edited)

👍 1