EcDB Offers A Simple, Intuitive Way To Keep Your Electronic Inventory Organized

ecdb

One of the most important tools for any hacker or maker is organization. You might consider it more of a concept rather than a physical tool, but regardless of how you like to frame it, ensuring your tools and components are (nearly) always where they should be is key. As the odds and ends add up, it can sometimes be hard remembering exactly what you have on hand – that’s where the ecDB comes in handy.

Short for electronics component DataBase, the ecDB was created by [Nils Fredriksson], and offers a clean and intuitive way to keep tabs on what you have in-house. Many of us have used spreadsheets and notebooks to do the same, but ecDB allows you to record much more data than you could with either solution.

This is immediately clear within a moment or two of looking at the site’s interface. Not simply limited to listing part names and quantities, ecDB allows you to record manufacturer info, package type, and pin counts, while also allowing you to attach PDF datasheets and images of your components as well.

We really like system that [Nils] put together, and suggest giving it a spin to see if it will help you keep things organized in your workshop.

59 thoughts on “EcDB Offers A Simple, Intuitive Way To Keep Your Electronic Inventory Organized

      1. Before adding a BOM, parts need a better entry system.

        Maybe each part that users put in could be submitted to a global parts database, so one would only need to supply the part numbers and all other fields would be auto-propagated, even giving links to where to source the parts.

        Then creating the BOM is just a matter of adding a list of part numbers and quantities and the site does the rest: check if you have it in inventory, post the costs and totals from various vendors.

  1. Beautiful! I wish i had some money just to donate!

    One thing you should do is make either a stand-alone program or offer the code/images/etc… for others to host there own database. I would love this as a local intranet thing.

    Ill gladly pay for that as well!

  2. Awesome! I just wish it had a local version.

    As a side note, since it’s not local, and therefore not isolated to one’s own network/computer, I wonder if there could be a social element added to this system (I know that sounds counter-intuitive to engineer-types). So-and-so has 20 pcs of [insert name of rare-as-hell obsolete discontinued part here] that I desperately need because there’s no drop-in replacement for the expensive equipment I need to fix? Send a secure message with an offer.

    1. PS: At the moment I’m photo-documenting all my components, bagging them, and stuffing them into plastic totes. Organized? Not really. I can’t be absolutely sure I have something specific, but if I need something, I can pull up a directory specific to that tote (each tote has its own category of parts), and see if I have a part with the right specs and footprint. Editing each photo with text to describe the parts and its source, and overlaying closeups for IC markings is a royal pain though.

      I don’t have to blindly dig for parts anymore, but there are still plenty of issues with the system.

  3. This is really neat. I do wish there was a local version though since I often don’t have internet when I’m working on my projects, but I always have my laptop. But it seems to be very well done and has a nice interface for someone with an always available network connections.

  4. This is one of those times I am reminded how sometimes have way too little time to pursue an idea that’s been in my head for far too long. This is one of those times. Well done!

    I’ve been toying with this kind of database concept for a while, and I sketched out a prototype built using the Drupal CCK module but I never polished it up enough even for my own use.

    A few suggestions:
    1) Allow linking to possible part substitutes in the database
    2) Allow linking to manufacturer or Digi-Key part IDs (You can then attempt to automate magical part relationships for parts entered at different times)
    3) Make this “embeddable” by other websites somehow. Give maker workshops a reason to standardize on this as a platform and make your service part of their website. (Whether that’s a services API or affiliate accounts, I don’t know… but my point is this is a also social network database of who has what parts to spare… more people on board is better).

  5. A social addition to this would be awesome! But then the users would have to update profiles to include location and more info.

    If the source for this doesnt become open/available for local usage then ill have to make my own…

    Or if you add a export feature it would be great as well! Like some post above. Mainly so one can have a backup and also so one can possibly create a stand alone program and use that to import or as the actual database locally.

    I hope this grows more! Please update the site as much as possible :)

  6. Tried it out right away and it seems useful. I’m with the crowd that thinks there should be a STAND ALONE VERSION so that an internet connection is not required. Love the idea though of being able to buy, sell, trade, through the site. Perhaps this could be the business model that keeps this project progressing. Keeping an eye on this one.

  7. Great!

    I’ve been thinking about making a site like this for a few years now. It’s one of those things I would like to do but might never get around to. Now maybe I don’t have to.

    A few people mentioned adding a social aspect and one even mentioned being able to message others asking for parts. I really hope you do that as it was something I wanted to feature strongly in mine.

    Besides finding hard to get parts it would be nice to be able to list common ones as available for sale/trade. It’s often so much cheaper to buy parts in quantity when you only need a few. There are certain values of resistor for example that my grandchildren couldn’t ever run out of at this point! It would be great if people could exchange them with one another to get what they need.

    Selling is good to but I like that trade/exchange focus better. More of a maker community, not just another Ebay. There used to be a site called SwitchDiscs, later renamed to SwitchPlanet where people could list their CD collections (later books & DVDs too). It had it’s own currency ‘SwitchBucks’ which you could then buy/sell with. Using ‘SwitchBucks’ encouraged people to list their own stuff, keep trading rather than just buy what you wanted and go. You could buy SwitchBucks with real dollars though too.

    I don’t know how practical that was, I know they did have a problem controlling inflation. They had a lot of forum activity and a strong community though too. Maybe we could have something like that for components?

    Of course… one should have the ability to keep their stuff private too.

  8. Having just started developing products, managing my components is a huge challenge. So some wish-list type comments follow, thinking aloud..

    Take the lowly 1K resistor. I have some from china that cost .1 cents, some that cost 2 cents, some that cost 8 cents. I do like to have component cost be a part of my physical inventory, so I can make decisions on which I grab.

    So there is managing the physical inventory

    And managing the DB – adding and subtracting

    I don’t even want to mention doing physical inventory to reconcile differences. I think any system has to be good enough that you don’t slack off and get in a situation where your inventory records are out of date. But there is the temptation to use a component for a short term proto that you intend to take apart, and then not update the inventory…

    Also…… When I make an order on digikey or mouser, I need a system that will take the invoice (whether cut and paste or pdf) and automatically add it to my inventory. No way should I have to enter that stuff in manually.

    Thanks!

  9. It is cool and I was tempted to use it, however, please help me understanding what is the advantage versus doing this in Excel. Still have to type in the p/n, qty and price and do a manual update. Any good reason to use this program? (not trying to be a party-pooper, just trying to understand)

  10. Very cool. Actually I’ve coded something like that for my own needs.

    A nice feature would be the possibility to make lists of components (say, a BOM for a particular circuit), and export it as a CSV file, or even better directly export it to an order with one of the main distributors, like Mouse, Farnell, Digikey, etc … Most have some kind of API to allow this.

    1. As an American I was both amused by this, and saddened at the fact that America’s right-wing “culture warriors” still seek to boycott SI/metric until it’s inventors repent for being both atheist AND French.

      Ronald Reagan joked when he ripped down the dual US/SI highway signs, as he did when he had the White House solar panels destroyed.

      Mixing US Customary and Imperial is a common mistake, but they’re not the same standards. US Customary uses the same terms as Imperial, but they measure differently.

      1. Except everything the federal government does is in metric, and has been for some time.

        You should be worried about the left-wing and their assault on the working-class and turning our schools into propangada centers for Marxists.

    1. Wow way to skip over the current side discussion about Metric vs. US, and then convincingly be obtuse about it. I’m sorry if the history of metric in the US is so inconvenient and threatening – that’s science for ya.

  11. Thats great
    way more than arena and sap im used too
    humm it would be perfect with an application running with the ability to work offline
    webbrowsing can be so frustating with this stuff :D

  12. Personally I would NOT use it………..
    It puts all the prices and supplier contacts in a place where it is not secured , which can then be scraped and sold.
    Call me old fashioned, but I prefer to keep my suppliers data tightly under wraps.

  13. One thing for me would be location of the part(s) or items. I have tons of stuff, but can never remember the exact location, since I’ve seen it here, and seen it there, and saw it over there….

    Another thing would be linking to other people/ I belonged to a Electronics forum (that shall remain nameless) and the good thing about it was people sharing or offering parts.

    If you needed something off the wall, somebody had one and was willing to ship it to you. We all shared plenty of stuff, tools included.

    Perhaps a printable bar code, so you can print custom labels, print the bar code on the label, so when you need to reorder something, just scan it with your phone. Job done. Just select what info you want on the label, and it’s extracted and you can print one or more at a time.

  14. what about being able to generate QR labels and option to scan items from mobile/webcam to either add to you database or remove that item. This would make it one killer app for me.

  15. Heh, I automatically assumed this was something to set up on your own network/webspace. I’m not sure whether it’s better or worse that it isn’t. But this is VERY interesting.

    I agree that integration with big-name distributors, and an easy way to automatically get datasheets would be huge pluses.

    I’d probably want something I can deploy locally though, for security. (I don’t mean as in privacy, but as in long-term data security)

  16. Very nice, but I would take forever to count all my electronic parts. I have probably millions of electronic pieces, and everything is very organized. The small parts (capacitors, diodes, transistors, resistors, crystals, screws, etc) are stored in glass jars that cover up one of the walls of my basement. Medium things (heat sinks, metal pieces, etc) are stored in plastic boxes also on my basement. The vacuum tubes are stored in drawers. And the big things (motors, high power parts, wires, etc) are stored in some crates in my basement too.

    1. @Murtaugh – If your parts are well organized, it wouldn’t be a matter of adding a precise count, just indexing the parts you have and estimating.

      For me at least – it’s not about being able to FIND something, it’s about being able to inventory that I HAVE something and does it seem low or not.

      Then when I order some parts for a project, I can piggyback other things I am getting low on.

    1. Who said this is for profit? ecDB is open source… or plans to be i think. If not its not like im giving this source out. This is hackaday dude, what do you expect?

      People are fine when they take apart a company site to learn from and mimic but when a person does it to another person its like OMG why! get out of here!

      The entire PHP/MYSQL code is written by hand by me so whats wrong with me cloning the style? Bunch of haters. I have my own internal site now up and running for inventory.

      I still dont understand whats so wrong? I give him props and love his site. Im not hating his work. Cloning should be one of the most flattering signs. I like his work so much i decided to clone it.

      Im no artist but im a wiz at coding things. So i think me using his style isnt a issue. If its a issue with him let him tell me. I havent heard from him yet. Also im not using on my main site anymore. Its a internal thing. The one on my site is old and not updated.

  17. I’ve moved from cardfile to some of its clones, excel, onenotes (big mistake), Treepad worked well. Now using Cherrytree (http://www.giuspen.com/cherrytree/) very successfully, it has
    =Portable install,
    =Open source,
    =Non proprietary SQLite file.
    =Lots or import and export options
    =Supported and active
    =Real database
    =can save pics in the records if you don’t mind the filesize
    =Proper free format hierarchy
    =Runs on one of the original netbooks with no issues
    My requirements are simple
    1 – Future proof (export options if system becomes unsupported)
    2 – Flexible hierarchy
    3 – easy data input or updating – including links to online datasheets or ebay suppliers, pics, cross reference
    4 – Free format

    I keep and synchronise the database file on Google Drive for access anywhere or on a flashdrive
    Nothing like hours or days of data input to loose when the software becomes unsupported

  18. Hi to all;

    I don’t know anything about MySQL so, I’ve installed MySQL Community 5.7 but I don’t know how to link it with ecDB.
    Please, any help will be welcome. Thanks

Leave a Reply

Please be kind and respectful to help make the comments section excellent. (Comment Policy)

This site uses Akismet to reduce spam. Learn how your comment data is processed.