OptaPlanner VS Directus

However, if you need to solve constraints etc., see: https://www.optaplanner.org/

Try looking for something built around Optaplanner - basically taking the end game of rostering and working backwards.

OptaPlanner takes some of the items tracked in tool like Odoo and creates plans based on them. I.E. how do you manage shifts while juggling multiple constraints (Jerry can only work weekends, Jeff can only work afternoons, Jim can work weekends but only on double time, etc.)

There is a library out there called Optaplanner that is designed for optimization of NP complete problems. It is hard to tell if that is exactly what this is, but I think you should be able to use this regardless.

Just stumbled upon https://www.optaplanner.org. Looks very interesting but also really overkill.

OptaPlanner - a generic scheduler.

OptaPlanner

I've never used it but it sounds like OptaPlanner may be a scheduler in the same vein?

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.