Bitcoin Forum

Bitcoin => Development & Technical Discussion => Topic started by: WatchTheif on April 07, 2014, 05:31:29 PM



Title: Bitcoind & MySQL Account Question
Post by: WatchTheif on April 07, 2014, 05:31:29 PM
What is a good way to manage multiple accounts using bitcoind's API and an external DB like MySQL?

Should it work something like this:
1. New user signs up, account address is generated with bitcoind for that account
2. Set the new receiving addresses account, with bitcoind's setaccount, to the new accounts id
3. Database the new account's receiving address, in my MySQL database, linked to that new accounts id
4. Account balances are kept updated in the MySQL database with bitcoind's walletnotify and, blocknotify
5. When an account withdraws funds, use contrib/spendfrom code to send the amount from that accounts receiving address to the sendto address the account requests

Also, Is the bitcoind's listunspent resource heavy on my server?
Is walletnotify and blocknotify reliable for keeping my accounts DB accurately updated?


Any guidance on this would be much appreciated.


Title: Re: Bitcoind & MySQL Account Question
Post by: WatchTheif on April 09, 2014, 05:42:53 PM
Well after no help on this form and a tone of searching I found a great post about this issue, broadly speaking.

For all the noobs like my self who need answers to ruffly this question, here is a good post.

This is the link that I found:
http://bitcoin.stackexchange.com/questions/21153/bitcoin-accounts-feature-is-it-practical-or-scalable



Cheers.