Skip to content

Latest commit

 

History

History
45 lines (30 loc) · 1.51 KB

README.md

File metadata and controls

45 lines (30 loc) · 1.51 KB

Pure SQL Task Management CLI

demo

Features

View Tasks

- View all tasks : SELECT * FROM list_tasks();

- Current week view: SELECT week();

- Specific week view: SELECT week('YYYY-MM-DD');

- Current month view: SELECT month();

- Specific month view: SELECT month('YYYY-MM-DD');

- Search tasks: SELECT search('term');

- See stats and a burndown chart: SELECT stat();

Edit Tasks

- Add task: SELECT add('task: YYYY-MM-DD');

- Complete task: SELECT done('task');

- Delete task: SELECT delete('task');

- Update task: SELECT change('Old Task -> New Task: YYYY-MM-DD');

General Editor Commands

- Quit: \q enter enter  

- Scroll Downwards: enter

Installation

  1. Install psql (comes with PostgreSQL or you can use homebrew etc.)
  2. createdb task_manager
  3. git clone https://github.com/RohanAdwankar/pureSQLCLI.git
  4. cat pureSQLCLI/task.sql - | psql -d task_manager

Why was this made?

  • To improve my SQL fluency as previously I've only written small queries. To learn a language I usually make a CLI. I guess SQL is no exception!
  • Needed a quick task manager that didn't have all the excess features and bloat.
  • I thought it would be funny to have a fully functional CLI entirely in a .sql file.

Next Steps

  • I added all the features I needed but if you want something else feel free to open an issue and I'll get to it!