bgpkit/monocle

nullable columns for sqlite message store

Closed this issue · 0 comments

The schema for SQLite database for the message store should consider making some columns nullable. For example, in a withdraw message, most of the fields are null. This became a problem when we try to import a sqlite db into other processing engines like duckdb, and the schema conflicts when reaching null values for non-nullable columns.