Mathesar 0.6.0¶

Want cross-table editing or bulk imports in Mathesar? Talk to us!

For our next release, we’re actively working on:

the ability to edit data from multiple tables in a single view
bulk import of data into existing tables

If you’re interested in either, we’d love your input so we’re prioritizing the right problems to solve. Talk to us for 20 min, we’ll give you a $25 gift card as a thank you.

Summary¶

Mathesar 0.6.0 introduces the file data type which allows you to upload, download, and preview files alongside your data. This release also brings a refreshed visual style to Mathesar, introducing semantic colors that make it easier to distinguish between databases, schemas, tables, and more at a glance.

This page provides a comprehensive list of all changes in the release.

Improvements¶

File data type¶

Mathesar now includes a file data type, which lets you attach and interact with files directly in your tables. Any file type can be stored, with images showing a thumbnail preview that can be expanded to a larger view. Other file types display an icon with file details. Files can be downloaded or removed from a row at any time.

A screenshot of Mathesar's table page with a single result modal open. — View an order along with its line items, related images, and a downloadable PDF invoice.

To use file columns, you’ll first need to configure an S3-compatible storage backend. Once configured, you can add files just like any other data type, and then upload files through the Mathesar interface.

Refreshed visual style with semantic colors¶

A Mathesar screenshot showcasing the new light mode — Mathesar’s refined light mode makes it easier to navigate and edit your data.

Mathesar’s interface now uses semantic colors to help you quickly understand and navigate your data. Databases, schemas, tables, and other objects each have distinct colors, making it easier to tell them apart at a glance. This update brings a clearer, more consistent visual style across the application, improving readability and reducing the cognitive load when working with complex datasets.

Related work:

#4563 #4833

Bug fixes¶

Updated default Gunicorn sync worker count to 3 and exposed worker count as an env var #4844
Moved installation page language-switcher to top right corner #4735
Fixed JSON rendering in the data explorer and in lists #4741
Fixed an issue with placeholder cell focus #4802 #4816 #4822
Now correctly fetch records data when adding a constraint #4734
Improved keyboard navigation for the form builder #4748
Now properly clear all statuses and errors when inserting a new row #4746

Maintenance¶

Write 0.6.0 release notes #4813
Add Form analytics #4726
Bump django from 4.2.22 to 4.2.24 #4755

Upgrading to 0.6.0¶

Improve Mathesar’s performance with multi-user installs

Mathesar now sets the WEB_CONCURRENCY variable to 3 by default, which can significantly improve performance for installs with multiple users.

Existing users should set the WEB_CONCURRENCY env var using our recommended settings.

For installations using Docker Compose¶

If you have a Docker compose installation, run the command below:

docker compose -f /etc/mathesar/docker-compose.yml up --pull always -d

Your installation directory may be different

You may need to change /etc/mathesar/ in the command above if you chose to install Mathesar to a different directory.

For direct installations of Mathesar on Linux, macOS, or WSL¶

Mathesar provides an install script that automates both fresh installs and upgrades for standalone (non-Docker) installations.

Previously referred to as “Installation from scratch”

In versions earlier than 0.3.0, this setup was referred to as “Installation from scratch”.

Follow the steps below to upgrade Mathesar:

Enter your installation directory into the box below and press Enter to personalize this guide:
- Do not include a trailing slash.
- Do not use any variables like $HOME.
Go to your Mathesar installation directory.
```
cd xMATHESAR_INSTALL_DIRx
```
Note

Your installation directory may be different from above if you used a different directory when installing Mathesar.

Download and run the install script for 0.6.0

curl -sSfL https://github.com/mathesar-foundation/mathesar/releases/download/0.6.0/nstall.sh -o install.sh
chmod +x install.sh

./install.sh .

Replace your gunicorn systemd service with a Mathesar systemd service
1. Disable and stop the existing gunicorn service
```
systemctl disable gunicorn.service
systemctl stop gunicorn.service
```
2. Follow the steps in Run Mathesar as a systemd service from the installation guide
3. Remove the gunicorn service file
```
sudo rm /lib/systemd/system/gunicorn.service
```
Update your Caddyfile
1. Use the configuration shown in Install and configure Caddy in the installation guide, and update your Caddyfile accordingly
2. Ensure that your domains are specified directly in the first line of the Caddyfile
3. Restart your Caddy service
```
systemctl restart caddy.service
```

Tip

If you’re running Mathesar only on localhost and do not want it to run as a service, you could:

Remove the gunicorn and caddy services
Start Mathesar manually with:
```
mathesar run
```