altium-library
altium-library copied to clipboard
issus
Offline Version of database
Is it possible to have an offline version of the database? Firewall issues and lack of internet connection prevent many users from using the library.
I have tested today and it is possible. I performed this test by writing a script which simply cloned the tables needed from the database and stored it into a local SQLite3 database. However the local database is currently 117 MiB and since that could amount to a lot of data transfers if run often I'm keeping this script for myself until given an OK by the project owner (or maybe a better solution was if a daily or weekly file could be made available by the project)
In the mean time you can try the following snapshot (zip ~10 MiB). celestial-2020-12-15.sqlite3.zip
Instructions:
- Install the SQLite3 ODBC driver from http://www.ch-werner.de/sqliteodbc/
- In Altium, create a new Database Library
- Choose "Use connection string"
- Use the connection string from https://www.connectionstrings.com/sqlite3-odbc-driver/ but replace the "Database" path with the path to your SQLite3 DB file
- Connect and save the .DbLib inside the altium-library/-directory.
- Now you should be able to add it to your libraries.
I find it a good direction to offer a backup. I don't want to hope that the database will still exist in 3 years.
This is a great idea. I appreciate your work very much. The offline database created according to your instructions works flawlessly!
Is it possible that the snapshot DB is not quite complete? E.g. I did not find the "Antenna" or the "Connector - Amphenol" parts. This is not a big deal, but if you could provide a complete library, that would be great.
This is a great idea. I appreciate your work very much. The offline database created according to your instructions works flawlessly!
Is it possible that the snapshot DB is not quite complete? E.g. I did not find the "Antenna" or the "Connector - Amphenol" parts. This is not a big deal, but if you could provide a complete library, that would be great.
I had a look at portal.altiumlibrary.com (db: "altium_library") and i see the same tables, or views actually, as I have in the sqlite database. There is however a table called "RF - Antennas", is that the one you were looking for? Also I checked and there are no new updates to the database so "celestial-2020-12-15.sqlite3.zip" is still up to date.
Regarding offline version of the database it would great if the users (us) would get "SHOW VIEW" privileges. That would mean that we wouldn't have to redo the views our self when creating an offline clone.
Is there any of the contributors/creators reading these issues? Would very much like to know if it's possible to get the "sql create" lines for the views, or if the "SHOW VIEW" privilege could be added to standard users. This would saves some time instead of having to reverse engineer them in order to create a offline synced version
@jlublin can you check if there is any update to the library? I am looking to deploy it locally and would really prefer if it is the latest update (the one you have uploaded here is around 10 months old). Much appreciated.
@jlublin Can you please provide us latest database to deploy it offline. It would be great support for us. Kindly help out.
@jlublin It will also be great if you can share now script with us to download database in sqllite3 locally. Please share your script.
As i've said on discord and other issues, this is NOT a supported way of using the database. Database usage is monitored, if you are downloading the whole database its going to look just like someone crawling the db maliciously and is likely to get your account banned.
I don't really understand why a public library cannot be available on a computer without an internet? In any case, you will have to convert it to integrated in real time...
In the form that she now does not work normally... Altium freezes strongly when the library is turned on because the server part is on their side
Try this! https://github.com/ximtech/altium-migrator.git & https://github.com/ximtech/altium-library.git It worked for me now i can load my components in offline(except price and stock info).
