Re:Working for a startup makes less sense, unless you are in...
by xondono on Tuesday March 26, 2019 @06:37PM
(#19496613)
Chris Gammell of Contextual Electronic and Amp Hour fame? Boy I better not screw this up! :D
Bad news: I use Altium
Good news: I’m trying out kicad on my spare time (feel free to take the credit)
As to the question, Altium is quite flexible in regards to using a database as a library, but it is riddled with bugs, workarounds and generally weird stuff. I’ve tried from the extremely simple to the overly complex. In that order:
- Easy level: Excel files on a shared NAS.
Pros:
* easy to set up.
* easy to convince management to try it out.
Cons:
* Not really a database
* You need to close Altium to add parts (this is very frustrating during sch capture)
- Medium level: Acces database (mdb) on a shared NAS
Pros:
* easy to set up (not as quite as excel but similar)
* you can add parts from inside Altium itself (with limited input interface)
Cons:
* because of how buggy Altium is the database tends to get completely corrupted. Almost daily backups are mandatory.
* You need to set up a form for part management, directly editing the mdb files is a path to disaster even with as little as 2 people.
Insane level: SQL server on AWS. Conected to local LAN through VPN. A simple php CRUD on apache for management.
Pros:
* Can handle heavish loads (a T2 micro can support about a dozen hardware engineers working in parallel)
* should be more scalable
* hides a lot of the complexity of the database for the junior engineers.
* small sized NAS won’t suffer while someone is generating a BOM.
* changes to database are more manageable if someone on the team knows sql.
* more reliable and resilient to altium bugs
Cons:
* No internet connection means no one works.
* possibly the most expensive solution
PS: I’m on my phone, I’ll reformat stuff when I get my pc to make it more legible
Bad news: I use Altium
Good news: I’m trying out kicad on my spare time (feel free to take the credit)
As to the question, Altium is quite flexible in regards to using a database as a library, but it is riddled with bugs, workarounds and generally weird stuff. I’ve tried from the extremely simple to the overly complex. In that order:
- Easy level: Excel files on a shared NAS.
Pros:
* easy to set up.
* easy to convince management to try it out.
Cons:
* Not really a database
* You need to close Altium to add parts (this is very frustrating during sch capture)
- Medium level: Acces database (mdb) on a shared NAS
Pros:
* easy to set up (not as quite as excel but similar)
* you can add parts from inside Altium itself (with limited input interface)
Cons:
* because of how buggy Altium is the database tends to get completely corrupted. Almost daily backups are mandatory.
* You need to set up a form for part management, directly editing the mdb files is a path to disaster even with as little as 2 people.
Insane level: SQL server on AWS. Conected to local LAN through VPN. A simple php CRUD on apache for management.
Pros:
* Can handle heavish loads (a T2 micro can support about a dozen hardware engineers working in parallel)
* should be more scalable
* hides a lot of the complexity of the database for the junior engineers.
* small sized NAS won’t suffer while someone is generating a BOM.
* changes to database are more manageable if someone on the team knows sql.
* more reliable and resilient to altium bugs
Cons:
* No internet connection means no one works.
* possibly the most expensive solution
PS: I’m on my phone, I’ll reformat stuff when I get my pc to make it more legible