database

package

Go to main page

Versions in this module

v1

v1.11.0

Dec 4, 2025

v1.10.0

May 16, 2025

Changes in this version

+ func NewNullTime(t time.Time) sql.NullTime

type DataAPIPayloadDeliveredEntry

+ BlockTimestamp sql.NullTime

type DatabaseService

+ func (s *DatabaseService) GetRecentPayloadsForExtraData(extraData []string, limit int) (resp []*TmpPayloadsForExtraDataEntry, err error)

+ type TmpPayloadsForExtraDataEntry struct

+ BlockTimestamp sql.NullTime

+ ExtraData string

+ InsertedAt time.Time

+ Slot uint64

v1.9.0

Jul 26, 2024

Changes in this version

type DataAPIPayloadDeliveredEntry

+ NumBlobTxs sql.NullInt64

+ NumBlobs sql.NullInt64

v1.8.2

Jul 25, 2024

Changes in this version

type DatabaseService

+ func MustConnectPostgres(log *logrus.Entry, dsn string) *DatabaseService

+ func (s *DatabaseService) GetLatestDeliveredPayload() (*DataAPIPayloadDeliveredEntry, error)

v1.8.0-alpha1

Jun 13, 2024

v1.4.0

Jun 13, 2023

v1.3.0

Jun 13, 2023

Changes in this version

+ var BuilderStatsEntryTypeBuilderPubkey = "builder_pubkey"

+ var BuilderStatsEntryTypeExtraData = "extra_data"

+ var TableBlockBuilderInclusionStats = tableBase + "_blockbuilder_stats_inclusion"

+ type BuilderStatsEntry struct

+ BlocksIncluded int

+ BuilderName string

+ BuilderPubkeys string

+ ExtraData string

+ Hours int

+ ID int64

+ InsertedAt time.Time

+ TimeEnd time.Time

+ TimeStart time.Time

+ Type string

type DatabaseService

+ func (s *DatabaseService) GetDeliveredPayloadsForSlots(slotStart, slotEnd uint64) (res []*DataAPIPayloadDeliveredEntry, err error)

+ func (s *DatabaseService) GetLastDailyBuilderStatsEntry(filterType string) (*BuilderStatsEntry, error)

+ func (s *DatabaseService) SaveBuilderStats(entries []*BuilderStatsEntry) error

v1.2.0

May 20, 2023

v1.1.0

Mar 18, 2023

v1.0.0

Feb 2, 2023

Changes in this version

+ var TableBlockBuilder = tableBase + "_blockbuilder"

+ var TableDataAPIBuilderBid = tableBase + "_data_api_builder_bid"

+ var TableDataAPIPayloadDelivered = tableBase + "_data_api_payload_delivered"

+ var TableError = tableBase + "_error"

+ var TableSignedBuilderBid = tableBase + "_signed_builder_bid"

+ func ExtraDataToUtf8Str(extraData types.ExtraData) string

+ func NewNullBool(b bool) sql.NullBool

+ func NewNullInt64(i int64) sql.NullInt64

+ func NewNullString(s string) sql.NullString

+ type BlockBuilderEntry struct

+ BuilderPubkey string

+ Description string

+ ID int64

+ InsertedAt time.Time

+ type BuilderProfitEntry struct

+ Aliases []string

+ ExtraData string

+ NumBlocks uint64

+ NumBlocksProfit uint64

+ NumBlocksSubsidised uint64

+ ProfitPerBlockAvg string

+ ProfitPerBlockMedian string

+ ProfitTotal string

+ SubsidiesTotal string

+ type DataAPIBuilderBidEntry struct

+ BlockHash string

+ BlockNumber sql.NullInt64

+ BuilderPubkey string

+ Epoch uint64

+ GasLimit uint64

+ GasUsed uint64

+ ID int64

+ InsertedAt time.Time

+ NumTx sql.NullInt64

+ ParentHash string

+ ProposerFeeRecipient string

+ ProposerPubkey string

+ Relay string

+ Slot uint64

+ Timestamp time.Time

+ Value string

+ func BidTraceV2WithTimestampJSONToBuilderBidEntry(relay string, entry relaycommon.BidTraceV2WithTimestampJSON) DataAPIBuilderBidEntry

+ type DataAPIPayloadDeliveredEntry struct

