Actions
Forum Thread Details
  • Replies 10 replies
  • Subscribers 180 subscribers
  • Views 766 views
  • Users 0 members are here
Related

How about ODBC support for parts?

craigarno

I miss being able to connect to my MySQL parts database when I use Eagle.

 

OrCAD CIS and Altium Designer have this feature, and I find it a time

saver to be able to access parts and vendors I've already qualified for

prior designs. This does imply a simple relational database to relate

parts database entries to vendor database entries.

 

Windows installations require an ODBC database connection to my server's

MySQL database. Linux uses the native MySQL interface.

 

I use LibreOffice "Database/Base" to maintain the MySQL parts database

when the user interface in CAD tool I'm using is making a change

difficult. It's as easy as using Excel or Access, and a lot more flexible.

 

Parents

  • Hi Craig,

     

    ODBC support has been requested several times previously by a number of people, myself included. I agree it would be a nice addition.

     

    I have worked around this issue by writing a php interface to my back end database (in this case sqlite but the principle is the same for MySQL) running on nginx (or you could use apache or whatever) and then using ULP's network functions to interact with the database via this web interface. It actually works reasonably well although I still need to iron out a few wrinkles in my implementation and rewrite some of my code to be more elegant.

     

    Best Regards,

     

    Rachael

  • in reply to rachaelp

    On 05/22/2016 11:15 AM, rachaelp wrote:

     

    I have worked around this issue by writing a php interface to my back

    end database

     

    Would you be willing to share your PHP and ULP code?

     

    Thanks,

    Craig

     

     

Reply Children
No Data