Blog  Category: RaspberryPi


Install apache php7 mySQL and phpmyadmin on Raspbian Stretch on a RaspberryPi

Install apache php7 mySQL and phpmyadmin on Raspbian Stretch on a RaspberryPiI've been eagerly awaiting the fourth version of the RaspberryPi for a while, but when it passed the point where I had expected it to be released I googled it only to find that the next incarnation may be a while. Darn it, I have to get anothe RaspberryPi3. So the time has come to commission it and I find the lastest version of Raspian called   more »



How to enable and change the Remote IR GPIO pin in OSMC

How to enable and change the Remote IR GPIO pin in OSMCSo you want to rig up your Raspberry Pi OSMC to be controlled by your favourite remote control, easy peasy - it is just a matter of plugging the IR receiver diode in and swith GPIO on in the settings. Dont like the standard pins 17 or 18, no problem - you can change them at teh same time, just follow these instructions. Go to 'My OSMC, Select   more »



Split and extract the first 1000 (N) rows from a text-csv-data file in Windows

One of the major annoyances for me working with very large datasets you get from someone else is that you often don't know the format the file is coming in, not a problem really just take a peak in Notepad++ or Excel and you are away. But quite often these files are millions of rows in length and it is just not possible to work it out. So   more »



Raspberry Pi 3 HDMI overscan settings and how to correct them

Raspberry Pi 3 HDMI overscan settings and how to correct themIf you've ever plugged a Raspberry Pi into a tv you've probably come across this issue - the displayed image either doesn't fill the screen or over-runs it. The usual bit of googling reveals that all you have to do is tweak a couple of overscan settings and you are good to go. It sounds easy but three Raspberry Pis in and I've only   more »



SSL on a RaspberryPi - does it slow your site down?

SSL on a RaspberryPi - does it slow your site down?First up I'm sorry about bathering on about this SSH thing but I to be honest I'm padding out the blog posts a little bit as there's one article I've written that I'm just not sure I want to publish, It's nothing bad, just not in keeping with the tone of this site so I've racked it up at the end of the post ready to go   more »



Remove Real VNC from RaspberryPi Pixel and install TightVNC

Remove Real VNC from RaspberryPi Pixel and install TightVNCI came across my old shortcut on my windows machine to vnc onto the Pi which prompted me to have a go connecting to my new RaspberryPi3. I duly fired it up only to receive an error message along the lines of 'No configured security type is supported'. After a bit of research it turns out that RealVNC has upped their security protocols and   more »



Running a SSL certificated/authenticated HTTPS website over dynamic DNS

Running a SSL certificated/authenticated HTTPS website over dynamic DNSOne of reasons why I originally held back on buying a SSL certificate for my website was that I wasn't sure that it'd work using a dynamic IP routing service - cos I didn't want to waste $15! Well you don't need to fret about it because I can confirm it works after I eventually got round to setting up a free LetsEncrypt.org one on   more »



Free LetsEncrypt secure SSL server certificate install tutorial for Raspberry Pi

Free LetsEncrypt secure SSL server certificate install tutorial for Raspberry PiFor me being SSL secured has always been the benchmark as having a bonafide website. That little green padlock next to your websites URL doesn't really mean much for a blog, but I always wanted one. At the start of last year I started thing about trying to get one. Ever being a skinflint I wanted to pay nothing for it, but logic   more »



How to make an clock for a raspberry pi with an OLED display

How to make an clock for a raspberry pi with an OLED displayMy dream RaspberryPi project that I am slowly chipping away at is to create the ultimate alarm clock. It is a slow burner though as at it's inception I had none of the skills I needed to pull it off. I've now amassed all of the technical skills to pull it off and I'm just left with finalising the design and finding the time and the   more »



How to run a python script as a service / in background / as a daemon

How to run a python script as a service / in background / as a daemonSo you've written a killer python script and you want to run it in the background as a service because when you close the terminal window/SSH session it kills it. I originally worked it out when I wrote my Twitterbot app, and was going to write it up seperately then but it took me so long to get it running in the background and I tried so may   more »



