Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create Table for Soroswap Liqudity Providers #37

Open
4 tasks
esteblock opened this issue Nov 13, 2024 · 51 comments · May be fixed by #46 or #61
Open
4 tasks

Create Table for Soroswap Liqudity Providers #37

esteblock opened this issue Nov 13, 2024 · 51 comments · May be fixed by #46 or #61

Comments

@esteblock
Copy link
Member

esteblock commented Nov 13, 2024

Budget: 300 USD

Guidelines:

Current Situation
At Soroswap we have tables for Router Events, Pairs, and Reserve Changes as you can see in https://github.com/soroswap/zephyr-programs/blob/main/programs/soroswap/zephyr.toml

What we need
We need to have information about our Liquidity Providers. We need their addresses, what pools they are contribution, and how much amount of LP tokens they have, what % of the pool they hold, etc...
In order to achieve this we would like to have a table that will look like

[[tables]]
name = "ssw_providers"

[[tables.columns]]
name = "provider_address" // address of the liquidity provider
col_type = "BYTEA"


[[tables.columns]]
name = "pool_address" // address of the pool
col_type = "BYTEA"

[[tables.columns]]
name = "shares" // amount of LP tokens the provider have
col_type = "BYTEA"
  • Create the table
  • Make the program fill the table
  • Create the tests
  • Check that all works fine
@Michaelkingsdev
Copy link

Michaelkingsdev commented Nov 13, 2024

I would be glad if this issue is assigned to me @esteblock

@Benjtalkshow
Copy link

Can i take this?

@0xdevcollins
Copy link

0xdevcollins commented Nov 13, 2024

I can handle this @esteblock

@mimisavage
Copy link

Can I be assigned to this

@esteblock
Copy link
Member Author

@Benjtalkshow please open draft PR today with something to see if you can do this

@Benjtalkshow
Copy link

Alright sir. Working on it

@Trustpad-web
Copy link

I would like to work with you

@esteblock
Copy link
Member Author

Unasigning @Benjtalkshow as PR #38 was abaondoned

@0xdevcollins
Copy link

@esteblock please can I take this up?

@Benjtalkshow
Copy link

Unasigning @Benjtalkshow as PR #38 was abaondoned

Alright sir. I didn’t abandon it anyways . I was hooked with ODHack-10. Sorry for the delay.

@esteblock
Copy link
Member Author

The issue is still available, Please lets continue over https://github.com/soroswap/zephyr-programs/pull/38/files
When its finished I will send rewards to @Benjtalkshow

@esteblock esteblock changed the title Budget 300 USD: Create Table for Soroswap Liqudity Providers Create Table for Soroswap Liqudity Providers Dec 6, 2024
@Benjtalkshow
Copy link

The issue is still available, Please lets continue over https://github.com/soroswap/zephyr-programs/pull/38/files

When its finished I will send rewards to @Benjtalkshow

Will make PR soon. I am currently running the test cases.

@Benjtalkshow Benjtalkshow linked a pull request Dec 6, 2024 that will close this issue
@Benjtalkshow
Copy link

The issue is still available, Please lets continue over https://github.com/soroswap/zephyr-programs/pull/38/files When its finished I will send rewards to @Benjtalkshow

Oops. Didn't notice i was unassigned. Just made a PR though. Have been battling with running tests.

@Benjtalkshow
Copy link

The issue is still available, Please lets continue over https://github.com/soroswap/zephyr-programs/pull/38/files When its finished I will send rewards to @Benjtalkshow

Oops. Didnt notice i was unassigned. Just made a PR though. Have been battling with running tests.

@kallis312
Copy link

I'd love to give this a go.

@DuendexCR
Copy link

Can I take this from here?

@Kom02
Copy link

Kom02 commented Dec 12, 2024

Hi, I’m Kevin Obando Molina, a full-stack software developer with 2 years of experience. I have worked with languages such as Java, JavaScript, TypeScript, MySQL, C#, and Python. I’m very interested in working on and learning more about this topic.

@BrunoAmbricca
Copy link

I would like to work on this issue

@Jagadeeshftw
Copy link

Hi @esteblock , I’d love to work on this issue as I have strong experience in building and managing APIs, handling server-side operations, and ensuring robust back-end performance. I’ve developed secure and efficient smart contracts, blockchain integrations, and high-performance backend systems.

My approach:

  1. To address this issue, I’ll first create the ssw_providers table with the specified schema.
  2. Next, I’ll implement the logic to populate the table with liquidity provider data.
  3. Finally, I’ll write and execute tests to ensure the data is captured and displayed accurately.

