Close
0%
0%

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.
Following
Liked Like project

Just one more thing

To make the experience fit your profile, pick a username and tell us what interests you.

Pick an awesome username
hackaday.io/
Your profile's URL: hackaday.io/username. Max 25 alphanumeric characters.
Pick a few interests
Projects that share your interests
People that share your interests

We found and based on your interests.

Choose more interests.

OK, I'm done! Skip
Public Chat
Similar projects worth following
2.8k views
4 comments
1.6k followers
View Gallery
Public Chat
Part-DB is an Open-Source (AGPL 3.0) inventory managment system with a focus on electronic components (but can be used for other things too). It is installed on a web server and so can be accessed with any browser without the need to install additional software. GitHub Repo: https://github.com/Part-DB/Part-DB-server

If you want to try out Part-DB you can find a demo instance under https://part-db.herokuapp.com

See the GitHub Repo for more info.

Features include:

  • Inventory management of your electronic parts. Each part can be assigned to a category, footprint, manufacturer and multiple store locations and price information. Parts can be grouped using tags. You can associate various files like datasheets or pictures with the parts.
  • Multi-Language support (currently German, English, Russian, Japanese and French (experimental))
  • Barcodes/Labels generator for parts and storage locations, scan barcodes via webcam using the builtin barcode scanner
  • User system with groups and detailed (fine granular) permissions. Two-factor authentication is supported (Google Authenticator and Webauthn/U2F keys) and can be enforced for groups. Password reset via email can be setuped.
  • Optional support for single sign-on (SSO) via SAML (using an intermediate service like Keycloak you can connect Part-DB to an existing LDAP or Active Directory server)
  • Import/Export system (partial working)
  • Project management: Create projects and assign parts to the bill of material (BOM), to show how often you could build this project and directly withdraw all components needed from DB
  • Event log: Track what changes happens to your inventory, track which user does what. Revert your parts to older versions.
  • Responsive design: You can use Part-DB on your PC, your tablet and your smartphone using the same interface.
  • MySQL and SQLite supported as database backends
  • Support for rich text descriptions and comments in parts
  • Support for multiple currencies and automatic update of exchange rates supported
  • Powerful search and filter function, including parametric search (search for parts according to some specifications)
  • Automatic thumbnail generation for pictures
  • Integration with KiCad: Use Part-DB as central datasource for your
    KiCad and see available parts from Part-DB directly inside KiCad.

With these features Part-DB is useful to hobbyists, who want to keep track of their private electronic parts inventory, or makerspaces, where many users have should have (controlled) access to the shared inventory.

Part-DB is also used by small companies and universities for managing their inventory.

Documentation and installation guides can be found here: https://docs.part-db.de/ 

