Review: The Billion User Table

our billion user table

Here’s a review and short contribution to the article and challenge on

You can find said article here. Its a short 10 minute read about how a smart contract platform can level the playing field for new startups as user onboarding is now trivial.

Ethereum Login


We take it for granted that we can interact easily with the services that we are used to. Social login allowed countless startups to utilise existing social network activity to onboard new users at the price of giving data to these social network operators.

Enter the world computer, Ethereum. In this case, we took it for granted that we could create an ethereum address and immediately interact with any DApp in the universe. Let’s take a look.

Unique Eth addresses

Ethereum has an incredible dominance in the blockchain space for DApps because of its first mover advantage. This graph has no sign of slowing down. Each address is unique to the user and does not rely on a pact with a social network operator.

Human-readable Addresses


What is this? Nobody can tell simply by looking at the address. Look it up however, and it is immediately evident it is WETH’s contract.


How about this? It works exactly like a typical web address. In fact, you could even customise it to be a vanity address like your_name.eth.

our favourite person

A domain service (Ethereum Name Service in this case) would let users keep a public address that’s more human readable for the rest of us.

Every web application, from the most embryonic MVP all the way up to Google, has a table called users (very few apps might give it a different name) whose job it is to hold the information that lets users log into and use the software — email address or phone number and (encrypted) password are the basic rows you’ll find in this table, but you also find a ton more proprietary data in there and in linked tables.

In this case, the entire Ethereum network is your user table. Stored in what is called a Merkle-Patricia tree.


This would make the state of your addresses immutable because of how the data is stored. Change one hash and the whole tree changes. This prevents horrific situations such as this:


And even worse, this:


Because it is transparent anyone can see how the transactions have flowed.

If anything were to happen to LinkedIn or to its internal assessment of the value of providing public endorsement data on-chain, the public would still have unfettered, permanent access to the old data.

Furthermore, even if any one app goes down, everyone’s data and prior interactions with said app is still safe. Auditors rejoice! You don’t have to trawl through thousand of e-mail like the infamous Enron scandal.


People underestimate the power of a decentralised computing platform. Rather than mangling multiple types of sign-in and sign-on solutions, you can have a single universal solution that is not only secure and tamper-proof but it truly belongs to you.

No need to sell your soul to social network operators to prove that you exist, get yourself verified through apps such as BrightID and voila you’re no longer a bot.




ever curious

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

{UPDATE} Slope Rider Total Hack Free Resources Generator

ARTH 2.0 Beta Testing Results and Rewards

Get NordVPN discount from Storytellers YouTube channel — safety online is cheaper than ever


WSO2 Identity and Access Manager Explores South Korean Market

EasyFi extends collaboration with Tidal to offer Multi-chain user insurance

Host Header Injection Leads To Pre-Account Takeover Worth 100$

China’s Government Agencies & WHO Undergo Cyber-attacks

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Hum Qing Ze

Hum Qing Ze

ever curious

More from Medium

Making life’s harsh realities work for you! Final series

As the search for Dele Giwa’s Assasinators Continue, A Recall of the Import of My slain editors…

Introduction to Mobile Commerce

Dan Ariely on decision making