Notes Sqlite

Voir :

https://www.linuxjournal.com/content/sqlite-secrecy-management-tools-and-methods

Voir aussi :

unqlite

PacketBase (Rest API pour SQLite)

sqlite databasename.sqlite .dump | sqlite3 databasename.sqlite3 sqlite3 base.db VACUUM;

There are a few steps to see the tables in an SQLite database:
List the tables in your database:
.tables
List how the table looks:
.schema tablename
Print the entire table:
SELECT * FROM tablename;
List all of the available SQLite prompt commands:
.help

Firefox

cd ~/.mozilla/firefox/*.default

Chercher un motif dans toutes les tables et champs

sqlite3 places.sqlite .dump |grep acme\.fr |awk '{print $3}' |sort -u

"moz_hosts"
"moz_favicons"
"moz_places"

Effacer

A faire : jointures

Méthode 1

sqlite3 places.sqlite
SELECT * FROM moz_hosts WHERE host LIKE "%plop.fr%" DELETE FROM moz_hosts WHERE host LIKE "%plop.fr%"

Méthode 2

cp -p places.sqlite places.sqlite.bck sqlite3 places.sqlite.bck .dump | grep -v 'plop\.fr' |sqlite3 places.sqlite

GUI

Liste :

Extension Firefox “SQLite Manager”

sqlitebrowser