My publication series I will turn into a book

Photo by Aziz Acharki on Unsplash

I don’t have nearly enough life experience to pass on complete wisdom, but I do believe I’ve built up a strong foundation of mental frameworks through my experience in dance, finance, data, and crypto.

When I was 5, I wanted to be an astronaut. At 10, a biologist. At 13, a bodybuilder. By 17, a psychologist. Approaching 19, a Nobel prize-winning economist. Around 20, on a trading desk. Recently at 22, a data scientist. Right now, I want to make sure I write at least two books in the course of my life.

What changed? My methodology behind discovery and…

Trade with gas efficiency!

This was first published on substack, make sure to follow 0xkowloon for more protocol deep dives.

Balancer protocol is an automated portfolio manager, liquidity provider and price sensor. Liquidity providers who want to earn trading fees and rebalance their portfolios can deposit their assets into a balancer pool. Arbitrageurs help liquidity providers to rebalance their portfolios by trading against the pools’ assets.

Contrary to Uniswap, which only holds two tokens in each pool, a balancer pool can hold up to eight tokens. A pool’s underlying token weights and trading fees are set when it is initialized. The pool’s weights are…

Understand the history of Ethereum wallets, what Access Legos are, and the implications of both on the future of dapp development and usability.

I’ve talked about product composability of decentralized applications (dapps) before, but with a fairly simplified diagram of the tech stack:

In reality, there are two layers I skipped (wallets and SDKs) and some added complexity with multi-chain (layer) dapps:

Stop trying to approach people on LinkedIn; you need to understand the structure of content, conversation, and community.

Asking people about networking looks like this. It all sounds like common sense, but most people have a chaotic or non-actionable approach to it. Let me try and help you make it more organized and actionable.

Networking is an exciting topic that has changed wildly over the years, especially during Covid-19. It used to mean getting someone’s business card, then in the digital world, that card became represented by a connection or a follow.

We’ve distilled networking down so much that having a point or signifier of contact seems good enough — but that won’t cut it anymore.

Networking is an iterative process where we slowly develop our own approach, but general frameworks make learning the process easier. …

Photo by israel palacio on Unsplash

Hands-On Tutorials

Let’s make your queries more efficient and readable, and also help you understand decentralized exchanges like Uniswap on Ethereum.

If you’ve missed part one of the basics of SQL and Ethereum, be sure to read that first. On the SQL side, today we’ll cover these slightly harder topics:

  1. Common Table Expressions (CTEs)
  2. Self joins
  3. Window functions like PARTITION, LEAD, LAG, NTILE
  4. Use of indexes in querying to make operations faster.
  5. Subqueries and the impact of subqueries on the efficiency of the query

On the Ethereum side, last time we learned about lending pools and collateralized debt positions. This time, I’m going to introduce you to a decentralized exchange (DEX) — think of this as a foreign exchange where you…

Photo by NASA on Unsplash

Overlaying a digital world right on top of our physical one has historically been difficult due to GPS inaccuracy and localization.

An intro to Augmented Reality

Broadly speaking, there are two types of augmented reality (AR) created and subsequently used by everyday consumers.

The first type is AR which detects objects in your vicinity to spawn digital objects/world from. This can be anything from plane detection to image targets, where you’ve set parameters on how game objects can be spawned after detection criteria are met.

Photo by Gia Oris on Unsplash

Hands-On Tutorials

Turns out Ethereum can be an amazing relational database to learn and practice SQL queries off of!

Ethereum is easier to understand when you learn how data is stored and managed on smart contracts, and SQL is easier to learn when you have more than just the simple two or three basic data tables to query off of.

By the end of this article, you’ll understand the basics of Ethereum, as well as the following SQL functions:

  • JOIN
  • Time conversions/parsing (DATE_TRUNC, Interval)

I’ll be doing an intermediate and advanced SQL/Ethereum guide as well, so be sure to follow me if you’re…

This is a non-technical intro to crypto products and community alignment, not an explainer of the new technology or its asset valuations.

A Lego community, it’ll make more sense later. (Photo by James Orr on Unsplash)

I know the article title is a very strong statement to lead with, but over the last few years I have witnessed and personally experienced how building products and businesses in crypto (namely on Ethereum) is unlike anything else I’ve ever seen. Technically, decentralized applications (dApps) or decentralized finance (DeFi) are the best examples of everything I’m going to discuss — otherwise called Web 3.0. Don’t worry if you have no idea what that is, I’ll build up to it in a non-technical fashion.

Also, my point here is not to say crypto is perfect (it’s still far from it)…

Web Scraping and Data Visualization

Basic web scraping with Selenium and BeautifulSoup4 to identify trends in how Bridgewater is investing.

I’m sure I’m not the first to tell you this, but there is a treasure trove of data online for you to use to help answer any questions you might have. For example, what if we were curious how some of the smartest minds in Finance were navigating the last ten years of equity markets in the U.S.? Bridgewater is a perfect example of this, and luckily for us they are mandated to publicly document the name and size of their holdings in a quarterly SEC report dubbed 13F-HR.

The Securities and Exchange Commission’s (SEC) Form 13F is a quarterly…

Chainlink on Ethereum

In this article, I will cover how my team set up dog walking data on MongoDB Atlas, exposed a GraphQL authenticated endpoint with Realm, and created a Chainlink External Adapter to get that data onto Ethereum Smart Contracts.

Photo by Feifei Peng on Unsplash

Last week, my team finished developing and submitting our MarketMake 2021 product FidoByte — a tokenized shelter-dog walking protocol. One of the most difficult parts of this project was figuring out how to manage a flexible database both on and off chain.

In this article, I want to show how data flows through our project and how you can replicate the same architecture.

Andrew Hong

Trying to provide some structure to our world. @andrewhong5297 on twitter and github,

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