Dated history in Browser?

Using /e/OS Applications
1

Hello !

I would like to retrieve the datetime of each history entry, to find an history at a specified datetime. But the history has no information about datetime.
Is it possible to have that in the data files, for instance ? Where and how the history is stored ?

Thanks for your help ! :slight_smile:

Regain your privacy! Adopt /e/OS the deGoogled mobile OS and online servicesphone

2

From what I see the onboard-browser´s history entries are grouped on a per day basis (under each date all sites that were opened at that day are listed - or is that only true for the recent part?)

Not exactly what you asked for… but you could try search terms and maybe that limits the entries to an extent that allows you to find the entry that you are looking for with much less scrolling (?)

3

thanks for your answer.

I am interested to see what I was doing at a date and a particular time.So i need to see the time of the history.

1 Like
4

do you have adb root in a community build? then you can pull the foundation.e.browser sqlite db from its data directory and query that one. There used to be a content query provider by chrome to do this more easily from the regular adb shell, but that got deprecated long ago.

5

Thank you tcecyk.

I have used adb, but not sure about the root and community build :grin:
My /e/OS build is e_FP3-user 12 TQ3A.230901.001.eng.root.2025312.145659

can you remind me the adb commands to use and the path to the sqlite file ? I will explore the file with sqlite3 command.

Thank you !

6

version string more telling than build string for adb root option (it’s 1-2 lines down from enabling adb in dev settings). The “user” build type is spoofed in community builds too.

Anyway, this is the pull and query:

adb pull /data/data/foundation.e.browser/app_chrome/Default/History
echo "select u.url,datetime(v.visit_time / 1000000 + (strftime('%s', '1601-01-01')), 'unixepoch', 'localtime') from urls u inner join visits v on v.url=u.id;" | sqlite3 History
7

Here is the version string : 2.9-t-20250321478215-official-FP3

8

Thanks @tcecyk !
That worked very well ! :blush: :pray:

9

ah interesting, so the official FP3 build has enabled adb root still? pirates arrrr

2 Likes