tag:blogger.com,1999:blog-5304409.post1632947366399275137..comments2024-03-17T16:17:20.145-07:00Comments on Amit's Thoughts: Firefox cookie management with sqliteAmithttp://www.blogger.com/profile/12159325271882018300noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-5304409.post-85344574145654845602013-09-28T12:09:28.566-07:002013-09-28T12:09:28.566-07:00Amit,
Very nice solution. Thanks. Amit,<br /><br />Very nice solution. Thanks. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5304409.post-7056016054593252522013-04-19T05:44:55.214-07:002013-04-19T05:44:55.214-07:00Your example was pretty much what I was looking fo...Your example was pretty much what I was looking for. Thank you!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5304409.post-79597063654460790312012-10-14T04:24:44.051-07:002012-10-14T04:24:44.051-07:00Relating to this Article there is another Blog Art...Relating to this Article there is another Blog Article, wich serves a little bash script providing searching and deleting of Firefox Cookies: <a href="http://blog.ueffing.net/Anzeigen-und-Loeschen-von-Firefox-Cookies-ueber-Konsole-mit-sqlite3/" rel="nofollow">http://blog.ueffing.net/Anzeigen-und-Loeschen-von-Firefox-Cookies-ueber-Konsole-mit-sqlite3/</a><br />.https://www.blogger.com/profile/09195308458242040906noreply@blogger.comtag:blogger.com,1999:blog-5304409.post-50314820598395208812012-03-11T10:07:45.143-07:002012-03-11T10:07:45.143-07:00I use the CookieCuller addon, which has been aroun...I use the CookieCuller addon, which has been around since about 2004. It does the same thing by letting me protect specific cookies from deletion. Then I can let Firefox delete cookies, but those marked protected will be saved. All without having to install Python and run a script.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5304409.post-48795737813399137592012-02-21T05:08:53.614-08:002012-02-21T05:08:53.614-08:00Excellent post, this was very helpful to me. I'...Excellent post, this was very helpful to me. I'm running a linux terminal services setup where I needed to script cookie removal for potentially running Firefoxes. It turns out that Firefox 10 at least does not lock its cookie database, so I could do it easily using your script. Thanks a lot!Bart N.noreply@blogger.comtag:blogger.com,1999:blog-5304409.post-85583941404156695512010-01-20T13:43:45.346-08:002010-01-20T13:43:45.346-08:00Great stuff. But when firefox is running it locks ...Great stuff. But when firefox is running it locks database:<br />demon@comp:~$ python cookies.py<br />Traceback (most recent call last):<br /> File "cookies.py", line 20, in <br /> cursor.execute('DELETE FROM moz_cookies WHERE host IN (".kauno.diena.lt",".diena.lt")')<br />sqlite3.OperationalError: database is locked<br /><br />Any ideas how to unlock database to manipulate its tables while firefox is running?Dimonhttps://www.blogger.com/profile/05688837270246347368noreply@blogger.comtag:blogger.com,1999:blog-5304409.post-77423286522425430982009-08-11T10:18:01.448-07:002009-08-11T10:18:01.448-07:00hm maybe there's some FF addon which stops the...hm maybe there's some FF addon which stops the database file from locking while firefox is running?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5304409.post-83982241950784087522009-07-03T08:04:35.943-07:002009-07-03T08:04:35.943-07:00Hi Anonymous, sorry, I don't know of a way aro...Hi Anonymous, sorry, I don't know of a way around it. I just upgraded to 3.5 and can't run my script while Firefox is running. Fortunately I don't leave my browser running all the time so I will just have to run the script after I quit the app.Amithttps://www.blogger.com/profile/12159325271882018300noreply@blogger.comtag:blogger.com,1999:blog-5304409.post-48893480930628771312009-07-02T10:25:28.748-07:002009-07-02T10:25:28.748-07:00Hey Amit
in firefox 3.5 the database file seems t...Hey Amit<br /><br />in firefox 3.5 the database file seems to be locked while firefox is open so it can only be opened and edited when firefox is closed...<br /><br />do you know if there's a way round that?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5304409.post-25537602261616315122009-06-27T08:45:13.752-07:002009-06-27T08:45:13.752-07:00Yes, you can delete it if you don't want any c...Yes, you can delete it if you don't want any cookies. Or you can block cookies from the Firefox settings. The SQL approach is handy when you want to apply more complex rules.Amithttps://www.blogger.com/profile/12159325271882018300noreply@blogger.comtag:blogger.com,1999:blog-5304409.post-83420711531914146922009-06-27T07:06:44.644-07:002009-06-27T07:06:44.644-07:00Amit...understanding that you might want to keep s...Amit...understanding that you might want to keep some cookies can't I just delete the file and next time Fire fox opens it'll create a new [empty] file?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5304409.post-16877183225184020642009-06-10T08:47:36.803-07:002009-06-10T08:47:36.803-07:00Hemebond, the only options I found in Firefox were...Hemebond, the only options I found in Firefox were per-site, and it seemed to be to block cookies. I wanted to allow cookies from certain sites, and I also wanted to remove some of the cookies even on “trusted” sites. I got more control of this through a script. In the future I might build some histograms of which cookies are being issued, along with sizes and expiration dates.Amithttps://www.blogger.com/profile/12159325271882018300noreply@blogger.comtag:blogger.com,1999:blog-5304409.post-73361218998484412872009-06-10T00:59:00.653-07:002009-06-10T00:59:00.653-07:00Why not just tell Firefox to nuke any untrusted co...Why not just tell Firefox to nuke any untrusted cookies when you close Firefox?Hemebondhttps://www.blogger.com/profile/15744268786661573261noreply@blogger.com