Tag: postgresql

Work Day 4: What I did on my summer vacation…

Let’s be honest. I had the BEST summer EVER. I spent three months tackling challenging problems, creating websites, coding in different languages—all while indulging my love of knitting and crocheting by using that as the topic for for three major class projects. Oh, and I got to defer dreary, boring crap in my everyday life I didn’t want to do anyway.

Now it was time to show someone the results…today was my big presentation for my boss, my mentor, and The Alum. Before anyone arrived for the meeting, I fired up my home laptop, got the two servers up and running on their ports, brought up my final project, got PostgreSQL going, etc. All was right with the world…until I tried to project my laptop onto the conference room big screen. I watched that lousy little dongle flash white over and over and over again. When everyone arrived, they informed me that a non-company device won’t work with the conference room multimedia equipment. That makes no sense to me—what if you have a guest presenter?

Despite the fact that I find this insane, the fact remained that my laptop was NOT playing nice with the big flatscreen. As luck would have it, my mentor had already downloaded my capstone project to his laptop. He also had my GitHub code. I was able to do the whole presentation from his machine. Everyone loved the site! I was able to intelligently answer questions about the application and the process. I also walked them through my code for the final project, too. Overall, it went very well!

Now, I just need a functioning work machine. Last I checked on the tech site, my laptop is 20.59% done. I’m really dying to know what comprises the .59%…

Day 61: Showtime!

Today was the day our final projects were due. I managed to do my final GitHub push at a bit past 11:00 a.m. I had to add some SELECT/UPDATE/DELETE options on our SQL code we provided for alternatively loading data via MySQL (vs. PostgreSQL). Also, I had to beef up my README file a bit. Oddly enough, my README files are all the rage with my instructor and with my classmates…

We all did well with our presentations—everyone did a great job with their sites! Yours truly had some technical difficulties, due to not having used Skype in meetings for over three months now. For the life of me, I couldn’t get the damn “Presenting” bar to go away, so that I could switch browser tabs. It was the height of embarrassing, especially when one of my fellow students (who’s probably half my age) had to help me get rid of it. Other than that, demonstrating my site went well. If you’re reading, Mary S., I invoked you as a prospective knitter on my site, to walk through the functionality. I had you register for the site, log in, flake out, needing to change your email on the site, and then you decided to delete your account. I showed off my @ViewChild functionality code used to “Go to Top” without reloading an entire page—I’m probably too ludicrously proud of this, but it’s because I figured it out by researching for myself. I think that is our biggest takeaway from our entire training—learning how to tap every resource we can to figure out an issue.

I feel relieved the presentation is over, but disappointed. This is it for fun coding for the week. From here on in is the transition back to reality…

Day 60: I think I can, I think I can, I think I can…

We’re nearing the finish line for our final project, and for Code Academy as a whole. I’m pretty set on the project, except to test one more time and make sure I’ve done a run-through for the presentation tomorrow. I’m somewhat nervous about the presentation, but we’ve done these before, so it shouldn’t be too much different.

I’m feeling sad…I’ve spent the last three months with a great group of fellow students. I’m going to miss everyone! I know…I’m insane. Some of them will be working in my same office, so it won’t completely be goodbye. Speaking of offices, I’m also going to miss being in the downtown office. Granted, I know from past experience that the long commute is the seventh circle of hell in the winter, but I’m going to miss being in the middle of everything.

On a more entertaining note, I attempted to install ProsgreSQL on my home laptop (to see if I could run my site from home) and it was a fiasco. It asked for the port number, but I think I was supposed to change it to 3000. As a result, despite REINSTALLING it and specifically indicating Port 3000, the app, when opened, is still expecting the default port, and now gives big, ugly errors. I’m going to have to figure this out tomorrow.

Day 54: Reprieve…

I’m not sure what divine intervention occurred today, but our instructor pushed out the due date. Instead of having to have our entire server done by 5:00 Friday, he extended the deadline to Saturday at 5:00 p.m…THEN he left the room, came back in, and declared that he didn’t care when it was done, as long as it was done so that it would work with our final Angular project.

I spent most of the day working on router/controller/services again, but with our instructor’s help, I finally managed to understand how to apply it to my existing connections. Anything else wrong was idiotic typos or case-sensitive issues. My personal favorite catastrophe was the “looping” server. All of a sudden, my console started spewing out “get JSON 404 over and over and OVER again. I tried commenting out code and taking out scripts, thinking they were the culprit. Come to find out, it was due to having the Node server debugger still open.

As of Friday afternoon, I STILL wasn’t done. Even though the due date has been pushed out, I’m going to work on the rest this weekend, so that I’m ready for learning Angular on Monday. I need to clean up the code, make sure pages validate, add comments, copy over the Postman tests, and pull out any unnecessary console.log troubleshooting code.

ALSO, I was so proud of myself for finishing the edit user profile page, but at the end of the day I realized that I had completely forgot to enact the delete function. Oops…

If I have time, I may try to render more pages. We only have to go as far as the landing page, but my site makes no sense without at least having the crocheting and knitting patterns page, too!

Day 52: MySQL…the Sequel…ize

Today we continued our MySQL adventure with something called “Sequelize” which honestly sounds like a Star Trek term—as in, “Mr. Sulu, sequelize the photon torpedoes!” It also sounds like something done with movie franchises that are well past their prime (“Rocky XIX,” anyone?). The entertaining thing is that autocorrect is coming up with all sorts of naughty words for Sequelize—especially if you initially spell it wrong.

Sequelize is an ORM (object-relational mapping) which we used for MySQL. This is also used for something called PostgreSQL, and yes, I think our instructor is just making stuff up now. All kidding aside, PostgreSQL seems to be very similar to Oracle tables, so I’m sure this will be beneficial to understand when I eventually return to our department.

The thing that’s giving me a coronary is that we need to learn all this stuff, at the rate of one major concept per day, and then APPLY IT TO THE CAPSTONE. I just barely have my routes operational from our last lab, and even so, my pages are not what one might call “functional,” except for the ones that applied to the requirements of the lab. To top it off, we now have to divide everything into routes, controllers, services, models…and I know I’m forgetting something. This is supposed to make the code easier to maintain, but honestly, if you can’t FIND anything, how much simpler is it??? I already get confused about which code is server code vs. client code. This is going to send me running screaming into the night…oh, right. We live in the boonies and THIS is what’s out there:

I’ll have to take my chances with the scary code…