Need guidance: Is this doable with SirixDB?

1

I am new to SirixDB and from my understanding it’s self-hosted so I suspect it won’t work for us. Nonetheless, let’s see if there’s hope:

We are looking into building

  • A text-based, Github located database that supports “Valid Time” (Valid time - Wikipedia) parsing/filtering in real time.
  • DB (file) will be updated collaboratively via PRs to the repo.
  • Client would take that DB, query as per requested time (time slider in the client), extract records and render them.
  • Move time slider, repeat

Do you think this is possible with SirixDB?
If not, any other recommendations?

Thanks!

2

Yes, you can open N read-only transactions, which are bound to specific revisions (either by revision or transaction commit time) concurrent and maybe in parallel to one read-write trx per resource in the database whereas a resource can be thought of as the equivalent to a table in a relational database.

So, currently you need to self-host (or deploy the docker container + maybe Keycloak) somewhere.

Kind regards
Johannes

1 Like
3

Regarding the time slider use case I’d say it’s an ideal fit.

Kind regards
Johannes

1 Like