2021-09-28 weekly planning

[kgodey]

Discussion topics

• Updates: General updates everyone should be aware of.
• Questions: Questions for the team to answer.
• Active Work: Work planned for the next week.
• Retrospective: Summary of last week's work.

About

Each Tuesday, we start a discussion about Mathesar's progress. Everyone is welcome to add a new topic to discuss or to comment on existing topics.

[kgodey]

Updates

Roadmap

I've cut the following milestones from our alpha release plan in order to focus on what we can do well by December.

• Computed Data
• Summarized Data
• Undo and Redo (DML)
• 2021-11 Stability release (we'll work these issues into other milestones)

We discussed cutting these features during our State of Mathesar meeting but decided to keep them in and see how it went. Based on the last couple of weeks, it seems clear that we were being too optimistic :).

I've also updated the milestone deadlines on our roadmap. Please review and comment below about what you think.

Team

Our hiring process for the frontend engineer has been completed. Our new hire starts on Oct 12, I'll do a proper introduction then.

We've also begun interviews for our backend engineer position. We're still accepting applications and referrals are appreciated.

Project Planning

We're now in the new GitHub Issues beta so I'm going to be moving Mathesar to the new project structure from our current Active, Backlog, and Future boards.

I've started setting up a Mathesar project but I'll need to set up some automations and views before it's usable. It's not a high priority so I anticipate it might take a couple of weeks to move over.

[mathemancer]

• Computed Data
• Summarized Data
• Undo and Redo (DML)

I think these are the right sacrifices to make at the moment.

[kgodey]

Questions

@mathemancer, @powellc, @ghislaineguerin, @pavish: Your responses are encouraged. Others are also welcome to respond.

Retrospective

• What went well over the past week?
• What could have gone better over the past week?
• Are there any improvements you'd like to suggest?

Active Work

• Does your workload for this week look okay?
• We have two milestones due in the next two weeks. Are there any blockers to meeting these deadlines?

Discussion

Please respond to the Updates post directly if you'd like to discuss anything there. If you have any other topics to discuss, please post them as new replies to the parent post.

[kgodey]

What went well over the past week?
What could have gone better over the past week?
Are there any improvements you'd like to suggest?

N/A, I was taking time off.

Does your workload for this week look okay?

It looks doable but I have interviews etc. this week, so I may not be able to get it all done.

We have two milestones due in the next two weeks. Are there any blockers to meeting these deadlines?

We need to resolve the add records UX issues, but that's on my list so I don't think it's a blocker.

[mathemancer]

What went well over the past week?

I clarified some things about the issues around server default setting, and found a promising direction to proceed on that. The text types PR is submitted.

What could have gone better over the past week?

Unfortunately, the server default setting problems bogged down the type implementation work.

Are there any improvements you'd like to suggest?

Nothing specific.

Does your workload for this week look okay?

Yes, I think so. There may be some types pushed into the next week, especially the custom money type.

We have two milestones due in the next two weeks. Are there any blockers to meeting these deadlines?

None that I can see.

[pavish]

What went well over the past week?
What could have gone better over the past week?

I think things went generally well during the last week. I was off for a couple days. There are no major updates.

Are there any improvements you'd like to suggest?

None, at the moment

Does your workload for this week look okay?

It looks okay to me.

We have two milestones due in the next two weeks. Are there any blockers to meeting these deadlines?

None.

[ghislaineguerin]

What went well over the past week?

It was good to have time to work on the UI and think about the UX in more detail.

What could have gone better over the past week?

I didn't make much progress on review rounds for views

Are there any improvements you'd like to suggest?

I needed to switch gears from views to UI so I think looking at views w fresh eyes will help

Does your workload for this week look okay?

It does

We have two milestones due in the next two weeks. Are there any blockers to meeting these deadlines?

None

[kgodey]

Active Work

This post lists work planned for this week (see also: Active). It also includes a current summary of milestones involved in this week's work.

[2021-10-01] [05] Editable Tables

• 9 issues already closed.
• Issues currently in progress:
  • [@pavish] Implement adding new records #197

[2021-10-08] [06] 2021-10 Stability

• 4 issues already closed.
• Issues currently in progress:
  • [@ghislaineguerin] General styling updates #473
  • [@pavish] Refactor frontend stores for table-data #651
  • [@pavish] Set up integration testing environment #639
• Issues not yet started:
  • [@kgodey] Refactor db code to work with existing connections #592
  • [@kgodey] Schema sqlalchemy engine caching is per-instance #280
  • [@kgodey] Set up logging in the backend code #583
  • [@ghislaineguerin] Design for loading, error, and retry states #636
  • [@ghislaineguerin] Review existing UI and create tickets for changes needed #638
  • [@pavish] Write integration tests for some important user scenarios #640
  • [@pavish] Unit tests for stores #641
  • [@pavish] Unit tests for all reusable components #642
  • [@kgodey] Set up staging environment for Mathesar #225
  • [@pavish] Move filter pane to dropdown #643
  • [@pavish] Frontend unit test cases: Readonly table view #213
  • [@bohemia420] Table, Database, & Schema APIs should support sorting by ID & name #635
  • [@bohemia420] Deleting all columns in a table results in a NoSuchTableError #668
  • [@pavish] Enable TypeScript strict mode #619

[2021-10-15] [07] Working with Tables

