Sean’s work log¶

TODO¶

Soon¶

Write first draft of user outreach email
Begin work to facilitate release process

Backlog¶

Review FidalMathew: Close RecordSelector on overlay click
Figure out who is helping Anshuman with with design and UI
Refactor CellSelection data structure and store
2023-08 Front end work
Research i18n Ally to see if we can use it to navigate to base translation source
Begin “User Communication Guide”, as a wiki page
Comment on or about Cannot import large csv tables
Resolve front end code standard prohibiting usage of events on components
PR to add docs on running front end in prod mode
PR to add docs on loading sample data
re-report mdformat issue in mdformat-mkdocs repo

2023-09-29 Friday¶

Send email about GitHub repository analytics
Team event
Comment within email thread about user feedback process
Prepare GitHub user outreach data

2023-09-28 Thursday¶

Finish categorizing users from our GitHub repo
1/1 with Rajat
User feedback meeting
1/1 with Kriti
Polish and publish github_to_duckdb code

2023-09-27 Wednesday¶

Team meeting
Investigate and close Continue looking for available names when an auto-generated constraint name is unavailable
Some small discussions
Some time playing with scraping issue/comment/user data from our GitHub repo into a database

2023-09-26 Tuesday¶

Troubleshoot Docker issues with Pavish preventing me from reviewing his PR
1/1 with Mukesh
Follow up with user about column comments
Review Upgrade node
Raise discussion about UX design for Excel/JSON import project
Review Fidal: Close record selector on overlay

2023-09-25 Monday¶

1/1 with Pavish
Some thinking on product direction
Review Mukesh: install docs
Review Pavish: column descriptions
1/1 with Kriti

2023-09-22 Friday¶

(Out due to two sick kids)

2023-09-21 Thursday¶

(Partial day due to one sick kid)

1/1 with Brent
Sync with Ghislaine and Pavish re: niche
Review Mukesh: installation docs

2023-09-20 Wednesday¶

(Out due to two sick kids)

2023-09-19 Tuesday¶

(Partial day due to two sick kids)

1/1 with Mukesh
Try removing all event listeners from cell-related components to see if it improves performance.
Troubleshooting running the front end in prod mode
Some smaller discussions

2023-09-18 Monday¶

(Partial day due to two sick kids)

1/1 with Rajat
Sync with Brent and Dom about API for pasting data into cells
1/1 with Dom
Several smaller discussions on Matrix
Review docs: Add troubleshooting guide link

2023-09-15 Friday¶

Attend community event
Some chat with community members in Matrix General
Some tinkering with baby steps towards building an internal Mathesar CRM instance
Briefly look into Handle API errors on schema page to help answer question from Rajat
Some continued work on JS table rendering performance research
Some continued work on CellSelection
Some smaller discussions

2023-09-14 Thursday¶

(Shorter due to headache)

Review Ghislaine’s niche research report
1/1 with Ghislaine re: niche research project
Some continued work on JS table rendering performance research
Cleanup of some tickets

2023-09-13 Wednesday¶

(Out due to sick kid)

2023-09-12 Tuesday¶

(Half day due to sick kid)

Spend a little time profiling JS perf with table page rendering to get a rough sense of where our bottle necks are.
1/1 with Mukesh
Survey work meeting
Wordsmith options for survey

2023-09-11 Monday¶

Push some more commits to my CellSelection PR
Open ticket Reactivity problem with cell value in Data Explorer table inspector
1/1 with Rajat
Some time exploring MotherDuck product

2023-09-08 Friday¶

Some smaller team management check-ins and follow-ups
Several small discussions
Partial 1/1 with Rajat
Re-review [i18n] Save preferred_language for auth user in db
Re-review [i18n] Language switcher for anon users
Review community PR fix: cell loses focus when clicking on its outline
1/1 with Ghislaine
Review Dont show “Go to Record Page” for error rows

2023-09-07 Thursday¶

A number of smaller team management tasks
1/1 with Anish
1/1 with Mukesh
Review copy in DB config UI, commenting in Figma, and starting a discussion on Matrix.
Finish and send critique of user survey
Some minor clean up in some tickets and PRs
Review docs changes in Remove db superuser requirement

2023-09-06 Wednesday¶

Catch up on emails
Some prep work for team meeting
Team meeting
1/1 with Pavish
Re-review user survey and begin drafting response

2023-09-05 Tuesday¶

(Vacation day)

2023-09-04 Monday¶

(Out for US holiday)

2023-09-01 Friday¶

Team event
Discuss scheduling of niche research meeting with Pavish and Ghislaine
Push more commits to my Cell Selection refactor PR

2023-08-31 Thursday¶

Brief team-management-related check-ins with Brent, Pavish, Ghislaine, Anish, Rajat
Open ticket Configure code formatting for Markdown within docs and wiki sites
Raise mdformat bug preventing us from using it
Publish Markdown Style Guide
Send Markdown syntax email
Some continued work on Cell Selection refactor

