<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[EthTools - Medium]]></title>
        <description><![CDATA[Posts pertaining to EthTools.com, a website for interacting with the Ethereum blockchain. - Medium]]></description>
        <link>https://medium.com/ethtools?source=rss----22e5e2b8e046---4</link>
        <image>
            <url>https://cdn-images-1.medium.com/proxy/1*TGH72Nnw24QL3iV9IOm4VA.png</url>
            <title>EthTools - Medium</title>
            <link>https://medium.com/ethtools?source=rss----22e5e2b8e046---4</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 03:15:03 GMT</lastBuildDate>
        <atom:link href="https://medium.com/feed/ethtools" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[PSA: Speculation is toxic]]></title>
            <link>https://medium.com/ethtools/psa-speculation-is-toxic-fbf2be13d5db?source=rss----22e5e2b8e046---4</link>
            <guid isPermaLink="false">https://medium.com/p/fbf2be13d5db</guid>
            <category><![CDATA[ethereum]]></category>
            <category><![CDATA[cryptocurrency]]></category>
            <category><![CDATA[eth]]></category>
            <category><![CDATA[ethereum-blockchain]]></category>
            <category><![CDATA[blockchain]]></category>
            <dc:creator><![CDATA[Thomas Clowes]]></dc:creator>
            <pubDate>Sat, 06 Jan 2018 20:06:07 GMT</pubDate>
            <atom:updated>2018-01-06T20:06:07.283Z</atom:updated>
            <content:encoded><![CDATA[<p>I have been fairly vocal on my <a href="https://twitter.com/GUA">personal Twitter account</a> about how speculation in cryptocurrency markets is getting out of hand.</p><p>I wrote a post in August entitled <a href="https://thomasclowes.com/why-how-i-built-ethtools-com/">Why/How I built EthTools.com</a>. The short version is that in 2015 I stumbled upon Ethereum. It sounded technologically promising and there was a small but tight community of interested parties discussing and working on ways of using it.</p><p>Fast forward to today. We all know what happened. The price rose, and as a result the makeup of the community changed.</p><p>Now, I am not in any way surprised that the idea of large financial gains attracts people to something but I am surprised the extent to which things changed. The worst thing in my view is how a number of early adopters who I respected have ‘dropped the act’ and now schill Ethereum for the purposes of making <strong>more</strong> money. They don’t build anything on the platform, they just schill.</p><p>Other community members who were building interesting products have seemingly disappeared. Where is <a href="https://twitter.com/pipermerriam">Piper</a>?</p><p>The newcomers who have joined the community based on the promise of financial gain are at least honest and up front about their intentions.</p><h3>Security</h3><p>In November 2016 I wrote about <a href="https://thomasclowes.com/ethereum-security-and-wallets/">Ethereum security</a>. This was an insanely popular post. I have also answered numerous questions on <a href="https://ethereum.stackexchange.com/users/425/thomas-clowes">Stack Exchange</a> and over on the <a href="http://community.ethtools.com/">EthTools.com community</a>.</p><p>Many newcomers know little about being secure whilst working with the Ethereum blockchain. When I first got interested.. nor did I.</p><p>Needless to say security is extremely important. No-one wants to lose money.</p><p>I run my own company: <a href="https://doublenegative.com/">Double Negative</a>. We build web applications. I decided to build a website for making interactions with the Ethereum blockchain simpler for newcomers. <a href="https://ethtools.com/">EthTools.com</a> was born.</p><p>One of the reasons I run Double Negative as a registered UK company is legitimacy. Unlike a large number of cryptocurrency businesses we are completely transparent because we have nothing to hide.</p><p>I made a development decision from Day 1 that EthTools.com would <strong>not</strong> <em>touch</em> Ether in any capacity. Bugs, audits, hackings etc were in no way of interest to me. As a company I did not want to consider the additional risk of in any way handling user funds. As such all EthTools.com tools simply offer an interface for interacting with the blockchain. This is similar to the <a href="https://myetherwallet.com/">MEW</a> offering.</p><p>In addition to this I try to be clear and concise when interacting with others. Take <a href="https://ethereum.stackexchange.com/a/24295/425">this answer</a> for example. I answer the question, market EthTools a little, and also try and provide a little educational food for thought.</p><h3>Your private key</h3><p>Today I was informed that EthTools.com was blocked by Metamask because it is a phishing website. I did a little investigating and stumbled upon <a href="https://github.com/MetaMask/eth-phishing-detect/commit/7d4a184fcb03da6c81ad11e33048409e1be40df5">this commit</a>.</p><p>EthTools.com was added to the ‘phishing list’ because of this post: <a href="https://www.reddit.com/r/ethereum/comments/7krhue/psa_you_do_not_need_to_provide_a_private_key_to_a/">PSA: You do not need to provide a private key to a faucet.</a>.</p><p>To answer the question. No, you <strong>do not</strong> need to provide your private key to use a faucet. You <strong>do</strong> need to provide a private key to use the EthTools.com faucet. Why? That is how it works. If you use the other tooling on the website you will note that we have a consistent ‘wallet loading’ interface across the site. Usage of this is documented in <a href="https://thomasclowes.com/tag/ethereum/">blog posts</a> and in <a href="https://www.youtube.com/channel/UCclllZ6rocahRo2K7szJWzw">video tutorials</a>. This is to make it easy and consistent for the user, <strong>not</strong> so we can steal your Ether.</p><p>The majority of the EthTools.com functionality is written in React (Javascript). It is front end code, and if you are so inclined you can see exactly what we store and what we send across the wire. Hint: We do not send your private key.</p><p>It was also built this way because when I originally <a href="https://twitter.com/GUA/status/892383436828291073">reached out</a> to Hudson at the Ethereum foundation about building a Ropsten faucet he noted (via email) the need to make sure that it was not abused in a manner that would allow a nefarious user to get millions of testnet Ether (with which they could spam the network).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/630/0*2txyimjL7BkKbtnq.png" /></figure><p>The plan for monetising EthTools.com was advertising. In the same way that Etherscan displays advertising.</p><p>Reddit posts (like the one in question) damage businesses like mine and in a roundabout way hurt Ethereum.</p><p>As a result of EthTools.com having been reported to Google, it is no longer the top search result for ‘Ropsten Faucet’. Fewer developers looking to get Ether to test their dApps will be able to do so.</p><p>What annoys me most is that <a href="https://www.reddit.com/user/TaxExempt">the user</a> that created the post made no effort to reach out to us through our contact form to check his/her facts. Nor did the individual who added it to the phishing list or any of the people who replied to the post.</p><p>I <strong>do</strong> appreciate the need to move quickly in certain circumstances so as to keep people safe but this was not one of those situations.</p><p>Then there is also the main argument of the post: <em>“If you give them you private ropsten keys and use the same one on the main net, they will steal your ether”</em>. If you are using the same address on Ropsten as you are on the main network please stop, read some more about security, and never do such a foolish thing ever again.</p><h3>Thoughts</h3><p>Whilst I still maintain my view that Ethereum has the potential to be world changing technology I am happy to engage and debate with people who hold different views. I like to have a complete view of the picture.</p><p>Over the past year I have noted some interesting things.</p><ul><li>There are still no killer apps on <strong>any</strong> blockchain.</li><li>Each blockchain has a powerful toxic section of their respective community.</li><li>No blockchain is in my opinion worth the apparent paper valuations.</li></ul><p>Another interesting point is the lack of integrated client diversity. There were always the arguments/discussions about having multiple implementations of the Ethereum virtual machine was a good thing yet there is no similar concern for products interfacing with the blockchain.</p><p><a href="https://www.myetherwallet.com/">MyEtherWallet</a>, <a href="https://metamask.io/">Metamask</a>, and <a href="http://truffleframework.com/">Truffle</a> are absolutely fantastic products doing their respective things but they are also your only choices.</p><p>Again I absolutely acknowledge the need for security education and for helping people keep their assets safe but perhaps it would be better to tell people that if they do not understand what they are doing then they should not be doing it at all.</p><p>If you lose money because you <strong>actually</strong> gave someone your private key then perhaps you should not have been doing what you were doing. In the same way you wouldn’t try and do <em>insert almost anything here</em> if you did not understand it.</p><h3>Moving forward</h3><p>As mentioned above the incentives for me to run EthTools.com do not align well with the approaches and attitudes of a developing (and changing) community. The product is in no way profitable at this point in time. We have spent thousands of dollars building and maintaining the tooling that we offer and situations like this make me believe that we may not be able to run the site as a business.</p><p>I am in the process of doing some very complex behind the scenes restructuring such that we can improve and optimise the tooling but also so we can provide some complex data analytics services to some interesting potential clients.</p><p>The long and the short of it is that seemingly the target market for the product is <strong>not</strong> the ‘community’ and as such we will be reconsidering the public offering of the product.</p><p><a href="https://twitter.com/5chdn/status/940611500250714113">Afri</a> (in relation to the proposals for releasing the locked Parity funds) seemed similarly disgruntled with the effects of our changing community. So does Vitalik.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/609/0*6WPMXemWEm8W59hJ.png" /></figure><p><em>Originally published at </em><a href="https://thomasclowes.com/psa-speculation-is-toxic/"><em>thomasclowes.com</em></a><em> on January 6, 2018.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=fbf2be13d5db" width="1" height="1" alt=""><hr><p><a href="https://medium.com/ethtools/psa-speculation-is-toxic-fbf2be13d5db">PSA: Speculation is toxic</a> was originally published in <a href="https://medium.com/ethtools">EthTools</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Ethereum Live. Visualising the Ethereum blockchain.]]></title>
            <link>https://medium.com/ethtools/ethereum-live-visualising-the-ethereum-blockchain-9ce78a1f746a?source=rss----22e5e2b8e046---4</link>
            <guid isPermaLink="false">https://medium.com/p/9ce78a1f746a</guid>
            <category><![CDATA[visualization]]></category>
            <category><![CDATA[js]]></category>
            <category><![CDATA[javascript]]></category>
            <category><![CDATA[ethereum]]></category>
            <category><![CDATA[ethtools]]></category>
            <dc:creator><![CDATA[Thomas Clowes]]></dc:creator>
            <pubDate>Sat, 25 Nov 2017 17:49:06 GMT</pubDate>
            <atom:updated>2017-11-25T17:49:06.005Z</atom:updated>
            <content:encoded><![CDATA[<p>One of <a href="http://doublenegative.com/">Double Negative’s</a> products is <a href="https://ethtools.com/">EthTools.com</a>, a website which provides a number of tools for interacting with the Ethereum blockchain.</p><p>I have recently been playing around with <a href="https://d3js.org/">D3.js</a> a visualisation library written is Javascript. It hit me that visualising the Ethereum blockchain would be incredibly cool and would allow for a better understanding of how the blockchain is being utilised. As blockchain becomes more prominent it is my view that analytical tools for working with the chain will become increasingly important.</p><p>D3.js is not a simple library to work with. It is as simple as it could be but given what it does it neccesitates a certain level of complexity. When playing with new libraries I tend to not read documentation and simply dive in. I would suggest that with D3.js you read the documentation first :)</p><p>The result of my playing is <a href="https://ethtools.com/mainnet/chain/transactions/live/">Ethereum Live</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*53aHn453OJVKeFjH.png" /></figure><p>Ethereum Live allows you to visualise transactions that have been mined on the Ethereum blockchain in real time (ish). Whilst developing the tool there were a number of engineering hurdles that I had to jump through mainly pertaining to the efficient loading of large amounts of data in near real time from the blockchain. During this process it hit me that without some enterprise level infrastructure loading <strong>all</strong> transactions in real time would be nigh on impossible. Even then.. I suspect that browsers simply could not handle the overhead associated with showing <strong>all</strong> transactions as they happen even with a well optimised library like D3.</p><p>The problem is that Ethereum is <strong>too</strong> popular.</p><p>I recently saw the below infographic on Twitter. It almost certainly needs to be taken with a pinch of salt (as it is being shared by speculators), but the general point stands. Lots of transactions.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*7Xd91j-a8dBNbJ7C.png" /></figure><p>Large scale usage and short block times mean that hundreds of transactions are being mined every minute. This will only increase.</p><p>Even if we could show them all in real time I suspect that the resulting graph would be of little use. It would be too crowded.</p><p>Instead I opted for a live graph with delayed loading.</p><ul><li>10 transactions will be loaded at a time that have been mined from the point at which you load the page.</li><li>If you are logged into your EthTools.com account, 10 further transactions will be loaded every <strong>5 seconds</strong>. If you are not logged in every <strong>20 seconds</strong>.</li><li>At any point you can click ‘Load more’ to.. load more.</li><li>At all points we detail how many transactions have been mined since that <strong>are not</strong> displayed (yet).</li></ul><p>This setup is to attempt to provide a useful tool which provides insight whilst not destroying our servers. We are absolutely open to suggestions on how this can be improved/optimised to provide the most value to you.</p><h3>Features</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*U1Dje8I5KZujL1bj.png" /></figure><ul><li>You can click a node to see details of the address.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*jOWlZJm97iEaoztE.png" /></figure><ul><li>You can click a a transaction (or internal transaction) line to see transaction details.</li><li>You can toggle the graph ‘type’ such that the color of the transaction lines visually represent the value of the transaction, the amount of gas used, or the gas price. You can easily see if most transactions are for 0.01 Ether or 1,000 Ether.</li><li>You can discern between contract transactions and value transfer transactions, and you can show/hide internal transactions.</li></ul><p>Whilst the code and the backend to power this tooling is fairly complex the actual end product is actually fairly simple. Simple but powerful. I think it provides a huge amount of insight.</p><p>It seemed only logical to utilise the same tooling to provide some additional visual functionality. As such you can now see a visual representation of transactions mined in a specific block as well as those sent/received by a specific address.</p><p>These graphs can be accessed from:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*HZLraud3GP0ldOtW.png" /></figure><ul><li>The individual block transactions page (for example <a href="http://ethtools.mac/mainnet/chain/block/4620652/transactions/">here</a>).</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*aiPhqcyomYarvyUb.png" /></figure><ul><li>The individual address/contract page (for example <a href="http://ethtools.mac/mainnet/chain/address/0xb825194ca1fba3f9b7b6f4af55448f50bc66ac2b/">here</a>).</li></ul><p><a href="http://ethtools.mac/mainnet/information/contact-us/">Contact us</a> if you have any comments or suggestions for further development. You can also follow <a href="https://twitter.com/ethtools/">EthTools</a> on Twitter or my <a href="https://twitter.com/GUA">personal account</a>.</p><p><em>Originally published at </em><a href="https://thomasclowes.com/ethereum-live-visualising-the-ethereum-blockchain/"><em>thomasclowes.com</em></a><em> on November 25, 2017.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9ce78a1f746a" width="1" height="1" alt=""><hr><p><a href="https://medium.com/ethtools/ethereum-live-visualising-the-ethereum-blockchain-9ce78a1f746a">Ethereum Live. Visualising the Ethereum blockchain.</a> was originally published in <a href="https://medium.com/ethtools">EthTools</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Why/How I built EthTools.com]]></title>
            <link>https://medium.com/ethtools/why-how-i-built-ethtools-com-97c276d7a839?source=rss----22e5e2b8e046---4</link>
            <guid isPermaLink="false">https://medium.com/p/97c276d7a839</guid>
            <category><![CDATA[blockchain]]></category>
            <category><![CDATA[en]]></category>
            <category><![CDATA[ethereum]]></category>
            <category><![CDATA[ethtools]]></category>
            <category><![CDATA[ether]]></category>
            <dc:creator><![CDATA[Thomas Clowes]]></dc:creator>
            <pubDate>Fri, 11 Aug 2017 17:05:29 GMT</pubDate>
            <atom:updated>2017-08-11T17:05:29.297Z</atom:updated>
            <content:encoded><![CDATA[<p>The problem that many users have with Ethereum (in its current form) is that whilst its value proposition is clear it is oftentimes difficult for individuals coming from a non-technical background to use.</p><p>There may be awesome products and tools being developed on the platform but that is of no use if one cannot actually <em>use</em> those tools.</p><p>Having been aware of Ethereum since mid 2015 I have been able to watch its development, and the influx of interest that has resulted. I felt that I should do my bit, and thus in late 2016 set out to build <a href="http://ethtools.com/">EthTools.com</a></p><p>As with any new technology I started out by learning what it does, and how it works. I noted that ‘wallets’ are pretty important, and as such went about building functionality to <a href="https://ethtools.com/mainnet/wallet/create/">create</a> or <a href="https://ethtools.com/mainnet/wallet/load/">load</a> an Ethereum wallet. My knowledge seeking adventure resulted in a primitive attempt at building an index of the Ethereum blockchain, and then the <a href="https://ens.domains/">Ethereum Name Service</a> popped up on my radar.</p><p>Having a background in what I will refer to as the ‘<em>traditional domain name industry</em>’ the Ethereum Name Service was an extremely interesting addition to the already promising technological potential of the Ethereum network. I wanted to build tools for interacting with the ENS. The fact that I have a degree in Economics made the theoretical (auction theory) Economics behind the ENS registrar contract even more enticing an area of study.</p><p>I built some tooling for the ENS, and released it. The service was overwhelmed with users, but unfortunately (despite my best efforts) many of them struggled to use the tools.</p><p>The most interesting aspect of Economic theory (in my opinion) has always been rationality. Many concepts assume human rationality. It became apparent to me that as well as not necessarily being rational, human beings are often times not sensical. I had created a tool for interacting with something new, and some people were using it with absolutely no understanding of how ‘it’ worked, and what it did.</p><p>“<em>Have you revealed your bid?</em>” I replied to one of the hundreds of incoming support requests. “<em>What is that?</em>” was the response.</p><p>Another expletive filled email demanded that I returned the users ‘stolen’ funds. Needless to say, no funds had been stolen (<a href="http://ethtools.com/">EthTools.com</a> is an interface to the Ethereum blockchain — we never see/touch/hold your funds in any capacity).</p><p>A further email ended in me querying if the user even knew what Ethereum was. I try not to be provocative, but the way the thread was going I was genuinely not sure.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*SqM9SCwmXyagKrBG.png" /></figure><p>It hit me that making interacting with the Ethereum blockchain (reasonable) user friendly was going to be tough, and that making it (unreasonable) user friendly was impossible.</p><p>There is oftentimes not widespread knowledge of new technology. When there is it tends to be news reports about how ‘Ransomware destroys world’. It intrigues me what would happen if there were to be a 15 minute segment on mainstream TV where someone sought to explain Ethereum in layman’s terms.</p><h3>Infrastructure</h3><p>To provide functionality for interacting with the Ethereum Name Service it became apparent that a well designed index of the Ethereum block chain would need to be developed. <a href="https://ethtools.com/mainnet/chain/blocks/">Blocks</a> are being mined all day every day, and these blocks contain the <a href="https://ethtools.com/mainnet/chain/transactions/">transactions</a> that users are executing through <a href="http://ethtools.com/">EthTools.com</a> as well as other services.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*3PqzO214UC_9k5Ku.png" /></figure><p>When a user starts an auction or bids for a domain name on <a href="http://ethtools.com/">EthTools.com</a>, they are submitting a transaction to the Ethereum block chain. By developing a well functioning index of the chain, we can build user interfaces and experiences which make interacting with the chain easier. For example when you submit a bid you want to know if you bid was successfully submitted and if the function call executed successfully without error.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*XkNjpRL8euWCavDb.png" /></figure><p>There has been a whole ‘<em>period</em>’ of recent Internet history whereby developers have focussed their time and energy on making everything quick and pretty. Ethereum dapps (given the nature of blockchain) can not be quick and pretty. After all, when I want to bid on an ENS name what I am really doing is telling thousands of computers around the world that I want to bid on a name.</p><p>The uneducated or those with nefarious intention will exclaim that Ethereum therefore sucks. It is distressing that human nature prevents the logical comeback of “<em>You have missed the point</em>” from resonating.</p><h3>Some tech</h3><p>Developing an index of the blockchain is not easy. Depending on your settings a Geth or Parity node which fully synchronises the Ethereum chain requires many gigabytes of storage space. As the chain grows, this will obviously increase. We however need an index of the chain that is searchable. If someone wants to see information about <a href="https://ethtools.com/mainnet/chain/block/1234567/">Block 1234567</a>, we need to be able to search for it and display it quickly.</p><p>With <strong>4 million</strong> blocks in the chain this becomes quite a challenge. As you can imagine, searching a database of 4 million records could take quite a bit of time. Fortunately computer processors and software offerings are extremely impressive in the modern day and age. SQL based databases such as mySQL can index the block number (in this case), and allow a search of this nature to return in a matter of milliseconds.</p><p>Sadly, this is the least of our worries. In each of those blocks are.. transactions. In these initial 4 million blocks, there are over <strong>30 million</strong> transactions. It gets worse. Each of those transactions is made up of ‘steps’ — a transaction executes a number of steps on the Ethereum Virtual Machine. There have been over <strong>200 million internal transaction steps</strong>. It is not quite so quick to search through that many rows. It is especially slow to execute complex queries such as searching for all transactions to/from a given address.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*WWSQNOJ_7baxR84u.png" /></figure><p>In my initial setup, searching for all transactions to the ENS Registrar contract took 40 seconds. Not only that, it put a lot of stress on our server resources <strong>and</strong> blocked other queries from being executed. I.E. If someone was ‘exploring’ the registrar contract, no-one else could do anything on the <a href="http://ethtools.com/">EthTools.com</a> website. We would like to scale to more than one concurrent user :)</p><p>The first thing that I noticed involves the mySQL query cache. When initially exploring ways of improving query speeds I tried disabling the query cache. It sped up my queries by a <strong>factor of ten</strong>. This was bemusing as one would assume that a cache would speed things up. It turns out that as I was indexing the chain (constant DB writes) I was causing my cache to be constantly invalidated. This was resulting in access issues due to serialisation of requests. More can be read about this <a href="https://www.percona.com/blog/2015/08/07/mysql-query-cache-worst-enemy-best-friend/">here</a>.</p><p>In mySQL “<a href="https://dev.mysql.com/doc/refman/5.7/en/create-index.html"><em>index values are always stored in ascending order</em></a>”. What I found was that it was more common for people to be interested in more recently executed transactions. This meant that if someone was searching for transactions at the head of the chain, even using an index mySQL would have to sort the results in the reverse direction prior to looking for the results required. This made things slower than necessary. Given mySQLs index order constraints there was a somewhat strange resolution to this — we store the block number associated with a transaction as a negative number. Block 123456 is stored as -123456 such that the results of these more common queries do not have to be sorted. This also improved query times by a <strong>factor of ten</strong>.</p><p>Unfortunately as we processed more and more transactions I noticed that getting transactions to/from the ENS Registrar contract was still too slow. We managed to resolve this with a mapping table, some appropriate indexes, and database <a href="https://dev.mysql.com/doc/refman/5.7/en/partitioning.html">partitioning</a>.</p><p>The mapping table maps addresses to transaction IDs independent of whether the transaction was to/from that address. We no longer need to search combined indexes. Instead we find all rows for a given address, and then load the transactions with the specific IDs that we have found. This is quick.</p><p>Partitioning allows you to behind the scenes split your database table into multiple database tables. You can split a table such that rows with ID 1–1000 are in partition 1, 1001–2000 in partition 2 etc. The benefit of that is that rather than searching the whole table mySQL can optimise knowing that it only needs to search partition A.</p><p>The result..? Well, <a href="https://ethtools.com/mainnet/chain/contract/0x6090a6e47849629b7245dfa1ca21d94cd15878ef/">this</a> is the ENS Registrar contract. It should load quickly.</p><h3>How interesting</h3><p>When I decided to build <a href="http://ethtools.com/">EthTools.com</a> I was interested in investigating new technology. Perversely I learned a lot about old technology (as well).<br> I have spent a lot of time trying to build useful functionality that serves a purpose. I have opted to do less, but hopefully do it better.</p><h3>The functionality</h3><p>So <a href="https://ethtools.com/">EthTools.com</a> offers:</p><ul><li>A fully featured and optimised <a href="https://ethtools.com/mainnet/chain/">blockchain explorer</a>.</li><li>Wallet tools for <a href="https://ethtools.com/mainnet/wallet/create/">creating</a> and <a href="https://ethtools.com/mainnet/wallet/load/">loading</a> a wallet generated by <a href="http://ethtools.com/">EthTools.com</a> as well as any wallets generated by number of other tools.</li><li>Tooling for <a href="https://ethtools.com/mainnet/ens/register/">registering</a> domain names with the Ethereum Name Service — starting an auction, bidding, revealing, and finalizing your bid.</li><li>Tooling for <a href="https://ethtools.com/mainnet/ens/your-domains/">managing domain names</a> registered through the ENS — setting resolver contracts, setting resolution addresses, and changing ownership.</li><li>An ENS <a href="https://ethtools.com/mainnet/ens/whois/">whois</a> service, and a log of all <a href="https://ethtools.com/mainnet/ens/events/">ENS events</a>.</li><li>Tooling for <a href="https://ethtools.com/mainnet/chain/contract/submit/">submitting</a> and <a href="https://ethtools.com/mainnet/chain/contract/0x92e79ae1c2f9bf8cee054fa472fbda2bf00905a8/verify/">verifying</a> contracts on the Ethereum blockchain.</li><li>Tooling for <a href="https://ethtools.com/mainnet/chain/contract/0x6090a6e47849629b7245dfa1ca21d94cd15878ef/interact/">interacting</a> with any deployed and verified contract.</li></ul><h3>Contracts !</h3><p>One of the killer features of Ethereum is that you can write and deploy smart contracts.</p><p>One of the killer features of <a href="http://ethtools.com/">EthTools.com</a> (in my opinion) is that you can interact with <strong>any</strong> deployed and verified contract on the blockchain. That is to say we provide an interface for all verified contracts.</p><p>I think this is cool enough that I gave it its own section.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*5uJZKkQhSBBtAiHF.png" /></figure><h3>Move quickly. Break things.</h3><p>I do not have a big team behind me and/or any kind of funding. I built <a href="http://ethtools.com/">EthTools.com</a> because I am aware of Ethereum’s potential to change the technological landscape moving forward.</p><p>If you encounter any bugs, or have any suggestions please <a href="https://ethtools.com/mainnet/information/contact-us/">let me know</a>.<br> When I first released our tooling for the ENS I was overwhelmed with requests for support. Given that <a href="http://ethtools.com/">EthTools.com</a> is available to users free of charge I am unable to guarantee personalised support. In light of this, I have set up the <a href="http://community.ethtools.com/">EthTools.com community</a> — a discussion forum where I will post guidance to commonly asked questions.</p><p>In addition to this I hope that other individuals interested in Ethereum and <a href="http://ethtools.com/">EthTools.com</a> will join the site and join the conversation. Shared support, technological discussion, and community are pretty great.</p><p><em>Originally published at </em><a href="https://thomasclowes.com/why-how-i-built-ethtools-com/"><em>thomasclowes.com</em></a><em> on August 1, 2017.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=97c276d7a839" width="1" height="1" alt=""><hr><p><a href="https://medium.com/ethtools/why-how-i-built-ethtools-com-97c276d7a839">Why/How I built EthTools.com</a> was originally published in <a href="https://medium.com/ethtools">EthTools</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Interacting with the Ethereum blockchain using EthTools.com (in VIDEOS !)]]></title>
            <link>https://medium.com/ethtools/interacting-with-the-ethereum-blockchain-using-ethtools-com-in-videos-5223c01502d?source=rss----22e5e2b8e046---4</link>
            <guid isPermaLink="false">https://medium.com/p/5223c01502d</guid>
            <category><![CDATA[ethtools]]></category>
            <category><![CDATA[en]]></category>
            <category><![CDATA[ethereum]]></category>
            <category><![CDATA[blockchain]]></category>
            <dc:creator><![CDATA[Thomas Clowes]]></dc:creator>
            <pubDate>Fri, 11 Aug 2017 17:02:37 GMT</pubDate>
            <atom:updated>2017-08-11T17:00:14.456Z</atom:updated>
            <content:encoded><![CDATA[<p>I have written a number of blog posts about Ethereum, the process of developing <a href="https://ethtools.com/">EthTools.com</a>, the reasoning behind it, and the features of the product.</p><p>Take a look:</p><ul><li><a href="https://thomasclowes.com/ethereum-security-and-wallets/">Ethereum — Security and wallets</a></li><li><a href="https://thomasclowes.com/ethtools-com-tools-for-ethereum/">EthTools.com — Tools for Ethereum</a></li><li><a href="https://thomasclowes.com/ethereum-contract-deployment-and-interaction/">Ethereum contract deployment and interaction</a></li><li><a href="https://thomasclowes.com/verifying-an-ethereum-signature-on-the-server-php/">Verifying an Ethereum signature on the server — PHP</a></li><li><a href="https://thomasclowes.com/ethereum-name-service-ens-integration/">Ethereum Name Service (ENS) Integration</a></li><li><a href="https://thomasclowes.com/why-how-i-built-ethtools-com/">EthTools.com — Why and how</a></li></ul><p>It struck me that I can write endlessly about what I have built, but sometimes words simply are not enough. They say a picture is worth a thousand words. What about a video?</p><p>I have gone ahead and produced a number of videos outlining how to use <a href="http://ethtools.com/">EthTools.com</a>. I am no professional videographer, but I believe they do their job — show new users (step by step) how to do things using the product.<br>The thumbnails also appropriately exhibit the extreme variety of facial expressions that I can produce.</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FZ8FMP8K1Oj8%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DZ8FMP8K1Oj8&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FZ8FMP8K1Oj8%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/53c4f5f17b4b383d40ba2c47d7d5d261/href">https://medium.com/media/53c4f5f17b4b383d40ba2c47d7d5d261/href</a></iframe><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FcCGYEd8tHCE%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DcCGYEd8tHCE&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FcCGYEd8tHCE%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/9f6eb12361a0e8f67f31e6a8146b3c28/href">https://medium.com/media/9f6eb12361a0e8f67f31e6a8146b3c28/href</a></iframe><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2F3fyP9GFSEWI%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D3fyP9GFSEWI&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2F3fyP9GFSEWI%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/8bac8ed78302cbd8da06a29f1a6f8c30/href">https://medium.com/media/8bac8ed78302cbd8da06a29f1a6f8c30/href</a></iframe><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FVoxxZD9afpk%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DVoxxZD9afpk&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FVoxxZD9afpk%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/e38373f18edfecbffd56a39b3fcf91a5/href">https://medium.com/media/e38373f18edfecbffd56a39b3fcf91a5/href</a></iframe><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fagw-UO-DLis%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dagw-UO-DLis&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fagw-UO-DLis%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/22d072e2e6f553333fef1133e5eed594/href">https://medium.com/media/22d072e2e6f553333fef1133e5eed594/href</a></iframe><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FniOmxq1drKU%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DniOmxq1drKU&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FniOmxq1drKU%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/3943a7ca519bd74785329080ca75d86a/href">https://medium.com/media/3943a7ca519bd74785329080ca75d86a/href</a></iframe><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FzkjXsFbvDGw%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DzkjXsFbvDGw&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FzkjXsFbvDGw%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/b68a5fe20b2b3d12753c5615726e6996/href">https://medium.com/media/b68a5fe20b2b3d12753c5615726e6996/href</a></iframe><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FQkNhLW5l8hU%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DQkNhLW5l8hU&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FQkNhLW5l8hU%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/e39b49f58a6dc7753ba61d3cea4450f8/href">https://medium.com/media/e39b49f58a6dc7753ba61d3cea4450f8/href</a></iframe><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FnnZBOaTmDm8%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DnnZBOaTmDm8&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FnnZBOaTmDm8%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/2eaede176995521f4b30593998df0f1f/href">https://medium.com/media/2eaede176995521f4b30593998df0f1f/href</a></iframe><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2F_7KvrCrbEKg%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D_7KvrCrbEKg&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2F_7KvrCrbEKg%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/4dda74ef5c7a5c3212f459266e85697e/href">https://medium.com/media/4dda74ef5c7a5c3212f459266e85697e/href</a></iframe><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FzodjfNkcYnw%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DzodjfNkcYnw&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FzodjfNkcYnw%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/048b33640ce4e8df4ec9ab3dab0fca4b/href">https://medium.com/media/048b33640ce4e8df4ec9ab3dab0fca4b/href</a></iframe><p>If people like these videos I will go ahead and produce some more. Let me know what you would like to see.</p><p>If you still have issues using <a href="http://ethtools.com/">EthTools.com</a> functionality, or have a question/query/suggestion, please head over to the <a href="http://community.ethtools.com/">EthTools.com community</a>.</p><p><em>Originally published at </em><a href="https://thomasclowes.com/interacting-with-the-ethereum-blockchain-using-ethtools-com-in-videos/"><em>thomasclowes.com</em></a><em> on August 11, 2017.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5223c01502d" width="1" height="1" alt=""><hr><p><a href="https://medium.com/ethtools/interacting-with-the-ethereum-blockchain-using-ethtools-com-in-videos-5223c01502d">Interacting with the Ethereum blockchain using EthTools.com (in VIDEOS !)</a> was originally published in <a href="https://medium.com/ethtools">EthTools</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>