Advertisements

SQL statement for selecting the latest record in each group

When you have multiple IoT devices of the same type, you may collect data in a single database table.

In such a case, you may choose to group data based on the device ID.

So how do you display the latest data capture from each device?

In this situation, we can choose to run an SQL statement that will return the latest record in each group.

Advertisements

How to connect your Raspberry Pi to a WiFi network with raspi-config in Raspbian Stretch

When you own a Raspberry Pi with in-built WiFi or an attached USB WiFi adapter, you will be able to connect it to a WiFi network.

Given that WiFi connectivity, you can use then your Raspberry Pi as a HTTP server and/or a HTTP client on the Internet without using a network cable.

When you have installed Raspbian Stretch on your Raspberry Pi, you can use raspi-config to connect your Raspberry Pi to a WiFi network. For this purpose, you can follow the steps mentioned in this post.

How to change the hostname of your Raspberry Pi via raspi-config in Raspbian Stretch

When you install Raspbian Stretch as the operating system for your Raspberry Pi, the default hostname is raspberrypi.

Since a Raspberry Pi is one of the things that programmers buy, we could deploy several at home.

When you have several Raspberry Pis deployed in your house, you may want them to be identified by hostnames.

So how can we change the hostname of our Raspberry Pi running Raspbian Stretch? This post shows how you can change the hostname of your Raspberry Pi via raspi-config in Raspbian Stretch.

How to change password of the current user in Raspbian Stretch using raspi-config

Especially when you enable SSH server on Raspbian Stretch, you should change the default password of the pi user.

When you want to change the default password of the current user in Raspbian Stretch, you can do it via raspi-config.

In case you need it, this post shows how to change password of the current user in Raspbian Stretch using raspi-config.

How to expand Raspbian Stretch file system via raspi-config

When you need more space for your existing Raspbian Stretch image, you need to rewrite it onto a larger microSD card. In order to use the additional storage space, you need to tell Raspbian Stretch to expand its file system.

In this situation, follow this post to expand Raspbian Stretch file system via raspi-config.