+ BlockCoinbaseAddress sql.NullString

+ BlockCoinbaseIsProposer sql.NullBool

+ BlockHash string

+ BlockNumber sql.NullInt64

+ BuilderPubkey string

+ CoinbaseDiffEth sql.NullString

+ CoinbaseDiffWei sql.NullString

+ Epoch uint64

+ ExtraData string

+ FoundOnChain sql.NullBool

+ GasLimit uint64

+ GasUsed uint64

+ ID int64

+ InsertedAt time.Time

+ Notes sql.NullString

+ NumTx sql.NullInt64

+ ParentHash string

+ ProposerFeeRecipient string

+ ProposerPubkey string

+ Relay string

+ Slot uint64

+ SlotWasMissed sql.NullBool

+ ValueCheckMethod sql.NullString

+ ValueCheckOk sql.NullBool

+ ValueClaimedEth string

+ ValueClaimedWei string

+ ValueDeliveredDiffEth sql.NullString

+ ValueDeliveredDiffWei sql.NullString

+ ValueDeliveredEth sql.NullString

+ ValueDeliveredWei sql.NullString

+ func BidTraceV2JSONToPayloadDeliveredEntry(relay string, entry relaycommon.BidTraceV2JSON) DataAPIPayloadDeliveredEntry

+ type DatabaseService struct

+ DB *sqlx.DB

+ func NewDatabaseService(dsn string) (*DatabaseService, error)

+ func (s *DatabaseService) Close() error

+ func (s *DatabaseService) GetBuilderProfits(since, until time.Time) (res []*BuilderProfitEntry, err error)

+ func (s *DatabaseService) GetDataAPILatestBid(relay string) (*DataAPIBuilderBidEntry, error)

+ func (s *DatabaseService) GetDataAPILatestPayloadDelivered(relay string) (*DataAPIPayloadDeliveredEntry, error)

+ func (s *DatabaseService) GetDeliveredPayloadsForSlot(slot uint64) (res []*DataAPIPayloadDeliveredEntry, err error)

+ func (s *DatabaseService) GetSignedBuilderBidsForSlot(slot uint64) (res []*SignedBuilderBidEntry, err error)

+ func (s *DatabaseService) GetStatsForTimerange(since, until time.Time, relay string) (relays []*TopRelayEntry, builders []*TopBuilderEntry, err error)

+ func (s *DatabaseService) GetTopBuilders(since, until time.Time, relay string) (res []*TopBuilderEntry, err error)

+ func (s *DatabaseService) GetTopRelays(since, until time.Time) (res []*TopRelayEntry, err error)

+ func (s *DatabaseService) SaveBuilder(entry *BlockBuilderEntry) error

+ func (s *DatabaseService) SaveDataAPIBid(entry *DataAPIBuilderBidEntry) error

+ func (s *DatabaseService) SaveDataAPIBids(entries []*DataAPIBuilderBidEntry) error

+ func (s *DatabaseService) SaveDataAPIPayloadDelivered(entry *DataAPIPayloadDeliveredEntry) error

+ func (s *DatabaseService) SaveDataAPIPayloadDeliveredBatch(entries []*DataAPIPayloadDeliveredEntry) error

+ func (s *DatabaseService) SaveSignedBuilderBid(entry SignedBuilderBidEntry) error

+ type SignedBuilderBidEntry struct

+ BlockHash string

+ BlockNumber uint64

+ Epoch uint64

+ ExtraData string

+ FeeRecipient string

+ GasLimit uint64

+ GasUsed uint64

+ ID int64

+ InsertedAt time.Time

+ LatencyMS int64

+ ParentHash string

+ PrevRandao string

+ ProposerPubkey string

+ Pubkey string

+ ReceivedAt time.Time

+ Relay string

+ RequestedAt time.Time

+ Signature string

+ Slot uint64

+ Timestamp uint64

+ Value string

+ func SignedBuilderBidToEntry(relay string, slot uint64, parentHash, proposerPubkey string, ...) SignedBuilderBidEntry

+ type TopBuilderEntry struct

+ Aliases []string

+ ExtraData string

+ NumBlocks uint64

+ Percent string

+ type TopRelayEntry struct

+ NumPayloads uint64

+ Percent string

+ Relay string

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL