This is a simple Android background Service Template. You can use it to run updates in the background without blocking the UI. To start and stop the service use the following lines in your activity: // starting the service Intent intent = new Intent(this, UpdateService .class); startService(intent); // stopping the service Intent intent = new ..
For the IoT you can use a cheap esp8266 microcontroller with WiFi onboard. To connect the esp8266 to the wireless network you can use the following lua snippet that will work with the nodemcu..
To get the first 10 in descending order in sqlite SELECT * FROM table ORDER BY id DESC LIMIT 10 To get the first 10 in ascending order in sqlite SELECT * FROM table ORDER BY id ASC LIMIT 10 Note: If there are less than 10 entrys in the sqlite database, you will get ..