flipside

    Try Quests to earn SOLTry Quests to earn SOL
    Share

    Unique Solana Programs

    • Q92. One way to track developer growth in an ecosystem is through the number of unique contracts used. Create a visualization of the number of unique programs used per day since the beginning of January.

    • What type of programs are the most popular, and what programs seem to be gaining in popularity over that timeframe? Does it appear that development is still ongoing in the bear market?

    \n

    Introduction

    • Solana tools allow developers to deploy on-chain programs “smart contracts”
    • Once a Program is deployed, anyone can execute the program.
    • These programs take advantage of the higher speed, efficiency and low cost of the Solana Network.

    Methodology

    Using Flipside data bank tables of Solana: solana.core.fact_events

    • With Count Distinct , to get the daily amount of unique programs used, and “Succeeded” column to filte.
    • With Count, to get the total amount of each program used in a certain timelapse.

    Wrapped Solana By Pinesheart query from flipside discord.

    First successful interaction query by Ponch (Nebychiquito)

    Analysis

    • In 2022 the daily amount of Unique Programs used in Solana has increased, in the average day of January the total unique programs used were below 500, then in February achieved 600, and the count only increases, where, in may 5 reach the 1000 mark of unique programs used.
    • Nowadays the average day has between 950-1100 unique programs used, although July 5 only 842 unique programs were used with only 835 with the success state.
    • Every day a subtle amount of unique programs fail.
    • Serum Dex Program V3 is the most popular program used in 2022 followed by Mango Dex Program, which is the expected, because users trade in these marketplaces every day and the third program is the Solana System Program.
    • The top 10 program only includes successful transactions, because in solana a lot of programs calls fail, one example of this is the following contract: JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo known as Jupiter Aggregator v2 this program is really popular and had a explosive usage on the Luna crash event, from may 9 to may 12, after that still remains as a popular choice but only a small portion of the transactions calls are acepted, thats why this contract doesn’t appear in the top 10.
    • Serum starts 2022 as the most daily popular program with successful transactions, but after April Mango becomes the daily preference, is only a matter of time until Mango becomes the most popular program with successful transactions, although activity usage of Serum has risen recently.
    • Wrapped Solana price has decreased all this year, but the unique program activity of solana has increased compared to the beginning of 2022, there is a lot of failed transactions too, like jupiter, but still, a lot of successful transactions remains nowadays.
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    Summary

    • Decentralized exchanges (DEX) programs are the most “successful” popular programs in Solana.
    • Mango DEX has gained more popularity in this year, closing the gap with Serum DEX.
    • DEX aggregators like Jupiter are also popular with a lot of activity in the month of May onwards, although only a small percent of their total transactions are successful.
    • Wrapped Solana price has been in the bear market all this year, but there is more unique programs used nowadays, Mango and Serum activity has been stable but other activity programs such as Jupiter has dropped in July.
    • New Programs activity has a stable growth, development is still going.
    Loading...