7 ms·
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
by zackdotcat 2y ago
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.
- burcs 2y agoHi I'm one of the founders of Outerbase, just want to clarify a few things, seems like you might have some wrong information on Outerbase. 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 https://github.com/outerbase/studio
- zackdotcat 2y agoMy apologies burcs, I indeed missed your table creator UI and the subsequent "Edit table" view, those are quite nice!