EEVblog Electronics Community Forum
General => General Technical Chat => Topic started by: magsimoe 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/ (https://dev.smddb.com/)
Let me know what you think. :)
Thanks
-
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)
-
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.
-
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.
-
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.
-
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.