Today I join Goldsky as a Principal Software Engineer. Goldsky’s mission is to make it easy to index, process and use blockchain data. This set of tools could become a foundational building block for many Web3 companies. We leverage streaming SQL to make it possible.

Web3? Link to this heading

I’ve never been a crypto, NFT or web3 enthusiast. Quite the opposite, I was (and I am) very skeptical about “web3” as the next iteration of the modern web. I’ve read many critics in this domain:

I’m no expert in this area, but after being briefly exposed to the world of web3 for a few months I can already see that some of the arguments are not that relevant anymore.

Yes, bitcoin is terribly energy inefficient, but have you seen modern proof-of-stake protocols like Polkadot?

Yes, many NFTs could be scams, but I truly believe that NFTs and online gaming may be a great match, as an example (can I show off my legendary World of Warcraft NFT sword in Call of Duty, please?).

Many people claim that web3 doesn’t actually solve any problems, everything can be done with more conventional ways and approaches. I think it’s true for many projects, but I do have a few favourite examples where decentralization provided by blockchain actually makes sense: Helium, Render Network, Arweave. Don’t you agree?

Finally, one of the strongest arguments against web3 is that true decentralization is really hard to achieve. And what we see with the most popular chains is actually centralization in the hands of a few parties. This is a tough one, but it’s not a purely technological one. However, permissionless blockchains are not the only type of blockchains out there…

Permissioned (or private, or “enterprise”) blockchains are not something many critics focus on. As a person who worked in a bookkeeping startup early in my career, I started understanding the importance of distributed immutable ledgers many years ago. Blockchain, as a data structure, provides an elegant implementation for that. Private, permissioned blockchains don’t need to be fully decentralized, so there are no concerns about ownership or performance. But they still provide the same set of features (e.g. smart contracts) and qualities (e.g. auditability). Private, permissioned blockchains also provide Byzantine fault tolerance, which can be important for large enterprises, governments, military, etc.

A badly written and inefficient dApp is easy to criticize. A shady startup stealing crypto from its users is a loud news story. Etc. Etc. It may be easy to dismiss the whole web3 world, but maybe we just don’t see enough successes yet? Blockchain itself is just another tool and we need to understand when and how to apply it. Even if 90% of all web3 products will shut down in the next 2 years I’d be excited to focus on the 10% that survived that might actually be life-changing.

Streaming SQL? Link to this heading

When you start thinking about processing blockchain data, using stream-processing seems like a great idea:

  • Blockchain data is (mostly, more about this next) immutable. It’s easy to persist the whole blockchain in a streaming platform like Apache Kafka.
  • Blockchain reorganization can be formulated as a problem of late-arriving data and retractions.
  • Even the most popular blockchains are not that big when it comes to data size: hundreds of gigabytes or single-digit terabytes. This is easy to handle with modern data tools.
  • Stream-processing provides functionality to perform merging, joins and lookups, aggregation and windowing. Also, stream-processing and, more widely, modern data tools, allow combining on-chain data with off-chain data seamlessly. For example, think about ingesting data from your relational database, joining it with blockchain data, then aggregating and writing to a data lake or data warehouse of your choice.

And I see how SQL becomes a standard for stream-processing right now. There are many big players (Confluent, Materialize) and many young startups (Decodable, Popsink, DataCater, Singularity Data, Tinybird, etc.) who realized that SQL is a perfect language for describing transformations, even complex stateful ones.

Goldsky? Link to this heading

Goldsky is not trying to be a solution to every web3 problem. Instead, we want to provide a solid platform for other companies to use blockchain data. Building high-quality web3 products is hard right now, partially because the tools and practices are so immature. But we see this as a great opportunity.

Finally, we’re hiring 😉. Ping me if you’re interested!