Scargill's Tech Blog
  • Home
  • Contact
  • Log In
  • Password Reset
  • New Visitors
  • Register

Category: SQL

Android Phone as Server

March 18, 2017March 19, 2017 Peter ScargillAndroid, Apache, Debian, MQTT, Node Red, SQL, SQL Lite, The Script74 Comments on Android Phone as Server

Why am I showing you a picture of a cracked-screen phone? Well because this particular phone is a bust Oukitel K10000, the phone with the world’s longest-lasting battery and an excellent workhorse. My friend Aidan gave me this (rather than chucking it away) some time ago and it has been…

Read More→

Track Broadband Outage in Node Red

April 16, 2016April 16, 2016 Peter Scargillbroadband, Node Red, SQL, SQL Lite3 Comments on Track Broadband Outage in Node Red

Actually I could have given this a range of titles – as the following is useful in a range of situations. But first let me explain my problem: The problem: I’ve been having broadband issues. The broadband cuts out for a few minutes without warning and then reconnects.  I just…

Read More→

Graphing Wonders

February 22, 2015February 22, 2015 Peter ScargillMQTT, mysql, Raspberry Pi 2, SQL23 Comments on Graphing Wonders

Tonight I’ve been building on my earlier work on graphing, if you read a few blogs back you’ll know I got some basic graphing running on the Raspberry Pi 2, taking MQTT data from a sensor and storing it in MYSQL. Well that was fine apart from the graphs having…

Read More→

Flashing Lights on Raspberry Pi 2

February 11, 2015February 11, 2015 Peter Scargillmysql, Raspberry Pi 2, SQL, Wordpress

So – having managed to get WordPress up and running on the P2 I thought it might be nice to step back toward the original plan and get some home control running. I like PHP so I thought that it might be nice to have a PHP page with some…

Read More→

Welcome

I'm Pete and this is my (big) technology blog.

Use the search box or check out the archives and other links below - be sure to SHARE what you like using the social media buttons and please subscribe to my Youtube video channel

To buy me a coffee or help with the costs of running the blog, please use the Paypal donate link below.


Please note that menu enhancements are only visible if you are a logged in, registered user.

Registrations with no name or suspicious looking email addresses will be considered to be spammers and will be deleted. Don't forget to tick the box so you will get email follow-ups to comments. We've a great community in here. Spammers and "guest post" companies beware - you have NO chance of success and a good chance of getting spammed badly in return.

Notice: I'm always happy to offer advice on stuff I've written - and indeed take advice. If I can help in any way just let me know but PLEASE don't ask me how to program in C/PASCAL/NODE/etc. There are many resources out there - if you want to program and can't - there's always Google.

Email Newsletter

Enter a name and your real email address if you would like to receive occasional summary emails.

Name

Email


Recent Posts

  • Banggood 30W DIY Laser Engraving Machine
  • More Printing Goodness – and now the Crealty LD-002H
  • HK1 RBOX R1 5G WiFi Android 10 TV Box
  • More New Year Gadgets – 12 Inch LED Ring Wall Clock
  • Bakeey POCO X3 NFC Case
  • Bakeey 8-in-1 USB-C Hub Docking Station Adaptor
  • RGB Smart Socket – EH?
  • Athom Smart Socket pre-Tasmota’d and Smart Light
  • Second 2021 Treat – a New Doorbell
  • BigTimer
  • NodeMCU 10-pack Bargain – first treat of the New Year
  • Merry Christmas and a New Poco X3
  • The rugged Doogee S68 Pro with Titanium Sides
  • The IOTCRICKET from ThingsOnEdge.COM
  • The YeeLight and node-red-contrib-yeelite-compat-hue
  • Crealty 3D LD-002R LCD Resin Printer and MORE
  • Smart Devices for 2021 and Beyond
  • USB-C to USB 3 Adaptors
  • VIGOTEC VG-L7X 20W Laser Engraver for Christmas
  • The Sincerest Form of Flattery
  • FriendlyArm NanoPi R4S SBC
  • Seeed Studio WT32-S1 Module for Ethernet to Serial
  • Solar HD1080P IP67 Camera
  • PiVPN (OpenVPN + WireGuard) Pi-hole and ZeroTier
  • My Node-Red Dashboard Controls for 2021
  • SQLITE3 Raspberry Pi Problems and Solutions
  • Chuwi Larkbox – Windows + Celeron Mini PC
  • Elegoo Uno Super Starter Kit
  • MaticBox Raspberry Pi 4 Case and accessories
  • Raspberry Pi 4 Cloning Challenge
  • Creative Outlier Air V2 Earbuds
  • Anycubic Photon Mono 3D Printer
  • Solar Power – the Wemos D1 and 12/24v Battery Chargers
  • Haylou GT1 Pro Bluetooth 5.0 Earbuds vs my Xiaomi Mi Earbuds
  • Node-Red Security – To Be or not To Be

Archives

  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • June 2012

Social

Facebooktwitterlinkedinyoutubeflickr

Disclaimer

As I have no idea of your level of technical skill or the requirements of your country laws in terms of electricity supply etc, I accept no responsibility for any damage attributed to following advice in these pages.

When dealing with wall outlet (high) voltages you should satisfy yourself that whatever you are doing is safe and if unsure, seek advice from someone who is sure.
Copyright (c) 2021 Peter Scargill - All Right Reserved

footer image
Copyright © 2020 Peter Scargill - All rights reserved.
Blog Kit by WP Charms