event-reduce VS Directus

You should check out the event-reduce algorithm[1]. It scales in a different way on how it calculates new results based on old-Results+Event. So it can have some benefits over materialized views depending on the data size and how many clients subscribe to a query.

[1] https://github.com/pubkey/event-reduce

Directus is an open data platform built to serve as a headless CMS, API, or Backend-as-a-Service (BaaS) for other applications. It is designed to make data accessible to people of all technical levels and to make it easy to build data-centric applications. Directus is extensible and can be integrated with many different frontend technologies to create stable, well-structured development and user experiences.

As of April 2024, Directus' GitHub repository has accumulated 25.2k stars and 3.5k forks, showcasing its active community. The project has secured $8+ million in funding, further fueling its growth and development.

I don't know, it's something I've wanted many times.

Recently I discovered https://directus.io/ which comes pretty close and it's open source.

Directus: The Shape-Shifting Maverick

The Backend to Build Anything or Everything | Directus

today I discovered https://directus.io/

You could try https://www.airtable.com/ (check the prices) or https://directus.io/ (check the prices) or hire someone :)

I using Directus CMS on several projects with pretty complicated flows, api extensions etc. probably there will be some work if you move. I liked Directus is because it's standard SQL I can always move my DB and documents to another solution. I don't use their hosted solution but they have an unlimited offering for $100 / month.

Have you looked at Directus? I’m not sure exactly what your needs are (sorry if I’ve misunderstood). I used it for my most recent project as the backend for data entry/queries/administration. It supports MySQL, but admins don’t need to know anything about SQL to do complex queries/filters/CSV exports from the Directus UI.