Bitcoin Forum
March 29, 2024, 03:43:24 PM *
News: Latest Bitcoin Core release: 26.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Open the Blockchain in a Database  (Read 482 times)
rolling (OP)
Hero Member
*****
Offline Offline

Activity: 824
Merit: 712


View Profile
July 30, 2013, 12:53:57 AM
 #1

Can anyone tell me how to open the blockchain using a database program such as Access?  I apparently have the blockchain since I have bitcoin installed but I can not view it in anything but the native program.  I tried importing the dat files but couldn't.
1711727004
Hero Member
*
Offline Offline

Posts: 1711727004

View Profile Personal Message (Offline)

Ignore
1711727004
Reply with quote  #2

1711727004
Report to moderator
1711727004
Hero Member
*
Offline Offline

Posts: 1711727004

View Profile Personal Message (Offline)

Ignore
1711727004
Reply with quote  #2

1711727004
Report to moderator
1711727004
Hero Member
*
Offline Offline

Posts: 1711727004

View Profile Personal Message (Offline)

Ignore
1711727004
Reply with quote  #2

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

Posts: 1711727004

View Profile Personal Message (Offline)

Ignore
1711727004
Reply with quote  #2

1711727004
Report to moderator
i3lome
Full Member
***
Offline Offline

Activity: 210
Merit: 100



View Profile
July 30, 2013, 01:11:37 AM
 #2

can you just use blockchain.info to get the information you need
rolling (OP)
Hero Member
*****
Offline Offline

Activity: 824
Merit: 712


View Profile
July 30, 2013, 01:17:14 AM
 #3

I want the whole blockchain.  It would take years viewing 1 block at a time.
lmn123
Newbie
*
Offline Offline

Activity: 9
Merit: 0


View Profile
July 30, 2013, 01:31:24 AM
 #4

Correct me if I'm wrong, but isn't the blockchain stored as plaintext? Can't you just view it by concatenating all the blockXX.dat files in the "~/.bitcoin/blocks" folder and just view them with a text viewer?
rolling (OP)
Hero Member
*****
Offline Offline

Activity: 824
Merit: 712


View Profile
July 30, 2013, 01:34:44 AM
 #5

I just get a bunch of scrambled characters.
lmn123
Newbie
*
Offline Offline

Activity: 9
Merit: 0


View Profile
July 30, 2013, 11:16:10 AM
 #6

Shoot I do too. Why did I think those were plaintext? Somebody who knows better will have to help.
whault
Newbie
*
Offline Offline

Activity: 16
Merit: 0


View Profile
July 30, 2013, 11:46:53 AM
 #7

The blocks are stored in something called LevelDB, which is already a very capable database format. While you wouldn't have any fun opening it up in Excel (it's 10GB afteral), you can use a python application named Abe to throw it all into a Postgres/MySQL database if you really insist. I would personally advise against it though.

https://github.com/jtobey/bitcoin-abe
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!