--- urn: "urn:penemure:a238ec94-5136-48c5-8567-7d2644fda113" backend: "pub" ancestors: - 📁 Penemure created: 2025-01-21 20:21:35.662313+00:00 updated: 2025-02-11 07:46:03.180589+00:00 tags: --- # 📓 design docs Here we'll keep track of some of the design documentation/planning 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 📓 SQLish ) 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.) ```query-cards GROUP SELECT urn, title_plain AS title, SUBSTRING(blurb, 1, 40) AS blurb, type FROM __all__ WHERE parents LIKE '%SELF%' GROUP BY type ORDER BY title_plain ASC ``` urn | title | blurb | type --- | ----- | ----- | ---- urn:penemure:9cc10c76-c478-4b93-8fbd-b799c99d9623 | 📓 Notion Data Model Comparison | Conceptually we have arrived at a result | note urn:penemure:7348525e-f231-4dda-bf6a-f0dc3309dadc | 📓 Tags | not sure i'm happy with the tags impleme | note urn:penemure:24395582-6805-466a-a706-013bce042f3e | 📓 Thoughts on "Separation of Concerns" | **[Separation of Concerns](https://www.c | note urn:penemure:f2929c20-6e87-442b-a0a1-2db57b9e6108 | 📓 Use git trailers? | [see this](https://alchemists.io/article | note urn:penemure:4f07407a-62ba-4842-86bf-d9e111a749e0 | 📓 blocks or markdown | Blocks or Markdown, the eternal question | note urn:penemure:45d21e13-cb52-4d82-82c6-79888b9731ba | 📓 markdown testing | # h1 **bold** text and _italic_ text | note urn:penemure:be939c4b-76e0-4ed0-a12b-da577b08cea7 | 📓 motivation | why did i want this time tracking: | note urn:penemure:33e09e7f-5c00-4d0e-b5f8-2b9546dec601 | 📓 parent vs project | I’m not sure why i have both ‘parent’ an | note urn:penemure:b2f13489-3bbd-4add-9e5b-cb138dff9713 | 📓 pm links | [https://www.notion.so/blog/data-model-b | note urn:penemure:51df2dcb-62a0-47e2-88e9-41b041c21709 | 📓 tasks & bugs | we’ve built in a task tracker. was that | note {: Title="note"}