Db-Sync Enterprise: high-availability setup of Cardano’s Db-Sync to run queries and access on-chain data as a service

[GENERAL] Name and Surname of Main Applicant

Alexander Diemand

[GENERAL] Email address of Main Applicant

adiemand@proton.me

Additional Applicants

Thomas Kaliakos (@thomaska)

Bitseat Tadesse (@bitseatt)

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

6

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

No

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

No

[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.” in this field.

No dependencies.

[GENERAL] Will your project outputs be fully Open Source?

Yes

[GENERAL] If NO, please describe which outputs are not going to be open source. If YES, please write “Project will be fully open source.” in this field.

Project will be fully open source.

[METADATA] Category of Proposal

Data, Explorers, Trackers

[IMPACT] Please describe your proposed solution.

We will offer on demand all the on chain data in a relational database that can be used by any client. In this way the pain of querying on-chain data, combining realtime and historical data will be mitigated.

[IMPACT] How does your proposed solution address the challenge and what benefits will this bring to the Cardano ecosystem?

We will offer to Cardano’s ecosystem a low barrier entry for querying realtime and historical on-chain data. It will be “Db-Sync as a Service”, pay as you go, and scalable to the user’s project needs.

[IMPACT] How do you intend to measure the success of your project?

We aim for 99% guaranteed uptime of the read replica:

• 365 days x 24 hrs x 3600 seconds = 31'536'000 seconds per year
• 1% downtime = 315'360 seconds per year or 87.6 hours or 3.65 days
• This downtime is needed to switch from one version to another on software upgrades and chain hardforks

[IMPACT] Please describe your plans to share the outputs and results of your project?

We offer Cardano projects two types of Db-Sync connections:

• $$$ Dedicated BIG PostgreSQL read-replica instance
• $$$ Dedicated small PostgreSQL read-replica instance
• $$$ Access to shared instance with usage quotas

[CAPABILITY/ FEASIBILITY] What is your capability to deliver your project with high levels of trust and accountability?

We have more than two years experience with our own developed Db-Sync Enterprise protocol which minimises downtime of a Db-Sync pipeline.

The project team covers all aspects required to achieve the stated goals.

[CAPABILITY/ FEASIBILITY] What are the main goals for the project and how will you validate if your approach is feasible?

G1: setup redundant and high-availability pipeline of Db-Sync

Public dashboard that shows system metrics

G2: dynamically add read replica and provide user access

Automatise signup procedure

G3: monitor pipeline uptime

Public dashboard to show uptime

[CAPABILITY/ FEASIBILITY] Please provide a detailed breakdown of your project’s milestones and each of the main tasks or activities to reach the milestone plus the expected timeline for the delivery.

M1: setup redundant and high-availability infrastructure for the project (2 months)

M2: create monitoring and dashboard view (2 months)

M3: automatise user signup (2 months)

[CAPABILITY/ FEASIBILITY] Please describe the deliverables, outputs and intended outcomes of each milestone.

D1: redundant and high-availability pipeline of Db-Sync setup

D2: monitoring in place and dashboard views of system metrics

D3: automatised user signup (payment with ADA?)

[RESOURCES & VALUE FOR MONEY] Please provide a detailed budget breakdown of the proposed work and resources.

B1: 20 PD architecture & design, project management, communication

B2: 20 PD system engineering (Devops) for pipeline setup

B3: 20 PD software engineering

B4: 20 PD data science: dashboard development

B5: hardware costs: est. $1000 per month

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

By sharing our redundant high-availability Db-Sync pipeline we can provide users with a sophisticated and reliable Db-Sync connection for a fair price.

We believe this offering enables a number of Cardano projects as it lowers entry barriers.

[IMPORTANT NOTE] The Applicant agreed to Fund10 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.

I Accept