| I'm not OP but from my experience with both tools there are some main differences within the products: 1. Mathesar includes a lot of cool UI elements for CRUD operations on tables, schemas, and columns. Outerbase doesn't have any UI for this, but only a SQL editor. 2. Mathesar has a lot of support for "relationships" (more accurately described as references in Postgres, but I digress) that Outerbase does not. For example, if you're inserting a foreign key column into Outerbase you have to manually type the value of the column you're referencing. In Mathesar, you'll see a dropdown of all the "related" rows and be able to search through their columns to find the record you need. 3. Mathesar is postgres-exclusive, while Outerbase works with many other DB providers. And more in terms of governance and usage: 1. Outerbase is paid, with a very restrictive free tier. The option to self host is only available to enterprise customers. 2. Mathesar is entirely free and self-hosted. |
Big fan of Mathesar by the way!
1. We have a incredibly powerful CRUD editor on our table, in fact you can drag and drop and select multiple columns & rows, I haven't seen many other DB editors support this.
2. We allow you to pick foreign key constraints from a dropdown as well.
3. This is true.
4. Outerbase is open-source with more and more features heading into our core offering there. https://github.com/outerbase/studio