Dotfiles, utilities, and other apparatus.
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
 

10 lines
220 B

#!/bin/bash
sqlite3 "$HOME/notes/metadata.db" <<SQL
.mode list
.separator ' - '
SELECT '~/notes/vimwiki/' || page, title FROM pages
-- WHERE page LIKE 'log/%'
WHERE datetime IS NOT NULL
ORDER BY datetime DESC
SQL