Differences

This shows you the differences between two versions of the page.

--- 5_years_of_miscellaneous_notes [2025/02/03 19:12] – dougy147
+++ 5_years_of_miscellaneous_notes [2025/02/03 19:25] (current) – dougy147
@@ Line 1: / Line 1: @@
 <!DOCTYPE markdown>
-:!: Those are random notes I took when confronted to unique or recurrent problems.
+:!: This is a //pot pourri// of notes I took when confronted to unique or recurrent problems.
 Be careful as some of them could be obsolete. :-?
@@ Line 32: / Line 32: @@
 In `/etc/cron.d/certbot` I added `0 */12 * * * root certbot renew --no-random-sleep-on-renew && systemctl restart postfix dovecot`
-# Upgrade every OpenWrt packages
+# Upgrade every OpenWrt packages at once
 ```console
@@ Line 47: / Line 47: @@
 ```
-# Dump mysql database
+# Dump a mysql database
 ```console
@@ Line 55: / Line 55: @@
 ```
-# Sort in place and keep unique
+# Sort in place and remove duplicate lines
 ```
@@ Line 61: / Line 61: @@
 ```
-# Process substitution to filter an output to file but keep whole output in terminal output
+# Filter an output to file but keep whole output in terminal output
 ```
@@ Line 67: / Line 67: @@
 ```
-This will print "hello world" on screen, but keep only "world" in output.txt.
+This uses process substitution, and will print "hello world" on the screen, but keep only "world" in output.txt.
@@ Line 73: / Line 73: @@
 ```console
-# web history sorted by date
+# display web history sorted by date
-$ sqlite3 ~/.mozilla/firefox/**xxxx**.default-release-**xxxx**/places.sqlite "SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id"|sort
+$ sqlite3 ~/.mozilla/firefox/xxxx.default-release-xxxx/places.sqlite "SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id"|sort
-# unique urls visited
+# display all unique visited urls
-$ sqlite3 ~/.mozilla/firefox/**xxxx**.default-release-**xxxx**/places.sqlite "SELECT url FROM moz_places"
+$ sqlite3 ~/.mozilla/firefox/xxxx.default-release-xxxx/places.sqlite "SELECT url FROM moz_places"
 ```
@@ Line 122: / Line 122: @@
 Now you can write `echo "this is printed" # this is not`
-# Break lines when compiling ".md" to ".pdf" with pandoc
+# Break lines in code blocks when compiling ".md" to ".pdf" with pandoc
 Add this to the YAML header options: