PostgreSQL mathesar.org

Mathesar slaps a web-based spreadsheet UI on your Postgres database  ↦

You know how collaborating with Google Sheets, Airtable & friends is super easy because anybody with a web browser and the correct permissions can get in on it? With Mathesar, you can enable that kind of access to any Postgres database!

Super powerful? I think so. Super risky?! Likely, especially if a lot of your data-related logic is in app code. Worth it? That’s up to you to decide…

Mathesar slaps a web-based spreadsheet UI on your Postgres database

Discussion

Sign in or Join to comment or subscribe

2023-03-09T16:03:37Z ago

I’m on the Mathesar core team and happy to answer any questions about the product.

One thing that’s worth highlighting is that Mathesar is open source!

Jerod, I appreciate your skepticism in considering the risk of connecting a powerful tool like this to a production app with business logic outside the database. To mitigate some of those risks, we do have a permissions system that allows admins to grant users read-only or “data entry only” access to the DB, while still allowing those users to save and update queries for viewing data.

Our vision for Mathesar extends beyond these sort of business intelligence use cases too – we’re also aiming to make Mathesar well-suited for stand-alone use cases where, instead of using Google Sheets or Airtable, you can self-host a product that follows relational database principles and enables collaboration with users of all skill levels.

2023-03-12T15:07:36Z ago

I don’t think that I would turn this loose on databases that I currently have (simply because how they were originally designed) but with a new database that is designed from scratch to use this kind of tool, I’d be all for that. This would keep you fat from being locked into some proprietary format that you couldn’t easily move later.

Player art
  0:00 / 0:00