No need to apologize, I have no Idea why you think I could feel insulted.
I just noted that this ādatabaseā thing is apparently important for a substantial group of people, and that it is a comparatively small effort to write an interface between KiCad and such an database.
I even find it likely that such tools already partly exist.
BOM tools are very near to export to a Database.
Some of the BOM tools integrate with spreadsheets.
Schematic symbols have custom fields for user defined data.
KiCost was made to get info from the web and combine with KiCad.
And there probably are more tools in this direction.
A custom field could for example be an UUID that defines a particular component class (0805 resistor, 0.05%, high stability) and the python scipt combines that with the value field to a completely specified symbol, and it complains if that value does not exist in that component type.
The main problem I see is the specifications of what these scripts should do exactly. Everybody seems to have their own and very specific demands of how they āneedā it to work.
Itās also being made more complicated because (as I understand it) KiCad is and wants to remain neutral. So no order codes from a specific manufacturer in KiCad, or tools that rely on specific websites.
Resistors are a good example, as they come in many sizes, qualities, values etc. What do you think of this workflow:
- Draw a schematic with default resistors (not even a footprint).
- Extract data from KiCad schematic, and compare with external database.
- Select specific component size / series / value etc in the database.
- Port all changes into KiCad schematic.
Another workflow would be to have KiCad libraries generated from database info, and then use only the preferred parts from that database.
New parts would then fist be (pre-modified) and extracted from KiCad, and the fields and graphic lines of schematic symbols would then get copied into the external database.
I see at least 2 ways of such a system getting started.
- First, someone can take up the scepter and implement exactly what they want for themself, and make it public. (It may exist already, as some companies internal secret sause)
- Some of the people who want such an database put their heads together to find some common ground and make a concise set of specifications that can be implemented by a software guy.
A common problem with Open Source program is to have a good lead in which direction to go. KiCad is doing marvelous in this regard, thanks to a small group of motivated and wise people who make the right decisions.
I use Open Source software exclusively, to the point that I rather donate money to an Open Source project, then pay less for a commercial program that works twice as good. And over the years Iāve seen quite some open source projects that get get abandoned or hump along without really getting anywhere.
Having some good well written specifications of how such a database interface should interact with KiCad would be a mayor step forward and increase itās chance of getting implemented. Some people do this for fun, and if they see such a document they think āHey, I can do that in a weekā, and then 2 months later it worksā¦