How Populate Ethereum Addresses to MySQL Database?

JollyGood

legendary

Activity: 2506

Merit: 1710

Top Crypto Casino

Quote from: starmyc on March 25, 2018, 11:03:11 AM

Quote from: JollyGood on March 25, 2018, 10:48:03 AM

Any idea on how to do this would be appreciated

Why do you need the entire ethereum blockchain to do this ?
You only need to generate a private/public key and store them, like using this method Generating a usable Ethereum wallet and its corresponding keys.

Thank you but I already found that post on the net and read it last night but am open to finding any other solutions before I start exploring a way to do it

JollyGood

legendary

Activity: 2506

Merit: 1710

Top Crypto Casino

Quote from: ManaMan on March 25, 2018, 11:09:36 AM

Quote from: JollyGood on March 19, 2018, 10:31:21 AM

I have never used Ethereum before but will use Ubuntu or AWS AMI to install it and sync the blockchain.

After that I want to generate addresses and populate those addresses in a MySQL database which will be linked to an ecommerce site for customers to use at checkout.

I have successfully achieved this process with Bitcoin and now want to do it with Ethereum.

I do not want anything to do with ETH contracts, I just want a new addresses to be displayed when the customer reaches checkout.

Any advice will be appreciated.

Easier what you can do if you will be just requesting payments is to use BIP39. What it does is that you will have a sequence from which you should be able to easily generate new addresses without the need of your private keys, there are libraries for this. So at the end of the day you will use some API like from etherscan and see the balance and you don't put private keys on your server and thus you don't expose them at all, even you won't need to have blockchain synced.

But if you still want to have full blockchain and do this, then you will have to create RPC and connect to your wallet through RPC with some programming language (can be what you want python, php....) that will take addresses and put them into table in SQL

Thank you but do you have any links I can browse examples of what you mentioned?

ManaMan

member

Activity: 238

Merit: 38

Quote from: JollyGood on March 19, 2018, 10:31:21 AM

I have never used Ethereum before but will use Ubuntu or AWS AMI to install it and sync the blockchain.

After that I want to generate addresses and populate those addresses in a MySQL database which will be linked to an ecommerce site for customers to use at checkout.

I have successfully achieved this process with Bitcoin and now want to do it with Ethereum.

I do not want anything to do with ETH contracts, I just want a new addresses to be displayed when the customer reaches checkout.

Any advice will be appreciated.

Easier what you can do if you will be just requesting payments is to use BIP39. What it does is that you will have a sequence from which you should be able to easily generate new addresses without the need of your private keys, there are libraries for this. So at the end of the day you will use some API like from etherscan and see the balance and you don't put private keys on your server and thus you don't expose them at all, even you won't need to have blockchain synced.

But if you still want to have full blockchain and do this, then you will have to create RPC and connect to your wallet through RPC with some programming language (can be what you want python, php....) that will take addresses and put them into table in SQL

starmyc

full member

Activity: 198

Merit: 130

Some random software engineer

Quote from: JollyGood on March 25, 2018, 10:48:03 AM

Any idea on how to do this would be appreciated

Why do you need the entire ethereum blockchain to do this ?
You only need to generate a private/public key and store them, like using this method Generating a usable Ethereum wallet and its corresponding keys.

JollyGood

legendary

Activity: 2506

Merit: 1710

Top Crypto Casino

Any idea on how to do this would be appreciated

JollyGood

legendary

Activity: 2506

Merit: 1710

Top Crypto Casino

Please any advice?

starmyc

full member

Activity: 198

Merit: 130

Some random software engineer

Quote from: JollyGood on March 19, 2018, 10:31:21 AM

After that I want to generate addresses and populate those addresses in a MySQL database which will be linked to an ecommerce site for customers to use at checkout.

I have successfully achieved this process with Bitcoin and now want to do it with Ethereum.

Just out of curiosity, how big is your mysql database after this on hard disk ?
How much time did it took to import ? How many records did you store ?

JollyGood

legendary

Activity: 2506

Merit: 1710

Top Crypto Casino

I have never used Ethereum before but will use Ubuntu or AWS AMI to install it and sync the blockchain.

After that I want to generate addresses and populate those addresses in a MySQL database which will be linked to an ecommerce site for customers to use at checkout.

I have successfully achieved this process with Bitcoin and now want to do it with Ethereum.

I do not want anything to do with ETH contracts, I just want a new addresses to be displayed when the customer reaches checkout.

Any advice will be appreciated.

Topic: How Populate Ethereum Addresses to MySQL Database? (Read 515 times)