{{tag>Brouillon DB}} # Notes Sqlite Voir : * https://www.linuxjournal.com/content/sqlite-secrecy-management-tools-and-methods Voir aussi : * unqlite * PocketBase (Rest API pour SQLite) * SQLCipher ~~~bash 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 ~~~bash cd ~/.mozilla/firefox/*.default ~~~ Chercher un motif dans toutes les tables et champs ~~~bash 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 ~~~bash sqlite3 places.sqlite ~~~ ~~~sql select * from moz_hosts where host like "%plop.fr%" delete from moz_hosts where host like "%plop.fr%" ~~~ Méthode 2 ~~~bash 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