Mathesar 0.2.2¶

Help shape the future of Mathesar

We’re looking to speak with users to better understand how Mathesar can help you or your team. It’s only a 20 minute interview, and we’re happy to offer a $25 gift card in return.

If you’re interested in helping, you can use this link to schedule a chat with Zack on the Mathesar team. Thank you!

Summary¶

Mathesar 0.2.2 introduces several improvements, including enhanced primary key handling, smart pasting for easier data entry, and various bug fixes. Users can now choose UUIDs as primary keys, designate any existing column as a primary key during data import, and benefit from a new UUID column type.

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

Improvements¶

Inserting records when the primary key has no default value¶

Previously, Mathesar required a default value to be set on the primary key column in order to insert records. However there are some valid use cases for primary keys without default values, such as a TEXT column that receives a manually-supplied value on each insert. In 0.2.2 Mathesar now allows you to insert records into such tables by entering the primary key values during the insert.

#4337 #4348

Configuring primary keys during import¶

When importing existing data, Mathesar automatically generates a primary key column. Previously, importing a simple CSV like:

First Name,Last Name
Jane,Park
Steve,Smith
Laura,Stein
Amy,Richards

would result in Mathesar automatically adding an integer “id” primary key column that auto-increments by default.

That’s still the default behavior. But now, you can choose the type of generated primary key column: either an auto-incrementing integer or a UUID column with a default value of a random UUIDv4:

A screenshot of Mathesar's import UI showing the new settings for using a generated UUID primary key column

Additionally, you can now designate any existing column as the primary key. If you select a UUID or Number column, you’ll have the option to apply the same default value settings that Mathesar uses for generated primary key columns.

#4353 #4358 #4366 #4316

Configuring primary keys when creating tables from scratch¶

When creating new tables in Mathesar, you’ll now have the option to set the name and type of your primary key column:

A screenshot of Mathesar's import UI showing the new settings for using a generated UUID primary key column

As when importing data, you can choose between an auto-incrementing integer or a UUID column with a default value of a random UUIDv4.

#4331

Pasting data into multiple Mathesar cells¶

Mathesar now supports pasting, making it easy to update multiple cells across multiple rows and/or columns in one go. It automatically handles type conversions, so you can paste data from different formats without hassle. Linked column references work just like any other value. You can also copy-paste multiple cells from a variety of other spreadsheet applications directly into Mathesar.

To paste cells that you’ve copied, select the top-left cell of the cell range in Mathesar where you want to paste. Then use your system’s keyboard shortcut to paste — ⌘ Command+V on macOS, or Ctrl+V on Windows and Linux.

You’ll see a confirmation dialog:

A screenshot of Mathesar's "paste confirmation" dialog

After choosing “paste”, your selected rows will be updated with the new values.

A screenshot of Mathesar's "paste confirmation" dialog

#4258 #4322 #4327 #4326 #4345

Improved support for UUID types¶

We’ve elevated PostgreSQL’s uuid data type to be a fully-supported type from within Mathesar.

As mentioned in the sections above, you can now configure UUID primary keys for tables created via import and from scratch.
UUID columns now display with an appropriate icon and column type label.
Hexadecimal serialization of UUIDs in CSV data will be inferred to the UUID type during import.
When searching and filtering records, you can now enter a substring of a UUID hexadecimal representation.
You can now add UUID columns to existing tables from Mathesar. (However you cannot yet define dynamic defaults for those columns from within Mathesar.)

#4316 #4329 #4351

Additional improvements¶

Nickname searching in database search #4354
Set default time type to ‘Time without Time Zone’ in new column form #4346

Bug fixes¶

Gracefully handle restrictions on editing data in tables lacking primary keys #4349
Fix error when saving a record in a table with a “GENERATED ALWAYS AS IDENTITY” primary key #4321
Allow the user to recover from failed type inference during import #4359
Fix bug causing Mathesar to infer certain text strings as money values when importing #4350
Fix text descender clipping in Select dropdown elements #4344
Fix problem with timezones and date/time keywords #4317
Don’t render invalid URLs as hyperlinks in URI cells #4365

Documentation¶

Fix documentation version chooser #4291
Fix search result styling #4287
Update README.md to fix typo #4361

Maintenance¶

Revert “Bump django from 4.2.18 to 4.2.20” #4325
Bump django from 4.2.18 to 4.2.20 #4315
Make SQL tests fail when test file is broken #4293

Upgrading to 0.2.2¶

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.2.2.

Go to your Mathesar installation directory
```
cd /etc/mathesar
```
Note

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

Pull version 0.2.2 from the repository

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

Update Python dependencies
```
pip install -r requirements.txt
```
Activate our virtual environment
```
source ./mathesar-venv/bin/activate
```
Run Django migrations
```
python manage.py migrate
```

Download and extract frontend assets

wget https://github.com/mathesar-foundation/mathesar/releases/download/0.2.2/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
```