From 479101f2700abf341d056432dfd9d96d269caaf9 Mon Sep 17 00:00:00 2001 From: Anthony Wang Date: Tue, 2 Jan 2024 23:47:05 +0000 Subject: Add tips and tricks for common operations --- README.md | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/README.md b/README.md index f3f77e7..9319663 100644 --- a/README.md +++ b/README.md @@ -27,3 +27,12 @@ Go version: ./sd < test ``` The C port is about 30% faster than the original Go code. + +## Tips and tricks + +- View card deck: `sqlite3 cards .dump` +- Get total number of cards: `sqlite3 cards "SELECT COUNT(*) FROM cards"` +- Get total number of cards with positive weight: `sqlite3 cards "SELECT COUNT(*) FROM cards WHERE weight>0"` +- Search for string in keys: `sqlite3 cards "SELECT * FROM cards WHERE key LIKE '%hello%'"` +- Add card to deck: [sd-add.fish](sd-add.fish) +- Edit deck: [sqlitevi.fish](sqlitevi.fish) or sqlitebrowser -- cgit v1.2.3-70-g09d2