Clever Geek Handbook

Accessing .sqlite db from phpmyadmin? FF cookies

I am trying to view my Firefox cookies (cookies.sqlite). Since I have never accessed the dbs with anything other than phpmyadmin, I don't understand how to view the contents of this sqlite file. There's localhost / sqlitemanager, but I'd rather stick with the phpmyadmin interface I'm used to.

Any ideas how I can open / view this sqlite db in the normal way in phpmyadmin? Is it possible?

Thank you in advance

PS I know that browser cookies are very often accessed / played. If you know of another tool more specific for this purpose, please write me an answer or suggest in the comments.

+2


source to share


3 answers


There are also several web interfaces for sqlite.

phpSQLiteAdmin

SQLiteManager

Simple SQLite Manager

SQLite Admin



WizSQLiteAdmin

ezSqliteAdmin

SQLiteWebAdmin

knoda

I haven't tried any of them yet - in fact, I found this SO question while researching sqlite web interfaces for my own use. But I am also coming from phpMyAdmin background, so the first one I plan to try is phpSQLiteAdmin.

+3


source


I guess there are various GUI programs out there that will hold your hand. However, I will show you what I would do if I was interested in a table moz_cookies

in db cookies.sqlite

.

$ 
$ sqlite3 cookies.sqlite
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> .schema
CREATE TABLE moz_cookies (id INTEGER PRIMARY KEY, name TEXT, value TEXT, host TEXT, path TEXT,expiry INTEGER, lastAccessed INTEGER, isSecure INTEGER, isHttpOnly INTEGER);
sqlite> select * from moz_cookies limit 1;
1248713741170186|PREF|ID=12d44375be9e7c86:U=d07dae1b87f4537c:LD=en:NR=100:TM=1248713740:LM=1254091506:FV=2:IG=3:S=Jdo_PXt92J5ojL6E|.google.com|/|1317163505|1255144201180851|0|0
sqlite>

You may need the sqlite3 CLI program. It is available on Unix and Windows.



SQLITE3(1)                                                          SQLITE3(1)

NAME
       sqlite3 - A command line interface for SQLite version 3

SYNOPSIS
       sqlite3 [options] [databasefile] [SQL]

SUMMARY
       sqlite3  is  a  terminal-based front-end to the SQLite library that can
       evaluate queries interactively and display the results in multiple for‐
       mats.  sqlite3 can also be used within shell scripts and other applica‐
       tions to provide batch processing features.

DESCRIPTION
       To start a sqlite3 interactive session, invoke the sqlite3 command  and
       optionally  provide  the name of a database file.  If the database file
       does not exist, it will be created.  If the database file  does  exist,
       it will be opened.

It has two categories of operations.

Commands that target the interactive shell itself start with .

. This is all a SQL query completed as usual with ;

.

+1


source


Adminer is a PHPMyAdmin-like system that supports MySQL, PostgreSQL, SQLite , MS SQL, Oracle, SimpleDB, Elasticsearch, MongoDB, etc.

0


source






More articles:


All Articles