This is an automated archive made by the Lemmit Bot.
The original was posted on /r/selfhosted by /u/tocf on 2025-01-29 22:49:23+00:00.
Hello /r/selfhosted! We just released Mathesar 0.2.0, our initial beta release! This marks our transition from alpha to beta, which means the project is now more stable, thoroughly tested, and we're comfortable saying it's ready to work with production PostgreSQL databases.
If this is the first time you're hearing of Mathesar: We're an intuitive, open source, spreadsheet-like UI to a PostgreSQL database. Mathesar uses and manipulates Postgres schemas, primary keys, foreign keys, constraints and data types. e.g. "Relationships" in our UI are foreign keys in the database.
Our features include:
- Connecting to an existing Postgres database or creating one from scratch.
- Access control using Postgres roles and privileges.
- Works harmoniously alongside your database and thousands of other tools in the Postgres ecosystem.
- Easily create and update Postgres schemas and tables.
- Use our spreadsheet-like interface to view, create, update, and delete table records.
- Filter, sort, and group - slice your data in different ways.
- Use our Data Explorer to build queries without knowing anything about SQL or joins.
- Import and export data into Mathesar easily to work with your data elsewhere.
- Data modeling support - transfer columns between tables in two clicks.
This release added the Postgres-based access control, exponentially sped up UI performance, and added some nice quality of life features like exporting data, a comprehensive user guide, and so on.
Here are some links:
I'd love feedback, thoughts, criticism, pretty much anything. Let me know what you think of Mathesar and what features you'd like to see next. You can also join our community on Matrix to chat with us in real time.
Here are some of the features we're considering building next,
- Better tools for administrators, including SSO, a UI for PostgreSQL row level security, and support for non-Postgres databases through foreign data wrappers.
- More ways to edit and query data, such as a unified interface for query building and editing, custom input forms, and a built-in SQL editor.
- Expanded support for data types, including location data (via PostGIS), long-form/formatted text (e.g., Markdown), and various file and image types.
Our roadmap will ultimately be shaped by feedback from our beta users. If there's something you'd like to see in Mathesar, let us know!