GitHub Repo: https://github.com/Part-DB/Part-DB-server

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

    Jan B. • 06/24/2024 at 11:49 • 0 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

  • Part-DB 1.11.0 - LCSC info provider, improved search and API

    Jan B. • 03/06/2024 at 11:50 • 0 comments

    LCSC info provider

    Part-DB now can use import part information from LCSC distributor. See documentation on how to use it.

    Improved search bar

    The search bar now makes suggestions for parts while typing. This should make searching much quicker in many cases.

    API improvements

    It is now possible to properly create new attachments and parameters on elements using the API like you would expect.

    Also, it is now possible to upload files to attachments via API and let Part-DB download URLs. See API docs for more info.

    Full changelog

    https://github.com/Part-DB/Part-DB-server/releases/tag/v1.11.1

  • Part-DB now featured on official KiCad website

    Jan B. • 02/19/2024 at 14:08 • 0 comments

    Part-DB is now featured on the official KiCad website under the external tools page:


    https://www.kicad.org/external-tools/

    Part-DB can be used with KiCad 8 as HTTP library as central inventory database.

  • Part-DB 1.10 - KiCad integration

    Jan B. • 12/07/2023 at 15:32 • 0 comments

    KiCad integration

    Part-DB now supports the experimental HTTP library feature in the KiCad nightly builds (KiCad 7.99). It allows to define metadata like the KiCad footprints and symbols on Part-DB parts and use Part-DB as libray inside KiCad.

    See here for more information.

    See Github release page for full changelog:

    https://github.com/Part-DB/Part-DB-server/releases/tag/v1.10.0

  • Part-DB 1.9.0 - Update existing parts from info providers, merge parts, part associations and more

    Jan B. • 11/25/2023 at 19:38 • 0 comments

    See Github release for full changelog:  https://github.com/Part-DB/Part-DB-server/releases/tag/v1.9.0

    ## Update existing parts
    Using the blue button in the tools tab on a part info page, you can update part info from an info provider. This means you can pull datasheets, price infos and more from digikey, octopart and more for existing parts.
    You still needs to review and manually choose what infos you wanna keep

    ## Merge parts
    You can now merge two parts together: If you have created two versions of the same part by accident, then you can now merge the two versions of the part into a single one. All information like datasheets, partLots, etc. are combined.

    ## Blue dot on newly created collection items
    Newly created items of a collection, which were not persisted to database yet, are marked with a blue dot on the delete item: 
    image

    This is especially useful when merging parts together or update parts from info providers. 

    ## Part Associations
    You can now associate part with each other. This can for example be used to denote alternative/compatible parts, or what part replaces an obsolete part.

  • Part-DB 1.8.0 - REST API, Mouser info provider and more

    Jan B. • 10/15/2023 at 15:00 • 0 comments

    With the new Version 1.8.0 release, Part-DB offers a REST API to let external applications interact with Part-DB.

    It allows reading and edit datastructures, parts and projects via an JSON based interface, so you can write your own software that interacts with Part-DB.
    To access the API an application requires an API token, which is generated on the users settings page. API access is experimental and must be enabled on a per user/group basis with the correct permission.

    See documentation for an introduction on how to use the API. In your Part-DB instance under the /api/ path you will find an interactive documentation, that shows you all available endpoints and allow you to try them out.

    You can look up all available endpoints and available parameters in the demo: https://part-db.herokuapp.com/api
    (you will need to login with username user and password user first)

    See the GitHub Release page for more info: https://github.com/Part-DB/Part-DB-server/releases/tag/v1.8.0

  • Version 1.6.0 - API Integration of Octopart, Digikey and more

    Jan B. • 07/31/2023 at 22:39 • 0 comments

    Part-DB now offers an information provider system, which allows you to query various cloud sources for part information.
    For now only creation of new parts is possible based on cloud providers, in later versions it will be possible to also merge the information in existing parts.

    The system is built to be universal, with just a little provider specific "driver" and the remain is done by Part-DB. That way it is pretty easy to integrate new data providers (so most likely other vendors and databases which offers APIs) into Part-DB.
    For now the following data sources (which use the distributor APIs) are available:

    • Octopart
    • Digikey
    • TME
    • Farnell / Element 14

    Depending on the provider, your created parts will automatically have a name, description, manufacturer and footprint info, part parameters, datasheets, pictures and shopping information/prices.

    See documentation for more info, especially on the configuration.

    You can test the new features in the demo (you need to login as user first).

  • Part-DB 1.3.0 - PartKeepr Import, Owner system and more

    Jan B. • 04/11/2023 at 12:14 • 0 comments

    Part-DB 1.3.0 was released and it offers a import/migration feature to import exsting PartKeepr databases to Part-DB and many more features.

    See release notes: https://github.com/Part-DB/Part-DB-server/releases/tag/v1.3.0

  • Import for parts

    Jan B. • 03/19/2023 at 21:51 • 0 comments

    With the new Part-DB 1.2.0 you can now import CSV files for parts. This allows you to migrate existing data into Part-DB.

    https://github.com/Part-DB/Part-DB-server/releases/tag/v1.2.0

  • Part-DB 1.1.0 - SAML Support

    Jan B. • 03/09/2023 at 15:23 • 0 comments

    With version 1.1.0 Part-DB now supports Single-Sign-On via SAML. Using a identity provider server like keycloak you can connect Part-DB to your central user managment, which should be especially useful for larger organizations like companies, universities or makerspaces.

    See https://docs.part-db.de/installation/saml_sso.html for more info

View all 13 project logs

Enjoy this project?

Share

Discussions

kriyasri wrote 08/07/2023 at 11:06 • point

hi

  Are you sure? yes | no

Vedran wrote 08/06/2023 at 13:04 • point

This is an awesome tool! For years, I've used local folders to try and save datasheets and lessons learned with different components, but wasn't too happy with that approach. I've set this up last night, started migrating data and so far, it's been great! Well done!


  Are you sure? yes | no

klemen.zurga wrote 03/10/2023 at 08:42 • point

I tried it and I think they are on the right path! Its simple to set up and it works okay.

  Are you sure? yes | no

Jarrett wrote 01/04/2017 at 20:08 • point

I want you to know that I'm still following this!

Plan on setting up an instance fairly soon and giving it a shot. I don't like any of the other options I've found for component management

  Are you sure? yes | no

Similar Projects

An site to share buildable kits
Project Owner Contributor

Kit Space

kaspar-emanuelKaspar Emanuel

Creation of modular, well characterized, and open source DNA vectors.
Project Owner Contributor

Standardized open source DNA vectors

koeng101koeng101

Happy Prototyping powered by Android
Project Owner Contributor

LabDroid

hrkltzhrkltz

Open source tuning tools for V8-powered GM vehicles from the early 2000s.
Project Owner Contributor

PCM Hammer

nsfwNSFW

Does this project spark your interest?

Become a member to follow this project and never miss any updates

By using our website and services, you expressly agree to the placement of our performance, functionality, and advertising cookies. Learn More

Yes, delete it Cancel

Report project as inappropriate

You are about to report the project "Part-DB - Open Source inventory software", please tell us the reason.

Send message

Your application has been submitted.

Remove Member

Are you sure you want to remove yourself as a member for this project?

Project owner will be notified upon removal.