Mathesar 0.10.0 Release

Mathesar 0.10.0 is here! This release improves data type support by adding UI support for PostgreSQL ENUM columns, introduces a custom User data type for storing references to Mathesar users, and adds lightweight tracking of the user who last changed a record.

Mathesar's UI is also now available in 🇪🇸 Spanish and 🇫🇷 French, thanks to some user-contributed translations! Plus a a few other fixes. Read our full release notes for complete details and upgrade instructions.

🔢 UI support for PostgreSQL ENUM columns

Previously, Mathesar rendered PostgreSQL ENUM columns as text fields and relied on database-level validation. In 0.10.0, ENUM columns now display a dropdown of valid values when editing cells, making data entry faster and reducing avoidable mistakes.

This should make Mathesar easier to use with existing PostgreSQL schemas that already rely on ENUM columns.

👷‍♂️ User data type

Mathesar 0.10.0 introduces a custom User data type for storing references to Mathesar users in table columns. You can use it for fields such as assignee, owner, reviewer, or point of contact directly inside Mathesar.

User-typed cells can display a username, display name, or email address, and they use a searchable dropdown while editing. User columns also support default values for new rows.

📋 Last-editor tracking

You can now designate a User-typed column to automatically store the current Mathesar user whenever a record is added or updated through Mathesar's UI or API.

This lets teams see which Mathesar user most recently added or edited a record without updating the column manually. Once enabled for a table, the selected column is updated automatically and can no longer be edited manually.

🇪🇸 Spanish and 🇫🇷 French UI

Mathesar's UI is now fully translated into Spanish and French, making the product easier to use for more teams in multilingual environments.