Re: PSA: How to archive your EXACT homescreen(s) apps to Windows for perfect cross-platform backup/restore sans the net

Both prior methods easily created the "nova.db" SQL file on the desktop.

This python script spits out the results into a human-readable file.
  # -------------------------------------------------------------------
  # novasql.py 
  # Parse nova.db binary SQL database using "python novasql.py"
  # python novasql.py > result.txt
  # -------------------------------------------------------------------
  # v1p0 20260819 Spits out the nova.db into a human-readable text file
  # -------------------------------------------------------------------
  import sys
  import sqlite3
  
  # Force standard output to use UTF-8 encoding to avoid Windows charmap errors
  sys.stdout.reconfigure(encoding="utf-8")
  
  # Connect to your extracted nova.db
  conn = sqlite3.connect("nova.db")
  cursor = conn.cursor()
  
  try:
    # Query table names to verify schema if needed
    cursor.execute("SELECT name FROM sqlite_master WHERE type='table';")
    print("--- TABLES ---")
    for table in cursor.fetchall():
      print(table[0])
    print("\n--- ITEMS ---")
  
    # Query favorites table (adjust column names if needed based on your Nova version)
    cursor.execute("SELECT title, intent FROM favorites;")
    for row in cursor.fetchall():
      print(f"Title: {row[0]} | Intent/Package: {row[1]}")
  
  except sqlite3.OperationalError as e:
    print("Database structure notice:", e)
  
  conn.close()
  # end of novasql.py

