diff options
| author | Anthony Wang | 2024-01-02 23:47:05 +0000 |
|---|---|---|
| committer | Anthony Wang | 2024-01-02 23:47:05 +0000 |
| commit | 479101f2700abf341d056432dfd9d96d269caaf9 (patch) | |
| tree | 4d7d174a62726e7f9d03b159a86580b46aebb8e0 | |
| parent | 97722764e82b3748a6ec60574fd3d3752048c101 (diff) | |
Add tips and tricks for common operations
| -rw-r--r-- | README.md | 9 |
1 files changed, 9 insertions, 0 deletions
@@ -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 |