search

prettymuchbryce / blockchainparser

A blockchain parser written in go
8 stars 0 forks source link

question about db schema #1

Open igorbarinov opened 9 years ago

igorbarinov commented 9 years ago

Hi Bryce! Looks like its gonna be a great project. I want to try it out.

I have the question about db. In your project you have script field in inputs and outputs tables as byte array. I would like to have it as varchar to query db for some analytics on script field. E.g. search for OP_RETURN field [...] like '6a%' in query. But with bytearray it will be slow because I have to use encode(script,'hex') something in queries. I met the same problem with toshi, abe and other blockchain nodes with RDBMS. Because you started recently may be we can discuss this use case?

prettymuchbryce commented 9 years ago

Hi Igor. Thanks for your suggestion. I didn't expect any open issues so quickly after making this repository public. I am still working toward completing a first iteration of the project. That being said, what you suggested sounds reasonable to me, and I will certainly take a look into it.