and If assigned, I’ll ensure that I deliver a robust and high-quality PR within 12-24 hours.

@greatest0falltime
Copy link

Hi @esteblock , I’d be thrilled to work on this issue as I have extensive experience in back-end development, including API integration, database optimization, and building scalable server-side solutions.

To solve this:
I’ll create the ssw_providers table with columns for provider address, pool address, and LP token shares.
Update the program logic to populate this table with relevant data.
Perform comprehensive tests to confirm that all functionalities work seamlessly.

ETA:
I expect to have a working solution ready within the next 24 hours. Kindly let me know if I can proceed!

Looking forward to contributing!

@ShantelPeters
Copy link

I’d love to work on this task.

@NueloSE
Copy link

NueloSE commented Dec 13, 2024

Would love to tackle this!

@Dorcas18
Copy link

I’m interested in this one.

@MrRoudyk
Copy link

Is it okay if I take this?

@godekina
Copy link

I would love to handle this issue! @esteblock

@BigBen-7
Copy link

can I fix this?

@Amarjeet325
Copy link

Is this issue still available?

@Nityam573
Copy link

Can I jump on this task?

@1nonlypiece
Copy link

Let me try this one!

@caxtonacollins
Copy link

I am a Full Stack Developer with two years of professional experience, specializing in web3. I have strong background in blockchain and extensive experience in Next.js/React, TypeScript, and Cairo.

I will like to take care of this.

@martinvibes
Copy link

i'm a frontend dev and blockchain dev
May I try my hand at this?
i would love to work on this and get it done

@vestor-dev
Copy link

Can I start working on this?
Would love to tackle this!
kindly assign :)

@Kingsuite
Copy link

I'd like to handle this task.

@jaykayudo
Copy link

Can i work on this?

@jaiminRaiyani
Copy link

I’d like to work on this.

1 similar comment
@emarc99
Copy link

emarc99 commented Dec 17, 2024

I’d like to work on this.

@greatest0falltime
Copy link

I’d like to resolve this.

@OJDIT
Copy link

OJDIT commented Dec 17, 2024

Could I take a shot at this, I will do well on this.

@DotworldX
Copy link

Can I work on this issue? I am interested to see how well I can handle this task being my first issue. I plan to capture and structure the relevant data points, such as LP addresses, pool contributions, LP token amounts, and pool percentages. Hope this is able to convince you to permit me work on it

@Psalmuel01
Copy link

Psalmuel01 commented Dec 18, 2024

I am super experienced in building liquidity pools.

About me:
I am a software engineer with strong technical skills and expertise in developing fully functional dapps. I also have experience in building liquidity pools, so I know the modalities around it. I have developed many such with excellent frontend integrations as well.

Recently, I built a Stellar DeFi liquidity pool (https://github.com/Psalmuel01/stellar-defi-frontend). My GitHub has a lot of proof of work, as well.

Leveraging on my skills and experience, l am confident in my ability to tackle new challenges and also solve complex technical issues.

Tackling this issue
• Given my experience in integrating stellar liquidity, I will ensure the frontend is exactly configured to fit the deployed contract, until it functions seamlessly.

ETA: 12 hours

@OthmanImam
Copy link

Can I take this issue?

@danielrobotz
Copy link

I'd like to take this issue.

@lalitkumawat1m
Copy link

I’d like to work on this.

@ekumamatthew
Copy link

Can I handle this task?

@emarc99
Copy link

emarc99 commented Dec 22, 2024

Is this issue still available @esteblock ?

@michojekunle
Copy link

I'd like to handle this task.

@syed-ghufran-hassan
Copy link

Let me try this one!

@qgatssdev qgatssdev linked a pull request Dec 24, 2024 that will close this issue
@aidenwong812
Copy link

Could I take on this issue?

@ebubechi-ihediwa
Copy link

Is this issue still available?

@ebubechi-ihediwa
Copy link

Hi,

My name is Ebubechi, and I am a developer proficient in JavaScript, TypeScript, and Rust. For this task, I will create the required table for Soroswap Liquidity Providers as specified, including the fields for provider addresses, pool addresses, and LP token shares.

I will:

  1. Implement the table structure using the provided schema.

  2. Write a script to populate the table with relevant data.

  3. Develop tests to ensure data integrity and functionality.

  4. Verify that the solution integrates seamlessly with the existing Soroswap program.

ETA: 3 business days.

@mymiracle0118
Copy link

Could I be assigned to this?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet