Sample Header Ad - 728x90

places.sqlite buggy? seems to behave abnormally. How to get $LAST_VISITED_URL?

0 votes
2 answers
55 views
I posted here . Here is my last-url.sh
#!/bin/bash
    
    rm  -rf /tmp/db.sqlite 
    cp ~/.mozilla/firefox/*.default-esr/places.sqlite /tmp/db.sqlite ;
    LAST_URL=sqlite3 /tmp/db.sqlite "select url from moz_places order by last_visit_date desc limit 1;";

    echo $LAST_URL
My script keeps giving me an example of a stackoverflow.com URL instead of the youtube.com one, even if I reload the page. Where is the issue hiding? I have only one xxxxxx.default-esr profile. Screenshot: firefox history sqlite database Testing Examples: the "google test" is a brand new visited URL, and the others were refreshed pages Now I ask myself how Firefox creates the history tab (it reflects the real history). Is it using which file or which SQL request on places? SQLite?
Asked by r01_mage (1 rep)
Mar 6, 2024, 10:01 PM
Last activity: Mar 9, 2024, 01:42 AM