koios-artifacts - 11 commits this week

Home / Cardano Community / koios-artifacts

Insights Pull Requests

Feb 28, 11-12 PM (0)

Feb 28, 12-1 PM (0)

Feb 28, 1-2 PM (0)

Feb 28, 2-3 PM (0)

Feb 28, 3-4 PM (0)

Feb 28, 4-5 PM (0)

Feb 28, 5-6 PM (0)

Feb 28, 6-7 PM (0)

Feb 28, 7-8 PM (0)

Feb 28, 8-9 PM (0)

Feb 28, 9-10 PM (0)

Feb 28, 10-11 PM (0)

Feb 28, 11-12 AM (0)

Mar 01, 12-1 AM (0)

Mar 01, 1-2 AM (0)

Mar 01, 2-3 AM (0)

Mar 01, 3-4 AM (0)

Mar 01, 4-5 AM (0)

Mar 01, 5-6 AM (0)

Mar 01, 6-7 AM (0)

Mar 01, 7-8 AM (0)

Mar 01, 8-9 AM (0)

Mar 01, 9-10 AM (0)

Mar 01, 10-11 AM (0)

Mar 01, 11-12 PM (0)

Mar 01, 12-1 PM (0)

Mar 01, 1-2 PM (0)

Mar 01, 2-3 PM (0)

Mar 01, 3-4 PM (0)

Mar 01, 4-5 PM (0)

Mar 01, 5-6 PM (0)

Mar 01, 6-7 PM (0)

Mar 01, 7-8 PM (0)

Mar 01, 8-9 PM (0)

Mar 01, 9-10 PM (0)

Mar 01, 10-11 PM (0)

Mar 01, 11-12 AM (0)

Mar 02, 12-1 AM (0)

Mar 02, 1-2 AM (0)

Mar 02, 2-3 AM (0)

Mar 02, 3-4 AM (0)

Mar 02, 4-5 AM (0)

Mar 02, 5-6 AM (1)

Mar 02, 6-7 AM (0)

Mar 02, 7-8 AM (0)

Mar 02, 8-9 AM (0)

Mar 02, 9-10 AM (0)

Mar 02, 10-11 AM (0)

Mar 02, 11-12 PM (0)

Mar 02, 12-1 PM (2)

Mar 02, 1-2 PM (0)

Mar 02, 2-3 PM (0)

Mar 02, 3-4 PM (0)

Mar 02, 4-5 PM (0)

Mar 02, 5-6 PM (1)

Mar 02, 6-7 PM (0)

Mar 02, 7-8 PM (0)

Mar 02, 8-9 PM (1)

Mar 02, 9-10 PM (0)

Mar 02, 10-11 PM (0)

Mar 02, 11-12 AM (3)

Mar 03, 12-1 AM (0)

Mar 03, 1-2 AM (0)

Mar 03, 2-3 AM (0)

Mar 03, 3-4 AM (0)

Mar 03, 4-5 AM (0)

Mar 03, 5-6 AM (0)

Mar 03, 6-7 AM (0)

Mar 03, 7-8 AM (0)

Mar 03, 8-9 AM (0)

Mar 03, 9-10 AM (0)

Mar 03, 10-11 AM (0)

Mar 03, 11-12 PM (0)

Mar 03, 12-1 PM (0)

Mar 03, 1-2 PM (0)

Mar 03, 2-3 PM (0)

Mar 03, 3-4 PM (0)

Mar 03, 4-5 PM (0)

Mar 03, 5-6 PM (0)

Mar 03, 6-7 PM (0)

Mar 03, 7-8 PM (0)

Mar 03, 8-9 PM (0)

Mar 03, 9-10 PM (0)

Mar 03, 10-11 PM (0)

Mar 03, 11-12 AM (0)

Mar 04, 12-1 AM (0)

Mar 04, 1-2 AM (0)

Mar 04, 2-3 AM (0)

Mar 04, 3-4 AM (0)

Mar 04, 4-5 AM (0)

Mar 04, 5-6 AM (0)

Mar 04, 6-7 AM (0)

Mar 04, 7-8 AM (0)

Mar 04, 8-9 AM (0)

Mar 04, 9-10 AM (0)

Mar 04, 10-11 AM (0)

Mar 04, 11-12 PM (0)

Mar 04, 12-1 PM (0)

Mar 04, 1-2 PM (0)

Mar 04, 2-3 PM (0)

Mar 04, 3-4 PM (0)

Mar 04, 4-5 PM (0)

Mar 04, 5-6 PM (0)

Mar 04, 6-7 PM (0)

Mar 04, 7-8 PM (0)

Mar 04, 8-9 PM (0)

Mar 04, 9-10 PM (0)

Mar 04, 10-11 PM (0)

Mar 04, 11-12 AM (0)

Mar 05, 12-1 AM (0)

Mar 05, 1-2 AM (0)

Mar 05, 2-3 AM (0)

Mar 05, 3-4 AM (0)

Mar 05, 4-5 AM (0)

Mar 05, 5-6 AM (0)

Mar 05, 6-7 AM (0)

Mar 05, 7-8 AM (0)

Mar 05, 8-9 AM (0)

Mar 05, 9-10 AM (0)

Mar 05, 10-11 AM (0)

Mar 05, 11-12 PM (0)

Mar 05, 12-1 PM (0)

Mar 05, 1-2 PM (0)

Mar 05, 2-3 PM (0)

Mar 05, 3-4 PM (0)

Mar 05, 4-5 PM (0)

Mar 05, 5-6 PM (0)

Mar 05, 6-7 PM (0)

Mar 05, 7-8 PM (0)

Mar 05, 8-9 PM (0)

Mar 05, 9-10 PM (0)

Mar 05, 10-11 PM (0)

Mar 05, 11-12 AM (0)

Mar 06, 12-1 AM (0)

Mar 06, 1-2 AM (0)

Mar 06, 2-3 AM (0)

Mar 06, 3-4 AM (0)

Mar 06, 4-5 AM (0)

Mar 06, 5-6 AM (0)

Mar 06, 6-7 AM (0)

Mar 06, 7-8 AM (0)

Mar 06, 8-9 AM (0)

Mar 06, 9-10 AM (0)

Mar 06, 10-11 AM (0)

Mar 06, 11-12 PM (0)

Mar 06, 12-1 PM (0)

Mar 06, 1-2 PM (0)

Mar 06, 2-3 PM (0)

Mar 06, 3-4 PM (0)

Mar 06, 4-5 PM (0)

Mar 06, 5-6 PM (0)

Mar 06, 6-7 PM (0)

Mar 06, 7-8 PM (0)

Mar 06, 8-9 PM (0)

Mar 06, 9-10 PM (0)

Mar 06, 10-11 PM (2)

Mar 06, 11-12 AM (1)

Mar 07, 12-1 AM (0)

Mar 07, 1-2 AM (0)

Mar 07, 2-3 AM (0)

Mar 07, 3-4 AM (0)

Mar 07, 4-5 AM (0)

Mar 07, 5-6 AM (0)

Mar 07, 6-7 AM (0)

Mar 07, 7-8 AM (0)

Mar 07, 8-9 AM (0)

Mar 07, 9-10 AM (0)

Mar 07, 10-11 AM (0)

Mar 07, 11-12 PM (0)

11 commits this week Feb 28, 2026 - Mar 07, 2026

hodlonaut · Sat, 07 Mar 26 00:43:49 +0000 · koios-artifacts

Changes to endpoints to utilize pool_stat (now core) table instead of reliance on grest.pool_active_stake_cache

44fcf3a2 · pool_active_stake_cache_to_pool_stat · 3/17 ++ 17 --

hodlonaut · Fri, 06 Mar 26 23:41:24 +0000 · koios-artifacts

Added couple of valid mainnet drep IDs to specs

9058cd26 · pool_active_stake_cache_to_pool_stat · 2/4 ++ 4 --

hodlonaut · Fri, 06 Mar 26 23:28:18 +0000 · koios-artifacts

Removed a note about is_valid flag, now that latest versions of db sync populate it in a meaningful way

7adcaac6 · pool_active_stake_cache_to_pool_stat · 5/5 ++ 5 --

dostrelith678 · Tue, 03 Mar 26 00:01:20 +0000 · koios-artifacts

chore(specs): deprecate account_updates (#396)

## Description
<!--- Describe your changes -->
Missing deprecated flag on `account_updates` endpoint.

450256de · v1.4.0alpha · 5/10 ++ 5 --

rdlrt · Tue, 03 Mar 26 00:01:17 +0000 · koios-artifacts

Merge branch 'v1.4.0alpha' into update-specs

c4ff2a0f · pull/396/head · 9/149 ++ 150 --

dostrelith678 · Tue, 03 Mar 26 00:01:04 +0000 · koios-artifacts

Optimise pool history caching (#398)

## Description
<!--- Describe your changes -->

Rewrites the pool history cache for better performance

## Which issue it fixes?
<!--- Link to issue: Closes #issue-number -->

b826002d · v1.4.0alpha · 3/108 ++ 107 --

dostrelith678 · Mon, 02 Mar 26 21:21:56 +0000 · koios-artifacts

join member and leader rewards into one CTE

01ec4e68 · chore/optimise-pool-history-cache · 1/18 ++ 35 --

dostrelith678 · Mon, 02 Mar 26 18:12:44 +0000 · koios-artifacts

fix conflicts

84f08cbb · chore/optimise-pool-history-cache · 1/8 ++ 29 --

dostrelith678 · Mon, 02 Mar 26 13:34:47 +0000 · koios-artifacts

Merge branch 'v1.4.0alpha' of github.com:cardano-community/koios-artifacts into chore/optimise-pool-history-cache

e849ee73 · chore/optimise-pool-history-cache · 5/37 ++ 23 --

dostrelith678 · Mon, 02 Mar 26 13:32:10 +0000 · koios-artifacts

Optimise pool history caching

59a4cd99 · chore/optimise-pool-history-cache · 3/112 ++ 111 --

rdlrt · Mon, 02 Mar 26 06:18:17 +0000 · koios-artifacts

(WIP) - pool_history_cache improvements:

- Avoid repeated calls to reward across 2 CTEs (leadertotal and membertotal merged to reward_totals)
- Make use of lateral join to avoid repeated call per row
- Use filter instead of subquery
- Move grest.total call to static (avoid calling it 30K times on mainnet)

Also, minor fixes to other cache tables

f9432fc2 · v1.4.0alpha · 5/59 ++ 83 --

Showing 11 of 11 recent commits. Check out Cardano Community on GitHub to see more.