not approved
Db-Sync Enterprise: high-availability setup of Cardano’s Db-Sync to run queries and access on-chain data as a service
Current Project Status
unfunded
Amount
Received
₳0
Amount
Requested
₳24,000
Percentage
Received
0.00%
Solution

We are developing and maintaining a high-availability infrastructure running Db-Sync to minimise downtime. Cardano projects can be hooked up to our Db-Sync Enterprise solution in short time.

Problem

Running Cardano’s Db-Sync pipeline is expensive and thus out of scope for small and medium sized projects on Cardano. This project’s goal is to provide an affordable & reliable solution for them.

Feasibility
Value for money
Impact / Alignment

Team

3 members

  • Project Information
  • Community Reviews
  • Team Information
Db-Sync Enterprise: high-availability setup of Cardano’s Db-Sync to run queries and access on-chain data as a service
Start date
-
Milestones
-
Next Milestone
-

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.

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.

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

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

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.

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

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)

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?)

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

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

Alexander Diemand (@cardanobigquery): architect, design, project management

Thomas Kaliakos (@thomaska): data quality responsibility, devops lead

Bitseat Tadesse (@bitseatt): data science, dashboard creation, social networks

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.

Community Reviews (1)

Comments

close

Playlist

  • EP2: epoch_length

    Authored by: Darlington Kofa

    3m 24s
    Darlington Kofa
  • EP1: 'd' parameter

    Authored by: Darlington Kofa

    4m 3s
    Darlington Kofa
  • EP3: key_deposit

    Authored by: Darlington Kofa

    3m 48s
    Darlington Kofa
  • EP4: epoch_no

    Authored by: Darlington Kofa

    2m 16s
    Darlington Kofa
  • EP5: max_block_size

    Authored by: Darlington Kofa

    3m 14s
    Darlington Kofa
  • EP6: pool_deposit

    Authored by: Darlington Kofa

    3m 19s
    Darlington Kofa
  • EP7: max_tx_size

    Authored by: Darlington Kofa

    4m 59s
    Darlington Kofa
0:00
/
~0:00