Removed some ordering and pool_info filtering I dont see us needing.
Home /
Cardano Community /
koios-artifacts
Jan 12, 6-7 AM (0)
Jan 12, 7-8 AM (0)
Jan 12, 8-9 AM (0)
Jan 12, 9-10 AM (0)
Jan 12, 10-11 AM (0)
Jan 12, 11-12 PM (0)
Jan 12, 12-1 PM (0)
Jan 12, 1-2 PM (0)
Jan 12, 2-3 PM (0)
Jan 12, 3-4 PM (0)
Jan 12, 4-5 PM (0)
Jan 12, 5-6 PM (0)
Jan 12, 6-7 PM (0)
Jan 12, 7-8 PM (0)
Jan 12, 8-9 PM (0)
Jan 12, 9-10 PM (2)
Jan 12, 10-11 PM (1)
Jan 12, 11-12 AM (0)
Jan 13, 12-1 AM (0)
Jan 13, 1-2 AM (0)
Jan 13, 2-3 AM (0)
Jan 13, 3-4 AM (0)
Jan 13, 4-5 AM (0)
Jan 13, 5-6 AM (0)
Jan 13, 6-7 AM (0)
Jan 13, 7-8 AM (0)
Jan 13, 8-9 AM (0)
Jan 13, 9-10 AM (0)
Jan 13, 10-11 AM (0)
Jan 13, 11-12 PM (0)
Jan 13, 12-1 PM (0)
Jan 13, 1-2 PM (0)
Jan 13, 2-3 PM (0)
Jan 13, 3-4 PM (0)
Jan 13, 4-5 PM (2)
Jan 13, 5-6 PM (0)
Jan 13, 6-7 PM (0)
Jan 13, 7-8 PM (0)
Jan 13, 8-9 PM (0)
Jan 13, 9-10 PM (1)
Jan 13, 10-11 PM (0)
Jan 13, 11-12 AM (0)
Jan 14, 12-1 AM (0)
Jan 14, 1-2 AM (0)
Jan 14, 2-3 AM (0)
Jan 14, 3-4 AM (0)
Jan 14, 4-5 AM (0)
Jan 14, 5-6 AM (0)
Jan 14, 6-7 AM (0)
Jan 14, 7-8 AM (0)
Jan 14, 8-9 AM (0)
Jan 14, 9-10 AM (1)
Jan 14, 10-11 AM (0)
Jan 14, 11-12 PM (0)
Jan 14, 12-1 PM (0)
Jan 14, 1-2 PM (0)
Jan 14, 2-3 PM (0)
Jan 14, 3-4 PM (0)
Jan 14, 4-5 PM (0)
Jan 14, 5-6 PM (0)
Jan 14, 6-7 PM (0)
Jan 14, 7-8 PM (0)
Jan 14, 8-9 PM (0)
Jan 14, 9-10 PM (0)
Jan 14, 10-11 PM (0)
Jan 14, 11-12 AM (0)
Jan 15, 12-1 AM (0)
Jan 15, 1-2 AM (0)
Jan 15, 2-3 AM (0)
Jan 15, 3-4 AM (0)
Jan 15, 4-5 AM (0)
Jan 15, 5-6 AM (0)
Jan 15, 6-7 AM (0)
Jan 15, 7-8 AM (0)
Jan 15, 8-9 AM (0)
Jan 15, 9-10 AM (0)
Jan 15, 10-11 AM (0)
Jan 15, 11-12 PM (0)
Jan 15, 12-1 PM (0)
Jan 15, 1-2 PM (0)
Jan 15, 2-3 PM (0)
Jan 15, 3-4 PM (0)
Jan 15, 4-5 PM (0)
Jan 15, 5-6 PM (0)
Jan 15, 6-7 PM (0)
Jan 15, 7-8 PM (0)
Jan 15, 8-9 PM (0)
Jan 15, 9-10 PM (1)
Jan 15, 10-11 PM (0)
Jan 15, 11-12 AM (0)
Jan 16, 12-1 AM (0)
Jan 16, 1-2 AM (0)
Jan 16, 2-3 AM (0)
Jan 16, 3-4 AM (0)
Jan 16, 4-5 AM (0)
Jan 16, 5-6 AM (0)
Jan 16, 6-7 AM (0)
Jan 16, 7-8 AM (0)
Jan 16, 8-9 AM (0)
Jan 16, 9-10 AM (0)
Jan 16, 10-11 AM (0)
Jan 16, 11-12 PM (0)
Jan 16, 12-1 PM (0)
Jan 16, 1-2 PM (0)
Jan 16, 2-3 PM (0)
Jan 16, 3-4 PM (0)
Jan 16, 4-5 PM (0)
Jan 16, 5-6 PM (0)
Jan 16, 6-7 PM (0)
Jan 16, 7-8 PM (0)
Jan 16, 8-9 PM (0)
Jan 16, 9-10 PM (0)
Jan 16, 10-11 PM (0)
Jan 16, 11-12 AM (0)
Jan 17, 12-1 AM (0)
Jan 17, 1-2 AM (0)
Jan 17, 2-3 AM (0)
Jan 17, 3-4 AM (0)
Jan 17, 4-5 AM (0)
Jan 17, 5-6 AM (0)
Jan 17, 6-7 AM (0)
Jan 17, 7-8 AM (0)
Jan 17, 8-9 AM (0)
Jan 17, 9-10 AM (0)
Jan 17, 10-11 AM (0)
Jan 17, 11-12 PM (0)
Jan 17, 12-1 PM (0)
Jan 17, 1-2 PM (0)
Jan 17, 2-3 PM (0)
Jan 17, 3-4 PM (0)
Jan 17, 4-5 PM (0)
Jan 17, 5-6 PM (0)
Jan 17, 6-7 PM (0)
Jan 17, 7-8 PM (0)
Jan 17, 8-9 PM (0)
Jan 17, 9-10 PM (0)
Jan 17, 10-11 PM (0)
Jan 17, 11-12 AM (0)
Jan 18, 12-1 AM (0)
Jan 18, 1-2 AM (0)
Jan 18, 2-3 AM (0)
Jan 18, 3-4 AM (0)
Jan 18, 4-5 AM (0)
Jan 18, 5-6 AM (0)
Jan 18, 6-7 AM (0)
Jan 18, 7-8 AM (0)
Jan 18, 8-9 AM (0)
Jan 18, 9-10 AM (0)
Jan 18, 10-11 AM (0)
Jan 18, 11-12 PM (0)
Jan 18, 12-1 PM (0)
Jan 18, 1-2 PM (0)
Jan 18, 2-3 PM (0)
Jan 18, 3-4 PM (0)
Jan 18, 4-5 PM (1)
Jan 18, 5-6 PM (0)
Jan 18, 6-7 PM (0)
Jan 18, 7-8 PM (0)
Jan 18, 8-9 PM (0)
Jan 18, 9-10 PM (0)
Jan 18, 10-11 PM (0)
Jan 18, 11-12 AM (0)
Jan 19, 12-1 AM (0)
Jan 19, 1-2 AM (0)
Jan 19, 2-3 AM (0)
Jan 19, 3-4 AM (0)
Jan 19, 4-5 AM (0)
Jan 19, 5-6 AM (0)
Jan 19, 6-7 AM (0)
9 commits this week
Jan 12, 2026
-
Jan 19, 2026
Pool info cache fixes
This PR fixes a couple of different issues found around pool data. 1. Issue mentioned in #381 fixed by correct descending ordering of registered_tx_id column for pool_info_cache insertion. 2. pool_calidus_keys was missing an ordering on pool_info_cache, needs to grab latest entry from this cache table. 3. pool_info need a distinct select due to a DBSync bug not yet having a bug fix deployed. Can be removed later when fix is deployed but doesn't cause any negative impact even after fix is applied. https://github.com/IntersectMBO/cardano-db-sync/issues/1986
asset_list Enhancement (#383)
## Description Fix optional filtering on policy and name to use indexed columns. PostgREST horizontal filtering cant do this on resulting encoded values. ## Which issue it fixes? Issue reported on Discord bugs channel from $papagoose --------- Co-authored-by: Dostrelith <[email protected]>
Updated docs description to mention reason for optional parameters and default ordering.
Merge branch 'main' of github.com:cardano-community/koios-artifacts into asset_list_fix
tx_by_metalabel fix (#384)
## Description Old pushed file seem to be a duplicate of tx_cbor.sql Needs docs update and RPC verified but at least the function now does what its supposed to. There might be some performance issues through postgrest call if I remember correctly. ## Which issue it fixes? #378
tx_by_metalabel fix
Old pushed file seem to be a duplicate of tx_cbor.sql Needs docs update and RPC verified but at least the function now does what its supposed to. There might be some performance issues through postgrest call if I remember correctly.
Fix optional filtering on policy and name to use indexed columns. PostgREST horizontal filtering cant do this on resulting encoded values.