Mac Finder – AC’s database files

for those interested in this type of thing….

Requirements:

  • Mac with Catalina OS
  • iPad with iOS 13+
  • AC version from 2.21 (available soon)
  • iPad and Mac connected via USB

Here’s a screenshot of my iPad in my Mac’s Finder

Finder showing my iPad's files

Finder showing my iPad’s files

 

Problems:

iPad not showing up in Finder? Here’s the fix!

AstroConnexionsUser.sqlite3 holds your chart files in the table AstroChartsList. This database can be inspected in the excellent free Mac app DB Browser for SQLite, which is the one I use.

DB Browser for SQLite

Please note if you are not familiar with databases, file structures, tables, sql, etc please do not ‘play’ around with AC’s databases. You may corrupt the database.

Deleting chart files in the table AstroChartsList.

  1. Close down AC on you iPad.
  2. Copy (drag and drop) the AstroConnexionsUser.sqlite3 database into DB Browser for SQLite. Delete the required files.
  3. Click on Write Changes.
  4. Inspect database to see if record is deleted.

It appears that this does not work.

However, here’s one method that appears to work ok: (for those that must! Note that I cannot guarantee that this will work.)

  1. Close down AC on you iPad.
  2. Copy (drag and drop) the AstroConnexionsUser.sqlite3 database into Finder. From finder drag and drop into DB Browser for SQLite.
  3. Delete the required files in the AstroChartsList table. Click on Write Changes.
  4. Drag and drop the database over the original database – as seen in the first screenshot above.
  5. Open AC. The deleted files should be missing.

Note: do not delete all the your chart records. Leave at least one chart record. 

However. It is highly recommended that DB Browser for SQLite is used to only inspect AC’s database. If you do decide to mess around – do a full back-up first then at least you will be able to do a restore if it all goes wrong! The responsibility is yours!

DB Browser for SQLite

DB Browser for SQLite

Back up your iPad

Requires:

  • Mac with Catalina OS (AFAIK)
  • iPad with iOS 13+

 

Back up iPad

Back up iPad

 

in BackupDatabaseMAC finder