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
- 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