Close

Part-DB 1.13.0 - PostgreSQL support, natural sorting and more

A project log for Part-DB - Open Source inventory software

Part-DB is an Open-Source inventory management system for your electronic components. It is installed on a web server and so can be accessed

jan-bJan B. 06/24/2024 at 11:490 Comments

# Part-DB 1.13.0 - PostgreSQL support, natural sorting and more 

## PostgreSQL

Part-DB now supports [PostgreSQL](https://www.postgresql.org/) as database. See [documentation](https://docs.part-db.de/installation/choosing_database.html) on how it compares with other database types.

## Natural Sorting

Part-DB now supports natural sorting in part tables and tress.

So instead of sorting elements like `DIP-14`, `DIP-28`, `DIP-4` , `DIP-8`, the elements now get sorted like expected as `DIP-4`, `DIP-8`, `DIP-14` and `DIP-28`.

If you are using PostgreSQL or MariaDB 10.7+ then this kind of sorting is supported natively and natural sorting gets automatically enabled.

If you are running SQLite or MySQL then it is possible to emulate natural sorting by setting the `DATABASE_EMULATE_NATURAL_SORT` to 1.

Please note that this emulation can be very slow and might have some issues and quirks.

# Full changelog

See Release page: https://github.com/Part-DB/Part-DB-server/releases/tag/v1.13.0

Discussions