• 22 issues already closed.
• Issues currently in progress:
  • [@mr-gabe49] Implement deleting a table #448
  • [@dmos62] Implement showing and changing a column's type #498
  • [@mr-gabe49] Implement deleting a column #496
• Issues remaining in backlog:
  • 10 frontend issues

[2021-10-22] [08] Initial Data Types

• 30 issues already closed.
• Issues currently in progress:
  • [@mathemancer] Backend work for Mathesar money custom type  #417
  • [@eito-fis] Handle TIME data type in the backend #426
  • [@powellc] Implement filtering options for Number types. #385
  • [@powellc] Handle BOOLEAN data type in the backend #387
  • [@mathemancer] Handle CHAR data type in the backend. #407
  • [@mathemancer] Handle TEXT data type in the backend. #405
  • [@mathemancer] Handle VARCHAR data type in the backend. #404
• Issues not yet started:
  • [@powellc] Implement range based grouping for numeric types. #384
  • [@mathemancer] Create URI custom type and handle it in the backend. #412
  • [@mathemancer] Handle TIMESTAMP data type in the backend #424
  • [@mathemancer] Handle INTERVAL type in the backend #430
  • [@mathemancer] Handle MONEY data type in the backend. #420
  • [@powellc] Implement filtering options for the email type #410
  • [@mathemancer] Unknown server_default settings silently deleted #681
  • [@mathemancer] Some server_default constants are not handled #682
  • [@kgodey] Store icon, labels, and input options for types on the backend #661
• Issues remaining in backlog:
  • 17 backend and database issues
  • 9 frontend issues
  • 8 product issues

[2021-10-31] [08A] 2021-10 improvements

• Issues currently in progress:
  • [@arvind-1] Column API should support creating columns without names  #555
• Issues not yet started:
  • [@silentninja] Handle non-unicode encoded datafiles #421
• Issues remaining in backlog:
  • 5 backend and database issues
  • 12 frontend issues
  • 3 infrastructure issues

[2021-11-05] [09] Working with Views

• 4 issues already closed.
• Issues currently in progress:
  • [@ghislaineguerin] Support for listing database views #455
  • [@ghislaineguerin] Design for many-to-many relationships between tables  #443
  • [@ghislaineguerin] Support for opening and interacting with a View #466
  • [@ghislaineguerin] Support for deleting a database view #454
  • [@ghislaineguerin] Design for usage of Foreign Key constraints #243
  • [@ghislaineguerin] Support for editing records within a view #456
• Issues remaining in backlog:
  • 7 backend and database issues
  • 2 product issues

[2021-11-19] [11] Multiple Database Support

• 7 issues already closed.
• Issues currently in progress:
  • [@aaditkamat] Backend support for tables without single-column primary keys #395
• Issues remaining in backlog:
  • 3 backend and database issues
  • 3 frontend issues
  • 2 design issues

[kgodey]

Retrospective

This post lists issue updates from 2021-09-22 until now by milestone.

[05] Editable Tables

• Issues started, not yet finished:
  • [@pavish] Implement adding new records #197

[06] 2021-10 Stability

• Issues closed:
  • [@mr-gabe49] Cancel import does not eliminate table under the left pane #646
• Issues started, not yet finished:
  • [@ghislaineguerin] General styling updates #473
  • [@pavish] Refactor frontend stores for table-data #651
  • [@pavish] Set up integration testing environment #639

[07] Working with Tables

• Issues closed:
  • [@mathemancer] IndexError when deleting a column #663
  • [@pegnott] Implement adding a new column #495
• Issues started, not yet finished:
  • [@mr-gabe49] Implement deleting a table #448
  • [@dmos62] Implement showing and changing a column's type #498
  • [@mr-gabe49] Implement deleting a column #496

[08] Initial Data Types

• Issues started, not yet finished:
  • [@mathemancer] Backend work for Mathesar money custom type  #417
  • [@eito-fis] Handle TIME data type in the backend #426
  • [@powellc] Implement filtering options for Number types. #385
  • [@powellc] Handle BOOLEAN data type in the backend #387
  • [@mathemancer] Handle CHAR data type in the backend. #407
  • [@mathemancer] Handle TEXT data type in the backend. #405
  • [@mathemancer] Handle VARCHAR data type in the backend. #404
• New issues created:
  • Some server_default constants are not handled #682, created by @mathemancer
  • Unknown server_default settings silently deleted #681, created by @mathemancer

[08A] 2021-10 improvements

• Issues started, not yet finished:
  • [@arvind-1] Column API should support creating columns without names  #555
• New issues created:
  • mathesar stuck in an infinite reload on deleting postgres tables #679, created by @bohemia420

[09] Working with Views

• Issues started, not yet finished:
  • [@ghislaineguerin] Support for listing database views #455
  • [@ghislaineguerin] Design for many-to-many relationships between tables  #443
  • [@ghislaineguerin] Support for opening and interacting with a View #466
  • [@ghislaineguerin] Support for deleting a database view #454
  • [@ghislaineguerin] Design for usage of Foreign Key constraints #243
  • [@ghislaineguerin] Support for editing records within a view #456

[11] Multiple Database Support

• Issues started, not yet finished:
  • [@aaditkamat] Backend support for tables without single-column primary keys #395

[13A] 2021-11 improvements

• New issues created:
  • Bump tmpl to latest version when npm audit raises alert #683, created by @pavish