essential-builder-db

The Essential builder database.

lib.rs:

The database API for the block builder's solution set pool and related storage.

The essential-builder-db crate provides a simple database API for managing the block builder's solution set pool and related storage, using SQLite as the underlying database. It allows you to store, query, and delete solution sets, as well as manage solution set submissions with timestamps.

Overview

• create_tables: Creates all required tables in the database.
• insert_solution_set_submission: Inserts a solution set and its associated submission timestamp.
• insert_solution_set_failure: Records a failure to apply a solution set to a block.
• get_solution_set: Retrieves a solution set by its content address.
• list_solution_sets: Lists all solution sets that were submitted within a given time range.
• list_submissions: Lists submissions based on timestamp.
• latest_solution_set_failures: Queries the latest failures for a given solution set.
• delete_solution_set: Deletes a solution set and its submissions given the solution set's address.
• delete_oldest_solution_set_failures: Deletes the oldest solution set failures until the stored number is within a given limit.