carp
carp copied to clipboard
dcSpark
A modular indexer for Cardano with an SQL Postgres backend (an alternative to the well known cardano-db-sync)
Right now use sea-orm `Condition` for TransactionInput fetching in the indexer. This creates a large SQL query that looks like ```sql OR ( "TransactionOutput"."output_index" = $2463 AND "Transaction"."hash" = $2464...
Right now the perf metrics are saved to console. They're hard to really grasp because: 1. The format is kind of ugly 2. Some tasks run in parallel so it's...
Currently sqlx (and therefore sea-orm) doesn't support u64 (aka `bit int unsigned`) for Postgres, which means instead we have to use `bytea` which isn't ideal. We should replace this if/when...
Currently, CML doesn't support Rust-friendly types so instead of using proper matching logic, we instead try parsing the address types one-by-one which isn't efficient. Once we add this feature to...
The genesis block parsing is inserting the genesis Utxo using the Shelley-era format instead of the Byron-era format. This happens because CML doesn't support the Shelley-era format https://github.com/dcSpark/cardano-multiplatform-lib/issues/61
For both ` TransactionOutput::find()` and `StakeCredential::find()`, the generated SQL query includes too many fields in the select (notably, it includes a payload field which slows down the query) I tried...
When defining our database schema, we made enums (such as the block era) be represented at the database level by plain ints. The problem with this is that later on...
We have TODOs for this in: - AddressCredential - StakeCredential - TransactionInput - TransactionOutput - Transaction - TxCredentialRelation Ex: https://github.com/dcSpark/oura-postgres-sink/blob/3150e74019509c0191a4d94c0b09c24c34c80f70/entity/src/address_credential.rs#L30
Currently, we store a parsed version of the genesis blocks inside https://github.com/dcSpark/oura-postgres-sink/tree/main/genesis This is okay for v1, but it makes this project hard to reuse for other networks that may...
Currently the `webserver/examples` folder consumes the `webserver/client` folder as an NPM library. There is no hot reload for this, so it's kind of tedious to have to rebuild every time...