-
Mathesar
Mathesar is an 100% open source collaborative web application that empowers users of all technical skill levels to view, edit, query, and collaborate on PostgreSQL data in an intuitive spreadsheet-like interface. It has native database-level access control, is self hosted and deployed in minutes, and works directly with Postgres objects without extra abstractions.
Just a heads-up, I’m opinionated on this!
Every app has some terminology you need to learn to use it effectively, we just think that terminology should actually map to how databases work, rather than being an arbitrary abstraction. Instead of inventing our own terms, we stick to tables, records, schemas, and relationships so that users who learn Mathesar are also learning concepts that translate directly to Postgres (or relational databases in general).
Making software approachable isn’t about hiding complexity, it’s about presenting it well. The UI patterns you use determine whether a system feels intuitive, not whether the underlying mental model is simple. A well-designed interface can make even complex concepts feel natural, while a bad one can make simple tasks frustrating. Mathesar doesn’t make databases approachable by pretending tables aren’t tables, it makes them approachable by using familiar interactions, and progressively exposing complexity.
We do want to work on surveys ("forms") soon, and we're definitely thinking about bulk actions and integrations as well. Please feel free to open a feature request on https://github.com/mathesar-foundation/mathesar/issues for anything that would particularly help your use case.
-
InfluxDB
InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
-
studio
A lightweight Database GUI in your browser. It supports connecting to Postgres, MySQL, and SQLite.
Hi 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
