---
urn: "urn:penemure:c025dbb4-8ac2-4985-b348-0dff9b10619f"
backend: "pub"
ancestors:
-  <span class="title">📁 Penemure</span>
created: 2025-02-03 07:36:34.931395+00:00
updated: 2025-02-03 09:30:00.279996+00:00

tags:
    milestone: "1.0"
---

# 📁 Editable Tables



We need editable tables, that's really a killer feature of notion. That you can sql select some data, and the results you get back, are actually mutable in place. So let's try and implement that.

Let's build a table real quick with some notable properties:

- a non mutable field (id)
- a mutable object attribute (title)
- oh wait, we have three variants of that mutable object attribute, and the edit should essentially go to the last one.
- a tag based attribute
- a tag based attribute that I didn't used to fill in automatically so will be missing in places.

<!-- urn:penemure:hexylena | ea5f52d3-7afd-47ce-9076-b92d280e9408 -->


```query-table-edit
GROUP SELECT
  id,
  title,
  title_plain,
  title_txt,
  status,
  priority
FROM task
ORDER BY
  id ASC
```

id | title | title_plain | title_txt | status | priority
-- | ----- | ----------- | --------- | ------ | --------
004894e3-7e64-4475-940e-e329dea20b54 | <a href="/penemure/note/004894e3-7e64-4475-940e-e329dea20b54.html"><span class="title">📝 RSS</span></a> | 📝 RSS | RSS | backlog | medium
082445d6-a97f-432c-a692-b15f0bcb5cbb | <a href="/penemure/note/082445d6-a97f-432c-a692-b15f0bcb5cbb.html"><span class="title">📝 customised manifest for form pages </span></a> | 📝 customised manifest for form pages  | customised manifest for form pages  | backlog | high
09a23b9f-b798-4197-9e31-1b7fc412121a | <a href="/penemure/note/09a23b9f-b798-4197-9e31-1b7fc412121a.html"><span class="title">📝 Custom Emoji / Icons</span></a> | 📝 Custom Emoji / Icons | Custom Emoji / Icons | Done | Low
0a3fc124-03a3-4315-8143-3f92c3932828 | <a href="/penemure/note/0a3fc124-03a3-4315-8143-3f92c3932828.html"><span class="title">📝 need to redo attachments now</span></a> | 📝 need to redo attachments now | need to redo attachments now | in-progress | 
19adaaea-ef36-463e-949d-36aba7e80ad7 | <a href="/penemure/note/19adaaea-ef36-463e-949d-36aba7e80ad7.html"><span class="title">📝 Starting time logging from a page, default to that as the title.</span></a> | 📝 Starting time logging from a page, default to that as the title. | Starting time logging from a page, default to that as the title. | backlog | medium
1bdddab5-c28e-47f4-a6fd-610fff4ff5f6 | <a href="/penemure/note/1bdddab5-c28e-47f4-a6fd-610fff4ff5f6.html"><span class="title">📝 Link backend to the backend's "home" if it exists, in note metadata</span></a> | 📝 Link backend to the backend's "home" if it exists, in note metadata | Link backend to the backend's "home" if it exists, in note metadata | backlog | medium
299e94f0-88fe-423f-a3fd-d92be09227a5 | <a href="/penemure/note/299e94f0-88fe-423f-a3fd-d92be09227a5.html"><span class="title">📝 tags needs to be completely redone (again)</span></a> | 📝 tags needs to be completely redone (again) | tags needs to be completely redone (again) | in-progress | 
2aa2d81a-a043-4e87-abeb-6252ce60da71 | <a href="/penemure/note/2aa2d81a-a043-4e87-abeb-6252ce60da71.html"><span class="title">📝 a second templated task</span></a> | 📝 a second templated task | a second templated task | backlog | medium
2fd1bd59-3029-4b12-b62e-141354d3a92c | <a href="/penemure/note/2fd1bd59-3029-4b12-b62e-141354d3a92c.html"><span class="title">📝 attachments deleted when editing</span></a> | 📝 attachments deleted when editing | attachments deleted when editing | Backlog | Low
31f89251-f274-4c92-94ca-2e5ea2d753f2 | <a href="/penemure/note/31f89251-f274-4c92-94ca-2e5ea2d753f2.html"><span class="title">📝 Logging: changing the title doesn't get saved</span></a> | 📝 Logging: changing the title doesn't get saved | Logging: changing the title doesn't get saved |  | 
331f68de-5f6c-4458-b166-f4d23b681994 | <a href="/penemure/note/331f68de-5f6c-4458-b166-f4d23b681994.html"><span class="title">📝 separate template tags and regular ones</span></a> | 📝 separate template tags and regular ones | separate template tags and regular ones | Backlog | 
3b1142c2-dfa7-4130-b846-a3f7659ea670 | <a href="/penemure/note/3b1142c2-dfa7-4130-b846-a3f7659ea670.html"><span class="title">📝 maybe do not allow selection of backend for logging time, superfluous, based on project only.</span></a> | 📝 maybe do not allow selection of backend for logging time, superfluous, based on project only. | maybe do not allow selection of backend for logging time, superfluous, based on project only. |  | 
3e1c8460-570c-40c7-9a50-514316c06e3e | <a href="/penemure/note/3e1c8460-570c-40c7-9a50-514316c06e3e.html"><span class="title">📝 select text + auto-create issues from it</span></a> | 📝 select text + auto-create issues from it | select text + auto-create issues from it | done | 
41bdd446-932c-4c95-b35f-f326eeba028c | <a href="/penemure/note/41bdd446-932c-4c95-b35f-f326eeba028c.html"><span class="title">📝 What I'm doing automation</span></a> | 📝 What I'm doing automation | What I'm doing automation | Backlog | Low
550d497d-7e20-4d28-a08d-edd4077ff392 | <a href="/penemure/note/550d497d-7e20-4d28-a08d-edd4077ff392.html"><span class="title">📝 Prevent circular parenting</span></a> | 📝 Prevent circular parenting | Prevent circular parenting | Done | 
55d5e8a6-ca25-4029-aab6-b60d5aa3c617 | <a href="/penemure/note/55d5e8a6-ca25-4029-aab6-b60d5aa3c617.html"><span class="title">📝 add stars/fav/bookmarks </span></a> | 📝 add stars/fav/bookmarks  | add stars/fav/bookmarks  | Backlog | Low
56495dc2-6b1c-4300-b3e5-68bc4bd726e4 | <a href="/penemure/note/56495dc2-6b1c-4300-b3e5-68bc4bd726e4.html"><span class="title">📝 Git based Overlay Filesystem</span></a> | 📝 Git based Overlay Filesystem | Git based Overlay Filesystem | done | 
5e6b0a58-58a8-411b-ba89-b21cc496e197 | <a href="/penemure/note/5e6b0a58-58a8-411b-ba89-b21cc496e197.html"><span class="title">📝 a templated task</span></a> | 📝 a templated task | a templated task | done | low
640e4949-6883-478d-a22c-19fa68961e08 | <a href="/penemure/note/640e4949-6883-478d-a22c-19fa68961e08.html"><span class="title">📝 duplicating turned URN refs into links properly</span></a> | 📝 duplicating turned URN refs into links properly | duplicating turned URN refs into links properly | backlog | low
6e7b16c8-9465-4d9d-9fc1-03e1178c9315 | <a href="/penemure/note/6e7b16c8-9465-4d9d-9fc1-03e1178c9315.html"><span class="title">📝 edit total time (updates end time.) rather than start/end</span></a> | 📝 edit total time (updates end time.) rather than start/end | edit total time (updates end time.) rather than start/end | backlog | 
78b539ad-f3f3-4847-9d6d-a9bfdc8ef849 | <a href="/penemure/note/78b539ad-f3f3-4847-9d6d-a9bfdc8ef849.html"><span class="title">📝 data logging</span></a> | 📝 data logging | data logging | backlog | 
7a1bb42d-eb09-4ce1-8356-0d4cd57cb7c5 | <a href="/penemure/note/7a1bb42d-eb09-4ce1-8356-0d4cd57cb7c5.html"><span class="title">📝 Templates</span></a> | 📝 Templates | Templates | done | 
81df246f-2e36-4fb1-9c81-4e9cb74adcae | <a href="/penemure/note/81df246f-2e36-4fb1-9c81-4e9cb74adcae.html"><span class="title">📝 Issue with Status Field</span></a> | 📝 Issue with Status Field | Issue with Status Field | done | 
8c51eadd-51a6-430a-8ff8-4f7410fcba46 | <a href="/penemure/note/8c51eadd-51a6-430a-8ff8-4f7410fcba46.html"><span class="title">📝 Mentions</span></a> | 📝 Mentions | Mentions | done | 
8ddfb721-f660-4785-9346-78185704c414 | <a href="/penemure/note/8ddfb721-f660-4785-9346-78185704c414.html"><span class="title">📝 metadata for file uploads?</span></a> | 📝 metadata for file uploads? | metadata for file uploads? | backlog | low
99c43a8b-675a-40ad-89da-98193cf28ad9 | <a href="/penemure/note/99c43a8b-675a-40ad-89da-98193cf28ad9.html"><span class="title">📝 log time should order by end time not update time</span></a> | 📝 log time should order by end time not update time | log time should order by end time not update time |  | 
a4feed42-d56b-44b2-ac65-124422048b4d | <a href="/penemure/note/a4feed42-d56b-44b2-ac65-124422048b4d.html"><span class="title">📝 Fix encoding of values into form</span></a> | 📝 Fix encoding of values into form | Fix encoding of values into form | Done | 
a9d4275a-656d-4265-b886-dcc5dcb9f8cd | <a href="/penemure/note/a9d4275a-656d-4265-b886-dcc5dcb9f8cd.html"><span class="title">📝 select tasks which changed from any State to completed within a specific time period</span></a> | 📝 select tasks which changed from any State to completed within a specific time period | select tasks which changed from any State to completed within a specific time period | backlog | medium
ae29780d-9b2a-4394-bbac-848b90beeaf4 | <a href="/penemure/note/ae29780d-9b2a-4394-bbac-848b90beeaf4.html"><span class="title">📝 If no blocks, auto open children</span></a> | 📝 If no blocks, auto open children | If no blocks, auto open children | Backlog | Low
b8f6f0b1-d936-4e00-be32-3a444846bd1e | <a href="/penemure/note/b8f6f0b1-d936-4e00-be32-3a444846bd1e.html"><span class="title">📝 Get it Working</span></a> | 📝 Get it Working | Get it Working | in-progress | 
b9f4c2d4-2ce9-46d6-984e-616340eff5d7 | <a href="/penemure/note/b9f4c2d4-2ce9-46d6-984e-616340eff5d7.html"><span class="title">📝 Manifest.json</span></a> | 📝 Manifest.json | Manifest.json | done | medium
c8f5e888-65e2-4876-9baa-7cf7c27c498e | <a href="/penemure/note/c8f5e888-65e2-4876-9baa-7cf7c27c498e.html"><span class="title">📝 hashtags?</span></a> | 📝 hashtags? | hashtags? | backlog | 
d2aefd7d-dde3-4ac6-810a-4fbf635e0f33 | <a href="/penemure/note/d2aefd7d-dde3-4ac6-810a-4fbf635e0f33.html"><span class="title">📝 fix night mode colours on gantt</span></a> | 📝 fix night mode colours on gantt | fix night mode colours on gantt | done | medium
d32d9e9a-38b3-4f3f-aca3-e79c4554b176 | <a href="/penemure/note/d32d9e9a-38b3-4f3f-aca3-e79c4554b176.html"><span class="title">📝 Mention</span></a> | 📝 Mention | Mention | done | 
d6ce8729-d114-41c2-abfc-c62f1d580876 | <a href="/penemure/note/d6ce8729-d114-41c2-abfc-c62f1d580876.html"><span class="title">📝 A public issue</span></a> | 📝 A public issue | A public issue | backlog | 
d7854764-54f5-45ee-8933-a62f1285eb73 | <a href="/penemure/note/d7854764-54f5-45ee-8933-a62f1285eb73.html"><span class="title">📝 persist start time of time logs when changed</span></a> | 📝 persist start time of time logs when changed | persist start time of time logs when changed | backlog | medium
da961955-1450-468c-a118-27e087c40730 | <a href="/penemure/note/da961955-1450-468c-a118-27e087c40730.html"><span class="title">📝 block transclude and search</span></a> | 📝 block transclude and search | block transclude and search | in-progress | 
e9aca66a-6f4f-4d58-a157-c7e25863bb97 | <a href="/penemure/note/e9aca66a-6f4f-4d58-a157-c7e25863bb97.html"><span class="title">📝 add function/flag to determine if a grouped result set is empty</span></a> | 📝 add function/flag to determine if a grouped result set is empty | add function/flag to determine if a grouped result set is empty | done | medium
f503acb6-07f6-409f-8ff5-6295f48e8d59 | <a href="/penemure/note/f503acb6-07f6-409f-8ff5-6295f48e8d59.html"><span class="title">📝 Block Properties</span></a> | 📝 Block Properties | Block Properties | backlog | 
fb2a9bd6-a259-4ba7-8b88-46f3cecf79fc | <a href="/penemure/note/fb2a9bd6-a259-4ba7-8b88-46f3cecf79fc.html"><span class="title">📝 Logging: auto-save title + body field too</span></a> | 📝 Logging: auto-save title + body field too | Logging: auto-save title + body field too |  | 
ff3237ca-0c2f-4c2f-8760-9cc81fd592d5 | <a href="/penemure/note/ff3237ca-0c2f-4c2f-8760-9cc81fd592d5.html"><span class="title">📝 edit title/project of older entries</span></a> | 📝 edit title/project of older entries | edit title/project of older entries | backlog | 
{: Title="None"}


<!-- urn:penemure:hexylena | ec633c72-a0ad-4c6d-96db-f92c1c00e077 -->


we'll need to 

- [x] add ID to every query, just, as a dupe, and then extract that into the `ResultSet`
- [x] add that into the HTML
- [ ] a new /patch route that accepts a tuple `(id, column, value)`
- [ ] JS to enable this


<!-- urn:penemure:hexylena | 5fff7d9e-7ba1-4db2-9120-9876994d9422 -->


## Misc Thoughts

we do sort of want to communicate to the frontend what the type of that column is. We'll need that for someday-UI, is it a status tag (enum) that needs to be rendered with the select box when clicked on?

Do we care that this impacts 'real' sql queries? Or do we operate under the assumption that $someday we'll have a UI that hides the SQL and correctly applies `GROUP`/`SQL` based on 

<!-- urn:penemure:hexylena | 567f9820-46c0-47b8-afad-3ffd2c7b864f -->


## Work Log

<!-- urn:penemure:hexylena | 539277f5-5426-476f-b340-61b06a228882 -->


```chart-gantt
GROUP SELECT
  title_plain AS title,
  url,
  start_date AS time_start,
  end_date AS time_end
FROM log
WHERE
  parents LIKE '%SELF%'
```

title | url | time_start | time_end
----- | --- | ---------- | --------
⏰ progress on editable tables | /penemure/note/bc71f53c-8c6b-4e26-855d-9e8143e9b899.html | 1738568581.0 | 1738575197.0
{: Title="None"}


<!-- urn:penemure:hexylena | 4d11cc70-512d-4723-97e2-50652242d204 -->