Hexylena's Project Management Tool

📁 Personal Project Manager

Metadata
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

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
TITLESTART_TIMEEND_TIME - START_TIME
⏰ Working on the project manager2024-07-30 08:00:0019738
⏰ Improving PM2024-07-31 08:41:414755
⏰ More dev work2024-08-06 09:04:0217345
⏰ More dev work2024-08-06 14:35:21108
⏰ More dev work 22024-08-06 14:46:12805
⏰ More dev work 32024-08-06 14:55:35573
⏰ More dev work 42024-08-06 15:07:4510
⏰ Adding support for notes in the time tracker2024-08-06 15:13:42151
⏰ Form for adding new notes2024-08-07 11:18:467200
⏰ Fixing sort order, template cleanup, edit button2024-08-12 13:45:207259

Tasks

SELECT title, created FROM tasks WHERE parent = '883892c6-0d44-4770-a912-0971e097f31a' AND type = 'task' GROUP BY Status order by created
Completed
✅ Remove 'project' concept
2024-07-29 10:07:02
✅ Swap out sql parser
2024-07-31 09:19:18

Photo by https://unsplash.com/@thematthoward on https://unsplash.com/photos/trees-on-fire-eAKDzK4lo4o

Children

TITLECREATEDAUTHOR
Project
📁 Design Docs2024-07-29 09:52:59 hexylena
📁 Web Editor2024-07-31 13:05:53 hexylena
Note
🗒 Adding Edit interface2024-08-12 15:13:54
Task
📝 Remove parsing of markdown AST, just render blocks as we have them2024-07-31 13:06:57 hexylena
📝 Add breadcrumbs going up to all root projects2024-07-31 13:31:24 hexylena
📝 stop adding tags2024-07-31 13:32:01 hexylena
📝 allow hiding the children section / collapsing by default2024-07-31 14:11:35 hexylena
📝 'upgrade' cli command2024-07-31 14:12:17 hexylena
📝 Add export/non-export flag2024-07-31 14:49:32 hexylena
📝 Auto-add author based on configured local identity2024-07-31 14:50:48
📝 How to 'continue' a time block2024-08-06 09:04:10
✅ Remove 'project' concept2024-07-29 10:07:02 hexylena
✅ Swap out sql parser2024-07-31 09:19:18 hexylena
✅ Handle missing projects dir2024-07-31 12:57:59 hexylena
✅ table views link to files are ugly2024-07-31 13:20:19 hexylena