Offline Version of database #83

Open
opened 2020-12-04 13:26:42 +00:00 by gaetano83 · 10 comments
gaetano83 commented 2020-12-04 13:26:42 +00:00 (Migrated from github.com)

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.

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.
jlublin commented 2020-12-15 15:52:39 +00:00 (Migrated from github.com)

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:

  1. Install the SQLite3 ODBC driver from http://www.ch-werner.de/sqliteodbc/
  2. In Altium, create a new Database Library
  3. Choose "Use connection string"
  4. 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
  5. Connect and save the .DbLib inside the altium-library/-directory.
  6. Now you should be able to add it to your libraries.
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](https://github.com/issus/altium-library/files/5696845/celestial-2020-12-15.sqlite3.zip) Instructions: 1. Install the SQLite3 ODBC driver from http://www.ch-werner.de/sqliteodbc/ 2. In Altium, create a new Database Library 3. Choose "Use connection string" 4. 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 5. Connect and save the .DbLib inside the altium-library/-directory. 6. Now you should be able to add it to your libraries.
ing-kuczmik commented 2020-12-15 17:06:46 +00:00 (Migrated from github.com)

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.

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.
TheRealHumaniac commented 2021-01-02 18:19:11 +00:00 (Migrated from github.com)

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.
jlublin commented 2021-01-10 08:16:51 +00:00 (Migrated from github.com)

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.

> 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.
MrZANE42 commented 2021-02-05 10:26:28 +00:00 (Migrated from github.com)

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.

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.
MrZANE42 commented 2021-05-11 12:51:35 +00:00 (Migrated from github.com)

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

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
adityadrs commented 2021-10-15 18:08:18 +00:00 (Migrated from github.com)

@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 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.
adityadrs commented 2022-07-09 06:42:49 +00:00 (Migrated from github.com)

@jlublin any chance you can do that?

@jlublin any chance you can do that?
mukeshnagal90 commented 2022-08-17 16:42:50 +00:00 (Migrated from github.com)

@jlublin Can you please provide us latest database to deploy it offline. It would be great support for us. Kindly help out.

@jlublin Can you please provide us latest database to deploy it offline. It would be great support for us. Kindly help out.
mukeshnagal90 commented 2022-08-17 16:46:47 +00:00 (Migrated from github.com)

@jlublin It will also be great if you can share now script with us to download database in sqllite3 locally. Please share your script.

@jlublin It will also be great if you can share now script with us to download database in sqllite3 locally. Please share your script.
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: AllSpice-Demos/Altium-Celestial-library#83
No description provided.