onsdag 23 november 2016

Gantt chart and SQL-play

Today I made a Gantt chart because it was needed to pass the course. It seems like a simple nice way of visualizing a project.


It's in swedish.

I also made a todo-list to complete the first activity "Larm-server kopplingsmöjligheter"


Larm-server kopplingsmöjligheterKlart


Förstå SQL-server (skapa databaser och sql-formattering)
Förstå hur SQL-server borde vara uppbyggda för projektet
Förstå skicka SQL-requests med raspberry pi (python)
Förstå skicka SQL-requests med raspberry pi (linux hax?) (Tomas-metoden)
Förstå input från Can-kort
Få hemsida/server att skicka mail

I first helped a colleague with programming some python to send out pulses to a LED.

Then I tried to understand how to work with python and SQL. I made a program using the library sqlite3.

I also installed sqlitebrowser to check if the .db file contained the shit i tried to put there.

It did!

However, I don't know if I can use sqlite when communicating to a MySQL-server... And I don't know what kind of passwords or security I need to have to access the server. So that I will probably check tomorrow.

Currently I'm programming on the raspberry pi itself, it's not superfast. So I will probably make some ftp connection so I can program on my computer and upload the code to the raspberry. Maybe I should put git into the mix as well.

Inga kommentarer:

Skicka en kommentar