Author Topic: Open SMD markings DB  (Read 1240 times)

0 Members and 1 Guest are viewing this topic.

Offline magsimoeTopic starter

  • Newbie
  • Posts: 1
  • Country: se
Open SMD markings DB
« on: June 02, 2022, 02:31:34 pm »
Just watched "EEVblog 1475 - What's This SMD Part?" yesterday and someone in the comments mentioned the need for an open database with smd markings.

It sounded like a good idea so I started working on it this morning and would love for you guys to check it out.
Any feedback is welcome. Good or bad.

I've just spent a couple hours on this but it seems to work ok.
https://dev.smddb.com/

Let me know what you think.  :)
Thanks
 
The following users thanked this post: thm_w, MuhScopeBroke

Offline mariush

  • Super Contributor
  • ***
  • Posts: 5247
  • Country: ro
  • .
Re: Open SMD markings DB
« Reply #1 on: June 02, 2022, 04:34:23 pm »
I wouldn't waste my time adding parts, if the website has no way of downloading the "database". A basic json export, a csv, anything, a weekly backup would be fine.
Lots of websites come and go, and your website will only be up as long as you're willing to pay for the domain name.
One could spend maybe half an hour in Python to load the json/csv in memory (or convert it to a sqlite database) and do a quick search, without having to use the website.

Didn't get to the add part because you need to sign up so I don't know what can you enter.   Hopefully one can enter category like "ldo", "switching regulator" , "opamp" etc and one or several packages.
The ability to filter by category (or at the very least group and move to front the parts which are that category) when you're sure it's a switching regulator for example, or by pin count would be a bonus.
 
Went through some sites searching for things like "1A"  when I had a mosfet with "1A=2C" written on it, and the first website I used dumped 50 linear regulators and "voltage detector ICs" but wouldn't allow me to specify that it's a 6 pin part, and most likely a mosfet/power stage (mosfets + drivers built in)
« Last Edit: June 02, 2022, 04:37:12 pm by mariush »
 

Offline thm_w

  • Super Contributor
  • ***
  • Posts: 9021
  • Country: ca
  • Non-expert
Re: Open SMD markings DB
« Reply #2 on: June 02, 2022, 10:04:22 pm »
For 2 hours work I'm impressed.

It would be good if you could scrape all existing reliable databases, to sort of get everything in one spot first.
The problem is, unsure of the legality of this, and, you risk getting bad data in.


Didn't get to the add part because you need to sign up so I don't know what can you enter.   Hopefully one can enter category like "ldo", "switching regulator" , "opamp" etc and one or several packages.
The ability to filter by category (or at the very least group and move to front the parts which are that category) when you're sure it's a switching regulator for example, or by pin count would be a bonus.
 
Went through some sites searching for things like "1A"  when I had a mosfet with "1A=2C" written on it, and the first website I used dumped 50 linear regulators and "voltage detector ICs" but wouldn't allow me to specify that it's a 6 pin part, and most likely a mosfet/power stage (mosfets + drivers built in)

Part number, description, marking, manufacturer, package.

Further filtering or sorting doesn't seem to be possible yet (eg. search for "1A mosfet"), as search only looks at part number and code.
I guess the best way to do this is maybe have a package and type dropdown, or additional search entry boxes with autofill as OP already did for entering a new part.
« Last Edit: June 02, 2022, 10:11:36 pm by thm_w »
Profile -> Modify profile -> Look and Layout ->  Don't show users' signatures
 

Offline DavidAlfa

  • Super Contributor
  • ***
  • Posts: 6819
  • Country: es
Re: Open SMD markings DB
« Reply #3 on: June 02, 2022, 11:19:27 pm »
Legality of creating a database to identify manufacturer markings?  Sorry, what? :-//

That's a good idea and it would be even greater in long-term, when it grows up.
« Last Edit: June 02, 2022, 11:21:14 pm by DavidAlfa »
Hantek DSO2x1x            Drive        FAQ          DON'T BUY HANTEK! (Aka HALF-MADE)
Stm32 Soldering FW      Forum      Github      Donate
 

Offline E-Design

  • Regular Contributor
  • *
  • Posts: 211
  • Country: us
  • Hardware Design Engineer
Re: Open SMD markings DB
« Reply #4 on: June 02, 2022, 11:27:14 pm »
a good idea in principle.. my advice: lose the login requirement. People cant be bothered with another login / password / reset password gizmo and time waster for such a website that gets rarely used. I know I wont.
That might open the door to spamming and what not, so find another way to moderate the posts / database but no login.
The greatest obstacle to discovery is not ignorance - it is the illusion of knowledge.
 

Offline thm_w

  • Super Contributor
  • ***
  • Posts: 9021
  • Country: ca
  • Non-expert
Re: Open SMD markings DB
« Reply #5 on: June 03, 2022, 12:56:27 am »
Legality of creating a database to identify manufacturer markings?  Sorry, what? :-//

That's a good idea and it would be even greater in long-term, when it grows up.

Legality of copying existing databases is what I'm talking about.
So you can search this site and know that everything found on google is covered already.

a good idea in principle.. my advice: lose the login requirement. People cant be bothered with another login / password / reset password gizmo and time waster for such a website that gets rarely used. I know I wont.
That might open the door to spamming and what not, so find another way to moderate the posts / database but no login.

It takes like 10 seconds to register, and any decent contributor is capable of using Lastpass/etc., you don't need to remember anything.
Profile -> Modify profile -> Look and Layout ->  Don't show users' signatures
 


Share me

Digg  Facebook  SlashDot  Delicious  Technorati  Twitter  Google  Yahoo
Smf