2023-08-30 Wednesday¶

Respond to “Avoiding regressions” email thread
Respond to “Product level permissions to account for related entities” thread
1/1 with Brent
Write script to identify stale work logs
Review “Quick User Check-in” survey, emailing critique
Clean up FE code standard PR, moving it to a draft PR on the main repo.

2023-08-29 Tuesday¶

(Shorter day due to some intermittent family demands throughout the day)

1/1 with Mukesh
Work on Sheet selection refactor
1/1 with Ghislaine
Some smaller conversations
Begin drafting response to “Avoiding regressions” thread

2023-08-28 Monday¶

Chat with Rajat about upcoming tasks
Review QA tickets opened by Brent, adding some comments
Work on Markdown style guide
Work on Sheet selection refactor

2023-08-25 Friday¶

Review Move UserProfile to the App level context from Route level context
Some prep work for team management while Kriti is away
Push more commits to my draft CellSelection PR

2023-08-24 Thursday¶

Address Review feedback in Migrate wiki to MkDocs
Handle deployment of new mkdocs wiki site
Troubleshoot changes with CNAME file on wiki deployment
1/1 with Kriti
Create ticket Decommission Wiki.js server
Resume work on Refactor CellSelection data structure and store

2023-08-23 Wednesday¶

Team meeting
Bring PR to Migrate wiki to MkDocs out of draft state

2023-08-22 Tuesday¶

Resolve conflicts in Refactor CellSelection data structure and store
Resolve conflicts in Make column type inference optional
Address Kriti’s feedback in Make column type inference optional
Begin work to Migrate wiki to MkDocs

2023-08-21 Monday¶

Troubleshoot some computer issues
Discussions

2023-08-18 Friday¶

(shorter day due to some kid stuff)

Update project page from previous cycle
Team meeting
Team event
Some smaller discussions

2023-08-17 Thursday¶

Catch up on several email and Matrix discussions
Some cleanup of GitHub tickets

2023-08-16 Wednesday¶

Call with Dom regarding priorities for cycle
Organize front-end cycle work into 2023-08 Front end work ticket
Respond to “Package version management” email thread
Respond to Brent’s “installing stuff” email thread

2023-08-15 Tuesday¶

(out sick)

2023-08-14 Monday¶

(out sick)

2023-08-11 Friday¶

Review [i18n] Language switcher for anon users
Continue Discussion about active cell height design and regression
Read and mull over Brent’s “install things” email. I have a lot to say about this, and I’ve already written a lot, but I’m not really sure how to respond in the thread, given how entrenched in our current approach the backend team already seems to be.
Open ticket Turn off the Stale Issues Bot
Identify high-priority issues for the cycle

2023-08-10 Thursday¶

Team meeting
Review [i18n] Save preferred_language for auth user in db
Write a response to Brent’s “Should we install things on the DB” notes (not sent yet, since Brent hasn’t begun the email thread).
Poke my head into some of the SQL work going on the backend to take a look at it, as it relates to Brent’s “Should we install things on the DB” thoughts

2023-08-09 Wednesday¶

Team meeting
Review [i18n] RichText component, adding some commits
Open ticket Flatten BaseTranslation object
Partially review [i18n] Export & import translations
Review [i18n] Load “en” translations parallely

2023-08-08 Tuesday¶

(Partial day due to sick kid)

Continue troubleshooting Docker issue
Review Shared queries - Auth handling for query requests, frontend consumer view, API tests

2023-08-07 Monday¶

Call with Dom re troubleshooting API weirdness
Continue troubleshooting issues with weird errors. Try unsuccessfully to wipe out all my Docker state
1/1 with Kriti
Bring optional inference PR out of draft state

2023-08-04 Friday¶

Team event
Some work on optional inference
Some smaller discussions

2023-08-03 Thursday¶

Some thinking about “niche” conversations and email thread
Call with Ghislaine about use cases
Some discussion about how to prioritize front end work this cycle
Resolve tricky git conflicts in my optional inference PR due to i18n work
Some work on optional inference

2023-08-02 Wednesday¶

(Another short day)

Some work on optional inference
Team meeting

2023-08-01 Tuesday¶

(Only able to work a couple hr due to failed kid nap)

Some work on optional inference

2023-07-31 Monday¶

(Half day)

Discuss front end issue with installing packages
Review [i18n] Install typesafe-i18n & translates one component and email dev list about package issue
Some work on optional inference
Some smaller discussions

2023-07-30 Sunday¶

(Some work during kids nap)

Matrix discussion with user about feature requests

2023-07-28 Friday¶

(half day)

Continue email discussion about user-reported tickets
Help troubleshoot Type suggestions broken
Send frontend fixes weekly project update email
Continue troubleshooting docker/npm problem
Some progress continuing to review [i18n] Install typesafe-i18n & translates one component

