matthewlai / JLCKicadTools

Tool for using JLCPCB assembly service with KiCad
GNU General Public License v3.0
340 stars 60 forks source link

sqlite3 vs pandas #74

Closed DanielO closed 2 years ago

DanielO commented 2 years ago

Hi, I wanted to try this plugin but had trouble because I'm using OSX and the way it attempts to install pip doesn't work because OSX won't load the unsigned numpy extensions into KiCAD (which is signed). It also appears to break the KiCAD install, although maybe that was something else.

I pondered making a pure python parser but figured it would be too slow, then I realised I can use sqlite3 for most of the heavy lifting.

My code is at https://github.com/DanielO/JLCKicadTools/tree/sqlite if you want to take a look.

The most horrible part is loading into the DB - I had it call the iconv binary to convert from gbk to UTF-8 (sqlite does not support many encodings).