{{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

<code bash>
sqlite databasename.sqlite .dump | sqlite3 databasename.sqlite3
sqlite3 base.db VACUUM;
</code>


<code ->
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
</code>

== Firefox

<code bash>
cd ~/.mozilla/firefox/*.default
</code>

Chercher un motif dans toutes les tables et champs
<code bash>
sqlite3 places.sqlite .dump |grep acme\.fr |awk '{print $3}' |sort -u
</code>

<code ->
"moz_hosts"
"moz_favicons"
"moz_places"
</code>



=== Effacer

** A faire : jointures **

Méthode 1

<code bash>
sqlite3 places.sqlite
</code>

<code sql>
select * from moz_hosts where host like "%plop.fr%"
delete from moz_hosts where host like "%plop.fr%"
</code>

Méthode 2

<code bash>
cp -p places.sqlite places.sqlite.bck
sqlite3 places.sqlite.bck .dump | grep -v 'plop\.fr' |sqlite3 places.sqlite
</code>

== GUI

Liste :

* Extension Firefox "SQLite Manager"
* sqlitebrowser