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

[jbtronics]

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

If you like Part-DB, please consider donating to help further development. See the sponsor button on the homepage.

PostgreSQL

Part-DB now supports PostgreSQL as database. See documentation 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

New features

• Support for PostgreSQL as database
• Support for natural sorting of tables and trees, on MariaDB 10.7 and PostgreSQL. On other platforms, a (slow) emulation is possible. See here for more information
• Support for importing parameters and attachments
• Added scan button to navbar in mobile view (PR add scan button to navbar in mobile view #626, thanks @RaptorDE)

Bugfixes

• Show correct data in partUnit column in part tables (fixes "MPN" is shown in "Measurement Unit" #630)
• Fixed error message, when using datetime filters with a range
• Use correct frontend translations, when using a locale with subregion (see Decouple time/date format from language selection #563)
• Fixed --overwrite option of backup command not working (issue --overwrite doesn't work #635)
• Hide tooltip after clicking navbar visibility toggler (The “Show/Hide sidebar” button tooltip is not automatically hidden after clicking it. #628)
• Hide mouser parts with an invalid product id (Runtime exception: Multiple parts found with ID N/A #616)
• Handle export of recursive datastructures better
• Fixed some issues with the timetravel feature

Miscellaneous

• Updated dependencies
• Fixed some deprecations
• Improvements of code quality

New Contributors

• @RaptorDE made their first contribution in add scan button to navbar in mobile view #626

Full Changelog: v1.12.1...v1.13.0

---

This discussion was created from the release Part-DB 1.13.0.

[amitzioni]

Thank you very much for the new version.
I installed part-db by downloading the archives and unpacking them. However now I see that for the update I should do git pull. Is there any other mechanism for updating part-db ?

[RaptorDE]

@jbtronics thanks for the update, could you please update the example csv and documentation in the wiki for the new import functions?

[TIGER53501]

Hello, how to configure docker-compose.yaml for use Postgre?

[Tropaion]

@jbtronics Does sorting by prefix also work with natural sorting? For example R, kR, MR?