Friday, March 10, 2017

Week 5: Day 20-24 - Postgres Server


Monday:
Mr. Elkner has changed my focus for this week. Instead of Khan Academy, I will be focusing on setting up an SQL server. Today, I changed the hostname for the Raspberry Pi, as you can see it's "cdevlin" now, named after Catherine Devlin. In addition, I created a test database following your directions..

Tuesday:
Today, I gave Ali some great advice on his Red Hat test. I showed him how to hack the system to change the root password, and told him the biggest focuses he should have on the test. Afterwards, I made some great progress on my SQL server. I created it, and it seems to be working. Now, I need to make it so other computers on the network can connect to it. I will be doing that next class.

Wednesday:
Today, I helped out Edson, Ian, and Helber with Github. They needed to configure their SSH keys, which need to be generated using "ssh-keygen". In addition, I finished creating the Postgres SQL server, and Mr. Elkner is able to connect to it properly. There are several potential things I may end up doing moving forward. It seems that I might be helping a Wakefield student to help out a taco truck driver track his sales/resources using a database. At the same time, I will be furthering my studies using the Postgres server.

Thursday:
Today, I helped out even more people with Github. It seems that I have got most of the class to bind their terminals to github with SSH keys, despite the several problems that I encountered. In addition, Ali has been assigned to create a virtual machine for me, so I can transfer my Postgres server from the weak Raspberry Pi, to the more powerful and spacious Ubuntu VM that I'm getting. I've been told by Mr. Elkner the plan of action for this tack truck project. I will be handling the SQL side of things using SQLite, which will be receiving information in JSON through Python as middleware. Very exciting stuff!

Friday:
I spent a lot of time researching relational databases, to understand the concept. Edgar F. Codd is the guy who created the relational model, using relational algebra & calculus. Relational databases, use his relational model. Ali had finished creating my virtual machine server. I spent the rest of class creating the Postgres server, which I did successfully.

1 comment:

  1. Remember, Mr. Ennis, that the assumed audience here is the world, not your instructor alone, so said person should be referred in the third person, not the second person. Nice work, btw.

    ReplyDelete