2023-07-27 Thursday¶

Open ticket Type suggestions broken
Spend some time partially reviewing [i18n] Install typesafe-i18n & translates one component
Open email discussion about Criteria for closing use-reported tickets
Resolve merge conflicts in Refactor CellSelection data structure and store
Push some more commits to my optional inference PR

2023-07-26 Wednesday¶

Continue work on optional inference
Team meeting
Some smaller discussions

2023-07-25 Tuesday¶

Chat about next steps for Rajat’s i18n PR.
Review Pavish’s Shareable links frontend PR
Push some more commits to my optional inference PR
Read and respond to product strategy documents in preparation for Wednesday’s meeting

2023-07-24 Monday¶

Open ticket: Discussion about active cell height design and regression
Review Use Truncate component in Record Selector table cells, pushing some additional commits and merging
Begin discussion about i18n project workflow
Open PR to Copy formatted cell values to clipboard instead of raw values
A small amount of work on optional inference

2023-07-21 Friday¶

Respond to Ghislaine’s ticket Change in Behaviour of Sorting, Filtering, Grouping and Copy-Paste for Linked Records
- Create ticket: Copying FK cells should copy the record summary instead of the PK value
- Create ticket: Behavior when sorting FK columns may be confusing to users
Send weekly project update emails for frontend fixes project and my work within the backend fixes project
Team meeting
Continued work on optional inference, pushing some more commits to my draft PR

2023-07-20 Thursday¶

Meet with Brent and Aritra about summarization functions
Chat about wiki sync problems
Create PR with 1 hour quick stab at migration to mkdocs
Create issue Migrate wiki to MkDocs
Continue working on Make column type inference optional

2023-07-19 Wednesday¶

Team meeting
Matrix chat with Kriti about some product design process stuff
Help triage Support for column descriptions/comments
Create ticket Help users understand the connection between descriptions and PostgreSQL comments
Several other smaller discussions
Push more commits to my draft CellSelection PR, beginning to integrate new CellSelection code into TabularData class

2023-07-18 Tuesday¶

Chat with Rajat about cell selection PR
Help answer questions for community contributor working on Use Truncate component in Record Selector table cells
Push more commits to my draft CellSelection PR, filling in logic within the scaffolding

2023-07-17 Monday¶

Open draft PR to Make column type inference optional and begin a discussion soliciting feedback from others
Open ticket Gracefully recover from failed type inference during import
Discuss Refactor CellSelection data structure and store with Pavish
Address review feedback in Clean up import docs and merge
Review Scroll sheet all the way down when clicking the New Record button, adding another commit and merging

2023-07-14 Friday¶

Send project update email
Review Date Input closes now on tab
Call with Dom to discuss type inference issues and brainstorm solutions
Open PR with Small clean up to import help text code
Open PR to Clean up import docs
Some progress to Make column type inference optional

2023-07-13 Thursday¶

GSoC project meeting with Aritra
Continued work on cell selection refactor
Add some more content to my “Querydown for Mathesar devs” Gist, explaining why I think “mandatory aggregation” is important, with an example using the Data Explorer
Minor updates to frontend fixes project description

2023-07-12 Wednesday¶

Open draft PR with scaffolding to Refactor CellSelection data structure and store, and write a summary requesting Pavish and Rajat review the approach.

2023-07-11 Tuesday¶

Re-review Updated frontend to send a single bulk delete request instead of one request for each record
Re-review Added margin between breadcrumb selector and bottom of the veiwport
Start discussion about graceful fallback behavior for all unsupported Postgres data types
Review Varsha’s Sample schema file for API Documentation
Installation planning meeting
Some progress writing code for SheetSelection refactor

2023-07-10 Monday¶

Mark Usability Improvements project as “cut short” so that it can be closed
Add 2023-07 frontend fixes project page
Respond to comment on Date input should close date picker when losing focus via Tab or Shift+Tab, posting clearer steps to reproduce.
Review Added margin between breadcrumb selector and bottom of the veiwport
Open ticket Time cell not saved after pressing Tab key
Open ticket Confusing timezone issue when editing Time cells
Review Add Peak Time aggregation function
Review Add Peak Day of Week aggregation function
Review Add Peak Month aggregation function
Review Updated frontend to send a single bulk delete request instead of one request for each record

2023-07-07 Friday¶

Team event
Catch up with some email discussions from the past week
Re-review Publicly Sharable Links spec
Begin mapping out some thoughts for the SheetSelection refactor RFC

2023-07-06 Thursday¶

Many meetings:
- Front end team meeting
- Core team meeting
- List data types meeting
- Installation planning meeting
- 1/1 with Kriti
Some work organizing info for upcoming project
Some work planning Friday’s team event
Review/merge small community dev docs pr Fix typo error in DEVELOPER_GUIDE.md