Wednesday, January 3, 2018

Expenses and SQL

I've been using the free version of Expense Manager to keep track of my expenses last 2017 and luckily I was able to make complete entries for the whole year. This year I plan to set a monthly budget and try to stick to it and I will be using last year's data. Expense Manager uses sqlite as storage and it has an option to backup the data either as raw sqlite data or csv. Instead of using the raw sqlite data backup, I created a new database (using sqlite3)  and created the expenses schema is below.  CREATE TABLE expenses(   ...

Tuesday, January 2, 2018

Highlights of my academic life in 2017

Presented a paper in PCSC 2017 Presented a paper in NCITE 2017 Started teaching again after four years of being on study leave Taught a new course: Computer and Network Security Attended technical conferences sponsored by private companies Helped SRG members in their SP/thesis proposals, undergraduate and graduate Participated in the 2017 ACM-ICPC Asia-Manila Regionals Presented in SESAM's graduate seminar on Space Science Maintained the operation of the Peak-Two Cloud Learned new Web Dev Technologies...