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

Median time past index #9

Closed
dcousens opened this issue May 9, 2017 · 5 comments
Closed

Median time past index #9

dcousens opened this issue May 9, 2017 · 5 comments
Labels

Comments

@dcousens
Copy link
Contributor

dcousens commented May 9, 2017

@Runn1ng I assume this is what you mean by timestamp index?
I'll push up this, as its only in my local fork of indexd atm...

@dcousens
Copy link
Contributor Author

dcousens commented May 11, 2017

@Runn1ng - are you literally just wanting txId | utc as a first-seen?
Would you also want scId | utc? Mind you, that could be a huge chunk of data and would be a 2nd order insertion.

Maybe even blockId | height | utc?
Then you could track how many orphans occur.

That said, each of these indexes would be re-org independent, and would continuously persist (obviously).

That said, all these could be optional.

@karelbilek
Copy link

karelbilek commented May 11, 2017

From documentation of bitcore

timestampindex

This index maps timestamps with block hashes and is useful for searching blocks by date instead of by height. This is useful for a block explorer that will give search options by date. However it should be noted that the timestamps of blocks can be out of order, as there is a tolerance of around 2 hours that a timestamp of block is allowed to be set.

So it's not first seen, but really time -> blockhash.

bitcoin/bitcoin@2045ffe#diff-81e4f16a1b5d5b7ca25351a63d07cb80R269

bitcoin/bitcoin@2045ffe#diff-24efdb00bfbe56b140fb006b562cc70bR2161

@karelbilek
Copy link

karelbilek commented May 16, 2017

You deleted your message :) but well... bitcore uses it for displaying blocks on certain date, that's all

https://insight.bitpay.com/blocks-date/2017-03-06

But really it's not a must-have feature in the end, I guess

@dcousens
Copy link
Contributor Author

@Runn1ng sorry, I realised you already addressed my question with:

This is useful for a block explorer that will give search options by date

Apologies for the confusion.

@dcousens dcousens removed their assignment Nov 3, 2017
@dcousens dcousens changed the title Mempool Transaction first-seen index Median time past index Jan 30, 2018
dcousens added a commit that referenced this issue Jan 30, 2018
@dcousens
Copy link
Contributor Author

dcousens commented Jan 30, 2018

Added in #37 (query functions are missing, but, you can trivially make a PR! :) )

48a97bd

dcousens added a commit that referenced this issue Jan 30, 2018
dcousens added a commit that referenced this issue Jan 30, 2018
dcousens added a commit that referenced this issue Jan 30, 2018
dcousens added a commit that referenced this issue Feb 1, 2018
dcousens added a commit that referenced this issue Jun 29, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants