You are only browsing one thread in the discussion! All comments are available on the post page.

Return

Kuujaku , (edited )
@Kuujaku@kbin.social avatar

Submitted: 2023-06-21
Received: 2023-07-06

8 year old account.

EDIT: (for Firefox) If you can't remember the date and want to know, you can get it by opening your firefoxes profile directory -> find places.sqlite -> open it with sqlite3 command line or with some gui software and execute this:

SELECT datetime(visit_date/1000000,'unixepoch') AS visit_date, url, title
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id AND url LIKE '%https://www.reddit.com/settings/data-request%';

EDIT: Added received date

Gamers_Mate ,

For firefox on windows which sqlite manager extension should I use? The SQLite Manager I found says "This add-on is not actively monitored for security by Mozilla. Make sure you trust it before installing."

abff08f4813c OP ,

I've only tried using sqlite from the command line, but binaries in a zipfile are available for windoze.

Kuujaku ,
@Kuujaku@kbin.social avatar

I had this picture in my head that sqlite-manager by lazierthanthou was still available, but now looking into it seems like it has been abandoned for quite some time. My bad! But about this "new" add-on i do not know.
For command line use you can use the binaries like @abff08f4813c said, which can be found here or some gui program like for example DB Browser

Gamers_Mate , (edited )

Awesome thankyou.
Submitted 2023-06-22
Received 2023-07-09

(It feels weird putting the year and month before day.)

Edit: I finally got to delete my account.

  • All
  • Subscribed
  • Moderated
  • Favorites
  • random
  • [email protected]
  • All magazines