Mathesar 0.1.7¶

Summary¶

Mathesar 0.1.7 introduces linked table navigation from the data cell context menu. This release also fixes the regeneration of exploration share URLs and removes the ‘group’ suffix in the Data Explorer column names.

See the upgrading section below for instructions on how to upgrade to this version.

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

Improvements¶

Users can now navigate to linked tables from the cell context menu, providing a more seamless experience when working with linked data.

#3526

Bug fixes¶

Fixed an issue where clicking “Regenerate Link” for a shared exploration failed to create a new URL and resulted in a 404 API request. Now, users will see a successful API call with a new, regenerated share URL.

#3521

Remove ‘group’ Suffix in Data Explorer¶

Resolved an issue in the Data Explorer where the grouping column name was incorrectly suffixed with ‘group’. Now, the original column names are preserved when summarizing data.

#3357

Documentation¶

Upgrade Instructions for 0.1.7 #3534

Maintenance¶

Bump Django from 4.2.10 to 4.2.11 #3496
Made Release Notes Script Portable #3529
Removed Stray Changes Post Script Update #3530
Integrated Changes from Previous Release Preparation #3517
Added Demo Target in Dockerfile for Future Deployments #3523
New RPC Endpoint Implementation for Superuser Functions #3524

Upgrading to Mathesar 0.1.7¶

For installations using Docker Compose¶

If you have a Docker compose installation (including one from the guided script), 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 installations done from scratch¶

If you installed Mathesar from scratch, then use these steps to upgrade your installation to 0.1.7.

Go to your Mathesar installation directory
```
cd xMATHESAR_INSTALLATION_DIRx
```
Note

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

Pull version 0.1.7 from the repository

git pull https://github.com/mathesar-foundation/mathesar.git
git checkout 0.1.7

Update Python dependencies
```
pip install -r requirements-prod.txt
```
Activate our virtual environment
```
source ./mathesar-venv/bin/activate
```
You can skip the following if you’re upgrading from versions 0.1.4 and above.
- If you’re upgrading from versions <= 0.1.3, update your environment variables according to the the new configuration specification.
- In particular, you must put the connection info for the internal DB into new POSTGRES_* variables. The DJANGO_DATABASE_URL variable is no longer supported.
Add the environment variables to the shell before running Django commands
```
export $(sudo cat .env)
```
Run Django migrations
```
python manage.py migrate
```

Download and extract frontend assets

wget https://github.com/mathesar-foundation/mathesar/releases/download/0.1.7/static_files.zip
unzip static_files.zip && mv static_files mathesar/static/mathesar && rm static_files.zip

Compile Mathesar translation files
```
python manage.py compilemessages
```

Update Mathesar functions on the database:

python -m mathesar.install --skip-confirm | tee /tmp/install.py.log

Restart the gunicorn server
```
systemctl restart gunicorn
```