How to pivot data by month in SQL and output to a temporary table

How to pivot data by month in SQL and output to a temporary tableThere are some things that aren't easy to do in SQL as you'd like. I don't know why it has to make the seemingly simple things to complete in Excel so annoyingly tricky. Dynamic pivots is one of those things that is overcomplicated, sure there's plenty of tutorials on the t'internet , but what they all seem to lack is   more »

Tags : SQL pivot


How to set up your Dell E310dw printer the really easy, bloat free way on windows

How to set up your Dell E310dw printer the really easy, bloat free way on windowsOne of the common themes of the computer industry is to try to install a load of bloat on your computer under the guise of making it easier for you, well when I first got my Dell E310dw and had a flick through the setup guide to head off any such shinangans I noticed they had some sort of 'universal' installer. Trying not to fall for that   more »



How to install Dell Printer E310dw on your Raspberry Pi

How to install Dell Printer E310dw on your Raspberry PiI'm always one for saving a bit of money and many years ago I came up with the plan that I could save a lot of money in printing costs if I didn't own a printer. It is a great idea, you'd be suprised at how much unnecessary printing you get up to and there's always the kick in the teeth of inkjet printer ink being more expensive   more »



The easy way to find and delete duplicates in SQL

The easy way to find and delete duplicates in SQLNext in my series of helpful SQL code is duplicates, I seem to always be having issues with duplicates. This annoys me immensely as all of the issues comes from other peoples data I have to work with. No problem I hear you say, google is awash with ways of how to delete them. Trouble is these are all based on blindly deleting superfluous rows   more »



How to add an auto incrementing ID field in SQL server

So it turns out that SQL is really quick to pick up, once you have the (very) basics down everything you need to do fall intuitively into place as it is all based on the first principals of a select statement. And even if you do get stuck all answers are a very rapid google search. The biggest trouble I have with starting off programming any new   more »

Tags : SQL number code


How to add better comments into SQL server

How to add better comments into SQL serverWhilst I'm firmly in the 'Tried and Test' camp for most things in life and I may only be new to SQL programming but there are just sometimes when I have to buck the mainstream trend and do it my way. One of these occasions is comments in SQL, the widely adopted way would be to use the prescribed double dash -- or the widely adopted   more »

Tags : SQL comment code


How to connect a photoresistor or light dependant resistor to an ESP8266-12E

How to connect a photoresistor or light dependant resistor to an ESP8266-12EHaving purchased my first Raspberry Pi a couple of years ago now I've still not got round to implementing some Internet of Things (IoT). The trouble was that I wasn't really convinced it was suitable for the job as I wanted something able to be battery operated to work in remote situations as the power draw was just too great. I liked the   more »



Best way to optimise images and pictures to display on the web

Conscious that hosting a website from a home internet connection from the Raspberry Pi may lead to slower load time than you'd want I've been working on speeding up its response. I've always been focused on server speed throughout its whole development in a bid to speed up load times. I think I've got it cracked – but the   more »



How to create real time graphs of CPU temperature on a Raspberry Pi

How to create real time graphs of CPU temperature on a Raspberry PiProbably heavily linked with my inner analyst, for a while now I've wanted to create some real-time graphing of some of my raspberry pi stats. I've had a couple of stabs at it but getting it to actually work has eluded me until now. The below example guides you through how to plot your CPU temp as a graph to an image file, the code is in   more »



How to make and set up a twitter bot on your own server / Raspberry Pi

How to make and set up a twitter bot on your own server / Raspberry PiAs a follow up from my ealier post introducing my twitter bot I thought I'd tell you how I did it and how to set one up on you own RaspberryPi or other Linux server. How it works It's not that tricky when you think it through, it is just hooking a few existing processes together to create your working bot. The only real tricky part for me   more »



The blog has now reached 50 posts!

The blog has now reached 50 posts!Well, I didn't think I had it in me to write so much, I'm generally not a person with much to say (this is a lot for me!). My general interest in all things tech had always since the early days compelled me to want to make my own website, trouble is you actually need to have some content to put on it. After a while toiling I'd decided   more »

