Notes Sqlite

Voir :

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

Voir aussi :

• unqlite
• PocketBase (Rest API pour SQLite)
• SQLCipher

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

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"

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

Liste :

• Extension Firefox “SQLite Manager”
• sqlitebrowser