The problem is the results are fugly... here's just a top of the result

  --- TABLES ---
  android_metadata
  appgroups
  drawer_groups
  customIcons
  favorites
  allapps
  
  --- ITEMS ---
  Title: None | Intent/Package: None
  Title: Apps | Intent/Package: #Intent;action=com.teslacoilsw.launcher.ACTION;launchFlags=0x10000000;component=com.teslacoilsw.launcher/.NovaShortcutHandler;S.LAUNCHER_ACTION=APP_DRAWER;end
  Title: Apps | Intent/Package: #Intent;action=com.teslacoilsw.launcher.ACTION;launchFlags=0x10000000;component=com.teslacoilsw.launcher/.NovaShortcutHandler;S.LAUNCHER_ACTION=APP_DRAWER;end
  Title: Apps | Intent/Package: #Intent;action=com.teslacoilsw.launcher.ACTION;launchFlags=0x10000000;component=com.teslacoilsw.launcher/.NovaShortcutHandler;S.LAUNCHER_ACTION=APP_DRAWER;end
  Title: Apps | Intent/Package: #Intent;action=com.teslacoilsw.launcher.ACTION;launchFlags=0x10000000;component=com.teslacoilsw.launcher/.NovaShortcutHandler;S.LAUNCHER_ACTION=APP_DRAWER;end
  Title: Nova Settings | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.teslacoilsw.launcher/.preferences.SettingsActivity;end
  Title: sys | Intent/Package: None
  Title: comms | Intent/Package: None
  Title: Settings | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.android.settings/.Settings;end
  Title: todo | Intent/Package: None
  Title: smtCalculator | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.simplemobiletools.calculator/.activities.SplashActivity.Orange;end
  Title: pic | Intent/Package: None
  Title: Camera | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.motorola.camera2/com.motorola.camera.Camera;end
  Title: GoogleContacts | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.google.android.contacts/com.android.contacts.activities.PeopleActivity;end
  Title: FM Radio | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.motorola.fmplayer/.ChangeThemeActivity;end
  Title: Email | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=org.dystopia.email/.ActivityMain;end
  Title: Messages | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.google.android.apps.messaging/.ui.ConversationListActivity;end
  Title: files | Intent/Package: None
  Title: auto | Intent/Package: None
  Title: Private Location | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.wesaphzt.privatelocation/.MainActivity;end
  Title: Simpletask | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=nl.mpcjanssen.simpletask/.Simpletask;end
  Title: Terminal Emulator | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=jackpal.androidterm/.Term;end
  Title: audio | Intent/Package: None
  Title: Audio Recorder | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.github.axet.audiorecorder/.activities.MainActivity;end
  Title: smtGallery | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.simplemobiletools.gallery.pro/.activities.SplashActivity.Orange;end
  Title: Yalp Store | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.github.yeriomin.yalpstore/.InstalledAppsActivity;end
  Title: Amaze | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.amaze.filemanager/.ui.activities.MainActivity;end
  Title: Simple Explorer | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.dnielfe.manager/.BrowserActivity;end
  Title: Tasks | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=org.tasks/com.todoroo.astrid.activity.TaskListActivity;end
  Title: My App List | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.projectsexception.myapplist/.MainActivity;end
  Title: Keepass2Android | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=keepass2android.keepass2android/crc64c98c008c0cd742cb.KeePass;end
  Title: App Backup & Restore | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=mobi.usage.appbackup/mobi.trustlab.appbackup.NewAppBackupActivity;end
  Title: App Backup & Restore | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=mobi.infolife.appbackup/.ui.viewpager.NewAppBackupActivity;end
  Title: Apk Extractor | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=axp.tool.apkextractor/.MainActivity;end
  Title: APK Export | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.ses.app.apkexport/.Main;end
  Title: Open Camera | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=net.sourceforge.opencamera/.MainActivity;end
  Title: F-Droid | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=org.fdroid.fdroid/.views.main.MainActivity;end
  Title: App Backup Lite | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.ruet_cse_1503050.ragib.appbackup.lite/.MainActivity;end
  Title: Barcode Scanner | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.google.zxing.client.android/.CaptureActivity;end
  Title: QR Code Reader | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=me.scan.android.client/.ui.ScanActivity;end
  Title: AddressToGPS | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=me.danielbarnett.addresstogps/me.danielbarnett.AddressToGPS.MainActivity;end
  Title: 2ndLine | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.enflick.android.tn2ndLine/authorization.ui.AuthorizationActivity;end
  Title: App Drawer | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=au.radsoft.appdrawer/.AppDrawer;end
  Title: List My Apps | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=de.onyxbits.listmyapps/.MainActivity;end
  Title: Binary Eye | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=de.markusfisch.android.binaryeye/.activity.SplashActivity;end
  Title: MuPDF viewer | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.artifex.mupdf.viewer.app/.LibraryActivity;end
  Title: AppOpsX | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.zzzmode.appopsx/.ui.main.MainActivity;end
  Title: BARIA | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.easwareapps.baria/.MainActivity;end
  Title: Compass | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.sgr_b2.compass/.activities.MainActivity;end
  Title: Here GPS Location | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.borneq.heregpslocation/.MainActivity;end
  Title: OpenTracks | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=de.dennisguse.opentracks/.introduction.IntroductionActivity;end
  Title: apk | Intent/Package: None
  Title: Keepass2Android | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=keepass2android.keepass2android/crc64c98c008c0cd742cb.KeePass;end
  Title: EDS Lite | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.sovworks.edslite/com.sovworks.eds.android.filemanager.activities.FileManagerActivity;end
  Title: smtCamera | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.simplemobiletools.camera/.activities.SplashActivity.Orange;end
  Title: smtDraw | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.simplemobiletools.draw.pro/.activities.SplashActivity.Orange;end
  Title: penguin | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.google.android.GoogleCamera/com.android.camera.CameraLauncher;end
  Title: OI Shopping List | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=org.openintents.shopping/.ShoppingActivity;end
  Title: ShoLi | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=name.soulayrol.rhaa.sholi/.MainActivity;end
  Title: Simply Do | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=kdk.android.simplydo/.SimplyDoActivity;end
  Title: Shopping List | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=privacyfriendlyshoppinglist.secuso.org.privacyfriendlyshoppinglist/.ui.main.SplashActivity;end
  Title: Shopping List | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.woefe.shoppinglist/.activity.MainActivity;end
  Title: 1List | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.lolo.io.onelist/.MainActivity;end
  Title: Notes | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.simplemobiletools.notes.pro/.activities.SplashActivity.Orange;end
  Title: notes | Intent/Package: #Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=com.bijoysingh.quicknote/com.maubis.scarlet.base.MainActivity;end