Sprint 7 Review

-
So, since my professor is still out on Christmas break (and so am I, for that matter) I asked my husband to be my accountabilibuddy. Yesterday I did a demo for him and showed him all the stuff I on which I worked during the sprint. He was suitably impressed. That's really about all I can say about the review, since I was unable to get any feedback from my adviser.

I have also started pondering what I absolutely need to get done before the system is live, and I decided that really the primary thing is to get all the database schema changes done. So those will be my first priority in the next sprint.

Some research was required to figure out exactly what changes are required for task dependency and subtask relationships, so I did that yesterday. I bought the book SQL Antipatterns some time ago, and it had a section on representing a tree structure in a database. The subtask relationships do form trees, as each task can only be a subtask of one task, but the task dependency relationships form directed graphs, since each task can depend on multiple tasks. Based on the advice in the book, I will use path enumeration for the subtask relationships, as the most frequent usecase (seeing all descendents/ancestors) is very fast for that method. And it would be fairly simple to implement.

However for the dependency relationships, it's going to be a bit more difficult. I did find an article on representing directed acyclic graphs (I do indeed want these to be acyclic!) with the use of a second table, an adjacency list, containing the complete list of paths (transitive closure) in the graph. I will admit this method makes my inner math geek very happy... So this is probably what I'll do.

My plan is to at least make the database schema changes, but actually using the new columns and table can wait until I have time later in the semester (hopefully).

Thus ends sprint 7.

Comments

Post a Comment

Popular posts from this blog

"Does it get easier?" Yes, but Also No...

-
Image
Image by Arek Socha from Pixabay It's complicated... "Does it get easier?" I see some form of this question asked a lot in beginner programming groups. I always struggle with how to answer this honestly and clearly, because the truth is not that simple. In some ways it does get easier, but in other ways it is almost always going to be difficult if you are advancing in your career . If you are a programmer and your job is easy for years on end, the most likely explanation is that you're in the kind of dead-end position that people try to avoid, not the kind of position people dream about when they think of becoming a developer. Most likely you are not getting better at being a dev, not working with new tech or solving new kinds of problems, not being given more responsibility, etc. etc. etc. I've seen some pushback from other newbie programmers on the idea that it could remain difficult past the initial learning stage. Notably I have never once seen somebody who...
Read more

How to Land Your First Dev Job: Develop Yourself, Market Yourself

-
Image
Image by magnetme from Pixabay In the coding and tech groups I'm in, I see the same question asked over and over by folks who are just learning to code, finishing up a bootcamp, degree, or other training program, or who have been looking for that first job for awhile and not having any luck: "what do I need to do to get my first dev job?" There's a whole ton of info out there on this topic, but it's scattered all over, so I thought I would gather together the best resources I've come across and share them, along with a bit of context, to try and help everybody struggling with or just plain wondering about this. There are a lot  of things you can do to improve your chances of finding a job and hopefully shorten your job search. They are broadly divided into 2 categories: developing yourself and your skills, and marketing yourself and your skills. Note that you don't need to do everything on this list, nor do you need to do it all at once. This is an "...
Read more

Git. The WHAT and WHY Edition.

-
Image
Lately I've seen a lot of new/aspiring developers talk about difficulties learning git . I was confused at first, because there are approximately a zillion git tutorials out there. But then I started really looking at what people were saying AND what all those tutorials contain. The problem is most tutorials start out with "here are a ton of git commands to memorize", and this is not where people are having problems. People are having problems with "what is git, why should I learn it, and what does it look like to use it in a real-life project?", and those questions are largely not answered in all those millions of tutorials. So at the risk of redundancy, I'm going to attempt to address these questions in Yet Another Article About Git. First, I want to make it clear that if you want to be a programmer, any kind of programmer, you need to know git. You just DO. This is the short version of the answer to "why should I learn it?".  The medium length a...
Read more