ORM SQL indexing

[aaronc]

Using EntryCodecs and ADR 038 (or alternative orm Hooks), orm data can be indexed in an SQL database if there is some conversion of proto.Message to SQL.

The proposed approach is to use https://gorm.io to target any backend it targets (Sqlite, Postgres, Mysql, etc.). The indexer would read the ORM proto extensions in order to tell GORM which fields to setup as the primary key, and using GORM AutoMigrate, the integration should be pretty straightforward.

[pratikbin]

gaia version 7.1.0 has psql indexing support, but I couldn't find the docs for creating initial migration or relation for index

[tac0turtle]

the sql indexer you are seeing here is the tendermint one. You will have to open a separate issue in that repo

[pratikbin]

Got it. Thank you

[alexanderbez]

gaia version 7.1.0 has psql indexing support, but I couldn't find the docs for creating initial migration or relation for index

The SQL schema exists in the Tendermint repo. The Tendermint repo documents how the indexer works and the schema needed:

https://github.com/tendermint/tendermint/blob/main/state/indexer/sink/psql/schema.sql

[pratikbin]

The Tendermint repo documents how the indexer works and the schema needed:

Totally missed it🫣

Thank you ser @alexanderbez

[aaronc]

Replaced by #20352