Blog Category: RaspberryPi
Install apache php7 mySQL and phpmyadmin on Raspbian Stretch on a RaspberryPi
I'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
So 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
If 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?
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
I 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
One 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
For 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
My 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
So 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
There 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 »
How to set up your Dell E310dw printer the really easy, bloat free way on windows
One 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
I'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
Next 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 »
How to add better comments into SQL server
Whilst 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 »
How to connect a photoresistor or light dependant resistor to an ESP8266-12E
Having 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
Probably 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
As 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!
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 »
The childs.be twitterbot is alive
My 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
If 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 »
How to log your own IP
Call 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
I'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
Well, 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!
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
This 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
Most 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
One 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
The 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 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 »
- What's your Robot name?
- How to remove bicycle tyre marks from painted walls
- Install apache php7 mySQL and phpmyadmin on Raspbian Stretch on a RaspberryPi
- How to clean the lid and nozzle of your Camelbak Podium bottle
- How to enable and change the Remote IR GPIO pin in OSMC
- Split and extract the first 1000 (N) rows from a text-csv-data file in Windows
- My new scale for measuring oldness
- A datedif function for excel that calculates correctly
- Raspberry Pi 3 HDMI overscan settings and how to correct them
- Create custom Excel function using an array/range input
- SSL on a RaspberryPi - does it slow your site down?
- Remove Real VNC from RaspberryPi Pixel and install TightVNC
- Running a SSL certificated/authenticated HTTPS website over dynamic DNS
- Excel: How to calculate distances between longitude / latitude co-ordinates
- Musing of the day 22-Feb-2017