|
Title: How Populate Ethereum Addresses to MySQL Database? Post by: JollyGood on March 19, 2018, 02:31:21 PM 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. Title: Re: How Populate Ethereum Addresses to MySQL Database? Post by: starmyc on March 19, 2018, 02:39:42 PM 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 ? Title: Re: How Populate Ethereum Addresses to MySQL Database? Post by: JollyGood on March 19, 2018, 03:48:25 PM Please any advice?
Title: Re: How Populate Ethereum Addresses to MySQL Database? Post by: JollyGood on March 25, 2018, 02:48:03 PM Any idea on how to do this would be appreciated
Title: Re: How Populate Ethereum Addresses to MySQL Database? Post by: starmyc on March 25, 2018, 03:03:11 PM 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. (https://kobl.one/blog/create-full-ethereum-keypair-and-address/) Title: Re: How Populate Ethereum Addresses to MySQL Database? Post by: ManaMan on March 25, 2018, 03:09:36 PM 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 Title: Re: How Populate Ethereum Addresses to MySQL Database? Post by: JollyGood on March 25, 2018, 03:41:45 PM 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? Title: Re: How Populate Ethereum Addresses to MySQL Database? Post by: JollyGood on March 25, 2018, 03:43:18 PM 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. (https://kobl.one/blog/create-full-ethereum-keypair-and-address/) 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 |