Part-DB 2.0.0

This upgrade introduces a new web based configuration system. Existing configuration using environment variables will continue to work. If you want to configure these parameters via the WebUI in the future, an additional migration step is required. See the upgrade guide for more information.

Breaking changes

• Part-DB now requires at least PHP 8.2 or higher. If you are still using PHP 8.1 you need to upgrade PHP first
• Nodejs 20 or higher is now required
• The config/banner.md file does not exist anymore. If you wanna customize the banner, either do it via the WebUI or the BANNER env.
• The parameters partdb.sidebar.items, partdb.sidebar.root_node_enable and partdb.sidebar.root_expanded in config/parameters.yaml,
  were removed. You can configure them now directly in the admin interface.

New features

• Introduced capability to configure system settings and info providers via the WebUI. No need to work with environment variables anymore
• Improved emoji dialog for rich text editor

Miscellaneous

• Updated dependencies

Full Changelog: v1.17.4...v2.0.0

Part-DB 1.17.3

Bug fixes

• Pass the proxy related settings to the docker application (issue #1001)

Full Changelog: v1.17.3...v1.17.4

Part-DB 1.17.3

Bug fixes

• Fixed a potential denial of service issue related to user avatars (thanks to @NaklehZeidan21)
• Fixed problem with mass creation dialog (#993)

Miscellaneous

• Updated dependencies

Part-DB 1.17.2

New features

• Added option to disable image overlay on part detail pages (#960, thanks @d-buchmann)
• Allow to use the percentage sign directly as unit in parameters, without needing to latex escape it
• Pass supplier part number info to KiCad as custom field (#955, thanks @barisgit)
• Add fields for KiCost KiCad plugin, so that you can easily create a BOM from the information (#910)

Bug fixes

• Fixed typos in info provider description (#942, thanks @d-buchmann)
• Link project root node to edit project page instead of listing all parts (#957, thanks @d-buchmann)
• Fixed problems if parameter value was 0 (#959, thanks @d-buchmann)

What's Changed

• Fix typo and copy-paste error by @d-buchmann in #942
• fix sidebar root node links by @d-buchmann in #957
• Add env option to disable part image overlay by @d-buchmann in #960
• Update AbstractParameter.php by @d-buchmann in #959
• Add supplier information to KiCad part exports by @barisgit in #955

Miscellaneous

• Updated dependencies

New Contributors

• @barisgit made their first contribution in #955

Full Changelog: v1.17.1...v1.17.2

Part-DB 1.17.1

Security fixes

Until this version, users could upload SVG files containing JS code, that would be executed if a user opened the SVG in a new tab, allowing for a XSS vulnerability. This was only possible if the SVG files were explicitly opened in a new tab, if the file was embedded inside a Part-DB tab, then there was no risk.

Since this version, SVG files gets sanitized during upload, to prevent any JS code execution. If you have existing SVG files, you can sanitize them, by running the console command php bin/console partdb:attachments:sanitize-svg.

If you are using Part-DB with nginx, you should add the following block to your server configuration, to further harden it by setting a content security policy for SVG files.

# Set Content-Security-Policy for svg files, to block embedded javascript in there
    location ~* \.svg$ {
        add_header Content-Security-Policy "default-src 'self'; script-src 'none'; style-src 'self' 'unsafe-inline'; img-src 'self' data:; frame-ancestors 'none';";
    }

For apache, this is done automatically in the .htaccess file of Part-DB.

New features

• Added barcode placeholders for C93 and datamatrix barcodes (#931, thanks to @monoxide13)

Miscellaneous

• Updated translations
• Updated dependencies

New Contributors

• @monoxide13 made their first contribution in #931

Full Changelog: v1.17.0...v1.17.1

Part-DB 1.17.0

Changes

• Use Digikey V4 API for digikey provider (by @Danixu in #875)

New features

• Added a way to change the location of parts as batch action, as long as they contain only one lot.
• Improved attachment download compatibility (thanks @Treeed)
• Show digikey packing type (tape&Reel, Box, etc.) in info provider search list
• Render units of parameters with Latex (#856)
• Added a command to download all external-only attachments to the local file system (php bin/console partdb:attachments:download)
• Added an experimental automigration feature to docker image. Set DB_AUTOMIGRATE to true in your docker-compose file to automatically apply database migrations on container startup.

Bug fixes

• Fixed bugs for pollin info provider
• Workaround a bug in KiCAD which could cause a crash (#878)
• Use own CA bundle for element14 provider, to workaround missing CA in debian (#891, #866)
• Fixed problems with mouser info provider, where part numbers could not be resolved to a unique part (#888, #616)
• Fixed 500 if internal attachment path was not resolvable to an URL (#898)
• Fixed problem that global_theme config param was ignored (#880)
• Fixed problem, that categories did not appear in KiCAD, even though they contained visible parts (#885)
• Make database migrationn more compliant with SQL standard (#900)

Miscellaneous

• Updated translations
• Updated dependencies

New Contributors

• @Danixu made their first contribution in #875

Full Changelog: v1.16.1...v1.17.0

Part-DB 1.16.1

Bug fixes

• Fixed LCSC provider (PR #873, @mkne)

Miscellaneous

• Updated translations
• Optimized database migration (this might fix issue #873)

Full Changelog: v1.16.0...v1.16.1

Part-DB 1.16.0

New features

• Added info providers for the german vendors reichelt.com and pollin.de. They use webscraping of the shop pages, as no official API is provider. Use at your own risk!
• Improved inputting/editing of attachment parts (made it easily editable and highlightable) (PR #849 @Treeed)
• Updated KiCAD EDA library list for EDA info autocomplete to latest KiCad version
• Improved attachment system. Attachments now keep the external URL info if a file was downloaded, so that you can track that later (PR #848, @Treeed)
• Added additional sorting and filter possibilities in attachments table
• Use newer farnell/element14 API version. This allows to retrieve the correct URL to products in farnell shop and gives us additional part description that will be put into the notes field in Part-DB

Bug fixes

• Fixed attachment statistics for sqlite (PR #847 @Treeed)
• Fixed problem with duplicate fields in jsonapi API schema description (issue #862)
• Fixed problem with wrong/missing API docs in some cases (issue #851)

Miscellaneous

• Updated dependencies
• Fixed some deprecation warnings
• Improved documentation

New Contributors

• @felbinger made their first contribution in #852

Full Changelog: v1.15.2...v1.16.0

Part-DB 1.15.2

If you are using Part-DB it would be helpful if you fill out this short survey on your usage of Part-DB (Google Forms): https://forms.gle/Q15twx3YYq3qCNfe8

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

There is a new experimental docker image, which is much faster. See this post for more info.

You can help to translate Part-DB to other languages. See this post for more info.

Changes and Improvements

• Deprecated GET_GROSS_PRICES env for TME provider with TME private access token, as it is ignored then and whether VAT is included or not in prices depends on account type
• Removed to show "All" entries in a log table, as the log can easily contain thousands of entries, that would most likely in an out of memory exception on server (see issue #835)
• If an info provider returns multiple attachments or parameters with the same name, they will be suffixed with a number (e.g. Param, Param (2), Param (3), etc.), so that they can be saved, without manually needing to edit their names (as Part-DB wants a unique name for them). See issue #840

Bug fixes

• Prevent error with TME info provider, if using TME private access key (issue #838)
• Fixed exception when exporting an empty list (issue #836)

Miscellaneous

• Updated dependencies
• Improved translations (thanks @mkne)
• Improved documentation (thanks @mkne)

Full Changelog: v1.15.1...v1.15.2

Part-DB 1.15.1

If you are using Part-DB it would be helpful if you fill out this short survey on your usage of Part-DB (Google Forms): https://forms.gle/Q15twx3YYq3qCNfe8

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

There is a new experimental docker image, which is much faster. See this post for more info.

You can help to translate Part-DB to other languages. See this post for more info.

Bugfixes

• Fixed problem that frontend assets could not be loaded properly if serving Part-DB under a prefixed path (issue #824)

Miscellaneous

• Updated dependencies

Full Changelog: v1.15.0...v1.15.1

Part-DB 1.15.0

If you are using Part-DB it would be helpful if you fill out this short survey on your usage of Part-DB (Google Forms): https://forms.gle/Q15twx3YYq3qCNfe8

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

There is a new experimental docker image, which is much faster. See this post for more info.

You can help to translate Part-DB to other languages. See this post for more info.

New features / Improvements

• Updated CKEditor to v41, which should load faster
• Show when a part already exists, when trying to add new parts from info provider (thanks to @Treeed)
• Allow to scan the EIGP114 barcodes on digikey and mouser parts to directly reference parts (thanks to @Treeed)
• Added the possibility to decode and view the content of barcodes (especially EIPG114)
• Allow to map categories from info providers to local categories, using the "alternative names" of local categories
• Highly improved barcode scanner, which should be much faster and more reliable and even a bit smaller than the old one
• Allow to directly save the current label options to a label profile (see issue #806)
• Do not preselect a category when creating a new part, so that users must explicitly select a category and not save one accidentally

Bugfixes

• Fixed LCSC provider (see issue #790), thanks to @vvekic
• Fixed sizing of text in the label editor field
• Fixed "Scan from image" feature of barcode scanner
• Fixed problem that API PATCH operations to parts touched unrelated fields (issue #800)

Miscellaneous

• Updated dependencies
• Updated translations
• Updated documentation

New Contributors

• @b-nagaj made their first contribution in #788
• @vvekic made their first contribution in #795
• @Treeed made their first contribution in #810

Full Changelog: v1.14.5...v1.15.0

Part-DB 1.14.5

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

There is a new experimental docker image, which is much faster. See this post for more info.

You can help to translate Part-DB to other languages. See this post for more info.

Changes

• Updated docker container PHP to PHP 8.3
• Use a different format for log files (plain text instead of JSON encoding). This should be easier to read and output shorter lines (see #781)
• Fixed problem that PostgresSQL searches were case sensitive. Now they are case-insentive to have the same and more useful behavior as on SQLIte and MySQL (see #784)

Improvements

• Allow usernames to contain @ sign (as long as it is not the first char) to allow email addresses as username (see #772)

Bugfixes

• Fixed errors, when accessing Part-DB via link-local IPv6 addresses (#782)
• Allow longer error lines in docker container. (#781)
• Fixed problem that SAML users could not access API via tokens (#765)

Miscellaneous

• Updated dependencies
• Updated translations

Full Changelog: v1.14.4...v1.14.5

Part-DB 1.14.4

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

There is a new experimental docker image, which is much faster. See this post for more info.

You can help to translate Part-DB to other languages. See this post for more info.

Security fixes

Attention: This version contains updated versions of dependencies, that fix security issues under certain conditions. The only one that should be relevant for Part-DB is CVE-2024-50340 which is only possible if you have the register_argc_argv PHP option enabled. This should be disabled by default on most systems, still you should update Part-DB to the latest version, to avoid any risks.

Improvements

• Fixed typos in translation (thanks @mkne, PR #757)

Miscellaneous

• Updated dependencies

New Contributors

• @mkne made their first contribution in #757

Full Changelog: v1.14.3...v1.14.4

Part-DB 1.14.3

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

There is a new experimental docker image, which is much faster. See this post for more info.

You can help to translate Part-DB to other languages. See this post for more info.

Improvements

• Added Polish as available language (thanks to Gregory)
• Improved responsive layout, tables and part info page now looks better on mobile view (#755, thanks @dotsam )
• Show a warning message, when password set command is run in non-interactive mode, where no password can be entered
• Added a special API filter for tags, which makes searching for parts with a certain tag via API much easier (#750)

Bugfixes

• Fixed problem that OEMSecrets provider could not be enabled on docker installations (#742)
• Fixed/Avoid problems with non-Unicode character encodings of file imports (#749)
• Changed size and position of back-to-top button to avoid it overlapping form buttons (#737)
• Fixed problem with storage location sorting with Postgres database (#734)

Miscellaneous

• Updated dependencies

New Contributors

• @dotsam made their first contribution in #755

Full Changelog: v1.14.2...v1.14.3

Part-DB 1.14.2

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

There is a new experimental docker image, which is much faster. See this post for more info.

You can help to translate Part-DB to other languages. See this post for more info.

Bugfixes

• Fixed search and table filtering (issue #735)

Miscellaneous

• Updated dependencies
• Updated translations
• Improved documentation (#727, Thanks to @plaes)

New Contributors

• @plaes made their first contribution in #727

Full Changelog: v1.14.1...v1.14.2

Part-DB 1.14.1

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

There is a new experimental docker image, which is much faster. See this post for more info.

You can help to translate Part-DB to other languages. See this post for more info.

Bugfixes

• Fixed wrong translation of end-of-life status (#700)
• Fixed problem that non-admins could not add the authenticator app 2FA method to their account (#717)
• Fixed problem that document was non-scrollable when coming from a modal (like in the part merge process) (#696)
• Fixed importing of parameters on parts (#718)
• Generate the correct paths for tables endpoints, when serving Part-DB from a subdirectory (#724)
• Properly close the part search field and search options, when clicking outside (#701)

Miscellaneous

• Updated dependencies
• Updated translations

Full Changelog: v1.14.0...v1.14.1

Part-DB 1.14.0

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

There is a new experimental docker image, which is much faster. See this post for more info.

You can help to translate Part-DB to other languages. See this post for more info.

New features

• Added OEMSecrets info provider (thanks to @pdo59, #679)
• Show number of results of info provider search and a message, if no results were found

Bugfixes

• Fixed exception when undeleting elements with embeds structures (#685)
• Properly apply old data from history logs to embedded data in entities
• Fixed problems with image size in list views in certain constellations (thanks to @vergissberlin, #689)
• Do not treat package parameter as number in digikey provider (#682)
• Do not round parameter values, now the full double precision can be inputted (#681)

Docker images

• Updated docker image to debian bookworm
• Use PHP 8.2 in docker images
• Refactored Dockerfile (thanks to @duhow, #683)

Miscellaneous

• Updated dependencies
• Removed unnecessary dependencies
• Updated translations

New Contributors

• @duhow made their first contribution in #683
• @pdo59 made their first contribution in #679
• @vergissberlin made their first contribution in #689

Full Changelog: v1.13.3...v1.14.0

#Part-DB 1.13.3

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

There is a new experimental docker image, which is much faster. See this post for more info.

You can help to translate Part-DB to other languages. See this post for more info.

New features

• Prevent information leakage in twig mode label error messages (it contained the project file path before)
• Allow to create a new sub category based on the current selected category by typing -> into the search field (issue #666)
• Attachment IDs can now be viewed in attachments list table

Bugfixes

• Use correct field for real datasheet URL in LCSCProvider by @frank-f in #670
• data_uri filter can now be used for labels in twig mode (issue #665)
• Fixed exception, when label templates contained invalid twig code (issue #671)
• Fixed filtering logic for exclusion of a value in combination with empty values (issue #658)
• Return a 404 code, instead of 500, when the file of an attachment can not be served.
• Fixed asymmetric padding of footer in datatables

Miscellaneous

• Updated dependencies

Full Changelog: v1.13.2...v1.13.3