Bitcoin Forum
August 16, 2022, 04:50:43 AM *
News: Latest Bitcoin Core release: 23.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Bitcoin in SQL  (Read 310 times)
databoi
Newbie
*
Offline Offline

Activity: 5
Merit: 73


View Profile
June 02, 2022, 01:47:04 PM
Last edit: June 02, 2022, 05:47:18 PM by databoi
Merited by Welsh (15), ETFbitcoin (14), malevolent (10), hugeblack (10), vapourminer (6), NeuroticFish (5), o_e_l_e_o (4), TryNinja (2), bitmover (2), tranthidung (1), SquirrelJulietGarden (1)
 #1

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.
1660625443
Hero Member
*
Offline Offline

Posts: 1660625443

View Profile Personal Message (Offline)

Ignore
1660625443
Reply with quote  #2

1660625443
Report to moderator
1660625443
Hero Member
*
Offline Offline

Posts: 1660625443

View Profile Personal Message (Offline)

Ignore
1660625443
Reply with quote  #2

1660625443
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1660625443
Hero Member
*
Offline Offline

Posts: 1660625443

View Profile Personal Message (Offline)

Ignore
1660625443
Reply with quote  #2

1660625443
Report to moderator
hugeblack
Legendary
*
Offline Offline

Activity: 1876
Merit: 2492



View Profile
June 03, 2022, 11:07:00 AM
 #2

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.

.BEST..CHANGE.███████████████
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
███████████████
..BUY/ SELL CRYPTO..
ETFbitcoin
Legendary
*
Offline Offline

Activity: 2240
Merit: 4793


View Profile
June 03, 2022, 11:32:06 AM
 #3

Thank you for open sourcing this database. I've seen some people who wanted SQL format for their project, so i bet some people find it's interesting. Do you have any plan to add another table (e.g. addresses)?

databoi
Newbie
*
Offline Offline

Activity: 5
Merit: 73


View Profile
June 03, 2022, 02:37:20 PM
 #4

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
Member
**
Offline Offline

Activity: 70
Merit: 314

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


View Profile
June 05, 2022, 06:19:05 AM
 #5

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

Another SQL RDBMS for blockchain data, not mentioned on the Dolt blog’s DB roundupthe =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.

“The worst stablecoin scam is USD—the dollar itself.” — Me.  |  Delete the bounties subforums, and ban paid signatures!
databoi
Newbie
*
Offline Offline

Activity: 5
Merit: 73


View Profile
June 06, 2022, 03:43:07 PM
 #6

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

Activity: 2520
Merit: 1986



View Profile
June 17, 2022, 04:35:53 PM
 #7

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.

     ▄█
   ▄██▌
 ▄████
▀▀▀█████▀
  ▐███▀
  ██▀
  ▀
..
▄▄▄███████▄▄▄
▄▄█████████████████▄▄
▄███████████████████████▄
███████████████████████████
██████████
███████████████████
██████████
█████████████████████
█████████████████████████████
█████████████████████████████
██
███████████████████████████
██
█████████████████████████
███████████████████████
▀▀█████████████████▀▀

▀▀▀███████▀▀▀
▄▄▄███████▄▄▄
▄▄█▀▀███████████▀▀█▄▄
▄████▄▄███████████▄▄████▄
█████
███▀▀▄▄▄▄▄▄▄▀▀████████
█████
██▀▄██████▀████▄▀███████
███████▀▄█████▀ ▐█████▄▀███████
██  ███ ████▀   ▀▀█████ ███  ██
██████▄▀█████  ▄█████▀▄██████
██████▄▀███▌▄██████▀▄██████
██
██████▄▄▀▀▀▀▀▀▀▄▄████████
▀█
███▀▀███████████▀▀████▀
▀▀█▄▄███████████▄▄█▀▀
▀▀▀███████▀▀▀
▄▀▀▀▀▀▀▀▀▀▀█████████
▀▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
█████████████████████

██████████▄▀▀▀▀▀▀▀▀▀

▄▄▄████████████████████▄▄▄
████████████████████████████
██████████████████████████████
███████████████████████████████
███████████████████████████████
███████████████████████████
▀██
█████████▀   ▀███████████▀
▀▀█████▀▀       ▀▀█████▀▀
.
..SPORTS  │  CASINO  │  ESPORTS..
...
..BET NOW..
NotATether
Legendary
*
Online Online

Activity: 966
Merit: 3460


aka. The Underboss


View Profile WWW
June 19, 2022, 04:25:44 AM
 #8

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
Jr. Member
*
Offline Offline

Activity: 40
Merit: 33


View Profile
June 19, 2022, 06:04:49 AM
 #9

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
Newbie
*
Offline Offline

Activity: 7
Merit: 0


View Profile
August 05, 2022, 02:01:37 AM
 #10

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?
ETFbitcoin
Legendary
*
Offline Offline

Activity: 2240
Merit: 4793


View Profile
August 05, 2022, 11:57:09 AM
Merited by hugeblack (4)
 #11

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.

Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!