Part of the standard way to handle time on computers is to set the hardware clock (a.k.a. the BIOS clock) to UTC. Then users can select a timezone for displaying as their system time. Contrary to this conventional way of doing things, the Windows operating system sets the hardware clock to the configured local time. Clock malfunctions tend to happen if you’re dual booting a Linux system. Posix operating systems expects the convention to be followed. Here’s how I addressed this problem.
Continue reading
Recording and Replaying GPS Data
In my last post on the Arduino Uno, I took my first steps with the micro-controller and started getting data from a GPS module – the Ublox NEO 6M. Once I was able to receive data from the module – which was pretty neat by itself if you think about it, I wanted to actually do something with the data. I thought a good next step would be recording data and playing it back while plotting it on a map.
Continue readingGetting GPS Data from the Ublox NEO-6M GPS Module
At work, we’re using microcontrollers. We use them to monitor equipment and the environment, also to control machines in ways such as automating tasks and/or responding to certain environmental conditions. I work on the enablement team, therefore it’s part of my mission to facilitate other teams in their goal achievement. The automation team is responsible for planning and execution of automation projects. As an application developer, I’m acquainting myself with the tools and techniques of their team to help enable them on the software side of things. For one of my first tasks, I was given a GPS receiver and an Arduino Uno.
Gold!
I have a project I’m working to to gather and analyse economic data. To get the daily gold spot price, I’m going to use goldpricez.com.
They provide a simple RESTful API serves up gold price data. You can check them out at the following link.
Npgsql Insert Time Without Timezone
I’m just getting started with Npgsql for .NET Core Entity Framework and I ran into some trouble trying to do an insert into a Postgres table with a time
data type. I initially tried to use a DateTime
object, as worked with the date
data type, but that didn’t work. The documentation said to use a TimeSpan
, but I didn’t know what to span. Here’s what I did to get it to work. Continue reading
PostgreSQL Quickstart
I’ve used mostly MySQL in the past, but a recent project called for working with PostgreSQL. The most immediate difference was that databases and schemas were semantically different. I took a liking to the DBMS – database management system, and plan to be using it in future projects. So, here I will notate some commands to quickly get up and running with PostgreSQL. Continue reading