Dandelion PostgREST GUI for developers and students

[GENERAL] Name and surname of main applicant

[GENERAL] Are you delivering this project as an individual or as an entity (whether formally incorporated or not)

[GENERAL] Please specify how many months you expect your project to last (from 2-12 months)

[GENERAL] Please indicate if your proposal has been auto-translated into English from another language.

[GENERAL] Summarize your solution to the problem (200-character limit including spaces)

We will provide an open source UI tool solution for developers for testing and querying Dandelion’s PostgREST API graphically

[GENERAL] Does your project have any dependencies on other organizations, technical or otherwise?

[GENERAL] If YES, please describe what the dependency is and why you believe it is essential for your project’s delivery. If NO, please write “No dependencies.”

This project depends on Dandelion Community APIs optimal working state and access to it, and the listing of a PostgREST API on the provided services.

[GENERAL] Will your project’s output/s be fully open source?

[GENERAL] Please provide here more information on the open source status of your project outputs

The full code of the UI tool adapted to work for Dandelion will be provided as open source.

The deployed solution will be offered for free.

[SOLUTION] Please describe your proposed solution.

Dandelion APIs has always been a friendly hand for developers and students on Cardano, as it give us all access to a community backed service of the official and most common APIs on the ecosystem.

Dandelion has a PostgREST API but for developers and students to discover the indexed data on the SQL database would be perfect to have a customized graphical user interface to explore it and to aid the user to build queries there to then incorporate to their projects.

I will offer that tool customized for Dandelion and any other project will be able to fork it and use their own API endpoints to point to their own services.

[IMPACT] Please define the positive impact your project will have on the wider Cardano community.

As Cardano evolves, kind and appealing services such as cardano-graphql that once was enough for us to cover the grand majority of data types and relations required is now getting a bit outdated. With great solutions such as Koios and the upcoming Ledger Sync replacement of cardano-db-sync we think for projects to scale and stay flexible to evolve in time is to directly consume the populated PostgresDB itself through a PostgREST API.

Increasing the early adoption of PostgREST API with tools like this we can point developers early to a solid direction instead of letting them pick tools that are getting limited or outdated as times goes on and will probably make them lose research and development time in vane.

[CAPABILITY & FEASIBILITY] What is your capability to deliver your project with high levels of trust and accountability? How do you intend to validate if your approach is feasible?

Regarding Dandelion, I cannot think of a more resilient and community focused project on Cardano. It has stayed with us with or without proper funding, it borned with a huge educational approach from Gimbalabs itself being their flagship API service for years now, and it has been powering projects like GameChanger Wallet since the very beginning of this ecosystem.

Cardano wont ever be the same without Dandelion APIs.

I, as GameChanger Finance Project Lead, have to offer my 2.5 years of product delivery and maintanance, even on several out of budget situations, plus all the finalized Catalyst projects with montly reports to keep myself accountable of the granted funds

[Project Milestones] What are the key milestones you need to achieve in order to complete your project successfully?

Tasks:

• Create the public Github repository of the UI tool.
• Adapt the code to work and point to Dandelion APIs

Output: The full open source code of the UI tool.

Acceptance Criteria: The existance of the github repository with the code

Tasks:

• Create some basic documentation.
• Deploy the code as a free service.

Output: The full open source code of the UI tool, basic documentation and the free deployment for the community.

Acceptance Criteria: The existance of the github repository with the code, the docs. The deployed application at the reported URL.

Output: The full open source code of the UI tool, basic documentation and the free deployment for the community.

Acceptance Criteria: The existance of the github repository with the code, the docs. The deployed application at the reported URL.

[RESOURCES] Who is in the project team and what are their roles?

Project Leader:

Adriano Fiorenza is Entrepreneur & Senior Full Stack Developer with 15+ years of experience software and IOT development. Founder and Developer of GameChanger Wallet, participated in 1st gen Plutus Pioneer Program, Team member at ALDEA, Gimbalabs colaborator

His Linkedin profile can be found at https://ar.linkedin.com/in/adriano-fiorenza

[BUDGET & COSTS] Please provide a cost breakdown of the proposed work and resources.

Milestones:

1. create repository and adapt - 80hs
2. docs and deployment - 32hs

Total: 112hs x USD 85/hr = USD 9.520,00 ~ ADA 25.052,63

[VALUE FOR MONEY] How does the cost of the project represent value for money for the Cardano ecosystem?

If I personally would have the insights provided here, the UI tool and the PostgREST API available back in 2021 I would have used them for developing GameChanger Wallet.

The offered solution at the low priced offered totally worth the use of this community funds only if we truly care to onboard developers and improve our builders and students ecosystem.

[IMPORTANT NOTE] The Applicant agrees to Fund Rules and also that data in the submission form and other data provided by the project team during the course of the project will be publicly available.