Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

feat: add stats endpoint for inscription counts #70

Merged
merged 18 commits into from
Jul 3, 2023

Conversation

janniks
Copy link
Contributor

@janniks janniks commented May 15, 2023

changes

  • adds /ordinals/v1/stats/inscriptions route
  • logic:
    • recalculates ingested block_height relative to >= event changed block_height

todo

  • Should I add a cache to this? There was something called chaintipcache a while back
  • Rewrite to not care about block order, which could also auto-fill gaps (for stats) but recalculates all following block stats
  • Add range filters (from-to)
  • Add pagination (default / max params?)
  • Add better tests
  • Many refactor commits, the PR is intended to be squashed in the end

@janniks janniks temporarily deployed to Preview May 15, 2023 14:21 — with GitHub Actions Inactive
@github-actions
Copy link

github-actions bot commented May 15, 2023

Vercel deployment URL: https://ordinals-mne5z94j3-blockstack.vercel.app 🚀

@janniks janniks force-pushed the feat/add-manual-stats-endpoint branch from 55126a6 to 4263526 Compare May 15, 2023 14:55
@janniks janniks temporarily deployed to Preview May 15, 2023 14:55 — with GitHub Actions Inactive
@janniks janniks linked an issue May 15, 2023 that may be closed by this pull request
@janniks janniks force-pushed the feat/add-manual-stats-endpoint branch from 4263526 to 49703d8 Compare May 16, 2023 13:28
@janniks janniks temporarily deployed to Preview May 16, 2023 13:28 — with GitHub Actions Inactive
@janniks janniks marked this pull request as ready for review May 16, 2023 13:41
src/pg/pg-store.ts Outdated Show resolved Hide resolved
tests/stats.test.ts Outdated Show resolved Hide resolved
migrations/1683909884000_inscriptions_per_block.ts Outdated Show resolved Hide resolved
migrations/1683909884000_inscriptions_per_block.ts Outdated Show resolved Hide resolved
migrations/1683909884000_inscriptions_per_block.ts Outdated Show resolved Hide resolved
src/api/routes/stats.ts Outdated Show resolved Hide resolved
src/pg/pg-store.ts Outdated Show resolved Hide resolved
src/pg/pg-store.ts Outdated Show resolved Hide resolved
src/pg/pg-store.ts Outdated Show resolved Hide resolved
src/pg/pg-store.ts Outdated Show resolved Hide resolved
src/pg/pg-store.ts Outdated Show resolved Hide resolved
tests/stats.test.ts Outdated Show resolved Hide resolved
@janniks janniks mentioned this pull request May 16, 2023
4 tasks
@janniks janniks temporarily deployed to Preview May 16, 2023 18:32 — with GitHub Actions Inactive
@janniks janniks temporarily deployed to Preview May 16, 2023 21:23 — with GitHub Actions Inactive
@smcclellan smcclellan added this to the Q2-2023 milestone May 18, 2023
@janniks janniks force-pushed the feat/add-manual-stats-endpoint branch from 21febe7 to 7ffff2f Compare May 19, 2023 12:42
@janniks janniks temporarily deployed to Preview May 19, 2023 12:42 — with GitHub Actions Inactive
@janniks janniks temporarily deployed to Preview May 19, 2023 14:52 — with GitHub Actions Inactive
@janniks janniks force-pushed the feat/add-manual-stats-endpoint branch from b8cb8fd to 9af6988 Compare May 19, 2023 15:00
@janniks janniks temporarily deployed to Preview May 19, 2023 15:00 — with GitHub Actions Inactive
@janniks janniks force-pushed the feat/add-manual-stats-endpoint branch from 152c70e to 3fb104c Compare June 5, 2023 13:55
@janniks janniks temporarily deployed to Preview June 5, 2023 13:55 — with GitHub Actions Inactive
@janniks janniks temporarily deployed to Preview June 5, 2023 13:56 — with GitHub Actions Inactive
@janniks janniks force-pushed the feat/add-manual-stats-endpoint branch from 19a640d to ac2250a Compare June 5, 2023 13:56
@janniks janniks temporarily deployed to Preview June 5, 2023 13:56 — with GitHub Actions Inactive
@janniks janniks requested a review from rafaelcr June 7, 2023 12:25
migrations/1683909884000_inscriptions-per-block.ts Outdated Show resolved Hide resolved
src/api/routes/stats.ts Outdated Show resolved Hide resolved
src/pg/pg-store.ts Outdated Show resolved Hide resolved
src/pg/pg-store.ts Outdated Show resolved Hide resolved
src/pg/pg-store.ts Outdated Show resolved Hide resolved
src/pg/pg-store.ts Outdated Show resolved Hide resolved
@janniks janniks requested a review from rafaelcr June 12, 2023 14:56
@janniks janniks temporarily deployed to Preview June 26, 2023 16:12 — with GitHub Actions Inactive
@janniks janniks temporarily deployed to Preview June 27, 2023 11:30 — with GitHub Actions Inactive
@janniks janniks force-pushed the feat/add-manual-stats-endpoint branch from 1186a8d to c62c19c Compare June 27, 2023 11:32
@janniks janniks temporarily deployed to Preview June 27, 2023 11:32 — with GitHub Actions Inactive
@janniks janniks temporarily deployed to Preview June 27, 2023 13:32 — with GitHub Actions Inactive
@janniks janniks requested a review from rafaelcr June 27, 2023 16:29
Copy link
Collaborator

@rafaelcr rafaelcr left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Excellent work @janniks , LGTM! I just left a final recommendation for the Etag calculation, feel free to merge after that is done. Thanks again and congratulations on your first contribution to this API!

EDIT: When you merge, please "Squash and merge"

src/pg/pg-store.ts Outdated Show resolved Hide resolved
@janniks janniks temporarily deployed to Preview July 3, 2023 10:29 — with GitHub Actions Inactive
@janniks janniks merged commit ac18e62 into develop Jul 3, 2023
6 checks passed
@janniks janniks deleted the feat/add-manual-stats-endpoint branch July 3, 2023 11:15
blockstack-devops pushed a commit that referenced this pull request Jul 6, 2023
## [1.0.0-beta.1](v0.4.7...v1.0.0-beta.1) (2023-07-06)

### ⚠ BREAKING CHANGES

* optimize transfer replay capability (#129)

### Features

* add stats endpoint for inscription counts ([#70](#70)) ([ac18e62](ac18e62))
* optimize transfer replay capability ([#129](#129)) ([97874cc](97874cc))

### Bug Fixes

* auto predicate registration option ([e1ed7c7](e1ed7c7))
* build event server using chainhook client library ([#105](#105)) ([ab4c795](ab4c795))
* chainhook client upgrades ([9a96492](9a96492))
* upgrade chainhook client ([cbbb951](cbbb951))
* upgrade chainhook client to 1.3.3 ([ee66f93](ee66f93))
@blockstack-devops
Copy link

🎉 This PR is included in version 1.0.0-beta.1 🎉

The release is available on GitHub release

Your semantic-release bot 📦🚀

blockstack-devops pushed a commit that referenced this pull request Aug 17, 2023
## [1.0.0-brc-20.1](v0.4.15...v1.0.0-brc-20.1) (2023-08-17)

### ⚠ BREAKING CHANGES

* optimize transfer replay capability (#129)

### Features

* add inscription number sort option ([#168](#168)) ([9f4cdbc](9f4cdbc))
* add stats endpoint for inscription counts ([#70](#70)) ([ac18e62](ac18e62))
* brc-20 balance at block ([#186](#186)) ([ced5cb3](ced5cb3))
* detect and tag recursive inscriptions ([#167](#167)) ([fb36285](fb36285))
* first balance endpoint ([f9c6654](f9c6654))
* first balance transfers ([dd8ec07](dd8ec07))
* holders endpoint ([a01f77e](a01f77e))
* mint within supply ([c8e5820](c8e5820))
* mints with balance changes ([32e90f7](32e90f7))
* optimize transfer replay capability ([#129](#129)) ([97874cc](97874cc))
* start storing token deploys ([bf4c7f6](bf4c7f6))
* token details ([5d35d5b](5d35d5b))
* token info endpoint ([8fad6b9](8fad6b9))
* tokens endpoint as paginated index ([ae2049b](ae2049b))

### Bug Fixes

* add address column to genesis and current ([d71e1d4](d71e1d4))
* add indexes for fks ([354ddd0](354ddd0))
* add secondary sorting by inscription number ([#177](#177)) ([99959df](99959df))
* allow gap fills for transfers ([026c275](026c275))
* allow multiple transfers of an inscription in one block ([#132](#132)) ([bc545f0](bc545f0))
* auto predicate registration option ([e1ed7c7](e1ed7c7))
* balances and rollbacks ([61b4139](61b4139))
* balances/:address ([687c2e4](687c2e4))
* build beta image ([13f2c13](13f2c13))
* build event server using chainhook client library ([#105](#105)) ([ab4c795](ab4c795))
* chainhook client upgrades ([9a96492](9a96492))
* consider `tx_index` in transfers by block endpoint ([#178](#178)) ([ed517d6](ed517d6))
* introduce materialized view to count address inscriptions ([#147](#147)) ([09a95d5](09a95d5))
* invalid decimal count ([aa15b0e](aa15b0e))
* make etag calculation sensitive to inscription location gap fills and upserts ([#156](#156)) ([5648c9e](5648c9e))
* only consider blessed inscriptions ([2a4700c](2a4700c))
* optimize COUNT calculations via the use of count tables ([#175](#175)) ([31498bd](31498bd))
* refresh views in parallel ([#154](#154)) ([a7674a9](a7674a9))
* remove old json content tables ([0732048](0732048))
* remove old json schemas ([8cc7f8a](8cc7f8a))
* remove unused json functions ([#165](#165)) ([3eb0e24](3eb0e24))
* rename location pointer tables ([b84d27e](b84d27e))
* rollback location pointers ([#174](#174)) ([3c9d7f0](3c9d7f0))
* save tx_index on locations to support transfers on same block ([#145](#145)) ([30a9635](30a9635))
* skip db migrations during readonly mode ([d5157f0](d5157f0))
* tick must be 4 bytes or less ([f6fd0a6](f6fd0a6))
* transfers only usable once ([542ec34](542ec34))
* upgrade chainhook client ([cbbb951](cbbb951))
* upgrade chainhook client to 1.3.3 ([ee66f93](ee66f93))
* warn correctly on missing prev locations ([879bf55](879bf55))
@blockstack-devops
Copy link

🎉 This PR is included in version 1.0.0-brc-20.1 🎉

The release is available on GitHub release

Your semantic-release bot 📦🚀

blockstack-devops pushed a commit that referenced this pull request Aug 29, 2023
## [1.0.0](v0.4.15...v1.0.0) (2023-08-29)

### ⚠ BREAKING CHANGES

* optimize transfer replay capability (#129)

### Features

* add inscription number sort option ([#168](#168)) ([9f4cdbc](9f4cdbc))
* add stats endpoint for inscription counts ([#70](#70)) ([ac18e62](ac18e62))
* detect and tag recursive inscriptions ([#167](#167)) ([fb36285](fb36285))
* optimize transfer replay capability ([#129](#129)) ([97874cc](97874cc))

### Bug Fixes

* add address column to genesis and current ([d71e1d4](d71e1d4))
* add secondary sorting by inscription number ([#177](#177)) ([99959df](99959df))
* allow multiple transfers of an inscription in one block ([#132](#132)) ([bc545f0](bc545f0))
* auto predicate registration option ([e1ed7c7](e1ed7c7))
* build beta image ([13f2c13](13f2c13))
* build event server using chainhook client library ([#105](#105)) ([ab4c795](ab4c795))
* chainhook client upgrades ([9a96492](9a96492))
* consider `tx_index` in transfers by block endpoint ([#178](#178)) ([ed517d6](ed517d6))
* introduce materialized view to count address inscriptions ([#147](#147)) ([09a95d5](09a95d5))
* make etag calculation sensitive to inscription location gap fills and upserts ([#156](#156)) ([5648c9e](5648c9e))
* optimize COUNT calculations via the use of count tables ([#175](#175)) ([31498bd](31498bd))
* refresh views in parallel ([#154](#154)) ([a7674a9](a7674a9))
* remove unused json functions ([#165](#165)) ([3eb0e24](3eb0e24))
* rename location pointer tables ([b84d27e](b84d27e))
* rollback location pointers ([#174](#174)) ([3c9d7f0](3c9d7f0))
* save tx_index on locations to support transfers on same block ([#145](#145)) ([30a9635](30a9635))
* semantic release process ([#202](#202)) ([1bd3f74](1bd3f74))
* skip db migrations during readonly mode ([d5157f0](d5157f0))
* upgrade api-toolkit ([#190](#190)) ([a691b67](a691b67))
* upgrade chainhook client ([cbbb951](cbbb951))
* upgrade chainhook client to 1.3.3 ([ee66f93](ee66f93))
* warn correctly on missing prev locations ([879bf55](879bf55))
@blockstack-devops
Copy link

🎉 This PR is included in version 1.0.0 🎉

The release is available on GitHub release

Your semantic-release bot 📦🚀

rafaelcr pushed a commit that referenced this pull request Aug 30, 2023
* optimize transfer replay capability (#129)

* add inscription number sort option ([#168](#168)) ([9f4cdbc](9f4cdbc))
* add stats endpoint for inscription counts ([#70](#70)) ([ac18e62](ac18e62))
* detect and tag recursive inscriptions ([#167](#167)) ([fb36285](fb36285))
* optimize transfer replay capability ([#129](#129)) ([97874cc](97874cc))

* add address column to genesis and current ([d71e1d4](d71e1d4))
* add secondary sorting by inscription number ([#177](#177)) ([99959df](99959df))
* allow multiple transfers of an inscription in one block ([#132](#132)) ([bc545f0](bc545f0))
* auto predicate registration option ([e1ed7c7](e1ed7c7))
* build beta image ([13f2c13](13f2c13))
* build event server using chainhook client library ([#105](#105)) ([ab4c795](ab4c795))
* chainhook client upgrades ([9a96492](9a96492))
* consider `tx_index` in transfers by block endpoint ([#178](#178)) ([ed517d6](ed517d6))
* introduce materialized view to count address inscriptions ([#147](#147)) ([09a95d5](09a95d5))
* make etag calculation sensitive to inscription location gap fills and upserts ([#156](#156)) ([5648c9e](5648c9e))
* optimize COUNT calculations via the use of count tables ([#175](#175)) ([31498bd](31498bd))
* refresh views in parallel ([#154](#154)) ([a7674a9](a7674a9))
* remove unused json functions ([#165](#165)) ([3eb0e24](3eb0e24))
* rename location pointer tables ([b84d27e](b84d27e))
* rollback location pointers ([#174](#174)) ([3c9d7f0](3c9d7f0))
* save tx_index on locations to support transfers on same block ([#145](#145)) ([30a9635](30a9635))
* semantic release process ([#202](#202)) ([1bd3f74](1bd3f74))
* skip db migrations during readonly mode ([d5157f0](d5157f0))
* upgrade api-toolkit ([#190](#190)) ([a691b67](a691b67))
* upgrade chainhook client ([cbbb951](cbbb951))
* upgrade chainhook client to 1.3.3 ([ee66f93](ee66f93))
* warn correctly on missing prev locations ([879bf55](879bf55))
rafaelcr added a commit that referenced this pull request Sep 12, 2023
* chore: add brc20 migrations

* feat: start storing token deploys

* feat: mints with balance changes

* chore: events table draft

* feat: first balance endpoint

* fix: balances and rollbacks

* feat: token info endpoint

* feat: tokens endpoint as paginated index

* test: paginated index

* test: brc20 format

* chore: more standard validation

* fix: tick must be 4 bytes or less

* fix: invalid decimal count

* feat: mint within supply

* test: mint limit

* chore: first transfers

* test: dont exceed avail balance for transfer

* test: multiple transfers in block

* feat: first balance transfers

* fix: transfers only usable once

* refactor: extract to separate functions

* fix: remove old json content tables

* fix: balances/:address

* feat: token details

* feat: holders endpoint

* fix: introduce materialized view to count address inscriptions (#147)

* fix: introduce materialized view to count address inscriptions

* fix: make index unique

* chore(release): 0.4.15 [skip ci]

## [0.4.15](v0.4.14...v0.4.15) (2023-07-13)

### Bug Fixes

* introduce materialized view to count address inscriptions ([#147](#147)) ([2e79311](2e79311))

* refactor: move brc20 pg to separate file

* fix: add indexes for fks

* fix: remove old json schemas

* refactor: move brc-20 files to its own folder

* chore(release): 1.0.0-beta.6 [skip ci]

## [1.0.0-beta.6](v1.0.0-beta.5...v1.0.0-beta.6) (2023-07-21)

### Bug Fixes

* make etag calculation sensitive to inscription location gap fills and upserts ([#156](#156)) ([5648c9e](5648c9e))
* refresh views in parallel ([#154](#154)) ([a7674a9](a7674a9))

* chore(release): 0.4.15 [skip ci]

* introduce materialized view to count address inscriptions ([#147](#147)) ([2e79311](2e79311))

* fix: build beta image

* fix: remove unused json functions (#165)

* chore(release): 1.0.0-beta.7 [skip ci]

## [1.0.0-beta.7](v1.0.0-beta.6...v1.0.0-beta.7) (2023-07-21)

### Bug Fixes

* build beta image ([13f2c13](13f2c13))
* introduce materialized view to count address inscriptions ([#147](#147)) ([2e79311](2e79311))
* remove unused json functions ([#165](#165)) ([3eb0e24](3eb0e24))

* fix: skip db migrations during readonly mode

* chore(release): 1.0.0-beta.8 [skip ci]

## [1.0.0-beta.8](v1.0.0-beta.7...v1.0.0-beta.8) (2023-07-21)

### Bug Fixes

* skip db migrations during readonly mode ([d5157f0](d5157f0))

* fix: allow gap fills for transfers

* feat: add inscription number sort option (#168)

* chore(release): 1.0.0-beta.9 [skip ci]

## [1.0.0-beta.9](v1.0.0-beta.8...v1.0.0-beta.9) (2023-07-25)

### Features

* add inscription number sort option ([#168](#168)) ([9f4cdbc](9f4cdbc))

* feat: detect and tag recursive inscriptions (#167)

* feat: initial impl

* fix: tests

* feat: filter by recursive

* fix: tests

* fix: make migration progressive

* chore(release): 1.0.0-beta.10 [skip ci]

## [1.0.0-beta.10](v1.0.0-beta.9...v1.0.0-beta.10) (2023-07-25)

### Features

* detect and tag recursive inscriptions ([#167](#167)) ([fb36285](fb36285))

* fix: warn correctly on missing prev locations

* chore(release): 1.0.0-beta.11 [skip ci]

## [1.0.0-beta.11](v1.0.0-beta.10...v1.0.0-beta.11) (2023-07-25)

### Bug Fixes

* warn correctly on missing prev locations ([879bf55](879bf55))

* fix: rollback location pointers (#174)

* chore(release): 1.0.0-beta.12 [skip ci]

## [1.0.0-beta.12](v1.0.0-beta.11...v1.0.0-beta.12) (2023-07-31)

### Bug Fixes

* rollback location pointers ([#174](#174)) ([3c9d7f0](3c9d7f0))

* fix: optimize COUNT calculations via the use of count tables (#175)

* feat: first iteration

* fix: rollbacks

* fix: block height ranges

* fix: block hash count

* fix: add custom count support

* feat: add cursed filter

* feat: genesis address filter

* chore(release): 1.0.0-beta.13 [skip ci]

## [1.0.0-beta.13](v1.0.0-beta.12...v1.0.0-beta.13) (2023-08-01)

### Bug Fixes

* optimize COUNT calculations via the use of count tables ([#175](#175)) ([31498bd](31498bd))

* fix: add secondary sorting by inscription number (#177)

* chore(release): 1.0.0-beta.14 [skip ci]

## [1.0.0-beta.14](v1.0.0-beta.13...v1.0.0-beta.14) (2023-08-02)

### Bug Fixes

* add secondary sorting by inscription number ([#177](#177)) ([99959df](99959df))

* fix: consider `tx_index` in transfers by block endpoint (#178)

* fix: upsert warning

* fix: transfers same block

* chore(release): 1.0.0-beta.15 [skip ci]

## [1.0.0-beta.15](v1.0.0-beta.14...v1.0.0-beta.15) (2023-08-04)

### Bug Fixes

* consider `tx_index` in transfers by block endpoint ([#178](#178)) ([ed517d6](ed517d6))

* fix: only consider blessed inscriptions

* feat: brc-20 balance at block (#186)

* build: release for brc-20 branch

* chore(release): 1.0.0-brc-20.1 [skip ci]

## [1.0.0-brc-20.1](v0.4.15...v1.0.0-brc-20.1) (2023-08-17)

### ⚠ BREAKING CHANGES

* optimize transfer replay capability (#129)

### Features

* add inscription number sort option ([#168](#168)) ([9f4cdbc](9f4cdbc))
* add stats endpoint for inscription counts ([#70](#70)) ([ac18e62](ac18e62))
* brc-20 balance at block ([#186](#186)) ([ced5cb3](ced5cb3))
* detect and tag recursive inscriptions ([#167](#167)) ([fb36285](fb36285))
* first balance endpoint ([f9c6654](f9c6654))
* first balance transfers ([dd8ec07](dd8ec07))
* holders endpoint ([a01f77e](a01f77e))
* mint within supply ([c8e5820](c8e5820))
* mints with balance changes ([32e90f7](32e90f7))
* optimize transfer replay capability ([#129](#129)) ([97874cc](97874cc))
* start storing token deploys ([bf4c7f6](bf4c7f6))
* token details ([5d35d5b](5d35d5b))
* token info endpoint ([8fad6b9](8fad6b9))
* tokens endpoint as paginated index ([ae2049b](ae2049b))

### Bug Fixes

* add address column to genesis and current ([d71e1d4](d71e1d4))
* add indexes for fks ([354ddd0](354ddd0))
* add secondary sorting by inscription number ([#177](#177)) ([99959df](99959df))
* allow gap fills for transfers ([026c275](026c275))
* allow multiple transfers of an inscription in one block ([#132](#132)) ([bc545f0](bc545f0))
* auto predicate registration option ([e1ed7c7](e1ed7c7))
* balances and rollbacks ([61b4139](61b4139))
* balances/:address ([687c2e4](687c2e4))
* build beta image ([13f2c13](13f2c13))
* build event server using chainhook client library ([#105](#105)) ([ab4c795](ab4c795))
* chainhook client upgrades ([9a96492](9a96492))
* consider `tx_index` in transfers by block endpoint ([#178](#178)) ([ed517d6](ed517d6))
* introduce materialized view to count address inscriptions ([#147](#147)) ([09a95d5](09a95d5))
* invalid decimal count ([aa15b0e](aa15b0e))
* make etag calculation sensitive to inscription location gap fills and upserts ([#156](#156)) ([5648c9e](5648c9e))
* only consider blessed inscriptions ([2a4700c](2a4700c))
* optimize COUNT calculations via the use of count tables ([#175](#175)) ([31498bd](31498bd))
* refresh views in parallel ([#154](#154)) ([a7674a9](a7674a9))
* remove old json content tables ([0732048](0732048))
* remove old json schemas ([8cc7f8a](8cc7f8a))
* remove unused json functions ([#165](#165)) ([3eb0e24](3eb0e24))
* rename location pointer tables ([b84d27e](b84d27e))
* rollback location pointers ([#174](#174)) ([3c9d7f0](3c9d7f0))
* save tx_index on locations to support transfers on same block ([#145](#145)) ([30a9635](30a9635))
* skip db migrations during readonly mode ([d5157f0](d5157f0))
* tick must be 4 bytes or less ([f6fd0a6](f6fd0a6))
* transfers only usable once ([542ec34](542ec34))
* upgrade chainhook client ([cbbb951](cbbb951))
* upgrade chainhook client to 1.3.3 ([ee66f93](ee66f93))
* warn correctly on missing prev locations ([879bf55](879bf55))

* feat: add more brc20 features (#183)

* refactor: update nullish access

* feat: add deploy_timestamp to brc-20 token endpoints

* feat: add minted_supply to brc-20 token endpoints

* refactor: improve scan performance with generated lower ticker

* feat: add prefix filtering to brc20 deploy tickers

* test: add token endpoint test

---------

Co-authored-by: janniks <janniks@users.noreply.github.com>

* fix: optimize inscription and brc-20 inserts (#189)

* chore: draft optims

* chore: more optimizations

* fix: reveals and transfers in same batch

* fix: inscriptions tests pass

* fix: optimize pointer logic

* fix: cache updated_at writes

* feat: scan block concept

* fix: individual items, start transfers

* fix: all tests pass

* fix: env var brc20 processing

* feat: add admin rpc server to control brc20 scans

* style: comments

* chore(release): 1.0.0-brc-20.2 [skip ci]

## [1.0.0-brc-20.2](v1.0.0-brc-20.1...v1.0.0-brc-20.2) (2023-08-24)

### Features

* add more brc20 features ([#183](#183)) ([c1939ce](c1939ce))

### Bug Fixes

* optimize inscription and brc-20 inserts ([#189](#189)) ([3807334](3807334))

* fix: sending transfer as fee returns amt to sender

* fix: add unique indexes for mints and transfers

* chore(release): 1.0.0-brc-20.3 [skip ci]

## [1.0.0-brc-20.3](v1.0.0-brc-20.2...v1.0.0-brc-20.3) (2023-08-24)

### Bug Fixes

* add unique indexes for mints and transfers ([b428bb4](b428bb4))
* sending transfer as fee returns amt to sender ([e23012a](e23012a))

* fix: upgrade api-toolkit (#190)

* fix: upgrade api-toolkit

* fix: isProdEnv helper

* fix: refresh supplies view only if BRC-20 is enabled

* chore(release): 1.0.0-brc-20.4 [skip ci]

## [1.0.0-brc-20.4](v1.0.0-brc-20.3...v1.0.0-brc-20.4) (2023-08-25)

### Bug Fixes

* refresh supplies view only if BRC-20 is enabled ([7d6705a](7d6705a))
* upgrade api-toolkit ([#190](#190)) ([0e673a7](0e673a7))

* fix: change uniqueness constraint in locations table

* chore(release): 1.0.0-brc-20.5 [skip ci]

## [1.0.0-brc-20.5](v1.0.0-brc-20.4...v1.0.0-brc-20.5) (2023-08-25)

### Bug Fixes

* change uniqueness constraint in locations table ([9a9c5de](9a9c5de))

* fix: place a cap on max insertion size

* chore(release): 1.0.0-brc-20.6 [skip ci]

## [1.0.0-brc-20.6](v1.0.0-brc-20.5...v1.0.0-brc-20.6) (2023-08-26)

### Bug Fixes

* place a cap on max insertion size ([bef5f23](bef5f23))

* fix: guard against empty recursion refs

* fix: optimize inscription backfill indexes (#197)

* fix: add recursion backfill and temporary skip (#198)

* fix: dont update cache timestamp during ingestion (#200)

* fix: do not insert repeated recursions (#199)

* fix: do not insert repeated recursions

* chore: remove custom launch

* chore: lock commit-analyzer to 9.0.2; rm dup plugins in releaserc file

* chore: revert releaserc file

* fix: split recursion insertion into chunks (#201)

* chore(release): 1.0.0 [skip ci]

* optimize transfer replay capability (#129)

* add inscription number sort option ([#168](#168)) ([9f4cdbc](9f4cdbc))
* add stats endpoint for inscription counts ([#70](#70)) ([ac18e62](ac18e62))
* detect and tag recursive inscriptions ([#167](#167)) ([fb36285](fb36285))
* optimize transfer replay capability ([#129](#129)) ([97874cc](97874cc))

* add address column to genesis and current ([d71e1d4](d71e1d4))
* add secondary sorting by inscription number ([#177](#177)) ([99959df](99959df))
* allow multiple transfers of an inscription in one block ([#132](#132)) ([bc545f0](bc545f0))
* auto predicate registration option ([e1ed7c7](e1ed7c7))
* build beta image ([13f2c13](13f2c13))
* build event server using chainhook client library ([#105](#105)) ([ab4c795](ab4c795))
* chainhook client upgrades ([9a96492](9a96492))
* consider `tx_index` in transfers by block endpoint ([#178](#178)) ([ed517d6](ed517d6))
* introduce materialized view to count address inscriptions ([#147](#147)) ([09a95d5](09a95d5))
* make etag calculation sensitive to inscription location gap fills and upserts ([#156](#156)) ([5648c9e](5648c9e))
* optimize COUNT calculations via the use of count tables ([#175](#175)) ([31498bd](31498bd))
* refresh views in parallel ([#154](#154)) ([a7674a9](a7674a9))
* remove unused json functions ([#165](#165)) ([3eb0e24](3eb0e24))
* rename location pointer tables ([b84d27e](b84d27e))
* rollback location pointers ([#174](#174)) ([3c9d7f0](3c9d7f0))
* save tx_index on locations to support transfers on same block ([#145](#145)) ([30a9635](30a9635))
* semantic release process ([#202](#202)) ([1bd3f74](1bd3f74))
* skip db migrations during readonly mode ([d5157f0](d5157f0))
* upgrade api-toolkit ([#190](#190)) ([a691b67](a691b67))
* upgrade chainhook client ([cbbb951](cbbb951))
* upgrade chainhook client to 1.3.3 ([ee66f93](ee66f93))
* warn correctly on missing prev locations ([879bf55](879bf55))

* ci: remove debug logs on semantic release [skip ci]

* fix: attempt to optimize brc-20 scan (#204)

* fix: use cursor query for brc-20 scan

* fix: optimize content retrieval

* fix: ignore transfers that are not brc-20

* fix: semantic release

* chore(release): 1.0.0-brc-20.7 [skip ci]

## [1.0.0-brc-20.7](v1.0.0-brc-20.6...v1.0.0-brc-20.7) (2023-08-30)

### Bug Fixes

* add recursion backfill and temporary skip ([#198](#198)) ([63571ee](63571ee))
* attempt to optimize brc-20 scan ([#204](#204)) ([f6545cd](f6545cd))
* do not insert repeated recursions ([#199](#199)) ([9c8508b](9c8508b))
* dont update cache timestamp during ingestion ([#200](#200)) ([8f973a3](8f973a3))
* guard against empty recursion refs ([71ce1a5](71ce1a5))
* optimize inscription backfill indexes ([#197](#197)) ([ab2f7bf](ab2f7bf))
* semantic release ([26cd2c6](26cd2c6))
* split recursion insertion into chunks ([#201](#201)) ([4ebc106](4ebc106))

* fix: optimize brc-20 scan by minimizing string conversions (#206)

* fix: filter brc-20 content from postgres

* fix: optimize transfer insert a bit

* chore: move to pg submodule

* chore(release): 1.0.0-brc-20.8 [skip ci]

## [1.0.0-brc-20.8](v1.0.0-brc-20.7...v1.0.0-brc-20.8) (2023-08-30)

### Bug Fixes

* optimize brc-20 scan by minimizing string conversions ([#206](#206)) ([98c12c8](98c12c8))

* fix: insert ops in single queries, reduce BigNumber usage (#207)

* fix: validate mint data in pg

* fix: mint in single query

* fix: insert transfer in single query

* fix: transfer send in single query

* fix: optimize BigNumber usage

* chore(release): 1.0.0-brc-20.9 [skip ci]

## [1.0.0-brc-20.9](v1.0.0-brc-20.8...v1.0.0-brc-20.9) (2023-08-30)

### Bug Fixes

* insert ops in single queries, reduce BigNumber usage ([#207](#207)) ([ef11e34](ef11e34))

* fix: cast numbers to postgres numeric

* chore(release): 1.0.0-brc-20.10 [skip ci]

## [1.0.0-brc-20.10](v1.0.0-brc-20.9...v1.0.0-brc-20.10) (2023-08-30)

### Bug Fixes

* cast numbers to postgres numeric ([f8ae276](f8ae276))

* fix: remove supply view, calculate supply as we mint

* chore(release): 1.0.0-brc-20.11 [skip ci]

## [1.0.0-brc-20.11](v1.0.0-brc-20.10...v1.0.0-brc-20.11) (2023-08-30)

### Bug Fixes

* remove supply view, calculate supply as we mint ([36addce](36addce))

* fix: guard against null bytes

* fix: null char escaping

* chore(release): 1.0.0-brc-20.12 [skip ci]

## [1.0.0-brc-20.12](v1.0.0-brc-20.11...v1.0.0-brc-20.12) (2023-08-30)

### Bug Fixes

* guard against null bytes ([9eddbfc](9eddbfc))
* null char escaping ([8bb4954](8bb4954))

* fix: go back to individual content fetch from utf8 pg errors

* chore(release): 1.0.0-brc-20.13 [skip ci]

## [1.0.0-brc-20.13](v1.0.0-brc-20.12...v1.0.0-brc-20.13) (2023-08-31)

### Bug Fixes

* go back to individual content fetch from utf8 pg errors ([4fd530d](4fd530d))

* feat: add BRC-20 event history endpoint (#191)

* feat: add BRC-20 event history/activity ingestion and endpoint

* refactor: switch to concat for a single activity subplan for transfers

* refactor: rename prepare_transfer to transfer

* test: fix faulty test due to duplicate inscription numbers

* refactor: switch to postgres enum type

* refactor: merge multiple queries using CTEs

* test: add test with multiple participants

* refactor: add updates from pr

* test: add block height test

* refactor: merge event inserts using CTEs

* fix: use correct ids for events

* fix: migrate into events with queries

---------

Co-authored-by: janniks <janniks@users.noreply.github.com>
Co-authored-by: Rafael Cardenas <rafael@rafaelcr.com>

* chore(release): 1.0.0-brc-20.14 [skip ci]

## [1.0.0-brc-20.14](v1.0.0-brc-20.13...v1.0.0-brc-20.14) (2023-08-31)

### Features

* add BRC-20 event history endpoint ([#191](#191)) ([d9967b1](d9967b1))

* fix: remove migration queries

* chore(release): 1.0.0-brc-20.15 [skip ci]

## [1.0.0-brc-20.15](v1.0.0-brc-20.14...v1.0.0-brc-20.15) (2023-08-31)

### Bug Fixes

* remove migration queries ([f53f889](f53f889))

* fix: optimize read queries, display amounts with correct decimals (#208)

* fix: single token

* fix: token list

* fix: holders, add tests

* fix: activity sorting

* fix: display amounts with correct number of decimals

* chore(release): 1.0.0-brc-20.16 [skip ci]

## [1.0.0-brc-20.16](v1.0.0-brc-20.15...v1.0.0-brc-20.16) (2023-09-01)

### Bug Fixes

* optimize read queries, display amounts with correct decimals ([#208](#208)) ([5d6453e](5d6453e))

* fix: holders count query (#209)

* chore(release): 1.0.0-brc-20.17 [skip ci]

## [1.0.0-brc-20.17](v1.0.0-brc-20.16...v1.0.0-brc-20.17) (2023-09-01)

### Bug Fixes

* holders count query ([#209](#209)) ([254ed75](254ed75))

* fix: temporarily disable count calculation to speed up requests (#210)

* chore(release): 1.0.0-brc-20.18 [skip ci]

## [1.0.0-brc-20.18](v1.0.0-brc-20.17...v1.0.0-brc-20.18) (2023-09-01)

### Bug Fixes

* temporarily disable count calculation to speed up requests ([#210](#210)) ([640e406](640e406))

* feat: add fast ingestion mode for faster replays (#211)

* chore(release): 1.0.0-brc-20.19 [skip ci]

## [1.0.0-brc-20.19](v1.0.0-brc-20.18...v1.0.0-brc-20.19) (2023-09-04)

### Features

* add fast ingestion mode for faster replays ([#211](#211)) ([7996587](7996587))

* fix: optimize sent as fee detection

* chore(release): 1.0.0-brc-20.20 [skip ci]

## [1.0.0-brc-20.20](v1.0.0-brc-20.19...v1.0.0-brc-20.20) (2023-09-06)

### Bug Fixes

* optimize sent as fee detection ([1c9b0f4](1c9b0f4))

* fix: calculate etag correctly on status endpoint (#213)

* fix: calculate etag correctly on status endpoint

* fix: vercel build

* chore(release): 1.0.0-brc-20.21 [skip ci]

## [1.0.0-brc-20.21](v1.0.0-brc-20.20...v1.0.0-brc-20.21) (2023-09-07)

### Bug Fixes

* calculate etag correctly on status endpoint ([#213](#213)) ([f0c42e2](f0c42e2))

* fix: optimize read queries by keeping count tables, implement rollbacks (#214)

* feat: total balances table

* fix: add total balance column

* fix: return balance to sender

* fix: more than once transfer

* fix: rollbacks

* fix: use new table for token holders

* fix: ticker length check

* feat: add tx_count to tokens (#215)

* fix: use correct inscription_id for transfer_send event

* feat: add tx_count to tokens

* refactor: rename activities events

---------

Co-authored-by: janniks <janniks@users.noreply.github.com>

* feat: count for activity types

* feat: token count

* test: rollbacks

* test: ignore tickers less than 4 bytes wide

---------

Co-authored-by: janniks <6362150+janniks@users.noreply.github.com>
Co-authored-by: janniks <janniks@users.noreply.github.com>

* chore(release): 1.0.0-brc-20.22 [skip ci]

## [1.0.0-brc-20.22](v1.0.0-brc-20.21...v1.0.0-brc-20.22) (2023-09-10)

### Bug Fixes

* optimize read queries by keeping count tables, implement rollbacks ([#214](#214)) ([574d349](574d349)), closes [#215](#215)

* fix: only increase counts on valid operations

* chore(release): 1.0.0-brc-20.23 [skip ci]

## [1.0.0-brc-20.23](v1.0.0-brc-20.22...v1.0.0-brc-20.23) (2023-09-10)

### Bug Fixes

* only increase counts on valid operations ([01f0865](01f0865))

* feat: add location to activity response

* chore(release): 1.0.0-brc-20.24 [skip ci]

## [1.0.0-brc-20.24](v1.0.0-brc-20.23...v1.0.0-brc-20.24) (2023-09-10)

### Features

* add location to activity response ([580861e](580861e))

* fix: change tx_count to json number (#216)

Co-authored-by: janniks <janniks@users.noreply.github.com>

* chore(release): 1.0.0-brc-20.25 [skip ci]

## [1.0.0-brc-20.25](v1.0.0-brc-20.24...v1.0.0-brc-20.25) (2023-09-11)

### Bug Fixes

* change tx_count to json number ([#216](#216)) ([20f9415](20f9415))

* fix: ticker filter for balances (#217)

* chore(release): 1.0.0-brc-20.26 [skip ci]

## [1.0.0-brc-20.26](v1.0.0-brc-20.25...v1.0.0-brc-20.26) (2023-09-11)

### Bug Fixes

* ticker filter for balances ([#217](#217)) ([1ca3bcd](1ca3bcd))

* fix: return to sender balance calculation (#218)

* chore(release): 1.0.0-brc-20.27 [skip ci]

## [1.0.0-brc-20.27](v1.0.0-brc-20.26...v1.0.0-brc-20.27) (2023-09-12)

### Bug Fixes

* return to sender balance calculation ([#218](#218)) ([226dfe6](226dfe6))

---------

Co-authored-by: semantic-release-bot <semantic-release-bot@martynus.net>
Co-authored-by: janniks <6362150+janniks@users.noreply.github.com>
Co-authored-by: janniks <janniks@users.noreply.github.com>
Co-authored-by: Dean Chi <21262275+deantchi@users.noreply.github.com>
blockstack-devops pushed a commit that referenced this pull request Sep 12, 2023
## [1.1.0](v1.0.0...v1.1.0) (2023-09-12)

### Features

* BRC-20 token support ([#78](#78)) ([a39bfd3](a39bfd3)), closes [#147](#147) [#147](#147) [#156](#156) [#154](#154) [#147](#147) [#165](#165) [#147](#147) [#165](#165) [#168](#168) [#168](#168) [#167](#167) [#167](#167) [#174](#174) [#174](#174) [#175](#175) [#175](#175) [#177](#177) [#177](#177) [#178](#178) [#178](#178) [#186](#186) [#129](#129) [#168](#168) [#70](#70) [#186](#186) [#167](#167) [#129](#129) [#177](#177) [#132](#132) [#105](#105) [#178](#178) [#147](#147) [#156](#156) [#175](#175) [#154](#154) [#165](#165) [#174](#174) [#145](#145) [#183](#183)

### Bug Fixes

* lint errors ([#220](#220)) ([f6bc735](f6bc735))

### Reverts

* Revert "Added H1 to the overview page" ([8fedf86](8fedf86))
g0drlc added a commit to g0drlc/btc-ordinals-api that referenced this pull request Jul 14, 2024
## [1.0.0-beta.1](hirosystems/ordinals-api@v0.4.7...v1.0.0-beta.1) (2023-07-06)

### ⚠ BREAKING CHANGES

* optimize transfer replay capability (#129)

### Features

* add stats endpoint for inscription counts ([#70](hirosystems/ordinals-api#70)) ([ac18e62](hirosystems/ordinals-api@ac18e62))
* optimize transfer replay capability ([#129](hirosystems/ordinals-api#129)) ([97874cc](hirosystems/ordinals-api@97874cc))

### Bug Fixes

* auto predicate registration option ([e1ed7c7](hirosystems/ordinals-api@e1ed7c7))
* build event server using chainhook client library ([#105](hirosystems/ordinals-api#105)) ([ab4c795](hirosystems/ordinals-api@ab4c795))
* chainhook client upgrades ([9a96492](hirosystems/ordinals-api@9a96492))
* upgrade chainhook client ([cbbb951](hirosystems/ordinals-api@cbbb951))
* upgrade chainhook client to 1.3.3 ([ee66f93](hirosystems/ordinals-api@ee66f93))
g0drlc added a commit to g0drlc/btc-ordinals-api that referenced this pull request Jul 14, 2024
## [1.0.0](hirosystems/ordinals-api@v0.4.15...v1.0.0) (2023-08-29)

### ⚠ BREAKING CHANGES

* optimize transfer replay capability (#129)

### Features

* add inscription number sort option ([#168](hirosystems/ordinals-api#168)) ([9f4cdbc](hirosystems/ordinals-api@9f4cdbc))
* add stats endpoint for inscription counts ([#70](hirosystems/ordinals-api#70)) ([ac18e62](hirosystems/ordinals-api@ac18e62))
* detect and tag recursive inscriptions ([#167](hirosystems/ordinals-api#167)) ([fb36285](hirosystems/ordinals-api@fb36285))
* optimize transfer replay capability ([#129](hirosystems/ordinals-api#129)) ([97874cc](hirosystems/ordinals-api@97874cc))

### Bug Fixes

* add address column to genesis and current ([d71e1d4](hirosystems/ordinals-api@d71e1d4))
* add secondary sorting by inscription number ([#177](hirosystems/ordinals-api#177)) ([99959df](hirosystems/ordinals-api@99959df))
* allow multiple transfers of an inscription in one block ([#132](hirosystems/ordinals-api#132)) ([bc545f0](hirosystems/ordinals-api@bc545f0))
* auto predicate registration option ([e1ed7c7](hirosystems/ordinals-api@e1ed7c7))
* build beta image ([13f2c13](hirosystems/ordinals-api@13f2c13))
* build event server using chainhook client library ([#105](hirosystems/ordinals-api#105)) ([ab4c795](hirosystems/ordinals-api@ab4c795))
* chainhook client upgrades ([9a96492](hirosystems/ordinals-api@9a96492))
* consider `tx_index` in transfers by block endpoint ([#178](hirosystems/ordinals-api#178)) ([ed517d6](hirosystems/ordinals-api@ed517d6))
* introduce materialized view to count address inscriptions ([#147](hirosystems/ordinals-api#147)) ([09a95d5](hirosystems/ordinals-api@09a95d5))
* make etag calculation sensitive to inscription location gap fills and upserts ([#156](hirosystems/ordinals-api#156)) ([5648c9e](hirosystems/ordinals-api@5648c9e))
* optimize COUNT calculations via the use of count tables ([#175](hirosystems/ordinals-api#175)) ([31498bd](hirosystems/ordinals-api@31498bd))
* refresh views in parallel ([#154](hirosystems/ordinals-api#154)) ([a7674a9](hirosystems/ordinals-api@a7674a9))
* remove unused json functions ([#165](hirosystems/ordinals-api#165)) ([3eb0e24](hirosystems/ordinals-api@3eb0e24))
* rename location pointer tables ([b84d27e](hirosystems/ordinals-api@b84d27e))
* rollback location pointers ([#174](hirosystems/ordinals-api#174)) ([3c9d7f0](hirosystems/ordinals-api@3c9d7f0))
* save tx_index on locations to support transfers on same block ([#145](hirosystems/ordinals-api#145)) ([30a9635](hirosystems/ordinals-api@30a9635))
* semantic release process ([#202](hirosystems/ordinals-api#202)) ([1bd3f74](hirosystems/ordinals-api@1bd3f74))
* skip db migrations during readonly mode ([d5157f0](hirosystems/ordinals-api@d5157f0))
* upgrade api-toolkit ([#190](hirosystems/ordinals-api#190)) ([a691b67](hirosystems/ordinals-api@a691b67))
* upgrade chainhook client ([cbbb951](hirosystems/ordinals-api@cbbb951))
* upgrade chainhook client to 1.3.3 ([ee66f93](hirosystems/ordinals-api@ee66f93))
* warn correctly on missing prev locations ([879bf55](hirosystems/ordinals-api@879bf55))
g0drlc added a commit to g0drlc/btc-ordinals-api that referenced this pull request Jul 14, 2024
* chore: add brc20 migrations

* feat: start storing token deploys

* feat: mints with balance changes

* chore: events table draft

* feat: first balance endpoint

* fix: balances and rollbacks

* feat: token info endpoint

* feat: tokens endpoint as paginated index

* test: paginated index

* test: brc20 format

* chore: more standard validation

* fix: tick must be 4 bytes or less

* fix: invalid decimal count

* feat: mint within supply

* test: mint limit

* chore: first transfers

* test: dont exceed avail balance for transfer

* test: multiple transfers in block

* feat: first balance transfers

* fix: transfers only usable once

* refactor: extract to separate functions

* fix: remove old json content tables

* fix: balances/:address

* feat: token details

* feat: holders endpoint

* fix: introduce materialized view to count address inscriptions (#147)

* fix: introduce materialized view to count address inscriptions

* fix: make index unique

* chore(release): 0.4.15 [skip ci]

## [0.4.15](hirosystems/ordinals-api@v0.4.14...v0.4.15) (2023-07-13)

### Bug Fixes

* introduce materialized view to count address inscriptions ([#147](hirosystems/ordinals-api#147)) ([2e79311](hirosystems/ordinals-api@2e79311))

* refactor: move brc20 pg to separate file

* fix: add indexes for fks

* fix: remove old json schemas

* refactor: move brc-20 files to its own folder

* chore(release): 1.0.0-beta.6 [skip ci]

## [1.0.0-beta.6](hirosystems/ordinals-api@v1.0.0-beta.5...v1.0.0-beta.6) (2023-07-21)

### Bug Fixes

* make etag calculation sensitive to inscription location gap fills and upserts ([#156](hirosystems/ordinals-api#156)) ([5648c9e](hirosystems/ordinals-api@5648c9e))
* refresh views in parallel ([#154](hirosystems/ordinals-api#154)) ([a7674a9](hirosystems/ordinals-api@a7674a9))

* chore(release): 0.4.15 [skip ci]

* introduce materialized view to count address inscriptions ([#147](hirosystems/ordinals-api#147)) ([2e79311](hirosystems/ordinals-api@2e79311))

* fix: build beta image

* fix: remove unused json functions (#165)

* chore(release): 1.0.0-beta.7 [skip ci]

## [1.0.0-beta.7](hirosystems/ordinals-api@v1.0.0-beta.6...v1.0.0-beta.7) (2023-07-21)

### Bug Fixes

* build beta image ([13f2c13](hirosystems/ordinals-api@13f2c13))
* introduce materialized view to count address inscriptions ([#147](hirosystems/ordinals-api#147)) ([2e79311](hirosystems/ordinals-api@2e79311))
* remove unused json functions ([#165](hirosystems/ordinals-api#165)) ([3eb0e24](hirosystems/ordinals-api@3eb0e24))

* fix: skip db migrations during readonly mode

* chore(release): 1.0.0-beta.8 [skip ci]

## [1.0.0-beta.8](hirosystems/ordinals-api@v1.0.0-beta.7...v1.0.0-beta.8) (2023-07-21)

### Bug Fixes

* skip db migrations during readonly mode ([d5157f0](hirosystems/ordinals-api@d5157f0))

* fix: allow gap fills for transfers

* feat: add inscription number sort option (#168)

* chore(release): 1.0.0-beta.9 [skip ci]

## [1.0.0-beta.9](hirosystems/ordinals-api@v1.0.0-beta.8...v1.0.0-beta.9) (2023-07-25)

### Features

* add inscription number sort option ([#168](hirosystems/ordinals-api#168)) ([9f4cdbc](hirosystems/ordinals-api@9f4cdbc))

* feat: detect and tag recursive inscriptions (#167)

* feat: initial impl

* fix: tests

* feat: filter by recursive

* fix: tests

* fix: make migration progressive

* chore(release): 1.0.0-beta.10 [skip ci]

## [1.0.0-beta.10](hirosystems/ordinals-api@v1.0.0-beta.9...v1.0.0-beta.10) (2023-07-25)

### Features

* detect and tag recursive inscriptions ([#167](hirosystems/ordinals-api#167)) ([fb36285](hirosystems/ordinals-api@fb36285))

* fix: warn correctly on missing prev locations

* chore(release): 1.0.0-beta.11 [skip ci]

## [1.0.0-beta.11](hirosystems/ordinals-api@v1.0.0-beta.10...v1.0.0-beta.11) (2023-07-25)

### Bug Fixes

* warn correctly on missing prev locations ([879bf55](hirosystems/ordinals-api@879bf55))

* fix: rollback location pointers (#174)

* chore(release): 1.0.0-beta.12 [skip ci]

## [1.0.0-beta.12](hirosystems/ordinals-api@v1.0.0-beta.11...v1.0.0-beta.12) (2023-07-31)

### Bug Fixes

* rollback location pointers ([#174](hirosystems/ordinals-api#174)) ([3c9d7f0](hirosystems/ordinals-api@3c9d7f0))

* fix: optimize COUNT calculations via the use of count tables (#175)

* feat: first iteration

* fix: rollbacks

* fix: block height ranges

* fix: block hash count

* fix: add custom count support

* feat: add cursed filter

* feat: genesis address filter

* chore(release): 1.0.0-beta.13 [skip ci]

## [1.0.0-beta.13](hirosystems/ordinals-api@v1.0.0-beta.12...v1.0.0-beta.13) (2023-08-01)

### Bug Fixes

* optimize COUNT calculations via the use of count tables ([#175](hirosystems/ordinals-api#175)) ([31498bd](hirosystems/ordinals-api@31498bd))

* fix: add secondary sorting by inscription number (#177)

* chore(release): 1.0.0-beta.14 [skip ci]

## [1.0.0-beta.14](hirosystems/ordinals-api@v1.0.0-beta.13...v1.0.0-beta.14) (2023-08-02)

### Bug Fixes

* add secondary sorting by inscription number ([#177](hirosystems/ordinals-api#177)) ([99959df](hirosystems/ordinals-api@99959df))

* fix: consider `tx_index` in transfers by block endpoint (#178)

* fix: upsert warning

* fix: transfers same block

* chore(release): 1.0.0-beta.15 [skip ci]

## [1.0.0-beta.15](hirosystems/ordinals-api@v1.0.0-beta.14...v1.0.0-beta.15) (2023-08-04)

### Bug Fixes

* consider `tx_index` in transfers by block endpoint ([#178](hirosystems/ordinals-api#178)) ([ed517d6](hirosystems/ordinals-api@ed517d6))

* fix: only consider blessed inscriptions

* feat: brc-20 balance at block (#186)

* build: release for brc-20 branch

* chore(release): 1.0.0-brc-20.1 [skip ci]

## [1.0.0-brc-20.1](hirosystems/ordinals-api@v0.4.15...v1.0.0-brc-20.1) (2023-08-17)

### ⚠ BREAKING CHANGES

* optimize transfer replay capability (#129)

### Features

* add inscription number sort option ([#168](hirosystems/ordinals-api#168)) ([9f4cdbc](hirosystems/ordinals-api@9f4cdbc))
* add stats endpoint for inscription counts ([#70](hirosystems/ordinals-api#70)) ([ac18e62](hirosystems/ordinals-api@ac18e62))
* brc-20 balance at block ([#186](hirosystems/ordinals-api#186)) ([ced5cb3](hirosystems/ordinals-api@ced5cb3))
* detect and tag recursive inscriptions ([#167](hirosystems/ordinals-api#167)) ([fb36285](hirosystems/ordinals-api@fb36285))
* first balance endpoint ([f9c6654](hirosystems/ordinals-api@f9c6654))
* first balance transfers ([dd8ec07](hirosystems/ordinals-api@dd8ec07))
* holders endpoint ([a01f77e](hirosystems/ordinals-api@a01f77e))
* mint within supply ([c8e5820](hirosystems/ordinals-api@c8e5820))
* mints with balance changes ([32e90f7](hirosystems/ordinals-api@32e90f7))
* optimize transfer replay capability ([#129](hirosystems/ordinals-api#129)) ([97874cc](hirosystems/ordinals-api@97874cc))
* start storing token deploys ([bf4c7f6](hirosystems/ordinals-api@bf4c7f6))
* token details ([5d35d5b](hirosystems/ordinals-api@5d35d5b))
* token info endpoint ([8fad6b9](hirosystems/ordinals-api@8fad6b9))
* tokens endpoint as paginated index ([ae2049b](hirosystems/ordinals-api@ae2049b))

### Bug Fixes

* add address column to genesis and current ([d71e1d4](hirosystems/ordinals-api@d71e1d4))
* add indexes for fks ([354ddd0](hirosystems/ordinals-api@354ddd0))
* add secondary sorting by inscription number ([#177](hirosystems/ordinals-api#177)) ([99959df](hirosystems/ordinals-api@99959df))
* allow gap fills for transfers ([026c275](hirosystems/ordinals-api@026c275))
* allow multiple transfers of an inscription in one block ([#132](hirosystems/ordinals-api#132)) ([bc545f0](hirosystems/ordinals-api@bc545f0))
* auto predicate registration option ([e1ed7c7](hirosystems/ordinals-api@e1ed7c7))
* balances and rollbacks ([61b4139](hirosystems/ordinals-api@61b4139))
* balances/:address ([687c2e4](hirosystems/ordinals-api@687c2e4))
* build beta image ([13f2c13](hirosystems/ordinals-api@13f2c13))
* build event server using chainhook client library ([#105](hirosystems/ordinals-api#105)) ([ab4c795](hirosystems/ordinals-api@ab4c795))
* chainhook client upgrades ([9a96492](hirosystems/ordinals-api@9a96492))
* consider `tx_index` in transfers by block endpoint ([#178](hirosystems/ordinals-api#178)) ([ed517d6](hirosystems/ordinals-api@ed517d6))
* introduce materialized view to count address inscriptions ([#147](hirosystems/ordinals-api#147)) ([09a95d5](hirosystems/ordinals-api@09a95d5))
* invalid decimal count ([aa15b0e](hirosystems/ordinals-api@aa15b0e))
* make etag calculation sensitive to inscription location gap fills and upserts ([#156](hirosystems/ordinals-api#156)) ([5648c9e](hirosystems/ordinals-api@5648c9e))
* only consider blessed inscriptions ([2a4700c](hirosystems/ordinals-api@2a4700c))
* optimize COUNT calculations via the use of count tables ([#175](hirosystems/ordinals-api#175)) ([31498bd](hirosystems/ordinals-api@31498bd))
* refresh views in parallel ([#154](hirosystems/ordinals-api#154)) ([a7674a9](hirosystems/ordinals-api@a7674a9))
* remove old json content tables ([0732048](hirosystems/ordinals-api@0732048))
* remove old json schemas ([8cc7f8a](hirosystems/ordinals-api@8cc7f8a))
* remove unused json functions ([#165](hirosystems/ordinals-api#165)) ([3eb0e24](hirosystems/ordinals-api@3eb0e24))
* rename location pointer tables ([b84d27e](hirosystems/ordinals-api@b84d27e))
* rollback location pointers ([#174](hirosystems/ordinals-api#174)) ([3c9d7f0](hirosystems/ordinals-api@3c9d7f0))
* save tx_index on locations to support transfers on same block ([#145](hirosystems/ordinals-api#145)) ([30a9635](hirosystems/ordinals-api@30a9635))
* skip db migrations during readonly mode ([d5157f0](hirosystems/ordinals-api@d5157f0))
* tick must be 4 bytes or less ([f6fd0a6](hirosystems/ordinals-api@f6fd0a6))
* transfers only usable once ([542ec34](hirosystems/ordinals-api@542ec34))
* upgrade chainhook client ([cbbb951](hirosystems/ordinals-api@cbbb951))
* upgrade chainhook client to 1.3.3 ([ee66f93](hirosystems/ordinals-api@ee66f93))
* warn correctly on missing prev locations ([879bf55](hirosystems/ordinals-api@879bf55))

* feat: add more brc20 features (#183)

* refactor: update nullish access

* feat: add deploy_timestamp to brc-20 token endpoints

* feat: add minted_supply to brc-20 token endpoints

* refactor: improve scan performance with generated lower ticker

* feat: add prefix filtering to brc20 deploy tickers

* test: add token endpoint test

---------

Co-authored-by: janniks <janniks@users.noreply.github.com>

* fix: optimize inscription and brc-20 inserts (#189)

* chore: draft optims

* chore: more optimizations

* fix: reveals and transfers in same batch

* fix: inscriptions tests pass

* fix: optimize pointer logic

* fix: cache updated_at writes

* feat: scan block concept

* fix: individual items, start transfers

* fix: all tests pass

* fix: env var brc20 processing

* feat: add admin rpc server to control brc20 scans

* style: comments

* chore(release): 1.0.0-brc-20.2 [skip ci]

## [1.0.0-brc-20.2](hirosystems/ordinals-api@v1.0.0-brc-20.1...v1.0.0-brc-20.2) (2023-08-24)

### Features

* add more brc20 features ([#183](hirosystems/ordinals-api#183)) ([c1939ce](hirosystems/ordinals-api@c1939ce))

### Bug Fixes

* optimize inscription and brc-20 inserts ([#189](hirosystems/ordinals-api#189)) ([3807334](hirosystems/ordinals-api@3807334))

* fix: sending transfer as fee returns amt to sender

* fix: add unique indexes for mints and transfers

* chore(release): 1.0.0-brc-20.3 [skip ci]

## [1.0.0-brc-20.3](hirosystems/ordinals-api@v1.0.0-brc-20.2...v1.0.0-brc-20.3) (2023-08-24)

### Bug Fixes

* add unique indexes for mints and transfers ([b428bb4](hirosystems/ordinals-api@b428bb4))
* sending transfer as fee returns amt to sender ([e23012a](hirosystems/ordinals-api@e23012a))

* fix: upgrade api-toolkit (#190)

* fix: upgrade api-toolkit

* fix: isProdEnv helper

* fix: refresh supplies view only if BRC-20 is enabled

* chore(release): 1.0.0-brc-20.4 [skip ci]

## [1.0.0-brc-20.4](hirosystems/ordinals-api@v1.0.0-brc-20.3...v1.0.0-brc-20.4) (2023-08-25)

### Bug Fixes

* refresh supplies view only if BRC-20 is enabled ([7d6705a](hirosystems/ordinals-api@7d6705a))
* upgrade api-toolkit ([#190](hirosystems/ordinals-api#190)) ([0e673a7](hirosystems/ordinals-api@0e673a7))

* fix: change uniqueness constraint in locations table

* chore(release): 1.0.0-brc-20.5 [skip ci]

## [1.0.0-brc-20.5](hirosystems/ordinals-api@v1.0.0-brc-20.4...v1.0.0-brc-20.5) (2023-08-25)

### Bug Fixes

* change uniqueness constraint in locations table ([9a9c5de](hirosystems/ordinals-api@9a9c5de))

* fix: place a cap on max insertion size

* chore(release): 1.0.0-brc-20.6 [skip ci]

## [1.0.0-brc-20.6](hirosystems/ordinals-api@v1.0.0-brc-20.5...v1.0.0-brc-20.6) (2023-08-26)

### Bug Fixes

* place a cap on max insertion size ([bef5f23](hirosystems/ordinals-api@bef5f23))

* fix: guard against empty recursion refs

* fix: optimize inscription backfill indexes (#197)

* fix: add recursion backfill and temporary skip (#198)

* fix: dont update cache timestamp during ingestion (#200)

* fix: do not insert repeated recursions (#199)

* fix: do not insert repeated recursions

* chore: remove custom launch

* chore: lock commit-analyzer to 9.0.2; rm dup plugins in releaserc file

* chore: revert releaserc file

* fix: split recursion insertion into chunks (#201)

* chore(release): 1.0.0 [skip ci]

* optimize transfer replay capability (#129)

* add inscription number sort option ([#168](hirosystems/ordinals-api#168)) ([9f4cdbc](hirosystems/ordinals-api@9f4cdbc))
* add stats endpoint for inscription counts ([#70](hirosystems/ordinals-api#70)) ([ac18e62](hirosystems/ordinals-api@ac18e62))
* detect and tag recursive inscriptions ([#167](hirosystems/ordinals-api#167)) ([fb36285](hirosystems/ordinals-api@fb36285))
* optimize transfer replay capability ([#129](hirosystems/ordinals-api#129)) ([97874cc](hirosystems/ordinals-api@97874cc))

* add address column to genesis and current ([d71e1d4](hirosystems/ordinals-api@d71e1d4))
* add secondary sorting by inscription number ([#177](hirosystems/ordinals-api#177)) ([99959df](hirosystems/ordinals-api@99959df))
* allow multiple transfers of an inscription in one block ([#132](hirosystems/ordinals-api#132)) ([bc545f0](hirosystems/ordinals-api@bc545f0))
* auto predicate registration option ([e1ed7c7](hirosystems/ordinals-api@e1ed7c7))
* build beta image ([13f2c13](hirosystems/ordinals-api@13f2c13))
* build event server using chainhook client library ([#105](hirosystems/ordinals-api#105)) ([ab4c795](hirosystems/ordinals-api@ab4c795))
* chainhook client upgrades ([9a96492](hirosystems/ordinals-api@9a96492))
* consider `tx_index` in transfers by block endpoint ([#178](hirosystems/ordinals-api#178)) ([ed517d6](hirosystems/ordinals-api@ed517d6))
* introduce materialized view to count address inscriptions ([#147](hirosystems/ordinals-api#147)) ([09a95d5](hirosystems/ordinals-api@09a95d5))
* make etag calculation sensitive to inscription location gap fills and upserts ([#156](hirosystems/ordinals-api#156)) ([5648c9e](hirosystems/ordinals-api@5648c9e))
* optimize COUNT calculations via the use of count tables ([#175](hirosystems/ordinals-api#175)) ([31498bd](hirosystems/ordinals-api@31498bd))
* refresh views in parallel ([#154](hirosystems/ordinals-api#154)) ([a7674a9](hirosystems/ordinals-api@a7674a9))
* remove unused json functions ([#165](hirosystems/ordinals-api#165)) ([3eb0e24](hirosystems/ordinals-api@3eb0e24))
* rename location pointer tables ([b84d27e](hirosystems/ordinals-api@b84d27e))
* rollback location pointers ([#174](hirosystems/ordinals-api#174)) ([3c9d7f0](hirosystems/ordinals-api@3c9d7f0))
* save tx_index on locations to support transfers on same block ([#145](hirosystems/ordinals-api#145)) ([30a9635](hirosystems/ordinals-api@30a9635))
* semantic release process ([#202](hirosystems/ordinals-api#202)) ([1bd3f74](hirosystems/ordinals-api@1bd3f74))
* skip db migrations during readonly mode ([d5157f0](hirosystems/ordinals-api@d5157f0))
* upgrade api-toolkit ([#190](hirosystems/ordinals-api#190)) ([a691b67](hirosystems/ordinals-api@a691b67))
* upgrade chainhook client ([cbbb951](hirosystems/ordinals-api@cbbb951))
* upgrade chainhook client to 1.3.3 ([ee66f93](hirosystems/ordinals-api@ee66f93))
* warn correctly on missing prev locations ([879bf55](hirosystems/ordinals-api@879bf55))

* ci: remove debug logs on semantic release [skip ci]

* fix: attempt to optimize brc-20 scan (#204)

* fix: use cursor query for brc-20 scan

* fix: optimize content retrieval

* fix: ignore transfers that are not brc-20

* fix: semantic release

* chore(release): 1.0.0-brc-20.7 [skip ci]

## [1.0.0-brc-20.7](hirosystems/ordinals-api@v1.0.0-brc-20.6...v1.0.0-brc-20.7) (2023-08-30)

### Bug Fixes

* add recursion backfill and temporary skip ([#198](hirosystems/ordinals-api#198)) ([63571ee](hirosystems/ordinals-api@63571ee))
* attempt to optimize brc-20 scan ([#204](hirosystems/ordinals-api#204)) ([f6545cd](hirosystems/ordinals-api@f6545cd))
* do not insert repeated recursions ([#199](hirosystems/ordinals-api#199)) ([9c8508b](hirosystems/ordinals-api@9c8508b))
* dont update cache timestamp during ingestion ([#200](hirosystems/ordinals-api#200)) ([8f973a3](hirosystems/ordinals-api@8f973a3))
* guard against empty recursion refs ([71ce1a5](hirosystems/ordinals-api@71ce1a5))
* optimize inscription backfill indexes ([#197](hirosystems/ordinals-api#197)) ([ab2f7bf](hirosystems/ordinals-api@ab2f7bf))
* semantic release ([26cd2c6](hirosystems/ordinals-api@26cd2c6))
* split recursion insertion into chunks ([#201](hirosystems/ordinals-api#201)) ([4ebc106](hirosystems/ordinals-api@4ebc106))

* fix: optimize brc-20 scan by minimizing string conversions (#206)

* fix: filter brc-20 content from postgres

* fix: optimize transfer insert a bit

* chore: move to pg submodule

* chore(release): 1.0.0-brc-20.8 [skip ci]

## [1.0.0-brc-20.8](hirosystems/ordinals-api@v1.0.0-brc-20.7...v1.0.0-brc-20.8) (2023-08-30)

### Bug Fixes

* optimize brc-20 scan by minimizing string conversions ([#206](hirosystems/ordinals-api#206)) ([98c12c8](hirosystems/ordinals-api@98c12c8))

* fix: insert ops in single queries, reduce BigNumber usage (#207)

* fix: validate mint data in pg

* fix: mint in single query

* fix: insert transfer in single query

* fix: transfer send in single query

* fix: optimize BigNumber usage

* chore(release): 1.0.0-brc-20.9 [skip ci]

## [1.0.0-brc-20.9](hirosystems/ordinals-api@v1.0.0-brc-20.8...v1.0.0-brc-20.9) (2023-08-30)

### Bug Fixes

* insert ops in single queries, reduce BigNumber usage ([#207](hirosystems/ordinals-api#207)) ([ef11e34](hirosystems/ordinals-api@ef11e34))

* fix: cast numbers to postgres numeric

* chore(release): 1.0.0-brc-20.10 [skip ci]

## [1.0.0-brc-20.10](hirosystems/ordinals-api@v1.0.0-brc-20.9...v1.0.0-brc-20.10) (2023-08-30)

### Bug Fixes

* cast numbers to postgres numeric ([f8ae276](hirosystems/ordinals-api@f8ae276))

* fix: remove supply view, calculate supply as we mint

* chore(release): 1.0.0-brc-20.11 [skip ci]

## [1.0.0-brc-20.11](hirosystems/ordinals-api@v1.0.0-brc-20.10...v1.0.0-brc-20.11) (2023-08-30)

### Bug Fixes

* remove supply view, calculate supply as we mint ([36addce](hirosystems/ordinals-api@36addce))

* fix: guard against null bytes

* fix: null char escaping

* chore(release): 1.0.0-brc-20.12 [skip ci]

## [1.0.0-brc-20.12](hirosystems/ordinals-api@v1.0.0-brc-20.11...v1.0.0-brc-20.12) (2023-08-30)

### Bug Fixes

* guard against null bytes ([9eddbfc](hirosystems/ordinals-api@9eddbfc))
* null char escaping ([8bb4954](hirosystems/ordinals-api@8bb4954))

* fix: go back to individual content fetch from utf8 pg errors

* chore(release): 1.0.0-brc-20.13 [skip ci]

## [1.0.0-brc-20.13](hirosystems/ordinals-api@v1.0.0-brc-20.12...v1.0.0-brc-20.13) (2023-08-31)

### Bug Fixes

* go back to individual content fetch from utf8 pg errors ([4fd530d](hirosystems/ordinals-api@4fd530d))

* feat: add BRC-20 event history endpoint (#191)

* feat: add BRC-20 event history/activity ingestion and endpoint

* refactor: switch to concat for a single activity subplan for transfers

* refactor: rename prepare_transfer to transfer

* test: fix faulty test due to duplicate inscription numbers

* refactor: switch to postgres enum type

* refactor: merge multiple queries using CTEs

* test: add test with multiple participants

* refactor: add updates from pr

* test: add block height test

* refactor: merge event inserts using CTEs

* fix: use correct ids for events

* fix: migrate into events with queries

---------

Co-authored-by: janniks <janniks@users.noreply.github.com>
Co-authored-by: Rafael Cardenas <rafael@rafaelcr.com>

* chore(release): 1.0.0-brc-20.14 [skip ci]

## [1.0.0-brc-20.14](hirosystems/ordinals-api@v1.0.0-brc-20.13...v1.0.0-brc-20.14) (2023-08-31)

### Features

* add BRC-20 event history endpoint ([#191](hirosystems/ordinals-api#191)) ([d9967b1](hirosystems/ordinals-api@d9967b1))

* fix: remove migration queries

* chore(release): 1.0.0-brc-20.15 [skip ci]

## [1.0.0-brc-20.15](hirosystems/ordinals-api@v1.0.0-brc-20.14...v1.0.0-brc-20.15) (2023-08-31)

### Bug Fixes

* remove migration queries ([f53f889](hirosystems/ordinals-api@f53f889))

* fix: optimize read queries, display amounts with correct decimals (#208)

* fix: single token

* fix: token list

* fix: holders, add tests

* fix: activity sorting

* fix: display amounts with correct number of decimals

* chore(release): 1.0.0-brc-20.16 [skip ci]

## [1.0.0-brc-20.16](hirosystems/ordinals-api@v1.0.0-brc-20.15...v1.0.0-brc-20.16) (2023-09-01)

### Bug Fixes

* optimize read queries, display amounts with correct decimals ([#208](hirosystems/ordinals-api#208)) ([5d6453e](hirosystems/ordinals-api@5d6453e))

* fix: holders count query (#209)

* chore(release): 1.0.0-brc-20.17 [skip ci]

## [1.0.0-brc-20.17](hirosystems/ordinals-api@v1.0.0-brc-20.16...v1.0.0-brc-20.17) (2023-09-01)

### Bug Fixes

* holders count query ([#209](hirosystems/ordinals-api#209)) ([254ed75](hirosystems/ordinals-api@254ed75))

* fix: temporarily disable count calculation to speed up requests (#210)

* chore(release): 1.0.0-brc-20.18 [skip ci]

## [1.0.0-brc-20.18](hirosystems/ordinals-api@v1.0.0-brc-20.17...v1.0.0-brc-20.18) (2023-09-01)

### Bug Fixes

* temporarily disable count calculation to speed up requests ([#210](hirosystems/ordinals-api#210)) ([640e406](hirosystems/ordinals-api@640e406))

* feat: add fast ingestion mode for faster replays (#211)

* chore(release): 1.0.0-brc-20.19 [skip ci]

## [1.0.0-brc-20.19](hirosystems/ordinals-api@v1.0.0-brc-20.18...v1.0.0-brc-20.19) (2023-09-04)

### Features

* add fast ingestion mode for faster replays ([#211](hirosystems/ordinals-api#211)) ([7996587](hirosystems/ordinals-api@7996587))

* fix: optimize sent as fee detection

* chore(release): 1.0.0-brc-20.20 [skip ci]

## [1.0.0-brc-20.20](hirosystems/ordinals-api@v1.0.0-brc-20.19...v1.0.0-brc-20.20) (2023-09-06)

### Bug Fixes

* optimize sent as fee detection ([1c9b0f4](hirosystems/ordinals-api@1c9b0f4))

* fix: calculate etag correctly on status endpoint (#213)

* fix: calculate etag correctly on status endpoint

* fix: vercel build

* chore(release): 1.0.0-brc-20.21 [skip ci]

## [1.0.0-brc-20.21](hirosystems/ordinals-api@v1.0.0-brc-20.20...v1.0.0-brc-20.21) (2023-09-07)

### Bug Fixes

* calculate etag correctly on status endpoint ([#213](hirosystems/ordinals-api#213)) ([f0c42e2](hirosystems/ordinals-api@f0c42e2))

* fix: optimize read queries by keeping count tables, implement rollbacks (#214)

* feat: total balances table

* fix: add total balance column

* fix: return balance to sender

* fix: more than once transfer

* fix: rollbacks

* fix: use new table for token holders

* fix: ticker length check

* feat: add tx_count to tokens (#215)

* fix: use correct inscription_id for transfer_send event

* feat: add tx_count to tokens

* refactor: rename activities events

---------

Co-authored-by: janniks <janniks@users.noreply.github.com>

* feat: count for activity types

* feat: token count

* test: rollbacks

* test: ignore tickers less than 4 bytes wide

---------

Co-authored-by: janniks <6362150+janniks@users.noreply.github.com>
Co-authored-by: janniks <janniks@users.noreply.github.com>

* chore(release): 1.0.0-brc-20.22 [skip ci]

## [1.0.0-brc-20.22](hirosystems/ordinals-api@v1.0.0-brc-20.21...v1.0.0-brc-20.22) (2023-09-10)

### Bug Fixes

* optimize read queries by keeping count tables, implement rollbacks ([#214](hirosystems/ordinals-api#214)) ([574d349](hirosystems/ordinals-api@574d349)), closes [#215](hirosystems/ordinals-api#215)

* fix: only increase counts on valid operations

* chore(release): 1.0.0-brc-20.23 [skip ci]

## [1.0.0-brc-20.23](hirosystems/ordinals-api@v1.0.0-brc-20.22...v1.0.0-brc-20.23) (2023-09-10)

### Bug Fixes

* only increase counts on valid operations ([01f0865](hirosystems/ordinals-api@01f0865))

* feat: add location to activity response

* chore(release): 1.0.0-brc-20.24 [skip ci]

## [1.0.0-brc-20.24](hirosystems/ordinals-api@v1.0.0-brc-20.23...v1.0.0-brc-20.24) (2023-09-10)

### Features

* add location to activity response ([580861e](hirosystems/ordinals-api@580861e))

* fix: change tx_count to json number (#216)

Co-authored-by: janniks <janniks@users.noreply.github.com>

* chore(release): 1.0.0-brc-20.25 [skip ci]

## [1.0.0-brc-20.25](hirosystems/ordinals-api@v1.0.0-brc-20.24...v1.0.0-brc-20.25) (2023-09-11)

### Bug Fixes

* change tx_count to json number ([#216](hirosystems/ordinals-api#216)) ([20f9415](hirosystems/ordinals-api@20f9415))

* fix: ticker filter for balances (#217)

* chore(release): 1.0.0-brc-20.26 [skip ci]

## [1.0.0-brc-20.26](hirosystems/ordinals-api@v1.0.0-brc-20.25...v1.0.0-brc-20.26) (2023-09-11)

### Bug Fixes

* ticker filter for balances ([#217](hirosystems/ordinals-api#217)) ([1ca3bcd](hirosystems/ordinals-api@1ca3bcd))

* fix: return to sender balance calculation (#218)

* chore(release): 1.0.0-brc-20.27 [skip ci]

## [1.0.0-brc-20.27](hirosystems/ordinals-api@v1.0.0-brc-20.26...v1.0.0-brc-20.27) (2023-09-12)

### Bug Fixes

* return to sender balance calculation ([#218](hirosystems/ordinals-api#218)) ([226dfe6](hirosystems/ordinals-api@226dfe6))

---------

Co-authored-by: semantic-release-bot <semantic-release-bot@martynus.net>
Co-authored-by: janniks <6362150+janniks@users.noreply.github.com>
Co-authored-by: janniks <janniks@users.noreply.github.com>
Co-authored-by: Dean Chi <21262275+deantchi@users.noreply.github.com>
g0drlc added a commit to g0drlc/btc-ordinals-api that referenced this pull request Jul 14, 2024
## [1.1.0](hirosystems/ordinals-api@v1.0.0...v1.1.0) (2023-09-12)

### Features

* BRC-20 token support ([#78](hirosystems/ordinals-api#78)) ([a39bfd3](hirosystems/ordinals-api@a39bfd3)), closes [#147](hirosystems/ordinals-api#147) [#147](hirosystems/ordinals-api#147) [#156](hirosystems/ordinals-api#156) [#154](hirosystems/ordinals-api#154) [#147](hirosystems/ordinals-api#147) [#165](hirosystems/ordinals-api#165) [#147](hirosystems/ordinals-api#147) [#165](hirosystems/ordinals-api#165) [#168](hirosystems/ordinals-api#168) [#168](hirosystems/ordinals-api#168) [#167](hirosystems/ordinals-api#167) [#167](hirosystems/ordinals-api#167) [#174](hirosystems/ordinals-api#174) [#174](hirosystems/ordinals-api#174) [#175](hirosystems/ordinals-api#175) [#175](hirosystems/ordinals-api#175) [#177](hirosystems/ordinals-api#177) [#177](hirosystems/ordinals-api#177) [#178](hirosystems/ordinals-api#178) [#178](hirosystems/ordinals-api#178) [#186](hirosystems/ordinals-api#186) [#129](hirosystems/ordinals-api#129) [#168](hirosystems/ordinals-api#168) [#70](hirosystems/ordinals-api#70) [#186](hirosystems/ordinals-api#186) [#167](hirosystems/ordinals-api#167) [#129](hirosystems/ordinals-api#129) [#177](hirosystems/ordinals-api#177) [#132](hirosystems/ordinals-api#132) [#105](hirosystems/ordinals-api#105) [#178](hirosystems/ordinals-api#178) [#147](hirosystems/ordinals-api#147) [#156](hirosystems/ordinals-api#156) [#175](hirosystems/ordinals-api#175) [#154](hirosystems/ordinals-api#154) [#165](hirosystems/ordinals-api#165) [#174](hirosystems/ordinals-api#174) [#145](hirosystems/ordinals-api#145) [#183](hirosystems/ordinals-api#183)

### Bug Fixes

* lint errors ([#220](hirosystems/ordinals-api#220)) ([f6bc735](hirosystems/ordinals-api@f6bc735))

### Reverts

* Revert "Added H1 to the overview page" ([8fedf86](hirosystems/ordinals-api@8fedf86))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Archived in project
Development

Successfully merging this pull request may close these issues.

Add stats endpoints for Explorer
4 participants