📁 Personal Project Manager
Key | Value |
---|---|
🏷 Tags | #project |
🏷 Tags | #management |
👤 Assignee | hexylena |
👤 Author | hexylena |
Created | 2024-01-25 17:01:01 |
Modified | 2024-08-06 09:41:46 |
Contents
About
Explicit Target Audience
Academic weapons 🔪✨
User Stories
- I want to quickly add a task to be categorised later, I should just be able to write the title and be done, no other information required.
- I want to create a project
- I want to track a project, split it into subprojects (maybe work packages)
- I want to start a timer when I start working, it should record what I'm working on that I manually enter
- I want to share a grocery list with my partner
Important Links
Sub-projects
TITLE |
---|
📁 Web Editor |
📁 Design Docs |
Work Log
one of my insane ideas was that “i’d like my json files in a directory to be sort of a database queryable via SQL!” and so I implemented the world’s worst sql parser (subsequently replaced with a slightly better one in ✅ Swap out sql parser) that would let the user filter flattened json blobs from their “”“”“database”“”“”.
(This is roughly similar to notion’s ability to do the same, except probably worse and less friendly since their’s has nice dropdowns.)
SELECT title, start_time, end_time - start_time FROM tasks WHERE parent = '883892c6-0d44-4770-a912-0971e097f31a' AND type = 'log' order by start_time
TITLE | START_TIME | END_TIME - START_TIME |
---|---|---|
⏰ Working on the project manager | 2024-07-30 08:00:00 | 19738 |
⏰ Improving PM | 2024-07-31 08:41:41 | 4755 |
⏰ More dev work | 2024-08-06 09:04:02 | 17345 |
⏰ More dev work | 2024-08-06 14:35:21 | 108 |
⏰ More dev work 2 | 2024-08-06 14:46:12 | 805 |
⏰ More dev work 3 | 2024-08-06 14:55:35 | 573 |
⏰ More dev work 4 | 2024-08-06 15:07:45 | 10 |
⏰ Adding support for notes in the time tracker | 2024-08-06 15:13:42 | 151 |
⏰ Form for adding new notes | 2024-08-07 11:18:46 | 7200 |
⏰ Fixing sort order, template cleanup, edit button | 2024-08-12 13:45:20 | 7259 |
Tasks
SELECT title, created FROM tasks WHERE parent = '883892c6-0d44-4770-a912-0971e097f31a' AND type = 'task' GROUP BY Status order by created
Completed
2024-07-29 10:07:02
2024-07-31 09:19:18
2024-07-31 12:57:59
2024-07-31 13:20:19
Not Started
2024-07-31 13:06:57
2024-07-31 13:31:24
2024-07-31 13:32:01
2024-07-31 14:11:35
2024-07-31 14:12:17
2024-07-31 14:49:32
2024-07-31 14:50:48
2024-08-06 09:04:10
Photo by https://unsplash.com/@thematthoward on https://unsplash.com/photos/trees-on-fire-eAKDzK4lo4o
Children
TITLE | CREATED | AUTHOR |
---|---|---|
Project | ||
📁 Design Docs | 2024-07-29 09:52:59 | hexylena |
📁 Web Editor | 2024-07-31 13:05:53 | hexylena |
Note | ||
🗒 Adding Edit interface | 2024-08-12 15:13:54 | |
Task | ||
📝 Remove parsing of markdown AST, just render blocks as we have them | 2024-07-31 13:06:57 | hexylena |
📝 Add breadcrumbs going up to all root projects | 2024-07-31 13:31:24 | hexylena |
📝 stop adding tags | 2024-07-31 13:32:01 | hexylena |
📝 allow hiding the children section / collapsing by default | 2024-07-31 14:11:35 | hexylena |
📝 'upgrade' cli command | 2024-07-31 14:12:17 | hexylena |
📝 Add export/non-export flag | 2024-07-31 14:49:32 | hexylena |
📝 Auto-add author based on configured local identity | 2024-07-31 14:50:48 | |
📝 How to 'continue' a time block | 2024-08-06 09:04:10 | |
✅ Remove 'project' concept | 2024-07-29 10:07:02 | hexylena |
✅ Swap out sql parser | 2024-07-31 09:19:18 | hexylena |
✅ Handle missing projects dir | 2024-07-31 12:57:59 | hexylena |
✅ table views link to files are ugly | 2024-07-31 13:20:19 | hexylena |