Bitcoin in SQL | Bitcointalksearch.org

ABCbits

legendary

Activity: 2870

Merit: 7490

Crypto Swap Exchange

Quote from: potmo on August 04, 2022, 09:01:37 PM

This is awesome! Any idea how much in terms of resources (especially storage I assume a new M1 macbook pro with 16gb ram is fine for everything else) for data storage plus running the server?

If you check 1st link shared by OP, it's stated the size of this dataset is 581GB. Few MacBook Pro which use M1 chip only has 512GB storage, so you need to make upgrade if you have 512GB model or free space of your macbook is less than 581GB + few GB for application to run SQL server. Other than that, M1 chip and 16GB is more than enough to run SQL server.

potmo

newbie

Activity: 7

Merit: 0

This is awesome! Any idea how much in terms of resources (especially storage I assume a new M1 macbook pro with 16gb ram is fine for everything else) for data storage plus running the server?

Minase

member

Activity: 72

Merit: 43

https://www.dolthub.com/repositories/web3/bitcoin/query/main?q=SHOW+CREATE+TABLE+%60blocks%60&active=Schemas
you can change tables from the left

Quote from: NotATether on June 18, 2022, 11:25:44 PM

The database schema is documented in other places, right? (such as the webpage you can download it from?) Or could you briefly describe it on this thread?

Because I wouldn't want to go through the trouble of loading a very large database just to see what schema it uses.

NotATether

legendary

Activity: 1568

Merit: 6660

bitcoincleanup.com / bitmixlist.org

The database schema is documented in other places, right? (such as the webpage you can download it from?) Or could you briefly describe it on this thread?

Because I wouldn't want to go through the trouble of loading a very large database just to see what schema it uses.

seoincorporation

legendary

Activity: 3346

Merit: 3130

Is a great project, and you could use this base to generate a block explorer, that would be a nice side project.

Isn't the first time I read something like this, and there is a big discussion about the topic because Blockchain is already a database, so, this is like putting a database inside of a database. And the fact that it needs to be connected to a node to be updated makes me feel like a resource wasting. But for some projects this is great.

Thanks for the apport and thanks for making it open source.

databoi

newbie

Activity: 5

Merit: 83

The project you mentioned is extremely interesting. I'm reading their white paper and will reach out. Thank you!

death_wish

member

Activity: 70

Merit: 320

Take profit in BTC. Account PnL in BTC. BTC=money.

Interesting. I will be taking a close look at this.

Another SQL RDBMS for blockchain data, not mentioned on the Dolt blog’s DB roundup: the =nil; Database Management System called =nil; 'DROP DATABASE * -. That’s sort of Solana-centric, but cross-chain; it looks like it is being developed as infrastructure support for a ZK-proof bridge system. I have not tried it.

databoi

newbie

Activity: 5

Merit: 83

To access all the wallets and their relevant balance I have some queries in this blog: https://www.dolthub.com/blog/2022-06-01-free-the-sql-data/. I can add an addresses table as a generated view for sure

hugeblack

legendary

Activity: 2702

Merit: 4002

First, thank you for making the code open source, I have a friend who is looking for such a database, I will ask him to check and review the code and if there is something I will update here or ask him to create an account in the forum.

databoi

newbie

Activity: 5

Merit: 83

I launched an open-source Bitcoin database https://www.dolthub.com/repositories/web3/bitcoin. Anyone should be able to clone and run mysql queries on top of it. It's built on a database tool called https://github.com/dolthub/dolt.

Let me know if this interesting, this current database is a little behind the head block but I have a more optimized database of Bitcoin coming soon.

Topic: Bitcoin in SQL (Read 479 times)