Bitcoin in SQL

[databoi]

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.

[1714026704]

1714026704

[hugeblack]

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]

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

[death_wish]

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]

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

[seoincorporation]

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.

[NotATether]

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.

[Minase]

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

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.

[potmo]

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?

[ABCbits]

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.