mathesar VS Strapi

Congratulations on launching, it's nice to see more open source products in this area (I work on https://mathesar.org/). Feel free to reach out if you'd like to talk and compare notes.

This is what we're trying to do with [Mathesar](https://github.com/centerofci/mathesar). We probably don't meet your needs yet because we don't support real-time concurrent editing, but we're actively working on the project and it is early days.

I'm an engineer on the Mathesar core team and I'd just like to clarify that Mathesar does support grouping to some extent. Here is a screenshot[1] that demonstrates the grouping functionality. Grouping levels are unlimited. You can play with this functionality on our live demo[2]. It's worth mentioning that Mathesar does not yet have the capability to expand and collapse groups, but that feature is planned[3].

Best of luck building Visual DB! Nice to see more innovation in this space!

[1]: https://mathesar.org/assets/crm-table-zoomed.png

[2]: https://demo.mathesar.org/

[3]: https://github.com/centerofci/mathesar/issues/475

I’m not sure if it’s okay to plug my project, but I work on Mathesar (https://github.com/centerofci/mathesar) which can be used as a Postgres GUI. We’re putting a lot of product/design effort into making it nice to use for non technical users.

Otherwise, I just use the command line.

We're trying to do this with Mathesar: https://github.com/centerofci/mathesar. Some feedback would be great!

We're trying to build a community driven project in this space - https://github.com/centerofci/mathesar. We just did our alpha release a couple of months ago.

I'm philosophically opposed to open core (Mathesar is run out of a non-profit), but I can see why other projects do it – finding funding for a big project like this is difficult without VCs (who expect returns).

I'm working on https://mathesar.org/ – it's an open source database solution built on Postgres, you can import data, connect to multiple databases, edit data and build reports. It can't connect to non-Postgres databases, so it may not work for you.

We've just released Mathesar v0.1.2. Major new features are support for multiple databases in the UI and more options for installing Mathesar. We also made a bunch of smaller UX improvements and fixed a few bugs. Our full release notes are here: https://github.com/centerofci/mathesar/releases/tag/0.1.2

We did this for our open source project, Mathesar (https://github.com/centerofci/mathesar), which also uses Django. It's a lot of work. You can take a look at our code if it's helpful.

Strapi provides a centralized data managing platform. This makes it easier to organize, update, and maintain the FAQ data. It also automatically generates a RESTful API for accessing the content stored in its database.

https://prisma.io is popular as I understand it. I've been trying out https://strapi.io the last week and am thoroughly impressed.

They both do much more than build queries. One big thing both do is automate database migration calculations. Strapi goes further and gives you a CMS and admin UI on top, as well as doing a lot more of the complex query building from a json object. Both still require a fundamental understanding of the data model and SQL

As of April 2024, Strapi's GitHub repository has garnered 59.7k stars and 7.5k forks, showcasing its widespread adoption. The project has also secured a substantial $45+ million in funding, cementing its position as a prominent player in the headless CMS space.

const pages = await client.GET("/pages", { params: { query: { filters: { // @ts-ignore - openapi generated from strapi results in Record // https://github.com/strapi/strapi/issues/19644 path: { $eq: path, }, }, // @ts-ignore populate: { blocks: { populate: "*" }, }, }, }, });

On a side note. Where do all these endpoints come from? Strapi is open source. We can read the source code. All these endpoint come from the Users and permissions plugin. So, if we go to Strapi on github and browse around the files a bit eventually you will find the auth.js file that contains all of the routes. You can also find the Strapi controllers in there if you're interested.

Strapi

Strapi: The Code Anarchist

Strapi - Open source Node.js Headless CMS 🚀