Différences

Ci-dessous, les différences entre deux révisions de la page.

--- tech:notes_sqlite [2025/03/24 15:06] – créée - modification externe 127.0.0.1
+++ tech:notes_sqlite [2026/06/07 19:12] (Version actuelle) – modification externe 127.0.0.1
@@ Ligne 1: / Ligne 1: @@
+<!DOCTYPE markdown>
+{{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