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

Maria Sophia wrote:
> DB Browser for SQLite v3.13.1:File > Open database > nova.db
> This visually shows the entire Android homescreen SQL database on Windows.

Given some icons on my home screen are grayed out, like Vela
which I recently uninstalled and Gas Buddy which I never installed
after migrating my homescreen from one phone to another, I decided
to test out the Windows FOSS DB Browser for SQLite to look at them.

DB Browser for SQLite v3.13.1:File > Open database > nova.db
Execute SQL
SELECT * FROM favorites WHERE title LIKE '%gasbuddy%' OR title LIKE
'%vela%';
Run

Execution finished without errors.
Result: 2 rows returned in 29ms
At line 1:
SELECT * FROM favorites WHERE title LIKE '%gasbuddy%' OR title LIKE
'%vela%';


1187	GasBuddy	
#Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=gbis.gbandroid/com.gasbuddy.mobile.init.ui.InitActivity;end	
63	0	3.0	0.0	1.0	1.0	0	-1		
gbis.gbandroid/com.gasbuddy.mobile.init.ui.InitActivity			1787108341512	9	


-1	23	0				0	0	

2892	Vela Maps	
#Intent;action=android.intent.action.MAIN;category=android.intent.category.LAUNCHER;launchFlags=0x10200000;component=app.vela/.Launcher;end	
63	0	2.0	0.0	1.0	1.0	0	-1			BLOB		1787108341502	0	11	2	0				0	0	

It will take me a while to figure the grayed icons out.