OpenJS running visionBoard

[UlisesGascon]

Contact Details

ulisesgascongonzalez@gmail.com

Description

Hey team!

As part of the Alpha Omega initiative, we need some infra resources to run OpenPathfinder - VisionBoard at the organization level. Context: openjs-foundation/security-collab-space#250 (comment) (cc: @bensternthal @ruddermann )

Database

Ideally, we can start with a simple postgres:17.2 instance with low resources as a "staging" environment. In the future, we can generate a similar environment for production.

Note: At this state all the data can be regenerated, so we don't have to worry about replication or scalability.

Files management

Similarly, we ideally need some sort of file system in place to store static generated files like plain HTML or JSON. We can start with small resources (e.g., 100MB) for staging. Once consolidated, we can move ahead to set up a "production" environment.

Note: At this state all the data can be regenerated, so we don't have to worry about replication or scalability.

Deadlines

In terms of deadlines, we can use local environments for now. We have a few weeks ahead until other maintainers are onboarded to the initiative.

Project

OpenJS

How urgent is this request?

Request / No Problem But Require Assistance or Support

[ryanaslett]

Howdy Ulises,

So question on this: how robust does the database need to be? i.e. could it be on sqlite, and perhaps even a cloudflare D1 database? (https://developers.cloudflare.com/d1/)

[UlisesGascon]

It doesn’t need to be very robust—I believe even a simple Docker container could be sufficient. However, we require certain database features that might limit our ability to use SQLite, such as JSON and JSONB querying. Additionally, we are running this as a containerized solution, meaning we only provide support for databases that can run locally via Docker/Docker Compose, such as PostgreSQL.

[bensternthal]

@UlisesGascon we'd like to see if we can grant you access to a service so that you can set this up yourself. The services that we currently use that have free credit programs are:

• Azure
• DigitalOcean
• Cloudflare (CF)

I am not sure if CF is an option here. That being said are you familiar enough with one of these to have a preference?

[UlisesGascon]

I am not sure if CF is an option here. That being said are you familiar enough with one of these to have a preference?

Yep, DigitalOcean is a good option we can go with the most simple managed database instance (ref) 1 GiB, 1 vCPU, 10 GiB