Bitcoin Stack Exchange
Bitcoin Stack Exchange

Questions tagged [mysql]

MySQL is an open-source, relational database management system.

MySQL is a “relational database management system” (RDBMS) that runs as a server providing multi-user access to a number of databases. Its source code is available under the GNU (General Public License).

MySQL offers standard database driver connectivity for using MySQL with applications and tools that are compatible with industry standards ODBC and JDBC.

8 questions
4
votes
4 answers

What is the currently most efficient and reliable method to store the Bitcoin blockchain in a local database?

I have seen several posts on this before, and have tried all the suggested solutions, but I can't get any of them to work. I am interested in analysing transactions with the OP_RETURN opcode for a project, and need to dump the entire Bitcoin in a…
Johannes Mols
  • 151
  • 5
2
votes
1 answer

Blockchain MySql Implementation - Updating Database

I know there are similar posts here about utilizing MySQL as the basis for an application which contains the contents of the blockchain, but i have not seen any on-point answers to the issue of updating the database after the initial dump. Assuming…
Brian Koffler
  • 23
  • 1
  • 3
1
vote
0 answers

How can I add the MySQL C++ connector to Bitcoin Makefile?

I'm trying to add a custom function to my bitcoin client that queries a mysql db. I followed this guide for the basic: https://technology.finra.org/code/compile-run-customize-your-own-bitcoin-client.html I build the bitcoin node from the source…
JJJ
  • 11
  • 1
1
vote
1 answer

modifying bitcoind to include mysql support

I am modifying bitcoind (working with 0.13.1) to include write the log to mysql db versus the log file. I have all the functions worked out and compiling outside of bitcoind The trouble I ran into is when trying to compile it all with…
Albert S
  • 1,600
  • 10
  • 21
0
votes
0 answers

add mysql dependency configure.ac bitcoin

i am working on bitcoin code, my aim is to move blockchain data to relational db but i am not able to resolve mysql dependency for different platform, platform includes mac and ubuntu. I have tried giving static and dynamic dependency but both of…
Talha Malik
  • 1
  • 2
0
votes
1 answer

What's the best way to store unspent transaction?

AFAIK, To send a raw transaction, which include both input and output. And What if we run it on the local node, we can simply fetch the unspent list by run bitcoin-cli listunspent, but If I just want to create a raw transaction on the client side, I…
Frank AK
  • 141
  • 9
0
votes
1 answer

Automated transactions to addresses from database

I want to create a website where people can submit their altcoin address and they receive some for free. The addresses are saved in a MySQL database and the transactions are send from just one address. How do I have to connect the database with the…
user3423840
  • 3
  • 1
-1
votes
1 answer

MySQL view to identify a transaction with retrived API datas

How would I identify a transaction taking in consideration the following I have a user table holding user datas ++ id | username | btc_recive_address++ ---------------------------------------- ++ 1 | myuser | 123kahpoiq31328 ++ order table …
fefe
  • 109
  • 6