Mealie
- Mealie is an open-source web application that provides a spreadsheet-like interface to a PostgreSQL database.
- It ensures privacy, data ownership, control, and interoperability.
- Mealie connects to various databases, allowing collaboration among multiple users on the same data.
- It simplifies working with foreign key columns by turning them into easy-to-use links that reference related records.
- Mealie provides a user-friendly way to customize and preview data, making it accessible to non-technical users.
Mathesar
- Mathesar is a relational spreadsheet application that aims to mirror the functionality of PostgreSQL while being easy to use for non-technical users.
- It achieves this by adding a thin layer of metadata to PostgreSQL to handle things like record summary templates.
- Mathesar has a built-in visual query builder called the Data Explorer, which allows users to easily create queries without needing to know SQL.
- Each record in Mathesar has its own page, which displays all the data related to that record.
- Mathesar makes it easy to create and edit records, including associating records with each other.
- Mathesar can be integrated with a PostgreSQL database by connecting to a running PostgreSQL server.
- The backend of the application is written in Python and Django, and uses PostgreSQL as the database.
- The frontend of the application is built using Svelte and TypeScript.
- The team is working on building their own component library for Svelte to address the lack of a mature ecosystem compared to React.
- Currently, the application only supports PostgreSQL, but there are plans to use PostgreSQL foreign data wrappers to connect to other databases like MySQL in the future.
- The application's current permission system is based on Django permissions, but the team is working on transitioning to the PostgreSQL roles and permissions system for improved security.
- MathAR allows users to map MathAR users to PostgreSQL roles for access control and security.
- Contributors are welcome to contribute code, provide feedback, or help steer the project's direction by providing input on the public roadmap.