Tags : 50 today blog RPI


The childs.be twitterbot is alive

The childs.be twitterbot is aliveMy latest project is now live, the @childs_be twitterbot is a go. The original idea was to have the pi tweet pictures from the barrelcam, at regular intervals. I had that running quite quickly and my attentions turned to adding functionality. I came up with being able to tweet the server's uptime and cpu temperature, but it seemed a bit lame   more »



Display your server uptime on your website

Display your server uptime on your websiteIf you host your own server and website like myself, you'll probably want to distplay your current uptime somewhere on your site. You are in luck, it is easy.... It uses the Linux command uptime and strips the unecessary gubbins from the output string: $ uptime This results contains some useful info including number of users logged on and   more »

Tags : uptime data RPI


How to log your own IP

How to log your own IPCall me paranoid but ever since the antics of ACS:Law in the noughties I've been logging my IP address, it is not because I'm am an illegal downloader, my intrigue came about from the thought of how you would prove that you didn't if I was wrongly accused. Stay with me here, but think of the things that can go wrong in the chain of   more »



How to display Flickr images on your own website

How to display Flickr images on your own websiteI've struggled for a long time trying to find a way to elegantly and simply display my flickr photos on my site. Up 'til now I've had to stick with slideshow apps from other websites like flickriver. This is until I found this blueimp Gallery when I was looking for some lightbox coding for my website. I didn't end up using the   more »



Raspberry Pi - record uptime

Raspberry Pi - record uptimeWell, i had pre-written a post celebrating a whole year of uptime for my RaspberryPi - guess I shouldn't have jinxed it! On Friday I came home to find the Pi unresponsive to web access, putty & vnc. There was noting for it and I had to suck up the loss and kill the power, oh well I shouldn't be to disappointed, 345 days is a respectable   more »



philfish.co.uk is launched - Phil Cam is live!

philfish.co.uk is launched - Phil Cam is live!The momentous day for Phil has been reached, his tank hosted server has launched! His Samsung Galaxy S2 server is live and pumping out his very own website. Phil is said to be delighted with his web 2.0 upgrade  and is looking forward share the images of the tank to the whole world. He says he's not finished yet and is working in the   more »



Set up a Wireless IP Webcam for free

Set up a Wireless IP Webcam for freeThis a hack for repurposing an old android handset as an ip webcam - all you need is your old unused android smartphone and the free app IP Webcam. Heres a rundown own the steps you need to go through, I'll take you through more of the detail below. Steps Find the old android device you'll be using and connect it to your wireless   more »



Setting up your own domain name with a dynamic IP address on Sky Broadband

Setting up your own domain name with a dynamic IP address on Sky BroadbandMost broadband connections will nowdays dynamically assign you with an IP address. This means that every few days or every time you restart your router you will be assigned a new IP address. Consequently if you want to host a website using your domain name then you are going to encounter a problem. What you need to do is get a static IP address   more »



Hosting your own webserver on port 80 with Sky broadband

Hosting your own webserver on port 80 with Sky broadbandOne of the first things I needed to check before ordering my Raspberry Pi was if it was technically feasable to host my own webserver from my Sky Broadband. In the past its been known by ISPs to block certain ports which makes it difficult and usually adds extra cost. One of the ways round the issue of your desired ports are blocked would be to   more »



New childs.be website launched

New childs.be website launchedThe new website has now gone live. With the acquisition of my Raspberry Pi comes a whole host of possibilities. My Pi is currently running as the server for this website. Unfortunately the Pi is not powerful engough to run Wordpress or Joomla (who'd of thought they were processor intensive) - it does run, but a four to six second delay in   more »



the Raspberry Pi is alive

the Raspberry Pi is aliveThe new server has now gone live, the Rasberry Pi is sitting quietly in the corner of my living room serving up my website to the internet. I know I've backdated this post, but it is to mark the moment in history - I'll give the Pi one final good luck reboot and it is ready to go with the aim of surviving a whole year of uptime. For many   more »



Share page

Subscribe to newsletter

Search Posts

Back to top